数据库管理语句

最近更新时间:2021-03-01 15:54:40

状态查询

通过 SQL 可以查看 proxy 的配置以及状态信息,目前支持如下命令:

  • /*proxy*/help;
  • /*proxy*/show config;
  • /*proxy*/show status;
说明:

如果使用 MySQL 客户端,需要在使用客户端时增加-c选项,如 mysql -hxxx.xxx.xxx.xxx -Pxxxx -uxxx -pxxx -c。

示例如下:

mysql> /*proxy*/help;
+-----------------------+-------------------------------------------------------+
| command               | description                                           |
+-----------------------+-------------------------------------------------------+
| show config           | show config from conf                                 |
| show status           | show proxy status,like route,shardkey and so on       |
| set sys_log_level=N   | change the sys debug level N should be 0,1,2,3        |
| set inter_log_level=N | change the interface debug level N should be 0,1      |
| set inter_time_open=N | change the interface time debug level N should be 0,1 |
| set sql_log_level=N   | change the sql debug level N should be 0,1            |
| set slow_log_level=N  | change the slow debug level N should be 0,1           |
| set slow_log_ms=N     | change the slow ms                                    |
| set log_clean_time=N  | change the log clean days                             |
| set log_clean_size=N  | change the log clean size in GB                       |
+-----------------------+-------------------------------------------------------+
10 rows in set (0.00 sec)
mysql> /*proxy*/show config;
+-----------------+--------------------+
| config_name     | value              |
+-----------------+--------------------+
| version         | V2R120D001         |
| mode            | group shard        |
| rootdir         | /shard_922         |
| sys_log_level   | 0                  |
| inter_log_level | 0                  |
| inter_time_open | 0                  |
| sql_log_level   | 0                  |
| slow_log_level  | 0                  |
| slow_log_ms     | 1000               |
| log_clean_time  | 1                  |
| log_clean_size  | 1                  |
| rw_split        | 1                  |
| ip_pass_through | 0                  |
+-----------------+--------------------+
14 rows in set (0.00 sec)
mysql> /*proxy*/show status;
+-----------------------------+------------------------------------------------------------------------------+
| status_name                 | value                                                                        |
+-----------------------------+------------------------------------------------------------------------------+
| cluster                     | group_1499858910_79548                                                       |
| set_1499859173_1:ip         | 10.49.118.165:5025;10.175.98.109:5025@1@IDC_4@0,10.231.23.241:5025@1@IDC_2@0 |
| set_1499859173_1:hash_range | 0---31                                                                       |
| set_1499911640_3:ip         | 10.49.118.165:5026;10.175.98.109:5026@1@IDC_4@0,10.231.23.241:5026@1@IDC_2@0 |
| set_1499911640_3:hash_range | 32---63                                                                      |
| set                         | set_1499859173_1,set_1499911640_3                                            |

同时 proxy 增强了 explain 的返回结果,显示 proxy 修改后的 SQL。

mysql> explain select * from test1;
+------+-------------+-------+------+---------------+------+---------+------+------+-------+-----------------------------------------+
| id   | select_type | table | type | possible_keys | key  | key_len | ref  | rows | Extra | info                                    |
+------+-------------+-------+------+---------------+------+---------+------+------+-------+-----------------------------------------+
|    1 | SIMPLE      | test1 | ALL  | NULL          | NULL | NULL    | NULL |   16 |       | set_2,explain select * from shard.test1 |
|    1 | SIMPLE      | test1 | ALL  | NULL          | NULL | NULL    | NULL |   16 |       | set_1,explain select * from shard.test1 |
+------+-------------+-------+------+---------------+------+---------+------+------+-------+-----------------------------------------+
2 rows in set (0.03 sec)