うまいぼうぶろぐ

linuxとhttpdとperlのメモ

mysql の table size確認

次のどっちかでいけそ?

mysql> SHOW TABLE STATUS;
mysql> USE information_schema;
mysql> SELECT table_schema,SUM(data_length) FROM information_schema.tables Group By table_schema ORDER BY SUM(data_length);