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 failing/recovering repeatedly

Discussion in 'Database Discussions' 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:
    30,678
    Likes Received:
    651
    Trophy Points:
    113
    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.
     
Loading...

Share This Page