After the 100% full hard disk problem I couldn\u2019t get MySQL to restart. I looked at the error logs and found these lines.
\n
\n151010 16:51:18 [ERROR] \/usr\/sbin\/mysqld: Table '.\/SS_connellsville\/alerts' is marked as crashed and should be repaired\n151010 16:51:18 [Warning] Checking table: '.\/SS_connellsville\/alerts'\n151010 16:51:56 [ERROR] \/usr\/sbin\/mysqld: Table '.\/SS_greensburg\/values_RSSI_3' is marked as crashed and should be repaired\n151010 16:51:56 [Warning] Checking table: '.\/SS_greensburg\/values_RSSI_3'\n151010 16:51:58 [ERROR] \/usr\/sbin\/mysqld: Table '.\/master\/node_groups' is marked as crashed and should be repaired\n151010 16:51:58 [Warning] Checking table: '.\/master\/node_groups'\n<\/code><\/pre><\/p>\nA stackoverflow post recommended using mysqlcheck. It must be used when the mysqld server is running. I couldn\u2019t see how to set it to just repair the databases that were causing problems, but I figured that it wouldn\u2019t hurt to run it on all of them. I was a bit concerned that it would run into problems when the cron jobs ran, but I set it running anyway. It changed the record count on all of the databases and ran for many hours. At least six, but I stopped monitoring and let it run overnight. I stopped MySQL and did a restart and it started without errors.<\/p>\n
\nmysqlcheck --repair --use-frm --all-databases\n<\/code><\/pre><\/p>\n","protected":false},"excerpt":{"rendered":"After the 100% full hard disk problem I couldn\u2019t get MySQL to restart. I looked at the error logs and found these lines. 151010 16:51:18 [ERROR] \/usr\/sbin\/mysqld: Table '.\/SS_connellsville\/alerts' is marked as crashed and should be repaired 151010 16:51:18 [Warning] Checking table: '.\/SS_connellsville\/alerts' 151010 16:51:56 [ERROR] \/usr\/sbin\/mysqld: Table '.\/SS_greensburg\/values_RSSI_3' is marked as crashed and should … Continue reading MySQL won\u2019t reboot<\/span><\/a><\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-2294","post","type-post","status-publish","format-standard","hentry","category-coding"],"_links":{"self":[{"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/posts\/2294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2294"}],"version-history":[{"count":0,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=\/wp\/v2\/posts\/2294\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wellgolly.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}