【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】OB
【 使用版本 】V3/V4
【问题描述】查询OB版本号的方法除了这两种还有其他方法吗?(1) select version(); (2) show variables like ‘%version_comment’;@论坛小助手
个人用这种比较多,方便快捷
obclient [oceanbase]> status
--------------
obclient Ver 2.2.4 Distrib 10.4.18-MariaDB, for Linux (x86_64) using readline 5.1
Connection id: 2939585
Current database: oceanbase
Current user: root@10.186.61.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: OceanBase 4.2.1.11 (r111010032025041110-c619217ab98c90c0883191ec778f7ba4a2f5566e) (Built Apr 11 2025 10:44:02)
Protocol version: 10
Connection: 10.186.63.129 via TCP/IP
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
TCP port: 2883
Active --------------
obclient [oceanbase]> \s
--------------
obclient Ver 2.2.4 Distrib 10.4.18-MariaDB, for Linux (x86_64) using readline 5.1
Connection id: 2939585
Current database: oceanbase
Current user: root@10.186.61.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: OceanBase 4.2.1.11 (r111010032025041110-c619217ab98c90c0883191ec778f7ba4a2f5566e) (Built Apr 11 2025 10:44:02)
Protocol version: 10
Connection: 10.186.63.129 via TCP/IP
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
TCP port: 2883
Active --------------
1 个赞
observer -V
2 个赞
这个是要到observer服务器上去执行吗
有用