Dear all, I'm new here, and i use "The Perfect Server - CentOS 5.3 x86_64 [ISPConfig 3]" of Falko. I do'nt know why my mysql auto stop that make all my sites can't connect. When I restart the server, nothing happens. Could you please help me ?
That has nothing to do with MySQL. Do you see any errors in your logs when you restart MySQL? IS this a physical server or a virtual machine?
Maybe it's a problem with your system resources. I suggest you set up munin so that you can track down problems with your system resources. http://www.howtoforge.com/server-monitoring-with-munin-and-monit-on-centos-5.2
help me Dear Falko, i was resetup myserver with thread "The perfect ... centos5.4 with Ispconfig3". However,I still have following errors: Until undefined time, all sites on server lost their connection to MySQL. Then, they will automatically connected after 5-10 minutes. When I restart MySQL, no errors happened. Falko think that: this error belong to another service out of mysql? This is /var/log/mysqld.log:
30 minutes ago, this situation happened again and I try not to restart mysql. I tried to connect by http://IP/phpmyadmin/. It display that: too many connections.
You can raise the max. amount of connections with the max_connections setting in your my.cnf, e.g. Code: max_connections = 1000 Restart MySQL afterwards.