Subject | High memory consumption |
---|---|
Author | Carsten Schäfer |
Post date | 2005-10-19T14:21:20Z |
Hi,
on one customer side Firebird Server is eating memory.
It's a Window 2003 Server with 2,8GH Xeon and 3 GB memory.
The FBServer (FB1.5.2 SuperServer) process memory usage is growing until
the machine begins to swap memory and keeps growing.
For testing purposes i've installed FB1.5.3 RC2 Classic Server on this
machine, now I've 3 or more fb_inet_server processes that keeps growing.
We 're connecting to the database via Jaybird 1.5.5 with connection and
statement pooling. We don't use autocommit-mode. We use only
standard-sql, no udfs.
Here are some statistics of the database (database size:700 MB):
Database header page information:
Flags 0
Checksum 12345
Generation 75741
Page size 8192
ODS version 10.1
Oldest transaction 75732
Oldest active 75733
Oldest snapshot 75733
Next transaction 75734
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 4096 KB
Next header page 0
Database dialect 3
Creation date Oct 17, 2005 3:46:07
Attributes force write
Variable header data:
Sweep interval: 0
*END*
On other customers sides(with smaller databases and less users) we don't
have these problems.
Does anybody have an explanation ?
mfg
Carsten
on one customer side Firebird Server is eating memory.
It's a Window 2003 Server with 2,8GH Xeon and 3 GB memory.
The FBServer (FB1.5.2 SuperServer) process memory usage is growing until
the machine begins to swap memory and keeps growing.
For testing purposes i've installed FB1.5.3 RC2 Classic Server on this
machine, now I've 3 or more fb_inet_server processes that keeps growing.
We 're connecting to the database via Jaybird 1.5.5 with connection and
statement pooling. We don't use autocommit-mode. We use only
standard-sql, no udfs.
Here are some statistics of the database (database size:700 MB):
Database header page information:
Flags 0
Checksum 12345
Generation 75741
Page size 8192
ODS version 10.1
Oldest transaction 75732
Oldest active 75733
Oldest snapshot 75733
Next transaction 75734
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 4096 KB
Next header page 0
Database dialect 3
Creation date Oct 17, 2005 3:46:07
Attributes force write
Variable header data:
Sweep interval: 0
*END*
On other customers sides(with smaller databases and less users) we don't
have these problems.
Does anybody have an explanation ?
mfg
Carsten