Subject Re: [firebird-support] Firebird.Log - Allocated 11343 page buffers of 20000 requested
Author Helen Borrie
At 10:54 PM 1/02/2006, you wrote:
>Hello
>
>What means this entries in the Firebird server log?
>The server is Firebird 1.5.2 clasical server
>
>.....
>SERVER Wed Feb 01 10:59:23 2006
>Database: C:\DATA\DATA.FDB
>Allocated 11343 page buffers of 20000 requested
>
>SERVER Wed Feb 01 10:59:25 2006
>Database: C:\DATA\DATA.FDB
>Allocated 11343 page buffers of 20000 requested
>.....

It means you have configured a ridiculously huge amount of page cache
for each connection (781 Mb per connection if your page size is 4Kb)
and you didn't have that much RAM available for those connection requests.

On classic, *each connection* gets its own page cache. The
installation default for Classic is 75 pages, which is usually a bit low.

Reduce the cache to 256 pages (for a 4K page size this gives you 1 Mb
of page cache per connection, which should be ample). If you have a
lot of RAM and very few connections, you could make it 512 or even
1024. When calculating the size you need, don't forget that the
allocation will increase with larger page sizes. If your server
doesn't have much RAM, you'll need to be more conservative.

./heLen