MySQLでディスクの使用状況を確認するSQL

データベースのディスク使用状況確認

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;