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/
On 2 December 2014 at 14:55, 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?
IIRC, The messages imply that MYISAM tables are being used, and that the system wasn't shut down cleanly. I seem to recall that INNODB tables are more resilient with unclean shutdowns. It should be possible to configure mysql to automatically repair tables on startup. Apart from that, in most cases, nothing to be concerned about - I believe it is similar to filesystem check. -- Brian May <brian@microcomaustralia.com.au>
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.
I should also note that if you don't have that setting I mentioned (which may be on by default in recent versions! ), a "crashed" MyISAM table will be set to read-only. So your repair operation is the correct course of action, and you can't just ignore it otherwise occupant l obviously apps get unhappy.
participants (3)
-
Arjen Lentz -
Brian May -
Russell Coker