查看当前时间
代码语言：javascript复制mysql> show @@time.current;
---------------
| TIMESTAMP |
---------------
| 1457440508666 |
---------------
1 row in set (0.00 sec)
mysql> 查看启动时间
代码语言：javascript复制mysql> show @@time.startup;
---------------
| TIMESTAMP |
---------------
| 1457439259286 |
---------------
1 row in set (0.00 sec)
mysql> Note: 这个时间是以ms为单位的Unix时间
查看当前版本
代码语言：javascript复制mysql> show @@version;
-----------------------------------
| VERSION |
-----------------------------------
| 5.5.8-mycat-1.5-GA-20160217103036 |
-----------------------------------
1 row in set (0.00 sec)
mysql> 查看系统状态
代码语言：javascript复制mysql> show @@server;
--------------- ------------- -------------- ------------ --------------- --------------- --------- -------- -----------------------
| UPTIME | USED_MEMORY | TOTAL_MEMORY | MAX_MEMORY | RELOAD_TIME | ROLLBACK_TIME | CHARSET | STATUS | AVG_BUFPOOL_ITEM_SIZE |
--------------- ------------- -------------- ------------ --------------- --------------- --------- -------- -----------------------
| 25m 18s 521ms | 11423568 | 129499136 | 477102080 | 1457439259286 | -1 | utf8 | ON | 873 |
--------------- ------------- -------------- ------------ --------------- --------------- --------- -------- -----------------------
1 row in set (0.00 sec)
mysql> 查看线程池
代码语言：javascript复制mysql> show @@threadpool ;
------------------ ----------- -------------- ----------------- ---------------- ------------
| NAME | POOL_SIZE | ACTIVE_COUNT | TASK_QUEUE_SIZE | COMPLETED_TASK | TOTAL_TASK |
------------------ ----------- -------------- ----------------- ---------------- ------------
| Timer | 2 | 0 | 0 | 3304 | 3304 |
| BusinessExecutor | 4 | 0 | 0 | 2024 | 2024 |
------------------ ----------- -------------- ----------------- ---------------- ------------
2 rows in set (0.00 sec)
mysql> 
