データベースのディスク使用状況確認
SELECT
FORMAT(SUM(data_length + index_length + data_free), 0)
FROM
information_schema.tables
WHERE
table_schema=database();
テーブル毎にディスク使用状況を確認する
SELECT
table_name
, engine
, FORMAT(table_rows, 0) AS table_rows
, FORMAT(avg_row_length, 0) AS avg_row_length
, FORMAT(data_length, 0) AS data_Byte
, FORMAT(index_length, 0) AS index_Byte
, FORMAT(data_free, 0) AS data_free_Byte
, FORMAT((data_length + index_length + data_free), 0) AS all_Byte
FROM
information_schema.tables
WHERE
table_schema=database()
ORDER BY
(data_length + index_length + data_free) DESC;