Bug #43660 SHOW INDEXES/ANALYZE does NOT update cardinality for indexes of InnoDB table
Submitted: 15 Mar 2009 17:49 Modified: 18 Jun 2010 22:57
Reporter: Valeriy Kravchuk Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:4.1.26, 5.0.60, 5.1.33-bzr OS:Any
Assigned to: Vasil Dimov CPU Architecture:Any

File: Maximum allowed size is 50MB.

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[7 Apr 2009 11:35] Sergey Vojtovich
A patch introducing new innodb_cardinality_algorithm option.

Attachment: innodb_cardinality_algorithm.patch (text/x-patch), 4.38 KiB.

[8 Apr 2009 13:03] Vasil Dimov
Patch for 5.1

Attachment: bug43660-5.1.diff (application/octet-stream, text), 6.37 KiB.

[9 Apr 2009 12:29] Sergey Vojtovich
A 5.0 backport of patch proposed by Vasil.

Attachment: innodb_cardinality_algorithm.patch (text/x-patch), 7.11 KiB.