MySQL Bugs: #48941: feature request for online optimize/analyze table for myisam tables

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:	None
Category:	MySQL Server: MyISAM storage engine	Severity:	S4 (Feature request)
Version:	5.x, 6.x	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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:
http://forge.mysql.com/worklog/task.php?id=2708