sql语句查看MySQL数据库大小
+---------------------------------------+-------+-------+-------+------------+---------+| CONCAT(table_schema, '.', table_name) | rows| DATA| idx | total_size | idxfrac |
+---------------------------------------+-------+-------+-------+------------+---------+
| zabbix.history_uint | 1.97M | 0.12G | 0.05G | 0.17G | 0.44 |
| zabbix.history | 1.60M | 0.09G | 0.04G | 0.13G | 0.47 |
| XX_Mobile.banklisttest | 0.06M | 0.01G | 0.00G | 0.01G | 0.00 |
| zabbix.events | 0.03M | 0.00G | 0.00G | 0.01G | 1.60 |
| XXXXfenxiao.pigcms_wechat_group_list| 0.04M | 0.00G | 0.00G | 0.00G | 0.15 |
| XXXXfenxiao.pigcms_behavior | 0.03M | 0.00G | 0.00G | 0.00G | 0.60 |
| b2b.ecs_stats | 0.05M | 0.00G | 0.00G | 0.00G | 0.13 |
| XX_Mobile.create_sn | 0.02M | 0.00G | 0.00G | 0.00G | 0.58 |
| b2b.ecs_goods | 0.00M | 0.00G | 0.00G | 0.00G | 0.04 |
| zabbix.trends_uint | 0.02M | 0.00G | 0.00G | 0.00G | 0.00 |
+---------------------------------------+-------+-------+-------+------------+---------+
10 rows in set (0.14 sec)
页:
[1]