Search code examples
mysqlmyisamcorruptionrepair

Repairing a Large MyISAM Datafile


I have a 54GB myisam file which reports a corrupt index file. Attempting to repair the file takes too long and stops running midway. What is the fastest way to repair this file and ensure it completes?


Solution

  • We finally resolved this problem by using the 5.1 version of myisamchk. It appears the 5.6 version has a bug related to inability to repair files larger than 4G.

    REF: https://bugs.mysql.com/bug.php?id=69839