| mysql persistent connections [message #2087] |
Fri, 30 May 2008 22:02  |
DrAgon 
Messages: 192
Registered: August 2007 |
Super-Seeder
Bug hunter |
|
|
What is your persistent connections mysql setting? enable or disabled? Do you have persisnet conection enabled in your php.ini?
if enabled...what is your max_connection setting in mysql conf file?
I ran into a problem the other night and stayed up till 4am....in order to keep the site back up and working..
I had persisnet connection on and sql connection were reaching max_connections and I had to monkey around for a while to keep the site up....Somehow previous to this mysql crash problem..I did make some network routing changes on inside db connection to the db server...and perhaps some wiring/cable changes..!! 
it seems like announce/scrap php were keeping connections open to the mysql db and it was reaching max_connection very rapidly ..afer few minutes... and mysql would crash (too many connections error message) and I had to stop mysql and restart and same thing over and over again!
I can't verity if it was a network change problem, bad cable or pmbt version of announce/scrape I'm running that is not closing connections efficineclty..... ..i never had this problem before 
so I do have persistent connection turned off temporarily ..
I will have to enable persistent connections soon again to see what the hell is going on and what has changed suddenly!
[Updated on: Fri, 30 May 2008 22:04] Report message to a moderator |
|
|
|
Members
Search
Help
Register
Login
Home
E-mail to friend 
