SELECT
table_name,
data_length,
index_length,
( data_length + index_length ) AS length,
table_rows,
concat( round( ( DATA_LENGTH + INDEX_LENGTH ) / 1024 / 1024, 3 ), 'Mb' ) AS total_size
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA = '数据库名称'
ORDER BY
table_rows DESC