Description:
Both "SHOW TABLE STATUS" and INFORMATION_SCHEMA.TABLES does not report table sizes correctly for compressed tables, e.g.:
mysql> select table_name,create_options, data_length from information_schema.tables where table_name like '%compr%';
+--------------+----------------------------------------+-------------+
| table_name | create_options | data_length |
+--------------+----------------------------------------+-------------+
| compressed | row_format=COMPRESSED KEY_BLOCK_SIZE=4 | 88883200 |
| uncompressed | | 39403520 |
+--------------+----------------------------------------+-------------+
2 rows in set (0.00 sec)
mysql> show table status like '%compr%';
+--------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------------------------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+--------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------------------------------+---------+
| compressed | InnoDB | 10 | Compressed | 998529 | 89 | 88883200 | 0 | 0 | 1835008 | NULL | 2011-07-20 14:52:45 | NULL | NULL | latin1_swedish_ci | NULL | row_format=COMPRESSED KEY_BLOCK_SIZE=4 | |
| uncompressed | InnoDB | 10 | Compact | 1000392 | 39 | 39403520 | 0 | 0 | 7340032 | NULL | 2011-07-20 14:52:17 | NULL | NULL | latin1_swedish_ci | NULL | | |
+--------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------------------------------+---------+
Whereas on disk:
# du -sh *compr*ibd
24M compressed.ibd
48M uncompressed.ibd
How to repeat:
create a table with data that compresses ok'ish, check space on disk vs space reported, yay, broken.
Suggested fix:
show correct data
