Re: [firebird-support] Help, tunning database
On 15-7-2013 16:31, trskopo wrote: Hi all, I have Superserver Firebird 2.5.1 installed on Win7 pro 64 bit on I7 2600K. When data grows, Firebird Server starting to slow down. I shutdown Firebird Server, starting again without changing anything and Firebird Server became smooth again. Any ideas, what is the problem with this? Firebird.conf mostly on its default values except for cpuaffinity set to 15 and DefaultDbCachePages set to 4096. Setting CpuAffinity to anything other than 2^n is a bad idea as it can cause slow down because of migrating threads to other cores. DefaultDbCachePages controls the number of pages in cache per database (if no specific value is configured for the database itself). With 4k pages, the value of 4096 means a page cache of only 16MB. With 16k pages: 64MB You might want to consider increasing it a bit more, or switching to classic or superclassic server. As you use Windows 7 64, you might actually be bitten by the filesystem cache issue, where Windows tries to cache beyond the available physical memory. See http://www.firebirdsql.org/file/documentation/release_notes/html/rlsnotes252.html#rnfb25-fbconf-fscache for settings to control this (although I believe you shouldn't be affected with the default setting). Mark -- Mark Rotteveel
[firebird-support] Help, tunning database
Hi all, I have Superserver Firebird 2.5.1 installed on Win7 pro 64 bit on I7 2600K. When data grows, Firebird Server starting to slow down. I shutdown Firebird Server, starting again without changing anything and Firebird Server became smooth again. Any ideas, what is the problem with this? Firebird.conf mostly on its default values except for cpuaffinity set to 15 and DefaultDbCachePages set to 4096. Anto
Re: [firebird-support] Help, tunning database
El 15/07/2013, a las 16:31, trskopo trsk...@yahoo.com escribió: Hi all, I have Superserver Firebird 2.5.1 installed on Win7 pro 64 bit on I7 2600K. When data grows, Firebird Server starting to slow down. I shutdown Firebird Server, starting again without changing anything and Firebird Server became smooth again. Any ideas, what is the problem with this? Firebird.conf mostly on its default values except for cpuaffinity set to 15 and DefaultDbCachePages set to 4096. Anto Probably is long running transactions. I have had this issue in two scenarios. One is long running transactions that makes db slowdown and the other one is when an auto sweep starts, because a long running transaction, there is an issue (that will be solved in 2.5.3) that makes Firebird run sweep several times. I have databases of 30 gb running fine for months without issues except when there is a long running transaction. The last issue was because gbak was out space and the gbak's transaction was opened for days. Our customer called us because the slowdown and we killed the gbak process and then auto sweep started. The sweep runned more than 2 hour (i think because the bug in 2.5.2) and after that all was running fine. (When i run a manual sweep in that database takes 20 minutes and does not slowdown the engine like when auto sweep is started) Jesús [Non-text portions of this message have been removed]