use information_schema;
select concat(round(sum(data_length/1024/1024), 2), 'mb') as data from tables;
select concat(round(sum(data_length/1024/1024), 2), 'mb') as data from tables where table_schema='dbname';
select table_schema,table_name,table_rows,data_length/1024/1024 from tables where table_schema='dbname'
记录