MyISAM table index file keep crashing on regular basis!
Table keep Crashing ERROR 126 (HY000): Incorrect key file for table './DB/Table.MYI'; try to repair it
It does get fixed by repair table开发者_如何学运维 but the problem is reoccurring!! and it's 5G table takes ~45mins to repair.
Check your slow query log for a long running query on table. Make sure other process like "backup" isn't interrupting it!!
精彩评论