select table_name, table_comment, table_rows, avg_row_length, round((data_length + index_length)/1024/1024) as total_size_MB, -- 合計サイズ round(data_length/1024/1024) as data_size_MB, -- データサイズ round(index_length/1024/1024) as index_size_MB -- インデックスサイズ from INFORMATION_SCHEMA.TABLES where table_schema = 'データベース名' order by total_size_MB desc, data_size_MB desc, index_size_MB desc, table_name