Subject Memory Usage
Author iananewby
Hi All,
We have a web server running which uses Firebird 1RC2 Superserver
(64bit), Interclient 1.6 on Linux. The system started running very
slowly today and investigation showed:

memory usage: 545Meg
CPU : 90%

I stopped the web server and no instances of interserver were

I did a gstat and found the following:
Database header page information:
Flags 0
Checksum 12345
Generation 8634
Page size 8192
ODS version 10.0
Oldest transaction 8598
Oldest active 8599
Oldest snapshot 8599
Next transaction 8628
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Mar 4, 2002 10:59:41

Variable header data:
Sweep interval: 20000

I tried to stop the server (using /etc/init.d/firebird stop) and got
an error message saying the server was unavailable after about 5

The server continued to use about 90% of the CPU for another 10 or
15 minutes and then stopped. I restarted firebird, restarted the web
server and everything is ok.

What can cause the database to use this amount of RAM and CPU? The
database is only about 20Meg in size and the transactions do not
seem to have stalled? I am using the default buffers settings.

Any help would be appreciated.

Ian Newby