Subject Firebird Memory Usage (Linux)
Author iananewby
Hi All,
I am using Firebird 1.0RC2 SS with Interclient 1.6 on Mandrake 8.1
(accessing two dialect 1 databases).

The linux top command shows the ibserver process currently taking up
45M of ram, with interserver taking up 5K.

The ibserver process is growing at about 10M of ram used per day at
the moment.

The two databases being accessed are only about 20Meg in total size.

Relevent sections of the gstat output follow:
Database "/data/wwwServers/TMI/WEB-INF/Interbase/TMILeanMan.gdb"
Database header page information:
Page size 8192
Oldest transaction 46252
Oldest active 46253
Oldest snapshot 46253
Next transaction 46254
Database dialect 1

Database "/data/wwwServers/TMI/WEB-INF/Interbase/Intelus.gdb"
Database header page information:
Page size 8192
ODS version 10.0
Oldest transaction 8878
Oldest active 8879
Oldest snapshot 8879
Next transaction 8918
Database dialect 1

Why is the RAM usage growing so drastically?

What can I do to stop this happening?

Regards
Ian Newby