Mysql Data Table repair command

One day, a data table in a database is being deleted, and a sudden power failure occurs. After the server restarts, it continues to run the DELETE command. The following error occurs:

Mysql> Delete from Table1 where ymd <= 20091031;
Error 126 (hy000): Incorrect key file for table './db1/table1.myi'; try to repair it

 

# Myisamchk-r/var/lib/MySQL/db1/table1.myi
Report that the repair is successful, but an error occurs after executing the DELETE command;

 

Mysql> repair table Table1;
The fix is successful. Run the DELETE command OK;

It is strange that we have not had time to study why, so we should record it first.