Hi Russell It indicates that you're running with a default config, untuned server is not really suitable or optimal for production. There'll be more settings that should be set or tuned for your particular environment and use. To get rid of this particular warning: myisam-recover-options=quick,backup However, the underlying issue is that the default engine should be InnoDB not MyISAM. But you will need to tune things appropriately if you were going to make that change. You can then also convert any existing tables. Regards, Arjen. On 2 December 2014 1:55:15 PM AEST, Russell Coker <russell@coker.com.au> wrote:
After a reboot of the LUV server to upgrade the kernel I got the following messages. I just ran "repair table" commands on all of them. Is this something to be concerned about?
Dec 2 14:51:32 itmustbe mysqld: 141202 14:51:32 [ERROR] /usr/sbin/mysqld: Table './wikimaus_officialwikidb/pagelinks' is marked as crashed and should be repaired Dec 2 14:51:32 itmustbe mysqld: 141202 14:51:32 [Warning] Checking table: './wikimaus_officialwikidb/pagelinks' Dec 2 14:51:32 itmustbe mysqld: 141202 14:51:32 [ERROR] /usr/sbin/mysqld: Table './wikimaus_officialwikidb/searchindex' is marked as crashed and should be repaired Dec 2 14:51:32 itmustbe mysqld: 141202 14:51:32 [Warning] Checking table: './wikimaus_officialwikidb/searchindex' Dec 2 14:51:32 itmustbe mysqld: 141202 14:51:32 [ERROR] /usr/sbin/mysqld: Table './wikimaus_officialwikidb/site_stats' is marked as crashed and should be repaired Dec 2 14:51:32 itmustbe mysqld: 141202 14:51:32 [Warning] Checking table: './wikimaus_officialwikidb/site_stats' Dec 2 14:51:32 itmustbe mysqld: 141202 14:51:32 [ERROR] /usr/sbin/mysqld: Table './wikimaus_officialwikidb/user' is marked as crashed and should be repaired Dec 2 14:51:32 itmustbe mysqld: 141202 14:51:32 [Warning] Checking table: './wikimaus_officialwikidb/user' Dec 2 14:51:32 itmustbe mysqld: 141202 14:51:32 [ERROR] /usr/sbin/mysqld: Table './wikimaus_officialwikidb/watchlist' is marked as crashed and should be repaired Dec 2 14:51:32 itmustbe mysqld: 141202 14:51:32 [Warning] Checking table: './wikimaus_officialwikidb/watchlist'
-- My Main Blog http://etbe.coker.com.au/ My Documents Blog http://doc.coker.com.au/ _______________________________________________ luv-main mailing list luv-main@luv.asn.au http://lists.luv.asn.au/listinfo/luv-main
-- Sent from my Android device with K-9 Mail. Please excuse my brevity.