mysql查看数据库数据量大小

查看整个库的大小

SELECT CONCAT(round(sum(DATA_LENGTH/1024/1024),2),"MB") as datazise FROM information_schema.TABLES;

 

查看数据库abc的大小

SELECT CONCAT(round(sum(DATA_LENGTH/1024/1024),2),"MB") as datazise FROM information_schema.TABLES WHERE table_schema="abc";

 

查看abc库中的df表大小

SELECT CONCAT(round(sum(DATA_LENGTH/1024/1024),2),"MB") as datazise FROM information_schema.TABLES WHERE table_schema="abc" and table_name="df";