WL#2629: SHOW TABLE STATUS: Include InnoDB index info
Affects: Server-7.1
—
Status: Assigned
InnoDB computes the sum of index sizes in ha_innobase::info(), so that SHOW TABLE STATUS can show the space consumption by index. And ... In INFORMATION_SCHEMA.TABLE_COMMENT, the amount of free space is appended to the regular comment. For example: mysql> create table tmo (s1 int) comment '!!' engine=innodb; Query OK, 0 rows affected (0.01 sec) mysql> select table_comment from information_schema.tables where table_name = 'tmo'; +--------------------------+ | table_comment | +--------------------------+ | !!; InnoDB free: 4096 kB | +--------------------------+ 1 row in set (0.00 sec) This information could appear instead in SHOW TABLE STATUS, and in INFORMATION_SCHEMA.TABLES, as a separate column. Gluh has suggested the name EXTRA for this column. See also BUG#11379.
Copyright (c) 2000, 2024, Oracle Corporation and/or its affiliates. All rights reserved.