提供了编程的基础技术教程

zl程序教程

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

当前栏目

Mycat 管理命令10

命令
2023-03-31 10:28:59 时间

强制断开连接

mysql> show @@connection;
+------------+------+-----------------+------+------------+------+--------+---------+--------+---------+---------------+-------------+------------+---------+------------+
| PROCESSOR  | ID   | HOST            | PORT | LOCAL_PORT | USER | SCHEMA | CHARSET | NET_IN | NET_OUT | ALIVE_TIME(S) | RECV_BUFFER | SEND_QUEUE | txlevel | autocommit |
+------------+------+-----------------+------+------------+------+--------+---------+--------+---------+---------------+-------------+------------+---------+------------+
| Processor1 |    1 | 192.168.100.102 | 9066 |      43190 | cc   | NULL   | utf8:45 |   1998 |  143920 |          4021 |       40960 |          0 |         |            |
| Processor1 |    3 | 192.168.100.102 | 8066 |      33145 | cc   | cctest | utf8:45 |    603 |    3621 |          1863 |       40960 |          0 | 3       | true       |
+------------+------+-----------------+------+------------+------+--------+---------+--------+---------+---------------+-------------+------------+---------+------------+
2 rows in set (0.00 sec)

mysql> kill @@connection 3;
Query OK, 1 row affected (0.00 sec)

mysql> show @@connection;
+------------+------+-----------------+------+------------+------+--------+---------+--------+---------+---------------+-------------+------------+---------+------------+
| PROCESSOR  | ID   | HOST            | PORT | LOCAL_PORT | USER | SCHEMA | CHARSET | NET_IN | NET_OUT | ALIVE_TIME(S) | RECV_BUFFER | SEND_QUEUE | txlevel | autocommit |
+------------+------+-----------------+------+------------+------+--------+---------+--------+---------+---------------+-------------+------------+---------+------------+
| Processor1 |    1 | 192.168.100.102 | 9066 |      43190 | cc   | NULL   | utf8:45 |   2044 |  144628 |          4046 |       40960 |          0 |         |            |
+------------+------+-----------------+------+------------+------+--------+---------+--------+---------+---------------+-------------+------------+---------+------------+
1 row in set (0.01 sec)

mysql>

重载配置

mysql> reload @@config;
Query OK, 1 row affected (0.15 sec)
Reload config success

mysql>

重载的是 schema.xml 配置

重置SQL统计

mysql> reload @@user_stat;
Query OK, 1 row affected (0.03 sec)
Reset show @@sql  @@sql.sum @@sql.slow success

mysql> show @@sql;
Empty set (0.00 sec)

mysql> show @@sql.sum;
+------+------+------+------+------+------+--------------+--------------+-----------+
| ID   | USER | R    | W    | R%   | MAX  | TIME_COUNT   | TTL_COUNT    | LAST_TIME |
+------+------+------+------+------+------+--------------+--------------+-----------+
|    1 | cc   |    0 |    0 | 0    | 0    | [0, 0, 0, 0] | [0, 0, 0, 0] |         0 |
+------+------+------+------+------+------+--------------+--------------+-----------+
1 row in set (0.00 sec)

mysql> show @@sql.slow;
Empty set (0.00 sec)

mysql>

关闭SQL统计

mysql> reload @@sqlstat=close ;
Query OK, 1 row affected (0.00 sec)
Set sql stat module isclosed=close, to succeed by manager. 

mysql>

关闭后，@@sql @@sql.sum @@sql.slow 就不会变化

打开SQL统计

mysql> reload @@sqlstat=open;
Query OK, 1 row affected (0.01 sec)
Set sql stat module isclosed=open, to fail by manager. 

mysql>

离线上线

mysql> offline;
Query OK, 1 row affected (0.00 sec)

mysql> show @@server;
+--------------+-------------+--------------+------------+---------------+---------------+---------+--------+-----------------------+
| UPTIME       | USED_MEMORY | TOTAL_MEMORY | MAX_MEMORY | RELOAD_TIME   | ROLLBACK_TIME | CHARSET | STATUS | AVG_BUFPOOL_ITEM_SIZE |
+--------------+-------------+--------------+------------+---------------+---------------+---------+--------+-----------------------+
| 8m 52s 140ms |    26609688 |    129499136 |  477102080 | 1457444457222 |            -1 | utf8    | OFF    |                   575 |
+--------------+-------------+--------------+------------+---------------+---------------+---------+--------+-----------------------+
1 row in set (0.00 sec)

mysql> online;
Query OK, 1 row affected (0.00 sec)

mysql> show @@server;
+-------------+-------------+--------------+------------+---------------+---------------+---------+--------+-----------------------+
| UPTIME      | USED_MEMORY | TOTAL_MEMORY | MAX_MEMORY | RELOAD_TIME   | ROLLBACK_TIME | CHARSET | STATUS | AVG_BUFPOOL_ITEM_SIZE |
+-------------+-------------+--------------+------------+---------------+---------------+---------+--------+-----------------------+
| 9m 0s 630ms |    26972784 |    129499136 |  477102080 | 1457444457222 |            -1 | utf8    | ON     |                   572 |
+-------------+-------------+--------------+------------+---------------+---------------+---------+--------+-----------------------+
1 row in set (0.00 sec)

mysql>

然而我并没变有发现前后操作有什么异常，依旧可以正常连接操作

定向清理慢SQL

mysql> clear @@slow where schema = cctest;
Query OK, 0 rows affected (0.01 sec)

mysql> clear @@slow where datanode = sd1;
Query OK, 0 rows affected (0.01 sec)

mysql>

Tip: 还有好多，虽然 show @@help 中有列出，但目前还不支持，也许还没实现(正在开发中) 如

mysql> reload @@route;
ERROR 1003 (HY000): Unsupported statement
mysql> reload @@user;
ERROR 1003 (HY000): Unsupported statement
mysql> rollback @@route ;
ERROR 1003 (HY000): Unsupported statement
mysql> rollback @@user ;
ERROR 1003 (HY000): Unsupported statement
mysql> show @@slow where datanode = sd1;
ERROR 1003 (HY000): Unsupported statement
mysql> show @@slow where schema =cctest;
ERROR 1003 (HY000): Unsupported statement
mysql>

Mycat还是一个成长中的项目，还需要一些时间将这些功能完善，但目前来看，主体功能已经可以满足大部分需求

命令汇总

  • grep 66 server.xml
  • netstat -ant | grep 66
  • mysql -u cc -p -P 9066 -h 192.168.100.102

原文地址

相关文章