[firebird-support] Re: Help, tunning database
Today, I faced same problem again, which is Firebird server became not responsive. Here are the latest settings : - win 7 64 bit - Firebirds 2.5.1 super server - page size 8192 - page buffer 8192 - no long transactions - temp cache limit set to 128MB - there are a few numbers errors in insert operations but all already rollback. I suspect that the problem is the noted problem with Windows File Cache on 64bit Windows systems -- the OS is loading too much into file cache which is causing a huge/excessive number of cache page writes, which results in the system grinding to a halt. So, the problem is not with FB but with Windows. Please google/yahoo this subject (it has also been mentioned in this list several times). http://dyemanov.blogspot.fr/2012/03/firebird-vs-windows-file-system-caching.html http://tracker.firebirdsql.org/browse/CORE-3791 Fixed Firebird 2.5.2 Paul
[firebird-support] Re: Help, tunning database
Dear all, Today, I faced same problem again, which is Firebird server became not responsive. Here are the latest settings : - win 7 64 bit - Firebirds 2.5.1 super server - page size 8192 - page buffer 8192 - no long transactions - temp cache limit set to 128MB - there are a few numbers errors in insert operations but all already rollback. I was not restarted FB server yet. I think if I do that FB will became normal again. Every times there are errors from execution of SQL statements (insert,delete ,update), although transactions has been rollback, FB became not responsive. Any ideas how to solve this problem without restarting FB server? Thanks, Anto
RE: [firebird-support] Re: Help, tunning database
Anto, Today, I faced same problem again, which is Firebird server became not responsive. Here are the latest settings : - win 7 64 bit - Firebirds 2.5.1 super server - page size 8192 - page buffer 8192 - no long transactions - temp cache limit set to 128MB - there are a few numbers errors in insert operations but all already rollback. I suspect that the problem is the noted problem with Windows File Cache on 64bit Windows systems -- the OS is loading too much into file cache which is causing a huge/excessive number of cache page writes, which results in the system grinding to a halt. So, the problem is not with FB but with Windows. Please google/yahoo this subject (it has also been mentioned in this list several times). Sean
Re: [firebird-support] Re: Help, tunning database
El 22/07/2013, a las 14:10, trskopo trsk...@yahoo.com escribió: Dear all, Today, I faced same problem again, which is Firebird server became not responsive. Here are the latest settings : - win 7 64 bit - Firebirds 2.5.1 super server - page size 8192 - page buffer 8192 - no long transactions - temp cache limit set to 128MB - there are a few numbers errors in insert operations but all already rollback. I was not restarted FB server yet. I think if I do that FB will became normal again. Every times there are errors from execution of SQL statements (insert,delete ,update), although transactions has been rollback, FB became not responsive. Any ideas how to solve this problem without restarting FB server? Thanks, Anto Why don't you try 2.5.2? 2.5.1 has some issues corrected in 2.5.2. [Non-text portions of this message have been removed]
[firebird-support] Re: Help, tunning database
Anto wrote: 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. And later: I did a small test, here are the settings : - FB Super Classic 2.5.1 64 bit - Win7 pro 64 bit Not related to your main problem, but if you are using SuperServer then cpuaffinity set to 15 may not be an optimal setting. -- Aage J.
[firebird-support] Re: Help, tunning database
--- In firebird-support@yahoogroups.com, Jesús GarcÃa jegaza@... wrote: El 15/07/2013, a las 16:31, trskopo trskopo@... 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] Thanks for your reply. How do I check that there is a long transaction running? Anto
Re: [firebird-support] Re: Help, tunning database
El 15/07/2013, a las 18:23, trskopo trsk...@yahoo.com escribió: --- In firebird-support@yahoogroups.com, Jesús García jegaza@... wrote: El 15/07/2013, a las 16:31, trskopo trskopo@... 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] Thanks for your reply. How do I check that there is a long transaction running? Anto Select * from mon$transactions for example [Non-text portions of this message have been removed]