Versão funcional para MySQL #1
Description
Versão funcional no MySQL 8.0.42
SELECT
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS ObjectName,
TABLE_ROWS AS TotalRows,
ROUND(DATA_LENGTH / 1024 / 1024, 2) AS DataMB,
ROUND(INDEX_LENGTH / 1024 / 1024, 2) AS IndexMB,
ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS TotalMB
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA NOT IN ('mysql', 'information_schema', 'performance_schema', 'sys')
ORDER BY
TotalMB DESC;