MySQLで各テーブルごとのサイズを確認するクエリ

SELECT  
    table_name, engine, table_rows AS tbl_rows,
    avg_row_length,  
    floor((data_length+index_length)/1024/1024/1024) AS all_gb,
    floor((data_length)/1024/1024/1024) AS data_gb,
    floor((index_length)/1024/1024/1024) AS idx_gb 
FROM 
    information_schema.tables  
WHERE
    table_schema=database()  
ORDER BY
    (DATA_LENGTH+INDEX_LENGTH) DESC;