Checking Database Table Size - ben600324/wiki GitHub Wiki
SELECT
TABLE_NAME AS Table
,
ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS Size (MB)
FROM information_schema.TABLES
ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC;
SELECT
TABLE_NAME AS Table
,
ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS Size (MB)
FROM information_schema.TABLES
ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC;