Vlad Thank you, english is not my first language, I interpreted the sentence as "go calculate the total amount of ram, then set the value as a number within such percentage of your ram...", but thanks for the clarification. Perhaps to avoid other users making the same mistake each configurable variable on firebird .cfg files could have a "domain" explaining what type of variable it is, like "Domain = From 0 to 100, up to 2 decimals allowed, decimal separator is DOT". Furthermore, in this case I first understood what was required was actually a percentage number, but then changed my mind as it would be too hard for most users to think that way, as percentage mathematically speaking the way to represent 20% is actually 0.2, so it goes from 0 to 1.
I hope this helps other users, Cheers, Fabian ----- Original Message ----- From: [email protected] [firebird-support] To: [email protected] Sent: Wednesday, June 01, 2016 9:32 PM Subject: [firebird-support] Re: Issue with Database Cache Size on FB 3.0 ---In [email protected], <fabianch@...> wrote : ... > The setting we are playing with are: > > On firebird.conf > > FileSystemCacheThreshold = 0 > FileSystemCacheSize = 17179869184 (this is 16 GB - the server has 32 GB > ram.) Does you ever read comments describing this setting ? I can do it for you : "measured in % of total physical RAM". I.e. any value not in range [0..100] is wrong by definition. Read firebird.log, it should contain error message: "Incorrect FileSystemCacheSize setting %d. Using default (30 percent)." If you really want to limit file system cache by 50% of avalable RAM - set FileSystemCacheSize value to 50 (and restart Firebird), no need to calc in bytes... Regards, Vlad
