SHOW
更新時間 2025-07-11 18:23:31
最近更新時間: 2025-07-11 18:23:31
分享文章
本文為您介紹DRDS管理命令中的SHOW命令。
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 secUDAL 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
注意
僅V2.9.0及以后新創建的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 |
+---------------------------+----------------------------------+
