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.
Asked
Active
Viewed 682 times
0
-
the tmp folder has a limit usually 2GB, try df -h to see it – Elzo Valugi Jan 18 '12 at 12:15
1 Answers
1
Check your slow query log for a long running query on table. Make sure other process like "backup" isn't interrupting it!!
axe
- 11
- 2