Frequent MySQL Downtime

Portal Home > Knowledgebase > Articles Database > Frequent MySQL Downtime

Posted by hbhb, 07-14-2007, 09:39 AM
One of my CPanel server often has MySQL downtime randomly.. once every 30-60 minutes I suspect is an overload or one of the user database is broken. How do I check and fix?
Posted by tanfwc, 07-14-2007, 09:53 AM
see the log file from MySQL. It might give you some clue on why it shutdown itself.
Posted by tonytis, 07-14-2007, 10:02 AM
I agree the MYSQL log is the first place to look. You might also check these others: 1. Does your server have enpugh memory? 2. Ifs the server overload from too may other Mysql users? 3. Here is a link allowing you to see hoa mny other sites are hosted on your server. It may help determine if your server is overloaded. http://www.seologs.com/ip-domains.html Hope this helps, Tony
Posted by SparkSupport, 07-14-2007, 10:19 AM
Yes, check the mysql error and see the error reporting there and paste the error here. You can check the mysql error log by running this command #tail -50 /var/lib/mysql/`hostname`.err
Posted by hbhb, 07-14-2007, 10:56 AM
I have check inside SQL hostname.err log 070714 19:18:31 mysqld started 070714 19:18:31 mysqld started 070714 19:18:31 InnoDB: Started; log sequence number 0 14120440 /usr/sbin/mysqld: ready for connections. Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL) 070714 22:52:18 [Note] /usr/sbin/mysqld: Normal shutdown 070714 22:52:18 InnoDB: Starting shutdown... 070714 22:52:19 InnoDB: Shutdown completed; log sequence number 0 14120440 070714 22:52:19 [Note] /usr/sbin/mysqld: Shutdown complete 070714 22:52:19 mysqld ended 070714 22:52:20 mysqld started 070714 22:52:20 InnoDB: Started; log sequence number 0 14120440 /usr/sbin/mysqld: ready for connections. Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL) There is nothing unusual, on 19:18, I restarted SQL because it was down. On 22:52 I restarted SQL again because it was down But between those time logs, it didn't mentioned why it was down.
Posted by hbhb, 07-15-2007, 12:40 AM
I actually copied a whole /etc/my.cnf from another server and it went fine! -case closed-