Re: ODP: [firebird-support] Page cache size in Firebird 3.0.4
I resend my email - it do not reaach the yahoo group :-( Hi Yes you have missed config in your db itself Database properties ODS Version 12 Page size 16384 Pages 437728 Size on disk 6.68GB >>>Page buffers 10240 Read only false You have page buffers set inside your DB. Default priority is Page buffers set inside DB if set to 0 go to point 2 Page buffers set in databases.conf if not present go to point 3 DefaultDbCachePages set in firebird.conf Regards, Karol Bieniaszewski
Re: [firebird-support] Page cache size in Firebird 3.0.4
> I am running SS FB 3.0.4 x64 in Windows 10 x64 with 16GB RAM.
>
> Database properties
>
> ODS Version 12
> Page size 16384
> Pages 437728
> Size on disk 6.68GB
> Page buffers 10240
> Read only false
>
> Settings
>
> Dialect 3
> Default character set NONE
> Sweep interval 2
> Forced writes
>
> Database alias in databases.conf file
> =
> my_dba = C:\Dba\my_dba.fdb
> {
> FileSystemCacheThreshold = 2M
> LockMemSize = 16M
> LockHashSlots = 30011
> TempCacheLimit = 2048M
> TempBlockSize = 2M
> DefaultDbCachePages = 65536
> }
>
> I ran a query with flamerobin, this is the statistic result :
> =
> 46220441 fetches, 17965 marks, 172471 reads, 82 writes.
> 8847 inserts, 0 updates, 0 deletes, 15730299 index, 8847 seq.
> Delta memory: 4206064 bytes.
> G_TMP: 8847 inserts.
> Total execution time: 52.434s
> Script execution finished.
>
> On Windows Task Manager, Firebird Server took 236MB RAM, max.
>
> If not mistaken, Page Cache Size should be
> Page Size x DefaultDbCachePages = 16384 x 65536 = ~ 1GB
>
> Why Firebird server only took 236 MB RAM ? Is this normal or something
> missed here ?
DefaultDbCachePages (65536 in your case) is only used if Page buffers at
database level is set to 0. Yours is set to 10240.
Hope this helps.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
[firebird-support] Page cache size in Firebird 3.0.4
Hi guys,
I am running SS FB 3.0.4 x64 in Windows 10 x64 with 16GB RAM.
Database properties
ODS Version 12
Page size 16384
Pages 437728
Size on disk 6.68GB
Page buffers 10240
Read only false
Settings
Dialect 3
Default character set NONE
Sweep interval 2
Forced writes
Database alias in databases.conf file
=
my_dba = C:\Dba\my_dba.fdb
{
FileSystemCacheThreshold = 2M
LockMemSize = 16M
LockHashSlots = 30011
TempCacheLimit = 2048M
TempBlockSize = 2M
DefaultDbCachePages = 65536
}
I ran a query with flamerobin, this is the statistic result :
=
46220441 fetches, 17965 marks, 172471 reads, 82 writes.
8847 inserts, 0 updates, 0 deletes, 15730299 index, 8847 seq.
Delta memory: 4206064 bytes.
G_TMP: 8847 inserts.
Total execution time: 52.434s
Script execution finished.
On Windows Task Manager, Firebird Server took 236MB RAM, max.
If not mistaken, Page Cache Size should be
Page Size x DefaultDbCachePages = 16384 x 65536 = ~ 1GB
Why Firebird server only took 236 MB RAM ? Is this normal or something missed
here ?
Thanks & regards,
Anto
