检查集群资源使用状态

obclient > SELECT t1.svr_ip, t1.svr_port, t1.zone, t2.with_rootserver, t1.cpu_total, t1.cpu_assigned cpu_ass, t1.cpu_assigned_percent cpu_ass_pct, round(t1.mem_total/1024/1024/1024,1) "mem_total(G)", round(t1.mem_assigned/1024/1024/1024,1) "mem_ass(G)", t1.mem_assigned_percent mem_ass_pct, t1.unit_num  FROM __all_virtual_server_stat t1 JOIN __all_server t2 ON (t1.svr_ip=t2.svr_ip) ORDER BY zone;
+----------+----------+-------+-----------------+-----------+---------+-------------+--------------+------------+-------------+----------+
| svr_ip   | svr_port | zone  | with_rootserver | cpu_total | cpu_ass | cpu_ass_pct | mem_total(G) | mem_ass(G) | mem_ass_pct | unit_num |
+----------+----------+-------+-----------------+-----------+---------+-------------+--------------+------------+-------------+----------+
| 10.0.0.1 |     7702 | zone1 |               1 |        22 |     8.5 |          38 |         25.1 |       21.3 |          84 |        3 |
| 10.0.0.2 |     7702 | zone2 |               0 |        22 |     8.5 |          38 |         25.1 |       21.3 |          84 |        3 |
| 10.0.0.3 |     7702 | zone3 |               0 |        22 |     8.5 |          38 |         25.1 |       21.3 |          84 |        3 |
+---------------+----------+-------+-----------------+-----------+---------+-------------+--------------+------------+-------------+----------+
3 rows in set