UDAL SHOW HELP
语法说明
显示所有的UDAL管理命令,返回信息说明如下:
参数 描述 Statement UDAL的管理命令 Description 管理命令描述信息
示例
UDAL SHOW version | SERVER
语法说明
显示DBProxy服务器版本
示例
mysql> UDAL SHOW version;
+----------------------------------------------------+---------------+----------------------+
| Server_version | Scm_version | Build_time |
+----------------------------------------------------+---------------+----------------------+
| 5.7.21-UDAL-DBPROXY-2.8.8_P10-2025-04-27T07:23:45Z | GIT: 4a82c2b4 | 2025-04-27T07:23:45Z |
+----------------------------------------------------+---------------+----------------------+
UDAL SHOW SERVER
语法说明
显示DBProxy服务器状态
示例
mysql> UDAL SHOW SERVER;
+----------------------+---------------------+---------------------+----------------+-----------------+-----------------------------+------------------------------+----------------------------+--------------------------------+------------------------------+---------------------------------+---------------------+----------------+----------------------------+-----------------------------+--------------+---------+-------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+-----------+
| Dbproxy_startup_time | Dbproxy_active_time | Dbproxy_server_port | Dbproxy_status | Dbproxy_cpu (%) | Dbproxy_used_memory (Bytes) | Dbproxy_total_memory (Bytes) | Dbproxy_max_memory (Bytes) | Dbproxy_virtual_memory (Bytes) | Dbproxy_share_memory (Bytes) | Dbproxy_resident_memory (Bytes) | System_current_time | System_cpu (%) | System_free_memory (Bytes) | System_total_memory (Bytes) | Ip | Charset | Bufferred_data_average_size (Bytes) | File (Json) | Net_state (Json) | Cpu_cores |
+----------------------+---------------------+---------------------+----------------+-----------------+-----------------------------+------------------------------+----------------------------+--------------------------------+------------------------------+---------------------------------+---------------------+----------------+----------------------------+-----------------------------+--------------+---------+-------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+-----------+
| 2025-04-27 15:55:16 | 2d 6h 8m | 8866 | ON | 0.02 | 132042384 | 2058354688 | 2058354688 | 4877078528 | 25587712 | 789880832 | 2025-04-29 22:03:18 | 0.02 | 129196032 | 3843751936 | 192.168.0.94 | utf8 | 1805 | {"tmpfs":{"total":"192187392","percent":"47%"},"devtmpfs":{"total":"418816","percent":"0%"},"/dev/vda1":{"total":"4292765696","percent":"15%"}} | {{"name":"lo","Rxbps":"0","Txbps":"0"},{"name":"eth1","Rxbps":"0","Txbps":"0"},{"name":"eth0","Rxbps":"23000","Txbps":"22000"}} | 2 |
+----------------------+---------------------+---------------------+----------------+-----------------+-----------------------------+------------------------------+----------------------------+--------------------------------+------------------------------+---------------------------------+---------------------+----------------+----------------------------+-----------------------------+--------------+---------+-------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+-----------+
UDAL SHOW DATASOURCE [ WHERE DATANODE = 'datanode' ]
语法说明
查看后端数据库某个节点连接池状态,返回信息说明如下:
参数 描述 Datanode 数据库节点名称 Datahost 物理数据库名称 Type 数据库类型 Host 主机地址 Port 端口号 Write/Read 读写标识 Active 活动连接数 Idle 空闲连接数 Size 连接池连接总数 Execute 连接使用次数
示例
mysql> UDAL SHOW DATASOURCE WHERE DATANODE = 'ggzdb';
+----------+-------------+-------+--------------+-------+------------+--------+------+------+---------+
| Datanode | Datahost | Type | Host | Port | Write/Read | Active | Idle | Size | Execute |
+----------+-------------+-------+--------------+-------+------------+--------+------+------+---------+
| ggzdb | master_node | mysql | 192.168.0.97 | 13049 | Write | 0 | 32 | 3000 | 0 |
+----------+-------------+-------+--------------+-------+------------+--------+------+------+---------+
1 row in set (0.00 sec)
UDAL SHOW THREADPOOL
语法说明
报告线程池状态,返回信息说明如下:
参数 描述 Name 连接池名称 Size 连接池大小 Active 活动连接数 Queued_task 待执行任务数 Completed_task 完成任务数 Total_task 任务总数(=TASK_QUEUE_SIZE+COMPLETED_TASK)
示例
mysql> UDAL SHOW THREADPOOL;
+------------------+------+--------+-------------+----------------+------------+
| Name | Size | Active | Queued_task | Completed_task | Total_task |
+------------------+------+--------+-------------+----------------+------------+
| BusinessExecutor | 2 | 0 | 0 | 2 | 2 |
+------------------+------+--------+-------------+----------------+------------+
1 row in set (0.00 sec)
UDAL SHOW PROCESSOR
语法说明
查看处理线程对应的状态信息,包含网络流量、写请求、缓冲区实用信息、对应连接数,返回信息说明如下:
参数 描述 Processor 处理线程号 Net_in 读取流量 Net_out 写出流量 Queued_messages 等待写出的数据包数量 Free_buffer 可用缓冲区数量 Total_buffer 缓冲区总量 Used_buffer(%) 已使用缓冲区百分比 Buffer_recycles 缓冲区回收次数 Frontend_connections 前端连接数量 Backend_connections 后端连接数量
示例
mysql> UDAL SHOW PROCESSOR;
+------------+----------+----------+-----------------+-------------+--------------+-----------------+-----------------+----------------------+---------------------+
| Processor | Net_in | Net_out | Queued_messages | Free_buffer | Total_buffer | Used_buffer (%) | Buffer_recycles | Frontend_connections | Backend_connections |
+------------+----------+----------+-----------------+-------------+--------------+-----------------+-----------------+----------------------+---------------------+
| Processor0 | 6787653 | 82256824 | 0 | 441 | 4000 | 88 | 255721 | 0 | 16 |
| Processor1 | 12711326 | 85469938 | 0 | 441 | 4000 | 88 | 255721 | 1 | 17 |
+------------+----------+----------+-----------------+-------------+--------------+-----------------+-----------------+----------------------+---------------------+
UDAL SHOW COMMAND
语法说明
查看各类数据包的执行次数,返回信息说明如下:
参数 描述 Processor 处理线程号 Use_database 切换数据库次数 Execute 查询次数(包括DML以及select语句的提交、preparedstatement的执行) Ping 前端连接状态检测次数 Kill 终止查询次数 Quit 关闭连接次数 Other 其它命令调用次数
示例
mysql> UDAL SHOW COMMAND;
+------------+--------------+---------+-------+------+-------+-------+
| Processor | Use_database | Execute | Ping | Kill | Quit | Other |
+------------+--------------+---------+-------+------+-------+-------+
| Processor0 | 2 | 88543 | 13104 | 0 | 15048 | 0 |
| Processor1 | 3 | 88404 | 13096 | 0 | 15047 | 0 |
+------------+--------------+---------+-------+------+-------+-------+
UDAL SHOW CACHE
语法说明
查看查看内部缓存使用情况,返回信息说明如下:
参数 描述 Cache 缓存分类名称 Size 缓存大小(按缓存条目计算) Cached 缓存中已缓存的数据条目 Access 访问次数 Hit 命中次数 Put 更新次数 Last_access 上次访问时间 Last_put 上次更新时间
示例
mysql> UDAL SHOW CACHE;
+---------------------+-------+--------+--------+------+------+-------------+----------+
| Cache | Size | Cached | Access | Hit | Put | Last_access | Last_put |
+---------------------+-------+--------+--------+------+------+-------------+----------+
| ER_SQL2PARENTID | 1000 | 0 | 0 | 0 | 0 | 0 | 0 |
| seq.sqlExplainCache | 10000 | 0 | 0 | 0 | 0 | 0 | 0 |
| SQLRouteCache | 10000 | 13 | 37 | 0 | 0 | 0 | 0 |
| seq.packCache | 10000 | 0 | 0 | 0 | 0 | 0 | 0 |
+---------------------+-------+--------+--------+------+------+-------------+----------+
4 rows in set (0.00 sec)
UDAL SHOW BACKEND [ COUNT ]
语法说明
查看后端连接信息,返回信息说明如下:
参数 描述 Processor 处理线程号 Connection_id 后端连接在DBProxy中的id Mysql_id 连接id Host 主机地址 Port 端口号 Local_port 本地端口号(服务器端口对应的客户端端口号) Net_in(Bytes) 网络输入流量 Net_out(Bytes) 网络输出流量 Active_time(Seconds) 连接持续时间 Closed 是否已关闭 Borrowed 是否使用中 Queued_messages 等待写出的数据包数量 Schema 物理数据库schema Charset 物理数据库字符集 Transaction_level 事务级别 Autocommit 是否自动提交
示例
+------------+---------------+----------+--------------+-------+------------+----------------+-----------------+-----------------------+--------+----------+-----------------+---------+---------+-------------------+------------+
| Processor | Connection_id | Mysql_id | Host | Port | Local_port | Net_in (Bytes) | Net_out (Bytes) | Active_time (Seconds) | Closed | Borrowed | Queued_messages | Schema | Charset | Transaction_level | Autocommit |
+------------+---------------+----------+--------------+-------+------------+----------------+-----------------+-----------------------+--------+----------+-----------------+---------+---------+-------------------+------------+
| Processor0 | 32 | 18345 | 192.168.0.97 | 13049 | 60620 | 96603 | 23619 | 197319 | false | false | 0 | GGZDB_1 | utf8 | READ_COMMITTED | true |
| Processor0 | 2 | 18343 | 192.168.0.97 | 13049 | 60610 | 94572 | 22170 | 197319 | false | false | 0 | GGZDB | utf8 | READ_COMMITTED | true |
| Processor0 | 4 | 18344 | 192.168.0.97 | 13049 | 60578 | 102206 | 24811 | 197319 | false | false | 0 | GGZDB_1 | utf8 | READ_COMMITTED | true |
| Processor0 | 6 | 18320 | 192.168.0.97 | 13049 | 60300 | 102095 | 24550 | 197319 | false | false | 0 | GGZDB_1 | utf8 | READ_COMMITTED | true |
| Processor0 | 8 | 18322 | 192.168.0.97 | 13049 | 60322 | 109975 | 25791 | 197319 | false | false | 0 | GGZDB | utf8 | READ_COMMITTED | true |+------------+---------------+----------+--------------+-------+------------+----------------+-----------------+-----------------------+--------+----------+-----------------+---------+---------+-------------------+------------+
5 rows in set (0.00 sec)
UDAL SHOW FRONTEND [ COUNT ] [ WHERE USER IN ( 'USER_LIST' , ...) ]
语法说明
查看前端连接信息,返回信息说明如下:
参数 描述 Processor 处理线程号 Connection_id 前端连接在DBProxy中的id Client_host 客户端主机地址 Client_port 客户端端口号 Local_port 本地端口号(提供给客户端的服务端口) Schema 连接使用中的数据库schema Charset DBProxy数据库字符集 Net_in(Bytes) 网络输入流量 Net_out(Bytes) 网络输出流量 Active_time(Seconds) 连接持续时间 Receive_buffer(Bytes) 接收数据的缓冲区大小 Queued_messages 等待写出的数据包数量 Transaction_level 事务级别 Autocommit 是否自动提交
示例
mysql> UDAL SHOW FRONTEND [ COUNT ] [ WHERE USER IN ( 'USER_LIST' , ...) ] ;
+------------+---------------+-------------+-------------+------------+--------+------------+---------+----------------+-----------------+-----------------------+------------------------+-----------------+-------------------+------------+-----------------------+
| Processor | Connection_id | Client_host | Client_port | Local_port | Schema | User | Charset | Net_in (Bytes) | Net_out (Bytes) | Active_time (Seconds) | Receive_buffer (Bytes) | Queued_messages | Transaction_level | Autocommit | Last_io_time(Seconds) |
+------------+---------------+-------------+-------------+------------+--------+------------+---------+----------------+-----------------+-----------------------+------------------------+-----------------+-------------------+------------+-----------------------+
| Processor1 | 802678 | 33.2.0.20 | 41916 | 8866 | NULL | udal_admin | utf8:33 | 748 | 30958 | 4174 | 4096 | 0 | READ_COMMITTED | true | 0 |
+------------+---------------+-------------+-------------+------------+--------+------------+---------+----------------+-----------------+-----------------------+------------------------+-----------------+-------------------+------------+-----------------------+
1 row in set (0.00 sec)
UDAL SHOW FRONTEND_CONNECTION_LIMIT [ WHERE USER = 'user' AND GROUP = 'group']
语法说明
显示用户组的前端连接限制
示例
mysql> UDAL SHOW FRONTEND_CONNECTION_LIMIT WHERE USER = 'udal_admin' AND GROUP = '默认分组';
Empty set (0.00 sec)
UDAL SHOW SESSION
语法说明
查看绑定事务的前后端连接信息,返回信息说明如下:
参数 描述 Processor 处理线程号 Connection_id 前端连接在DBProxy中的ID Frontend_client_host 前端连接对应的客户端主机地址 Frontend_client_port 前端连接对应的客户端端口号 Frontend_schema 前端连接使用中的数据库schema Frontend_active_time(Seconds) 前端连接持续时间 Frontend_queued_messages 前端连接等待写出的数据包数量 Frontend_receive_buffer(Bytes) 前端连接接收数据的缓冲区大小 Charset DBProxy数据库字符集 Transaction_level 事务级别 Autocommit 是否自动提交 Origin_sql 用户提交的SQL Backend_host 后端连接主机地址 Backend_port 后端连接端口 Backend_database 后端连接物理数据库schema Backend_active_time(Seconds) 后端连接连接持续时间 Backend_queued_messages 后端连接等待写出的数据包数量 Backend_closed 后端连接是否已关闭 Backend_borrowed 后端连接是否使用中
示例
mysql> UDAL SHOW SESSION;
Empty set (0.00 sec)
UDAL SHOW HEARTBEAT
语法说明
查看主机的后端数据库的心跳状态,返回信息说明如下:
参数 描述 Datahost 物理数据库名称 Type 数据库类型 Host 主机地址 Port 端口号 Result 心跳测试返回结果,可能值:
OK
ERROR
TIMEOUT
INIT
Retry 当前重试失败次数 Status 心跳检测任务状态(CHECKING/IDLE) Timeout(Milliseconds) 超时时间 Cost(Milliseconds) 最近3个时段的平均响应时间,默认为1分钟、10分钟或30分钟 Last_try 上次使用时间 Stopped 是否已停止心跳检测
示例
mysql> UDAL SHOW HEARTBEAT;
+------------------------+-------------+-------+--------------+-------+--------+-------+--------+------------------------+---------------------+---------------------+---------+
| Datahost | Datasource | Type | Host | Port | Result | Retry | Status | Timeout (Milliseconds) | Cost (Milliseconds) | Last_try | Stopped |
+------------------------+-------------+-------+--------------+-------+--------+-------+--------+------------------------+---------------------+---------------------+---------+
| mysql-85-ggz-test_5473 | master_node | mysql | 192.168.0.97 | 13049 | OK | 0 | IDLE | 30000 | 0,1,0 | 2025-04-29 23:30:48 | false |
+------------------------+-------------+-------+--------------+-------+--------+-------+--------+------------------------+---------------------+---------------------+---------+
1 row in set (0.00 sec)
UDAL SHOW SEQUENCE [ WHERE SCHEMA = 'schema' AND SEQUENCE = 'sequence' ]
语法说明
查看sequence服务器序列信息监视器信息,返回信息说明如下:
参数 描述 Schema 序列所在schema Sequence_name 序列名称 Current_value 序列当前值 Max_value 序列最大值 Increment 每个DBProxy节点每次获取的序列号段大小 Min 最小值 Max 最大值 Is_cycle 是否循环序列
示例
mysql> UDAL SHOW SEQUENCE [ WHERE SCHEMA = 'ggz' AND SEQUENCE = 'PERFTEST_SEQ_CRM_CUST_ID' ] ;
+--------+--------------------------+---------------+-----------+-----------+------+---------------------+----------+
| Schema | Sequence_name | Current_value | Max_value | Increment | Min | Max | Is_cycle |
+--------+--------------------------+---------------+-----------+-----------+------+---------------------+----------+
| ggzdb | perftest_seq_crm_cust_id | 2 | 1001 | 1000 | 1 | 9223372036854775807 | false |
+--------+--------------------------+---------------+-----------+-----------+------+---------------------+----------+
1 row in set (0.00 sec)
UDAL SHOW LOGGER LEVEL
语法说明
查看日志级别信息,返回信息说明如下:
参数 描述 Logger 日志分类名称 Level 日志级别
示例
mysql> UDAL SHOW LOGGER LEVEL;
+---------------------------------------------------------------------------+-------+
| Logger | Level |
+---------------------------------------------------------------------------+-------+
| com.ctg.udal.dbproxy.command.set.SetPasswordMysqlCommand | INFO |
| com.ctg.udal.dbproxy.parser.ByteParse | INFO |
| com.ctg.udal.dbproxy.util.FrontendConnectionStateTable | INFO |
| org.apache.curator.utils.DefaultTracerDriver | INFO |
| org.apache.curator.RetryLoop | INFO |
| com.ctg.udal.dbproxy.cache.CacheService | INFO |
| com.ctg.udal.dbproxy.ddl.dao.impl.UdalClusterNodeGroupDaoImpl | INFO |
| com.ctg.udal.dbproxy.configloader.loader.IndexLoader | INFO |
| com.ctg.udal.dbproxy.util.OperationRecordUtil | INFO |
| com.ctg.udal.dbproxy.cache.DefaultLayeredCachePool | INFO |
| com.ctg.udal.dbproxy.tracker.handler.WarnHandler | INFO |
| com.ctg.udal.dbproxy.configloader.core.EventDispatcher | INFO |
| com.ctg.udal.dbproxy.server.handler.RouteHandler | INFO |
| com.ctg.udal.dbproxy.route.util.RouterUtil | INFO |
| com.ctg.udal.dbproxy.configloader.loader.HostLoader | INFO |
+---------------------------------------------------------------------------+-------+
xxx rows in set (0.00 sec
UDAL SHOW LVS ZOOKEEPER
语法说明
查看LVS zookeeper配置信息,返回信息说明如下:
参数 描述 Zookeeper_status zookeeper状态,可能值:
NORMAL
ERROR
示例
mysql> UDAL SHOW LVS ZOOKEEPER;
+------------------+
| Zookeeper_status |
+------------------+
| ERROR |
+------------------+
1 row in set (0.00 sec)
UDAL SHOW CONFIG WRITEHOST [ WHERE DATANODE IN ( 'datanode_list' , ... ) ];
语法说明
查看所有写数据库节点信息,返回信息说明如下:
参数 描述 Datanode 数据库节点名称
Host 主机地址 Port 端口号 User 数据库用户 Password 数据库密码(密文)
示例
mysql> UDAL SHOW CONFIG WRITEHOST WHERE DATANODE IN ( 'ggzdb' , 'ggzdb1') ;
+----------+-------------+-------+---------------+--------------------------------------------------------------------------------------------------+
| Datanode | Host | Port | User | Password |
+----------+-------------+-------+---------------+--------------------------------------------------------------------------------------------------+
| ggzdb | master_node | 13049 | dbproxy_79352 | C5E919872A4B82635A320D8B86AFC107399E946B27D1E5DF900275EBCC2A2F1905815C790F107E730610C4FA186A7C0C |
| ggzdb1 | master_node | 13049 | dbproxy_79352 | C5E919872A4B82635A320D8B86AFC107399E946B27D1E5DF900275EBCC2A2F1905815C790F107E730610C4FA186A7C0C |
+----------+-------------+-------+---------------+--------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
UDAL SHOW CONFIG TABLENODE [ WHERE TABLENAME IN ( 'tablename_list' , ... ) ]
语法说明
查看所有数据表配置信息,返回信息说明如下:
参数 描述 Schema schema名称 Table table名称 Datanode 所属数据库节点 Database 所属节点上的schema
示例
mysql> UDAL SHOW CONFIG TABLENODE;
+--------+-------+----------+-----------------+-------------+----------+
| Schema | Table | Datanode | Table type | Subtables | Database |
+--------+-------+----------+-----------------+-------------+----------+
| GGZDB | T1 | ggzdb_1 | SHARDING+BUCKET | T1_B1,T1_B2 | GGZDB_1 |
| GGZDB | T1 | ggzdb_2 | SHARDING+BUCKET | T1_B1,T1_B2 | GGZDB_2 |
+--------+-------+----------+-----------------+-------------+----------+
2 rows in set (0.00 sec)
mysql> UDAL SHOW CONFIG TABLENODE WHERE TABLENAME IN ( 'T1' );
Empty set (0.00 sec)
UDAL SHOW CONFIG TABLERULE [ WHERE TABLENAME IN ( 'tablename_list' , ... ) ]
语法说明
查看表规则信息,返回信息说明如下:
参数 说明 Schema schema名称 Table table名称 Area column 分组字段 Sharding column 分片字段 Function name 分片算法名称 Function detail 分片算法详细配置 Buckets 分桶数 Inner area column 库内分表分组字段 Inner sharding column 库内分表分片字段 Inner function name 库内分表分片算法名称 Inner function detail 库内分表分片算法详细配置
示例
mysql> UDAL SHOW CONFIG TABLERULE;
+--------+-------+-------------+-----------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------+---------+-------------------+-----------------------+---------------------+-----------------------+
| Schema | Table | Area column | Sharding column | Function name | Function detail | Buckets | Inner area column | Inner sharding column | Inner function name | Inner function detail |
+--------+-------+-------------+-----------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------+---------+-------------------+-----------------------+---------------------+-----------------------+
| GGZDB | T1 | -- | ID | mod-2 | {"isAutoCreated":true,"name":"mod-2","count":2,"functionClass":"com.ctg.udal.dbproxy.route.function.PartitionByMod","functionDesc":"按2取模"} | 2 | -- | -- | -- | -- |
+--------+-------+-------------+-----------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------+---------+-------------------+-----------------------+---------------------+-----------------------+
1 row in set (0.00 sec)
mysql> UDAL SHOW CONFIG TABLERULE WHERE TABLENAME IN ( 'T1' );
Empty set (0.00 sec)
UDAL SHOW CONFIG DATANODE [WHERE SCHEMA = 'schema'];
语法说明
查看所有物理分片配置信息,返回信息说明如下:
参数 说明 Datanode 数据库节点名称 Datahost 物理数据库名称 Database 数据库节点上的schema Index 数据库节点索引号(在dnindex.properties中配置) Type 数据库类型 Active 活动中连接数 Idle 空闲连接数 Size 连接池连接总数 Execute 连接使用次数 Recovery_time (Seconds) 等待恢复心跳检测剩余时间
示例
mysql> UDAL SHOW CONFIG DATANODE [WHERE SCHEMA = 'gzzdb'];
+----------+------------------------+----------+-------+-------+--------+------+------+---------+-------------------------+
| Datanode | Datahost | Database | Index | Type | Active | Idle | Size | Execute | Recovery_time (Seconds) |
+----------+------------------------+----------+-------+-------+--------+------+------+---------+-------------------------+
| ggzdb_2 | mysql-85-ggz-test_5473 | GGZDB_2 | 0 | mysql | 0 | 0 | 3000 | 0 | -1 |
| ggzdb_1 | mysql-85-ggz-test_5473 | GGZDB_1 | 0 | mysql | 0 | 0 | 3000 | 0 | -1 |
| ggzdb1_1 | mysql-85-ggz-test_5473 | GGZDB1_1 | 0 | mysql | 0 | 0 | 3000 | 0 | -1 |
| ggzdb | mysql-85-ggz-test_5473 | GGZDB | 0 | mysql | 0 | 0 | 3000 | 0 | -1 |
| ggzdb1 | mysql-85-ggz-test_5473 | GGZDB1 | 0 | mysql | 0 | 0 | 3000 | 0 | -1 |
+----------+------------------------+----------+-------+-------+--------+------+------+---------+-------------------------+
5 rows in set (0.01 sec)
UDAL SHOW CONFIG GRANTS WHERE USER = 'user'
语法说明
查看用户的权限,返回信息说明如下:
参数 说明 User 用户名 Schema 授权Schema Grant 权限信息
示例
mysql> UDAL SHOW CONFIG GRANTS WHERE USER = 'udal_admin';
+------------+----------------+--------+-------+-------+
| User | Privilege_type | Schema | Table | Grant |
+------------+----------------+--------+-------+-------+
| udal_admin | SCHEMA | GGZDB | | ALL |
| udal_admin | SCHEMA | GGZDB1 | | ALL |
+------------+----------------+--------+-------+-------+
2 rows in set (0.00 sec)
UDAL SHOW SEQUENCE [ SCHEMA ]
语法说明
查看sequence服务器序列信息监视器,返回信息说明如下:
参数 说明 Schema 序列所在Schema Sequence_name 序列名称 Current_value 序列当前值 Max_value 序列最大值 Increment 每个DBProxy节点每次获取的序列号段大小 Min 最小值 Max 最大值 Is_cycle 是否循环序列
示例
mysql> UDAL SHOW SEQUENCE [ UDAL_ADMIN];
+------------+-------------------+----------------------+----------------------+-----------+------+--------+----------+
| Schema | Sequence_name | Current_value | Max_value | Increment | Min | Max | Is_cycle |
+------------+-------------------+----------------------+----------------------+-----------+------+--------+----------+
| udal_admin | seq_udal_admin_id | -9223372036854775808 | -9223372036854775808 | 1000 | 1 | 999999 | false |
+------------+-------------------+----------------------+----------------------+-----------+------+--------+----------+
1 row in set (0.00 sec)
UDAL SHOW LOCKS
语法说明
查看当前dbproxy集群的锁
示例
mysql> UDAL SHOW LOCKS;
Empty set (0.00 sec)
UDAL SHOW METRIC SQL { SLOW | TPS}
语法说明
查看SQL统计信息,返回信息说明如下:
参数 说明 User 语句发起者用户名 Req_address 请求来源 Stmt 语句 Cost 总耗时 Dn_cost 单节点耗时 Start_time 执行起始时间 End_time 执行结束时间
示例
mysql> UDAL SHOW METRIC SQL SLOW;
Empty set (0.00 sec)
mysql> UDAL SHOW METRIC SQL TPS;
+-------+--------+------+----------+----------+----------+---------------+---------------+
| Total | Errors | Tps | Avg_cost | Max_cost | Min_cost | Start_time | End_time |
+-------+--------+------+----------+----------+----------+---------------+---------------+
| 0 | 0 | 0 | 0 | 0 | 0 | 1746500302647 | 1746500307648 |
+-------+--------+------+----------+----------+----------+---------------+---------------+
1 row in set (0.00 sec)
UDAL SHOW TOP 10
语法说明
支持的语法:
udal show top 10 [ALL|SLOW|BROADCAST] [COUNT|TOTAL|AVG|MAX]
查看DBProxy实例执行次数最多的SQL语句信息,返回信息说明如下:
参数 说明 STATEMENT 语句 COUNT 执行次数 TYPE 语句类型 BEGIN 开始时间 END 结束时间
示例
mysql> UDAL SHOW TOP 10;
Empty set (0.00 sec)
UDAL SHOW SQLPROTECTOR [ALL|BLACKLIST|WHITELIST]
语法说明
查看SQL保护器列表
示例
mysql> UDAL SHOW SQLPROTECTOR ALL;
Empty set (0.00 sec)
UDAL SHOW {TRACE|TRACES} [STATUS] [WHERE {ID|TRACEID} = 1]
语法说明
显示跟踪配置文件
示例
mysql> UDAL SHOW TRACE WHERE TRACEID =1;
Empty set (0.00 sec)
UDAL SHOW CLUSTER STATUS [ALL] [TOP N]
语法说明
查看集群状态
示例
mysql> UDAL SHOW CLUSTER STATUS ALL;
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+
| Cluster_status | Timestamp |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+
| {"instanceName":"drds-174-ggz-test","instanceStatus":"WORKING","timeStamp":"2025-05-06 11:06:29","groupStatusRecords":[{"groupName":"默认分组","groupStatus":"WORKING","nodeStatusRecords":[{"instanceName":"drds-174-ggz-test","groupName":"默认分组","nodeName":"node1","nodeStatus":"WORKING","nodeStatusInfo":"-","clientConnections":"0/800","timestamp":"2025-05-06 11:06:28","rdsStatusRecords":[{"rdsName":"mysql-408-ggz-test_5495","rdsStatus":"WORKING","rdsStatusInfo":"-","sourceStatusRecords":[{"sourceName":"master_node","sourceType":"WRITE","sourceStatus":"WORKING","sourceStatusInfo":"-","sourceConnectionPool":"0/3000","sourceMaxConnections":"35/1000"}]}]}]}]} | 2025-05-06 11:06:29 |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+
1 row in set (0.03 sec)
UDAL SHOW BINLOG STATUS
语法说明
查看Binlog状态
示例
mysql> UDAL SHOW BINLOG STATUS ;
+-------------------------+--------------------+------------------+----------+--------------+------------------+---------------------+---------------------+--------------------------------------------+
| Datahost | Url | File | Position | Binlog_do_db | Binlog_ignore_db | Pre_now | Now | Executed_gtid_set |
+-------------------------+--------------------+------------------+----------+--------------+------------------+---------------------+---------------------+--------------------------------------------+
| mysql-408-ggz-test_5495 | 192.168.0.72:13049 | mysql-bin.000002 | 1127167 | | | 2025-05-06 15:31:29 | 2025-05-06 15:31:29 | d0c66d84-2a20-11f0-b675-fa163ee5cb62:1-688 |
+-------------------------+--------------------+------------------+----------+--------------+------------------+---------------------+---------------------+--------------------------------------------+
1 row in set (0.04 sec)
UDAL SHOW TABLE
语法说明
查看表信息
支持的完整语法如下:
UDAL SHOW TABLE [WHERE [DELETE_STATUS = 0] [AND ZK_SCHEMA_CODE = ?] [AND ZK_TABLE_CODE = ?] [AND TABLE_TYPE IN (?, ...)] [AND TABLE_TYPE NOT IN (?, ...)] [AND SCHEMA_NAME = ?] [[AND (TABLE_NAME LIKE ? OR TABLE_NAME LIKE ? OR ...)] || [AND TABLE_NAME = ? ] || [AND TABLE_NAME IN (?, ...)]] ORDER BY TABLE_ID]
示例
mysql> UDAL SHOW TABLE;
+----------+-----------+-------------+---------------+------------+-----------------+----------------+---------------+---------------------+---------------------+---------------+
| Table_id | Tenant_id | Schema_name | Table_name | Table_type | Zk_cluster_code | Zk_schema_code | Zk_table_code | Create_time | Update_time | Delete_status |
+----------+-----------+-------------+---------------+------------+-----------------+----------------+---------------+---------------------+---------------------+---------------+
| 1 | 6749 | ggzdb | sbtest1 | 2 | 13714 | 13977 | 13999 | 2025-05-06 14:10:32 | 2025-05-06 14:11:07 | 0 |
| 2 | 6749 | ggzdb | student | 2 | 13714 | 13977 | 14005 | 2025-05-06 14:59:28 | 2025-05-06 14:59:56 | 0 |
| 3 | 6749 | ggzdb | student_score | 2 | 13714 | 13977 | 14012 | 2025-05-06 14:59:42 | 2025-05-06 15:00:06 | 0 |
| 4 | 6749 | udal_admin | student | 2 | 13714 | 13943 | 14078 | 2025-05-06 15:06:29 | 2025-05-06 15:06:30 | 0 |
+----------+-----------+-------------+---------------+------------+-----------------+----------------+---------------+---------------------+---------------------+---------------+
UDAL SHOW DDL_JOB
语法说明
查看DDL任务的详细信息
支持的语法如下:
UDAL SHOW DDL_JOB [ WHERE [JOB_ID=?] || [TASK_ID=?] || [TASK_ID IN (?,...)] [schema_id=? [AND result=?][AND script like '%?%'][AND create_time>=?][AND create_time<=?] ORDER BY create_time DESC] ]
参数说明如下:
参数 描述 JOB_ID DDL任务的唯一标识符 TASK_ID 异步任务的唯一标识符
注意
必须是一个合法的uuid。
schema_id 逻辑库ZK节点的完整路径 result 任务的执行结果,取值范围:
0:成功
1:正在执行
2:失败
3:取消
4:警告
script DDL 脚本内容,支持模糊查询 create_time 任务的创建时间,支持范围查询
示例
mysql> UDAL SHOW DDL_JOB DETAIL WHERE JOB_ID=28;
+------+--------+--------+-------------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+----------------+---------------------+---------------------+--------------+------------+--------------+-----------+--------------------------------------------------------------------------------------+---------+-------------+-----------------------------------------------------------------------+--------------------------------------------------------------------------------------------+----------------------------------------------------+
| Id | Sub_id | Job_id | Schema_name | Object_name | Script | Result | State | Start_time | End_time | Elapsed_time | Cancelable | Ddl_type | Object_id | Dn_id | Dn_name | Is_standard | Schema_id | Db_url | Remark |
+------+--------+--------+-------------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+----------------+---------------------+---------------------+--------------+------------+--------------+-----------+--------------------------------------------------------------------------------------+---------+-------------+-----------------------------------------------------------------------+--------------------------------------------------------------------------------------------+----------------------------------------------------+
| 40 | 29 | 28 | ggzdb | t4 | CREATE TABLE IF NOT EXISTS `t4` (
`id` int(10) NOT NULL,
`k` int(10) NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
KEY `xid` (`id`)
) | 0 | FINISH_SUCCESS | 2025-05-07 10:16:08 | 2025-05-07 10:16:08 | 0 | 0 | CREATE TABLE | NULL | /dbproxy_cluster/dbproxy_cluster_00000****4/shardings/data_node/data_node_0000013978 | ggzdb | 1 | /dbproxy_cluster/dbproxy_cluster_00000****4/schemas/schema_00000****7 | jdbc:mysql://192.168.0.72:13049/ggzdb?useUnicode=true&characterEncoding=utf-8&useSSL=false | Execute statement in dn [ggzdb:ggzdb] successfully |
+------+--------+--------+-------------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+----------------+---------------------+---------------------+--------------+------------+--------------+-----------+--------------------------------------------------------------------------------------+---------+-------------+-----------------------------------------------------------------------+--------------------------------------------------------------------------------------------+----------------------------------------------------+
1 row in set (0.02 sec)
UDAL SHOW DDL_SUB_JOB
语法说明
查看DDL子任务的详细信息
支持的语法如下:
UDAL SHOW DDL_SUB_JOB [ WHERE [JOB_ID=?] || [JOB_ID IN (?,...)] [SUB_ID=?] ]
参数说明如下:
参数 描述 JOB_ID DDL任务的唯一标识符 SUB_ID DDL子任务的唯一标识符
示例
mysql> UDAL SHOW DDL_SUB_JOB;
+--------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+--------+-----------+-----------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+----------+--------------+
| Sub_id | Job_id | Script | Execute_time | Result | Cost_time | Remark | Audit_remark | Table_name | Progress | Elapsed_time |
+--------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+--------+-----------+-----------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+----------+--------------+
| 4 | 4 | sharding @@database name="udal_admin" set datasource ="mysql-408-ggz-test_5495:10"; | 2025-05-06 10:37:53 | 0 | 835 | | NULL | NULL | 100% | 835 |
+--------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+--------+-----------+-----------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+----------+--------------+
1 rows in set (0.08 sec)
UDAL SHOW DDL_OWNER
注意
仅2025年5月28日00:00及以后新创建的DBProxy实例,或DBProxy集群中的所有节点都升级到V2.9.0及以后版本,才支持执行该命令。您可以执行udal show version
命令获取版本。
语法说明
查看当前集群中负责DDL操作的节点信息,即DDL Owner信息。
回显说明
该命令会从Zookeeper中获取当前集群中的DDL Owner信息,回显信息说明如下:
参数 | 数据类型 | 描述 |
---|---|---|
NODE_ID | VAR_STRING | DDL Owner节点ID |
NAME | VAR_STRING | DDL Owner节点名称 |
IP | VAR_STRING | DDL Owner节点的IP地址 |
PORT | LONG | DDL Owner节点的端口号 |
示例
mysql> UDAL SHOW DDL_OWNER;
+-----------------+-------------+----------------+------+
| Node_id | Name | Ip | Port |
+-----------------+-------------+----------------+------+
| node_0000001057 | dbproxy8233 | 192.168.56.105 | 8233 |
+-----------------+-------------+----------------+------+
1 row in set (0.02 sec)
UDAL SHOW OPERATION_LOG
语法说明
查看运维日志开启状态,命令回显信息说明如下:
参数 描述 Name 运维日志文件名称 Value 是否开启运维日志,可能值:
ON:表示开启
OFF:表示关闭
说明
您可以执行
UDAL SHOW OPERATION_LOG = 'ON/OFF'
命令,开启或关闭运维日志功能。
示例
mysql> UDAL SHOW OPERATION_LOG;
+---------------------------+----------------------------------+
| Name | Value |
+---------------------------+----------------------------------+
| operation_log | OFF |
+---------------------------+----------------------------------+