Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL failing/recovering repeatedly

Discussion in 'Database Discussion' started by Authorlink, Mar 23, 2015.

  1. Authorlink

    Authorlink Registered

    Joined:
    Mar 23, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    USA
    cPanel Access Level:
    Website Owner
    We've received several emails about MySQL failing, then recovering a few minutes afterwards. We haven't experienced any unusual spike in traffic or bandwidth usage, and the site itself appears unchanged. Is this something we should be worried about?

    Service Name: mysql
    Service Status: failed
    Notification: The service “mysql” appears to be down.
    Service Check Method: The system’s command to check or to restart this service failed.
    Number of Restart Attempts: 1
    Startup Log:
    Starting MySQL. SUCCESS!
    Log Messages:
    150320 17:06:24 mysqld_safe mysqld from pid file /var/lib/mysql/aut.authorlink.com.pid ended
    150320 17:06:24 mysqld_safe mysqld restarted
    150320 17:06:24 mysqld_safe Number of processes running now: 0
    2015-03-20 17:06:19 19156 [Note] /usr/sbin/mysqld: ready for connections.
    150320 17:06:18 mysqld_safe mysqld restarted
    150320 17:06:18 mysqld_safe Number of processes running now: 0
    2015-03-19 04:40:33 3973 [Note] /usr/sbin/mysqld: ready for connections.
    150319 04:40:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150319 04:38:08 mysqld_safe mysqld from pid file /var/lib/mysql/aut.authorlink.com.pid ended
    Memory Information:
    • Used: 1.24 GB
    • Available: 9.45 GB
    • Installed: 10.69 GB
    Load Information: 2.30 1.83 0.83
    Uptime: 41 days, 12 hours, 18 minutes, and 46 seconds
    IOStat Information:
    avg-cpu: %user %nice %system %iowait %steal %idle
    4.34 0.06 0.62 0.00 0.00 94.97
    Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
    ChkServd Version: 15.8

    Service Name: mysql
    Service Status: recovered
    Notification: The service “mysql” is now operational.
    Service Check Raw Output:
    The 'mysql' service passed the check.
    Startup Log:
    Starting MySQL. SUCCESS!
    Log Messages:
    2015-03-20 17:07:51 19717 [Note] /usr/sbin/mysqld: ready for connections.
    150320 17:07:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150320 17:06:24 mysqld_safe mysqld from pid file /var/lib/mysql/aut.authorlink.com.pid ended
    150320 17:06:24 mysqld_safe mysqld restarted
    150320 17:06:24 mysqld_safe Number of processes running now: 0
    2015-03-20 17:06:19 19156 [Note] /usr/sbin/mysqld: ready for connections.
    150320 17:06:18 mysqld_safe mysqld restarted
    150320 17:06:18 mysqld_safe Number of processes running now: 0
    2015-03-19 04:40:33 3973 [Note] /usr/sbin/mysqld: ready for connections.
    Memory Information:
    • Used: 1.24 GB
    • Available: 9.44 GB
    • Installed: 10.69 GB
    Load Information: 0.32 0.82 0.66
    Uptime: 41 days, 12 hours, 23 minutes, and 42 seconds
    IOStat Information:
    avg-cpu: %user %nice %system %iowait %steal %idle
    4.34 0.06 0.62 0.00 0.00 94.97
    Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
    ChkServd Version: 15.8
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,378
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    I don't see anything abnormal in the output you provided. Do you notice any additional entries in the MySQL error log (/var/lib/mysql/$hostname.err) in the minutes before MySQL restarts?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice