查询mysql数据库大小

select concat(round(sum(data_length/1024/1024),2),'MB') as data from information_schema.`TABLES`;

select * from (
  select table_schema, concat(round(sum(data_length/1024/1024),2),'MB') as dataSize from information_schema.`TABLES` GROUP BY table_schema ) t
    where t.dataSize > 1 order by t.dataSize desc
;


select * from (
  select table_schema, round(sum(data_length/1024/1024),2) as dataSize from information_schema.`TABLES` GROUP BY table_schema ) t
    where t.dataSize > 1 order by t.dataSize desc
;