I am running an alter statement on a very large table.

show processlist shows the state as "Repair by sorting".

Is there a way to see the status, or get an estimate of how much work has been completed/remaining?


1 Answer 1


Repair by sorting is a phase that creates a temp table, populates a temp index file, and prepares all indexes for the target. This would require being in the operating system to view the temp file's size as well as the data and time stamp.

If you ever need to see such progress, there are two things you can do

Other than these suggestions, there is nothing else you can do.

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.