Bug #97543 imprecise info on innodb file sizes
Submitted: 7 Nov 2019 22:31 Modified: 18 Nov 2019 16:12
Reporter: Rick James Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6, 5.7, 8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: documentation, innodb

[7 Nov 2019 22:31] Rick James 
Description:
On https://dev.mysql.com/doc/refman/5.6/en/tables-table.html

"For InnoDB, DATA_LENGTH is the approximate amount of memory allocated for the clustered index, in bytes."  (Ditto for INDEX_LENGTH)

* My experience has been that Data_length and Index_length have always reflected the exact amount of space involved on the disk for the table.

* The sentence refers to "file" space, not "memory".

How to repeat:
N/A
[7 Nov 2019 22:38] MySQL Verification Team 
Thank you for the bug report.
[18 Nov 2019 16:12] Daniel Price 
Posted by developer:
 
The referenced content has been corrected. The change should appear online soon.

Thank you for the bug report.