1.关于mysql空间使⽤率的查询:
1.1 查看所有数据库所占磁盘空间⼤⼩:
select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from information_schema.TABLES 1.2 查看数据库中指定库(udb)的⼤⼩:
select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from information_schema.TABLES where table_schema='udb'
因篇幅问题不能全部显示,请点此查看更多更全内容