代码改变世界

Mysql查询数据量大小

2022-10-20 11:28  假面Wilson  阅读(202)  评论(0)  编辑  收藏  举报 
--按实例
SELECT CONCAT(round(sum(DATA_LENGTH/1024/1024/1024),2),"GB") as datazise FROM information_schema.TABLES
--按库
SELECT table_schema,CONCAT(round(sum(DATA_LENGTH/1024/1024/1024),2),"GB") as datazise FROM information_schema.TABLES GROUP BY table_schema;
--按表
SELECT table_schema,table_name,CONCAT(round(sum(DATA_LENGTH/1024/1024),2),"MB") as datazise FROM information_schema.TABLES GROUP BY table_schema,table_name;