查看mysql数据库的表大小

SELECT table_name AS '表名', round(((data_length + index_length) / 1024 / 1024), 2) AS '大小(MB)'
FROM information_schema.tables
WHERE table_schema = '数据库名'
ORDER BY (data_length + index_length) DESC;

mysql -u 用户名 -p

use 数据库名;

SELECT table_name AS '表名', round(((data_length + index_length) / 1024 / 1024), 2) AS '大小(MB)'
FROM information_schema.tables
ORDER BY (data_length + index_length) DESC;