Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question
up vote 4 down vote accepted

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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