Bug #3926 Progress of ALTER TABLE ENABLE KEYS
Submitted: 28 May 2004 14:08 Modified: 12 Dec 2005 13:26
Reporter: Mirza Hadzic Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[28 May 2004 14:08] Mirza Hadzic
Description:
Single call to ALTER TABLE t ENABLE KEYS usualy takes hours in my case (depends on table size, can also take days). It would be cool to get somehow info on percentage of indicies already re-constructed (in separate thread or call-back), so I can display it to the end-user.

How to repeat:
ALTER TABLE t ENABLE KEYS
[12 Dec 2005 13:26] Valeriy Kravchuk
Thank you for a feature request. You pointed out only one of the long-running statements. I believe, that for any statement that works more than, say, 10 seconds, there should be a way to monitor it's progress. Oracle has similar feature for all it's internal long-running processes. So, I think, it will be useful to add something similar in future versions of MySQL 5. But it is not a simple thing to do, so don't expect it to be implemented soon.
[21 Jul 2008 7:38] MySQL Verification Team
See patch at http://jcole.us/blog/archives/2007/02/08/progress-in-mysql-process-list/