zl程序教程

您现在的位置是:首页 >  其他

当前栏目

Mycat 管理命令3

2023-03-31 10:28:51 时间

查看当前时间

mysql> show @@time.current;
+---------------+
| TIMESTAMP     |
+---------------+
| 1457440508666 |
+---------------+
1 row in set (0.00 sec)

mysql> 

查看启动时间

mysql> show @@time.startup;
+---------------+
| TIMESTAMP     |
+---------------+
| 1457439259286 |
+---------------+
1 row in set (0.00 sec)

mysql> 

Note: 这个时间是以ms为单位的Unix时间


查看当前版本

mysql> show @@version;
+-----------------------------------+
| VERSION                           |
+-----------------------------------+
| 5.5.8-mycat-1.5-GA-20160217103036 |
+-----------------------------------+
1 row in set (0.00 sec)

mysql> 

查看系统状态

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> 

查看线程池

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>