こういうかんじ:
mysql> select table_name, table_rows, avg_row_length, (data_length + index_length) / 1024 / 1024 as total_mb, data_length / 1024 / 1024 as data_mb, index_length / 1024 / 1024 as index_mb from information_schema.tables where table_schema = '...'; +---------------------------------+------------+----------------+----------+---------+----------+ | table_name | table_rows | avg_row_length | total_mb | data_mb | index_mb | +---------------------------------+------------+----------------+----------+---------+----------+ | foo | 10224 | 350 | 6 | 3 | 3 | | bar | 391760 | 274 | 102 | 102 | 0 | +---------------------------------+------------+----------------+----------+---------+----------+ 2 rows in set (0.01 sec)
