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?
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. It only takes a minute to sign up.Sign up to join this community
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.