The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql service goes down often

Discussion in 'Database Discussions' started by Supriya Aher, Dec 23, 2012.

  1. Supriya Aher

    Supriya Aher Member

    Joined:
    Jan 18, 2012
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    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?
     
Loading...

Share This Page