I have the following problem with my database:
Server: IBM 4xSixCore, 24 GB RAM
Linux Debian 2.6.30-2-amd64
Firebird 22.214.171.12485 ClassicServer
About 100 attachments once a time
Clients: PHP, IBX (VCL), .NET FirebirdClient.
After restarting all machine everything go fine.
But after some users disconnect (logout), properly or not properly (ex.
killing client process), server slows down.
When I look at atop I see, that makes 60-70 % of processor power is used (at
start there are moment where 100 % is).
Insert or update statements get the same time, but select time can grows a
couple of times.
There is not older transactions that 3-5 minutes. I have 1000-2000 active
transactions in the same time.
Sweep is set to 20 000,00, and works fine and fast.
Where could be a problem ? As i said, I can observe slowing down after some
connections are closed.
What is strange - the are a lot of MON$STATEMENTS record, that doesn't have
transactions (atransaction is closed), and they leaves almost all connection
time. There are in Prepared state, but they are not closed when transaction
is. Could it have the influence for slowing down ?
To get server faster, I must stop xinet, kill all fb_inet_server, wait about
20 sec, and then start. If not wait, just kill all fb_inet_server, problem
Anther issue: I had a problem with connection loosing by mobile devices,
when WIFI connection is lost. Mobile client was detecting connection lost,
but on server side this connection (and it's transaction) was still visible
(in MON$TRANSACTIONS). I was thinking, that this lost connections could
slow down server, so I had set ConnectionTimeOut for 30 sec in
firebird.conf. But there is comments, that it shouldn't be used with Windws
Any ideas, where could be a problem ? In firebird.conf, or maybe in some
linux settings ?
I really need a help, I spend almost 2 weeks and know I'm thinking to
downgrade to Firebird 2.0 ...
View this message in context: http://old.nabble.com/FB-2.1.3-slow-down-aftger-connecion-is-closed-tp27247201p27247201.html
Sent from the firebird-devel mailing list archive at Nabble.com.