查看mysql数据库空间大小

最新推荐文章于 2023-12-08 15:08:39 发布

Miraya

最新推荐文章于 2023-12-08 15:08:39 发布

阅读量767

点赞数

分类专栏： mysql python 文章标签：数据库 mysql table schema byte

本文链接：https://blog.csdn.net/Miraya/article/details/6249917

版权

python 同时被 2 个专栏收录

5 篇文章 0 订阅

订阅专栏

mysql

1 篇文章 0 订阅

订阅专栏

今天客户要他的数据库的大小统计信息，我网上搜了一下，果然有好方法：



进入information_schema数据库;



执行：



SELECT CONCAT(table_schema,'.',table_name) AS 'Table Name', 



CONCAT(ROUND(table_rows/10000,2),' 万') AS 'Number of Rows', 



CONCAT(ROUND(data_length/(1024*1024),2),' MB') AS 'Data Size', 



CONCAT(ROUND(index_length/(1024*1024),2),' MB') AS 'Index Size' , 



CONCAT(ROUND((data_length+index_length)/(1024*1024),2),' MB') AS 'Total', 



CONCAT(AVG_ROW_LENGTH,' Byte') As 'Row_Length'



FROM information_schema.TABLES WHERE table_schema LIKE 'DB_NAME'; 







eg:







SELECT CONCAT(table_schema,'.',table_name) AS 'Table Name', 



CONCAT(ROUND(table_rows/10000,2),' 万') AS 'Number of Rows', 



CONCAT(ROUND(data_length/(1024*1024),2),' MB') AS 'Data Size', 



CONCAT(ROUND(index_length/(1024*1024),2),' MB') AS 'Index Size' , 



CONCAT(ROUND((data_length+index_length)/(1024*1024),2),' MB') AS 'Total', 



CONCAT(AVG_ROW_LENGTH,' Byte') As 'Row_Length' 



FROM information_schema.TABLES WHERE table_schema LIKE 'myshowcn';



执行结果：