mysql max connections problem
I have a big problem with mysql and ispconfig:
Yesterday I created a new virtual machine with vmware server 2 and installed
debian lenny with ispconfig.
I left the server active with only one or two virtual mail users and no connection to internet.
This morning the server was down and I couldn't log in with ispconfig because of a mysql error. I restart the vm and the server came back to life...
I watched the connections to mysql and I noticed that every minute a new "ispconfig user" starts a new connection to the db without stopping it, never!
So after a couple of hours mysql reaches the max connection limit and the server stops to work.
What can I do?