MySQLの運用で役立つコマンド集 - QiitaSELECT TABLE_SCHEMA, round( sum( DATA_LENGTH ) / ( 1024 * 1024 ) , 2 ) AS DATA_SIZE, round( sum( INDEX_LENGTH ) / ( 1024 * 1024 ) , 2 ) AS INDEX_SIZE, round( round( sum( DATA_LENGTH ) + sum( INDEX_LENGTH ) ) / ( 1024 *1024 ) , 2 ) AS TOTAL_SIZE FROM information_schema.TABLES GROUP BY TABLE_SCHEMA ORDER BY TOTAL_SIZE DESC;
