mysql查看数据库中各个表的大小

SELECT
TABLE_NAME,
TABLE_ROWS,
(DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024 AS weight,
DATA_LENGTH,
DATA_LENGTH + INDEX_LENGTH
FROM
information_schema. TABLES
WHERE
TABLE_SCHEMA = ‘ebook’
ORDER BY
weight DESC,
table_rows DESC;