SQL para obtener el tamaño de las tablas de MySQL ordena por size.
SELECT ROUND((t.DATA_LENGTH)/POW(1024,3),3) AS data_sizeGB,
ROUND((t.INDEX_LENGTH)/POW(1024,3),3) AS index_sizeGB,
ROUND((t.DATA_LENGTH+t.INDEX_LENGTH)/POW(1024,3),3) AS used_sizeGB,
ROUND((t.DATA_FREE)/POW(1024,3),3) AS free_sizeGB,
ROUND((t.DATA_LENGTH+t.INDEX_LENGTH+t.DATA_FREE)/POW(1024,3),3) AS total_sizeGB,
t.*
FROM information_schema.`TABLES` AS t
WHERE 1
AND t.TABLE_SCHEMA=DATABASE()
AND t.TABLE_TYPE='BASE TABLE'
ORDER BY used_sizeGB DESC;Resumen del Size de la base MySQL
SELECT ROUND(SUM(t.DATA_LENGTH+t.INDEX_LENGTH)/POW(1024,3),3) AS used_sizeGB,
ROUND(SUM(t.DATA_FREE)/POW(1024,3),3) AS free_sizeGB,
ROUND(SUM(t.DATA_LENGTH+t.INDEX_LENGTH+t.DATA_FREE)/POW(1024,3),3) AS total_sizeGB
FROM information_schema.`TABLES` AS t
WHERE 1
AND t.TABLE_SCHEMA=DATABASE()
AND t.TABLE_TYPE='BASE TABLE';