Re: [firebird-support] Re: Help, tunning database

2013-07-22 Thread Jesus Garcia 


El 22/07/2013, a las 14:10, "trskopo"  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]

RE: [firebird-support] Re: Help, tunning database

2013-07-22 Thread Leyne, Sean 
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

2013-07-15 Thread Jesus Garcia 


El 15/07/2013, a las 18:23, "trskopo"  escribió:

> 
> 
> --- In firebird-support@yahoogroups.com, Jesús García  wrote:
> >
> > El 15/07/2013, a las 16:31, "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]