MySQL如何统计数据库及数据库中表大小,大部分程序员都收藏了...
953人浏览 2023-10-23 14:51:31

统计指定数据库大小
SELECT TABLE_SCHEMA ,CONCAT(ROUND(SUM(DATA_LENGTH/1024/1024),2),'M') AS 'DATA_LENGTH_MB' ,CONCAT(ROUND(SUM(INDEX_LENGTH/1024/1024),2),'M') AS 'INDEX_LENGTH_MB' ,CONCAT(ROUND(SUM(DATA_LENGTH/1024/1024)+SUM(INDEX_LENGTH/1024/1024),2),'M') AS 'TOTAL_LENGTH_MB' FROM information_schema.tables WHERE table_schema='kcms';
执行效果:

查询指定数据库下各表大小
SELECT TABLE_SCHEMA ,CONCAT(ROUND(SUM(DATA_LENGTH/1024/1024),2),'M') AS 'DATA_LENGTH_MB' ,CONCAT(ROUND(SUM(INDEX_LENGTH/1024/1024),2),'M') AS 'INDEX_LENGTH_MB' ,CONCAT(ROUND(SUM(DATA_LENGTH/1024/1024)+SUM(INDEX_LENGTH/1024/1024),2),'M') AS 'TOTAL_LENGTH_MB' FROM information_schema.tables WHERE table_schema='kcms';
执行效果:

相关推荐
-
mysqldump备份操作大全及相关参数详解2023-10-23 15:39:38
-
Java,MySQL,主备复制原理,Canal,实现数据异构,Demo案例
Java,MySQL,主备复制原理,Canal,实现数据异构,Demo案例2023-10-23 15:39:26 -
MySQL事务控制和锁定语句2023-10-23 15:37:22
-
MYSQL 登录与退出,查看当前数据库2023-10-23 15:37:06
-
MySQL常用图形管理工具有哪些?2023-10-23 15:32:26