I got Database error on all my sites today all of sudden, my server hosts about 5 sites with decent traffic... At first it was just one site, then within a couple minutes all the sites went down. First I used 'top' but the stats show that the server is only using 40-50% resources. Then I tried to check with mysql commands under root access but I couldn't even get in... Got ERROR 1040 (00000): Too many connections When I tried to use mysql -u root -p Tried to restart mysqld but it froze my root connection. Requesting a server reboot at the moment, anyone have any idea what would cause this? I moved a site with decent traffic over to the server 2 days ago, could that have overwhelmed it? Also does anyone know how to prevent this or which log(s) to check to determine the cause? Thank you in advance for all helpful replies
Hi, you can limit the number of connections in /etc/my.cnf. Have a look at max_connections in there and maybe increase it? Matt