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
;
查询mysql数据库大小
最新推荐文章于 2024-04-13 12:16:19 发布