Bug #48941 feature request for online optimize/analyze table for myisam tables
Submitted: 20 Nov 2009 12:35
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: MyISAM storage engine Severity:S4 (Feature request)
Version:5.x, 6.x OS:Any
Assigned to: CPU Architecture:Any

[20 Nov 2009 12:35] Shane Bester
currently optimize table and analyze table are not performed in a truly online fashion, and this causes reads/writes to be blocked.   this is a feature request to make this optimize/analyze table online so that no blocking occurs.

How to repeat:
try read/write from a table while optimize/analyze is running.

Suggested fix:
optimize/analyze table could be implemented similar to this: