I have same issue with idle connection on mysql. But my case, i’m using php to connect to mysql and i’m using mysql_pconnect(). with p as persisted connection. when the problem hit i simply replace function mysql_pconnect() with mysql_connect()
Comment: Are PHP persistent connections evil ?
December 28, 2009 By 31 Comments
…, it’s in a well-designed web application where persistent connections are beneficial. Badly-designed applications don’t use them either… they succumb to the gotchas. And the potential gotchas of pconnect are all symptoms of bad design themselves: having far too…), with fastCGI + PHP (1 process, 24 children), connecting to mysql via Unix sockets with persistent connections. I have not had any problems. Even…
