MySQL failing/recovering repeatedly

Authorlink

• March 23, 2015 11:21

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? [SPOILER="MySQL Failure Email"> 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: [LIST]

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 [SPOILER="MySQL Recovery Email"> 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: [LIST]

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

• 

  cPanelMichael

  • March 24, 2015 13:03

  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.

  0

Please sign in to leave a comment.