查看数据库中表占用空间

1. 先进去MySQL自带管理库：information_schema
2. 自己的数据库：v3_log
3. 自己的表：v3order_assign_logistics_history

mysql> use information_schema;
Database changed
mysql> select data_length,index_length from tables where
table_schema=’v3_log’ and table_name =
‘v3order_assign_logistics_history’;
+————-+————–+
| data_length | index_length |
+————-+————–+
| 2894069760 | 221339648 |
+————-+————–+
row in set (0.02 sec)

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=’v3_log’ and table_name =
‘v3order_assign_logistics_history’;
+————-+————–+
| data_length | index_length |
+————-+————–+
| 2894069760 | 221339648 |
+————-+————–+
row in set (0.02 sec)