DefaultDbCachePages seems ignored
----------------------------------
Key: CORE-5455
URL: http://tracker.firebirdsql.org/browse/CORE-5455
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.2
Environment: Debian 8, kernel: 3.16.0-4-amd64, FB build:
3.0.2.32669-0.amd64, server mode: Super, RAM memory: 32 Gb
Reporter: Cristiano Ferrari
FB 3.0 release notes tell me that the maximum number of pages that can be
configured for the database cache running under 64-bit environment is (2^31)-1
pages, so, 2,147,483,647 pages.
I have an database with 5.5 GB (page size 8192, 709504 pages allocated) and
want to put all database pages on cache.
So, I've set the DefaultDbCachePages parameter in firebird.conf to 800,000
pages.
Restarted service via "systemctl restart firebird-superserver.service" (checked
from firebird.log).
However, gstat show me that page cache still in default values
<quote>
Database "/opt/safebd/dados/base.fdb"
Database header page information:
Flags 0
Generation 335725
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 3389
Oldest active 3390
Oldest snapshot 3390
Next transaction 335681
Sequence number 0
Next attachment ID 125
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 4096
Next header page 0
Database dialect 3
Creation date Jan 16, 2017 18:23:01
Attributes
Variable header data:
Sweep interval: 20000
*END*
</quote>
Before that service restart, I've set this parameters on firebird.conf (no one
per database):
DefaultDbCachePages = 800000
AuthServer = Legacy_Auth, Srp, Win_Sspi ## because using 2.5 fbclient.dll
RelaxedAliasChecking = 1 ## just in case
ConnectionTimeout = 60
WireCrypt = Disabled ## because using 2.5 fbclient.dll
LockMemSize = 10M
LockHashSlots = 65521
ServerMode = Super
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
