共计 1599 个字符,预计需要花费 4 分钟才能阅读完成。
状态查问
通过 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)
正文完