查询mysql所有表的大小_MySQL

先用

use information_schema;

SELECT sum(DATA_LENGTH+INDEX_LENGTH) as size,table_name FROM tables where table_schema='数据库名' group by table_name order by size desc;

哪些表数据量大就一目了然了噢