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

[23 May 2004 8:05] Dale Johnson
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
[26 Jul 2009 11:29] Valeriy Kravchuk
This is a duplicate of (later but already reviewed and affecting customers) bug #32712.