MySQL查看表占用空间大小 [转]

最新推荐文章于 2024-02-19 10:00:00 发布

Goith

最新推荐文章于 2024-02-19 10:00:00 发布

阅读量243

点赞数

分类专栏：数据库\mysql

本文链接：https://blog.csdn.net/gaoce227/article/details/72785147

版权

数据库\mysql 专栏收录该内容

37 篇文章 0 订阅

订阅专栏

01      //先进去MySQL自带管理库：information_schema  
02	//自己的数据库：test_database  
03	//自己的表：test_table 
04	   
05	mysql> use information_schema; 
06	Database changed 
07	mysql> select data_length,index_length 
08	    -> from tables where 
09	    -> table_schema='test_database' 
10	    -> and table_name = 'test_table'; 
11	+-------------+--------------+ 
12	| data_length | index_length | 
13	+-------------+--------------+ 
14	|   166379520 |    235782144 | 
15	+-------------+--------------+ 
16	1 row in set (0.02 sec) 
17	   
18	mysql> select concat(round(sum(data_length/1024/1024),2),'MB') as data_length_MB, 
19	    -> concat(round(sum(index_length/1024/1024),2),'MB') as index_length_MB 
20	    -> from tables where 
21	    -> table_schema='test_database' 
22	    -> and table_name = 'test_table'; 
23	+----------------+-----------------+ 
24	| data_length_MB | index_length_MB | 
25	+----------------+-----------------+ 
26	| 158.67MB       | 224.86MB        | 
27	+----------------+-----------------+ 
28	1 row in set (0.03 sec)