MySQL Bugs: #3865: analyze table way too slow

Bug #3865	analyze table way too slow
Submitted:	23 May 2004 8:05	Modified:	26 Jul 2009 11:29
Reporter:	Dale Johnson	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: MyISAM storage engine	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
I would be nice if this would not do a full table scan, but instead to sample.  For the big tables where analyze matters most, it is almost prohibitively slow.

How to repeat:
for tables larger than 1Gb, this is very slow.

Suggested fix:
use random sampling techinique to review index value distributions

This is a duplicate of (later but already reviewed and affecting customers) bug #32712.