myisamchk and tmd file during repair of table
Posted by: Guy Lacroix
Date: March 16, 2015 08:14PM


Using MySQL 4.1 on CentOS 4.7.

I have a large table (150G) with a corrupted index MYI file. I get the errno 145 when i try to select the table.

Whenever i try to repair the table using repair table or myisamchk, the TMD file grows too big and fills up the disk.

Is there a way to re-direct the TMD file to another filesystem during the repair? If i had enough room to accommodate the MYD and the TMD in the same FS, i would be ok but that option is not available.

Any info or ideas would be appreciated.



Options: ReplyQuote

Written By
myisamchk and tmd file during repair of table
March 16, 2015 08:14PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.