Someone crashing MySQL? How can I stop it?

Portal Home > Knowledgebase > Articles Database > Someone crashing MySQL? How can I stop it?

Posted by gpl24, 02-28-2011, 07:46 AM
This happens frequently. Not on a momentary-basis, but frequent enough that I notice it happens. Is someone attacking MySQL/DDoSing? Or are my settings too low, perhaps? (How would I check?)
Posted by eth00, 02-28-2011, 10:15 AM
Looks like MySQL is crashing entirely or maybe hitting a limit. Are you or some software on your server restarting it? You should take a look at the mysql and messages log, they may have something. You could use sysstat or mrtg to track the load and correlate with timestamps in the apache log.
Posted by Patrick, 02-28-2011, 10:17 AM
Usually if someone were flooding MySQL they would hit the user_connection limit and the error logs would state such. Have you checked the MySQL log file and see what it says? The file location may be different under Linux but try: ls -la /var/db/mysql/*.err It should give you a result along the lines of: /var/db/mysql/server.net.err Open the file and check the timestamp around the time the MySQL server went down and see if it provides any hints. Is this a VPS per chance, or a dedicated server? It's kind of unusual for MySQL to crash... Edit: eth00 beat me to it.
Posted by gpl24, 03-01-2011, 10:24 PM
I'm running Linux on Cpanel, so I tried running (in ssh): /bin/ls: /var/db/mysql/*.err: No such file or directory I checked /var/log/messages, but it emptied since I posted these logs (getting these about 100x a minute, not sure if it's related?): Mar 1 03:10:26 host named[2656]: client x.x.x.x#60221: view internal: query (cache) 'x.x.x.x.in-addr.arpa/PTR/IN' denied Would cpanel put the Mysql logs in a different location?