查看MySQL表占用空间大小

最新推荐文章于 2024-07-21 03:21:53 发布

weixin_34216196

最新推荐文章于 2024-07-21 03:21:53 发布

阅读量49

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/heartdong/blog/123861

版权

2019独角兽企业重金招聘Python工程师标准>>>

mysql> use information_schema; 
Database changed

mysql>  select data_length,index_length  
    ->  from tables where  
    ->  table_schema='allot'  
    ->  and table_name = 'AllotBaseInfo'; 
+-------------+--------------+
| data_length | index_length |
+-------------+--------------+
|    61104190 |            0 |
+-------------+--------------+
1 row in set (0.00 sec)

转换为MB

mysql> select concat(round(sum(data_length/1024/1024),2),'MB') as data_length_MB,
    -> concat(round(sum(index_length/1024/1024),2),'MB') as index_length_MB   
    -> from tables where   
    -> table_schema='allot'   
    -> and table_name = 'AllotBaseInfo'; 
+----------------+-----------------+ 
| data_length_MB | index_length_MB | 
+----------------+-----------------+ 
| 58.27MB        | 0.00MB          | 
+----------------+-----------------+ 
1 row in set (0.55 sec)

转载于:https://my.oschina.net/heartdong/blog/123861