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)