[Mysql] データベースのテーブル別利用状況を調べるコマンド
SELECT
table_name,
engine,
data_length / 1024 / 1024 AS data_mb,
data_free / 1024 / 1024 AS free_mb
FROM information_schema.tables
WHERE table_schema = 'leo';
SELECT
table_name,
engine,
data_length / 1024 / 1024 AS data_mb,
data_free / 1024 / 1024 AS free_mb
FROM information_schema.tables
WHERE table_schema = 'leo';