MySQL查看表占用空间大小

搬家后的博客链接: IT客栈 www.itkezhan.org

1. //查看的MySQL自带管理库:information_schema
2. //例如要查的数据库是:test
3. //例如要查的表是test数据库中的bikes

1. mysql> use information_schema;  
2. Database changed  
3. mysql> select data_length,index_length  
4.     -> from tables where  
5.     -> table_schema='test'  
6.     -> and table_name = 'bikes';  
7. +----------------+------------------+  
8. | data_length | index_length |  
9. +----------------+------------------+  
10. | 166379520 |   235782144 |  
11. +----------------+------------------+  
12. 1 row in set (0.02 sec)  
13.   
14. mysql> select concat(round(sum(data_length/1024/1024),2),'MB') as data_length_MB,  
15.     -> concat(round(sum(index_length/1024/1024),2),'MB') as index_length_MB  
16.     -> from tables where  
17.     -> table_schema='test'  
18.     -> and table_name = 'bikes';  
19. +-----------------------+------------------------+  
20. | data_length_MB | index_length_MB |  
21. +-----------------------+------------------------+  
22. |      158.67MB      |      224.86MB        |  
23. +-----------------------+------------------------+  
24. 1 row in set (0.03 sec)