Re: max_connections recovery

2002-07-27 Thread Troy Hakala
The language is English (same as server) and the client is PHP. I've never seen this problem even when maxing out the connections at the default 100. On Thursday, July 25, 2002, at 02:55 PM, Georg Richter wrote: On Thursday, 25. July 2002 18:48, Troy Hakala wrote: Hello, I've been

Re: max_connections recovery

2002-07-27 Thread Paul DuBois
At 11:17 -0700 7/26/02, Troy Hakala wrote: ok, i turns out I have lots of sleeping connections. This is because I'm using PHP's mysql_pconnect which opens persistent connections so the next connect (on the same process) will reuse the connection. this does appear to improve performance

Re: max_connections recovery

2002-07-27 Thread Dicky Wahyu Purnomo
Pada Fri, 26 Jul 2002 11:17:08 -0700 Troy Hakala [EMAIL PROTECTED] menulis : ok, i turns out I have lots of sleeping connections. This is because I'm using PHP's mysql_pconnect which opens persistent connections so the next connect (on the same process) will reuse the connection. this does

Re: max_connections recovery

2002-07-26 Thread Troy Hakala
ok, i turns out I have lots of sleeping connections. This is because I'm using PHP's mysql_pconnect which opens persistent connections so the next connect (on the same process) will reuse the connection. this does appear to improve performance overall, which is good. but it seems to leave lots

max_connections recovery

2002-07-25 Thread Troy Hakala
I've been running MySQL for 2 years with no problems. Yesterday, I increased the max_connections because I was getting too many connections error. This morning, the server again reached its limit but it never seemed to recover from it and constantly gave the too many connections error. I was