标签： data

SELECT TABLE_NAME AS "Tables",
TABLE_ROWS AS "Rows",
round(((data_length) / 1024 / 1024), 2) AS "Data (MB)",
round(((index_length) / 1024 / 1024), 2) AS "Index (MB)"
FROM information_schema.TABLES
WHERE table_schema = "database_name"
ORDER BY (data_length + index_length) DESC;

SELECT table_name AS "Tables", TABLE_ROWS AS "Rows", round(((data_length) / 1024 / 1024), 2) AS "Data (MB)", round(((index_length) / 1024 / 1024), 2) AS "Index (MB)" FROM information_schema.TABLES WHERE table_schema = "database_name" ORDER BY (data_length + index_length) DESC;