2019-03-12 16:02:27 146次浏览
select sum(DATA_LENGTH)+sum(INDEX_LENGTH) from information_schema.tables where table_schema=’cacti’;
use information_schema;
select concat(round(sum(DATA_LENGTH/1024/1024),2),’M’) from tables where table_schema=’数据库名称’ AND table_name=’表名’;
所有内容来及个人经验和互联网摘取，如有雷同纯属巧合，如有冒犯，欢迎留言，分享即快乐，感谢互联网中每一位懂得分享的ituser！QQ群：127331971(备注:ituser.cn)
