My server ground to a halt today saying there were to many open MySQL connections. After a reboot I issued the SHOW STATUS command which now shows 791 open connections after about half an hour. Is there a way of finding out what script is opening these connections?
Demaestro
8:09 pm on Mar 18, 2008 (gmt 0)
ouch.... you might have to write some code that will log all the SQL somewhere and then add it to all the places that use an SQL connection and add it.
I found good instructions on how to go about it. I will PM them to you because I am unsure about posting the link.
