状态查询 通过 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 debu