Re: [firebird-support] Issue with Database Cache Size on FB 3.0
Dimitry That is my concern, on FB 2.5 I was able to see the memory allocated as soon as the first connection is granted to the DB, but on FB 3 I am not seeing almost any memory been allocated what makes me believe that something is not right. However as more users connect and use the DB, the memory usage / allocation is growing, so something has either changed, or I have not configured properly the cfg files. Regards, Fabian - Original Message - From: Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] To: firebird-support@yahoogroups.com Sent: Wednesday, June 01, 2016 3:38 PM Subject: Re: [firebird-support] Issue with Database Cache Size on FB 3.0 01.06.2016 05:30, Alexey Kovyazin wrote: > > Firebird caches only actually used pages. But it allocates all the configured memory immediately, so the memory usage (virtual/reserved bytes) should be visible anyway. Dmitry Posted by: Dmitry Yemanov ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: [firebird-support] Issue with Database Cache Size on FB 3.0
Hi Alexey Thank you, I've noticed as the App was being used the DB cache was eating more memory, so I guess the config may be ok, it is a matter of loading more users online and check the memory Cheers Fabian - Original Message - From: Alexey Kovyazin (ak) a...@ib-aid.com [firebird-support] To: firebird-support@yahoogroups.com Sent: Wednesday, June 01, 2016 12:30 PM Subject: Re: [firebird-support] Issue with Database Cache Size on FB 3.0 Hi Fabian, Firebird caches only actually used pages. The small cache means that your application touches the small part of the database. -- Regards, Alexey Kovyazin IBSurgeon PS It is difficult and wrong to give you any direct advice without all details in hands - it can lead to worse performance than with default parameters. среда, 01 июня 2016г., 04:16 +03:00 от Fabian Ernesto Chocron fabia...@itbizolutions.com.au [firebird-support] firebird-support@yahoogroups.com: Hi All We are having trouble setting up the database cache size on FB 3.0 running on Windows 2008 R2 64 bits with 32 GB ram. The problem we have is we cannot get the server to allocate the ram for the cache as we intend. With FB 2.54 we had the DB cache set very high, close to 1 GB per database, all running in RAM memory. With FB 3.0 we read it can allocate much more RAM to the cache, but it appears the server is allocating very small amount of Ram when the first user connects to the DB, and as we connect more users to the DB the ram consumption increases slowly. The setting we are playing with are: On firebird.conf FileSystemCacheThreshold = 0 FileSystemCacheSize = 17179869184 (this is 16 GB - the server has 32 GB ram.) On databases.conf MyTestDB = c:\Temp\MyDb.fdb { DefaultDbCachePages = 458752 } Any ideas what could be wrong? Or what settings would give us maximum RAM usage for the DB cache (we dont want file system cache meaning HDD cache, we want to have the DB in RAM for the purpose of reading the DB) Cheers, Fabian
Re: [firebird-support] Issue with Database Cache Size on FB 3.0
01.06.2016 05:30, Alexey Kovyazin wrote: > > Firebird caches only actually used pages. But it allocates all the configured memory immediately, so the memory usage (virtual/reserved bytes) should be visible anyway. Dmitry
Re: [firebird-support] Issue with Database Cache Size on FB 3.0
Hi Fabian, Firebird caches only actually used pages. The small cache means that your application touches the small part of the database. -- Regards, Alexey Kovyazin IBSurgeon PS It is difficult and wrong to give you any direct advice without all details in hands - it can lead to worse performance than with default parameters. среда, 01 июня 2016г., 04:16 +03:00 от Fabian Ernesto Chocron fabia...@itbizolutions.com.au [firebird-support] firebird-support@yahoogroups.com : > >Hi All > >We are having trouble setting up the database cache size on FB 3.0 >running on Windows 2008 R2 64 bits with 32 GB ram. > >The problem we have is we cannot get the server to allocate the ram for >the cache as we intend. With FB 2.54 we had the DB cache set very high, >close to 1 GB per database, all running in RAM memory. With FB 3.0 we >read it can allocate much more RAM to the cache, but it appears the >server is allocating very small amount of Ram when the first user >connects to the DB, and as we connect more users to the DB the ram >consumption increases slowly. The setting we are playing with are: > >On firebird.conf > >FileSystemCacheThreshold = 0 >FileSystemCacheSize = 17179869184 (this is 16 GB - the server has 32 GB >ram.) > >On databases.conf > >MyTestDB = c:\Temp\MyDb.fdb >{ >DefaultDbCachePages = 458752 >} > >Any ideas what could be wrong? Or what settings would give us maximum >RAM usage for the DB cache (we dont want file system cache meaning HDD >cache, we want to have the DB in RAM for the purpose of reading the DB) > >Cheers, >Fabian > >