OK I was adding an index to a table, and I checked on progress using show processlist and under state it output Repair by sorting.

From the MySQL docs:

Repair by sorting

The repair code is using a sort to create indexes.

So what is the 'repair code'? Did something break?

1 Answer 1


Nothing broke, it's just part of the process of rebuilding indexes on a table. This can take quite a while on very large tables.

  • +1 !!! This also includes the dreaded 'Repair by keycache' if sort buffers are not large enough for 'Repair by sorting' to complete. Commented May 18, 2011 at 2:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.