mysql> SELECT Data_length,Index_length,TABLE_NAME,TABLE_SCHEMA FROM information_schema.tables where TABLE_SCHEMA = "dbt2"; +-------------+--------------+------------+--------------+ | Data_length | Index_length | TABLE_NAME | TABLE_SCHEMA | +-------------+--------------+------------+--------------+ | 200081408 | 23724032 | customer | dbt2 | | 16384 | 0 | district | dbt2 | | 25755648 | 0 | history | dbt2 | | 11026432 | 0 | item | dbt2 | | 3686400 | 0 | new_order | dbt2 | | 272580608 | 0 | order_line | dbt2 | | 18415616 | 14204928 | orders | dbt2 | | 381648896 | 0 | stock | dbt2 | | 16384 | 0 | warehouse | dbt2 | +-------------+--------------+------------+--------------+
参考
http://q.hatena.ne.jp/1283251244
http://dev.mysql.com/doc/refman/5.1/ja/tables-table.html