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;
哪些表数据量大就一目了然了噢