php获取mysql大小

 

查看指定数据库大小： 

SELECT sum(DATA_LENGTH)+sum(INDEX_LENGTH) FROM information_schema.TABLES where 

 

TABLE_SCHEMA='数据库名'; 

得到的结果是以字节为单位，除1024为K，除1048576(=1024*1024)为M

转载于:https://www.cnblogs.com/legend-song/p/3454155.html