Mysql service goes down often

Supriya Aher

Member
Jan 18, 2012
9
0
51
cPanel Access Level
Root Administrator
Hello,

Servers mysql services goes down very often and then needs to be started manually each time.


If we check the status of mysql service then below is the output:

"MySQL is running but PID file could not be found [FAILED]"

On checking the mysql error logs , we get just the below errors:
===========================================

tail -f /var/lib/mysql/servername.err

121222 22:16:27 [ERROR] /usr/sbin/mysqld: Table './guiaycom_wp458/wp_options' is marked as crashed and should be repaired
121222 22:16:27 [ERROR] /usr/sbin/mysqld: Table './guiaycom_wp458/wp_options' is marked as crashed and should be repaired
121222 22:16:27 [ERROR] /usr/sbin/mysqld: Table './guiaycom_wp458/wp_options' is marked as crashed and should be repaired
121222 22:16:27 [ERROR] /usr/sbin/mysqld: Table './guiaycom_wp458/wp_options' is marked as crashed and should be repaired
121222 22:25:57 [ERROR] /usr/sbin/mysqld: Table './isprofit_smf1/smf_log_online' is marked as crashed and should be repaired
121222 22:25:57 [ERROR] /usr/sbin/mysqld: Table './isprofit_smf1/smf_log_online' is marked as crashed and should be repaired
121222 22:26:53 [ERROR] /usr/sbin/mysqld: Table './fishresc_newfrw/members_online' is marked as crashed and should be repaired
121222 22:26:53 [ERROR] /usr/sbin/mysqld: Table './fishresc_newfrw/members_online' is marked as crashed and should be repaired
121222 22:29:12 [ERROR] /usr/sbin/mysqld: Table './isprofit_smf1/smf_log_online' is marked as crashed and should be repaired
121222 22:29:12 [ERROR] /usr/sbin/mysqld: Table './isprofit_smf1/smf_log_online' is marked as crashed and should be repaired
121222 22:30:18 [ERROR] /usr/sbin/mysqld: Table './fishresc_newfrw/members_online' is marked as crashed and should be repaired
121222 22:30:18 [ERROR] /usr/sbin/mysqld: Table './fishresc_newfrw/members_online' is marked as crashed and should be repaired
=====================================


Can I know, what can cause this and how to resolve the mysql PID file could not be found error permanently?