MySQL Can't restart

[ultimator]

I have tried to restart mysql but it fails continually, i have tried rebooting yet the situation remains the same, what can i do, i get this message from cpanel

Waiting for mysql to restart.....finished.

mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/s1.myserver.com.pid) running as root with PID 9172 (process table check method)

mysql has failed, please contact the sysadmin (result was "mysql is not running").

thanks

 

[mtindor]

I have tried to restart mysql but it fails continually, i have tried rebooting yet the situation remains the same, what can i do, i get this message from cpanel



thanks

You will probably want to check /var/lib/mysql/<server_hostname>.err . At the end of that file you should see relevant errors logged to help you determine what is going on.

If you're servers name is zeus.someservername.ext, then:

tail -n 100 /var/lib/mysql/zeus.someservername.ext.err

An easy way to tell the name of the error log is just to do this: ls -alt /var/lib/mysql|grep '\.err'

Mike

- - - Updated - - -

Based upon your previous post here:

http://forums.cpanel.net/f5/partition-full-378561.html

... I'm betting that the reason your MySQL will not start is because you don't have any free space on / .

Mike

 

[ultimator]

thanks, i discovered that the <hostname>.err file in /var/lib/mysql is over 1.5Gb in size, i deleted it and restarted mysql and its working now. thanks

 

[mtindor]

thanks, i discovered that the <hostname>.err file in /var/lib/mysql is over 1.5Gb in size, i deleted it and restarted mysql and its working now. thanks

I'm glad that helped you. Although, you perhaps should have checked into what errors were logged, as well as how recently they were logged, before removing that file. There is a reason err logs fill up. Mine do not. As a general rule, the only time I see anything in the err log is when I restart MySQL or update it.

And, 1.5 GB free isn't much . You might want to consider going through your system and seeing if you can find other possible files to delete / archive. Depending upon your system activity, you might have large logs in /var/log, /usr/local/cpanel/logs, /var/log/cpanel/logs, /usr/local/apache/logs, etc. If there are some signfiicantly large that you can remove, you might want to consider compressing them and keeping them for a period of time, and of course after you compress them you can delete the original ones and restart the services that produce those logs so that they continue to log properly.

Mike

 

[cPanelMichael]

Hello

Yes, it sounds like the /var partition on your system may have been full. Removing the log file opened up some space and allowed MySQL to restart. Going forward, you may want to review the following document to get a better idea of the space used and available to your /var partition:

cPanel - Manage HD Space

Thank you.