手头刚好有个测试机centos7.9下载安装试试看看，安装过程很方便，遇到failed和warning
设置好参数后重新执行即可。
参考文档：https://www.oceanbase.com/docs/community-observer-cn-10000000000901197
用到的命令：
yum install wget
wget https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/oceanbase-all-in-one/7/x86_64/oceanbase-all-in-one.4.0.0.0-beta-100120221102135736.el7.x86_64.tar.gz
tar -zxvf oceanbase-all-in-one.4.0.0.0-beta-100120221102135736.el7.x86_64.tar.gz
cd oceanbase-all-in-one/bin
./install.sh
92 source ~/.oceanbase-all-in-one/bin/env.sh
93 which obd
94 which obclient
95 obd -h
96 obd demo
97 vi /etc/security/limits.conf
98 cat /etc/security/limits.conf
99 ulimit -HSn 102400
100 sysctl -a|grep fs.aio-max-nr
101 vi /etc/sysctl.conf
102 sysctl -p
103 obd demo
104 vi /etc/security/limits.conf
105 cat /etc/security/limits.conf
106 ulimit -HSn 1024000
107 obd demo
108 obd demo -f
110 obclient -h127.0.0.1 -uroot -P2881
112 obclient -h127.0.0.1 -uroot -P2881 -Doceanbase
113 obclient -h127.0.0.1 -uroot -P2881 -Doceanbase
117 obclient -h127.0.0.1 -uroot@sys -P2881 -c -Aoceanbase
118 obclient -h127.0.0.1 -uroot@sys -P2881 -c -Doceanbase
119 obclient -h192.168.207.151 -uroot@sys#demo -P2883 -p -c -A oceanbase
120 netstat -tunlp|grep 288
121 yum install net-tools -y
124 obclient -h192.168.207.151 -uroot@sys#demo -P2882 -p -c -A oceanbase
125 obclient -h127.0.0.1 -uroot@sys -P2881 -c -A -Doceanbase
操作记录：
*****[2022-11-04 09:43:41]*****
Last login: Thu Nov 3 16:14:27 2022 from 192.168.205.36
[root@ceph02 ~]# pwd
/root
[root@ceph02 ~]# yum install wget
已加载插件：fastestmirror
Loading mirror speeds from cached hostfile
epel/x86_64/metalink | 16 kB 00:00:00
* base: mirrors.bupt.edu.cn
* epel: d2lzkl7pfhq30w.cloudfront.net
* extras: mirrors.bupt.edu.cn
* updates: mirrors.bupt.edu.cn
base | 3.6 kB 00:00:00
cr | 2.9 kB 00:00:00
epel | 4.7 kB 00:00:00
extras | 2.9 kB 00:00:00
updates | 2.9 kB 00:00:00
(1/2): epel/x86_64/updateinfo | 1.0 MB 00:00:06
(2/2): epel/x86_64/primary_db | 7.0 MB 00:00:21
正在解决依赖关系
--> 正在检查事务
---> 软件包 wget.x86_64.0.1.14-18.el7_6.1 将被 安装
--> 解决依赖关系完成
依赖关系解决
=======================================================================================================================================================================================
Package 架构 版本 源 大小
=======================================================================================================================================================================================
正在安装:
wget x86_64 1.14-18.el7_6.1 base 547 k
事务概要
=======================================================================================================================================================================================
安装 1 软件包
总下载量：547 k
安装大小：2.0 M
Is this ok [y/d/N]: y
Downloading packages:
wget-1.14-18.el7_6.1.x86_64.rpm | 547 kB 00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
正在安装 : wget-1.14-18.el7_6.1.x86_64 1/1
验证中 : wget-1.14-18.el7_6.1.x86_64 1/1
已安装:
wget.x86_64 0:1.14-18.el7_6.1
完毕！
[root@ceph02 ~]# wget https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/oceanbase-all-in-one/7/x86_64/oceanbase-all-in-one.4.0.0.0-beta-100120221102135736.el7.x86_64.tar.gz
--2022-11-04 09:45:15-- https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/oceanbase-all-in-one/7/x86_64/oceanbase-all-in-one.4.0.0.0-beta-100120221102135736.el7.x86_64.tar.gz
正在解析主机 obbusiness-private.oss-cn-shanghai.aliyuncs.com (obbusiness-private.oss-cn-shanghai.aliyuncs.com)... 106.14.229.148
正在连接 obbusiness-private.oss-cn-shanghai.aliyuncs.com (obbusiness-private.oss-cn-shanghai.aliyuncs.com)|106.14.229.148|:443... 已连接。
已发出 HTTP 请求，正在等待回应... 200 OK
长度：257703079 (246M) [application/gzip]
正在保存至: “oceanbase-all-in-one.4.0.0.0-beta-100120221102135736.el7.x86_64.tar.gz”
100%[=============================================================================================================================================>] 257,703,079 505KB/s 用时 9m 3s
2022-11-04 09:54:19 (463 KB/s) - 已保存 “oceanbase-all-in-one.4.0.0.0-beta-100120221102135736.el7.x86_64.tar.gz” [257703079/257703079])
[root@ceph02 ~]# cat /sys/kernel/mm/redhat_transparent_hugepage/enabled
cat: /sys/kernel/mm/redhat_transparent_hugepage/enabled: 没有那个文件或目录
[root@ceph02 ~]# echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled
-bash: /sys/kernel/mm/redhat_transparent_hugepage/enabled: 没有那个文件或目录
[root@ceph02 ~]# cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)
[root@ceph02 ~]#
[root@ceph02 ~]#
[root@ceph02 ~]# echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled
-bash: /sys/kernel/mm/redhat_transparent_hugepage/enabled: 没有那个文件或目录
[root@ceph02 ~]# find / -name enabled
/sys/devices/pci0000:00/0000:00:1e.0/0000:05:03.0/drm/card0/card0-VGA-1/enabled
/sys/devices/virtual/powercap/intel-rapl/enabled
/sys/devices/virtual/powercap/intel-rapl/intel-rapl:0/enabled
/sys/devices/virtual/powercap/intel-rapl/intel-rapl:0/intel-rapl:0:0/enabled
/sys/devices/virtual/powercap/intel-rapl/intel-rapl:0/intel-rapl:0:1/enabled
/sys/devices/virtual/powercap/intel-rapl/intel-rapl:1/enabled
/sys/devices/virtual/powercap/intel-rapl/intel-rapl:1/intel-rapl:1:0/enabled
/sys/devices/virtual/powercap/intel-rapl/intel-rapl:1/intel-rapl:1:1/enabled
/sys/firmware/acpi/hotplug/container/enabled
/sys/firmware/acpi/hotplug/pci_root/enabled
/sys/firmware/acpi/hotplug/memory/enabled
/sys/firmware/acpi/hotplug/processor/enabled
/sys/kernel/mm/transparent_hugepage/enabled
/sys/kernel/debug/kprobes/enabled
/sys/module/zswap/parameters/enabled
[root@ceph02 ~]# cat /sys/kernel/mm/transparent_hugepage/enabled
[always] madvise never
[root@ceph02 ~]# echo never > /sys/kernel/mm/transparent_hugepage/enabled
[root@ceph02 ~]# cat /sys/kernel/mm/transparent_hugepage/enabled
always madvise [never]
[root@ceph02 ~]# ll
总用量 2274872
-rw-------. 1 root root 1395 11月 3 11:32 anaconda-ks.cfg
drwxr-xr-x. 24 root root 4096 11月 3 16:22 ceph
-rw-r--r--. 1 root root 2071756662 11月 3 09:00 ceph-rdma.tar.gz
-rw-r--r--. 1 root root 257703079 11月 2 16:02 oceanbase-all-in-one.4.0.0.0-beta-100120221102135736.el7.x86_64.tar.gz
[root@ceph02 ~]# tar -zxvf oceanbase-all-in-one.4.0.0.0-beta-100120221102135736.el7.x86_64.tar.gz
oceanbase-all-in-one/
。。。。。。
oceanbase-all-in-one/obd/etc/profile.d/obd.sh
[root@ceph02 ~]# cd oceanbase-all-in-one
[root@ceph02 oceanbase-all-in-one]# cd bin
[root@ceph02 bin]# ll *.sh
-rw-r--r--. 1 root root 238 11月 2 13:57 env.sh
-rwxr-xr-x. 1 root root 1217 11月 2 13:57 install.sh
-rwxr-xr-x. 1 root root 161 11月 2 13:57 uninstall.sh
[root@ceph02 bin]# ./install.sh
name: grafana
version: 7.5.17
release:1
arch: x86_64
md5: 1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6
add /root/oceanbase-all-in-one/rpms/grafana-7.5.17-1.el7.x86_64.rpm to local mirror
name: obagent
version: 1.2.0
release:4.el7
arch: x86_64
md5: 0e8f5ee68c337ea28514c9f3f820ea546227fa7e
add /root/oceanbase-all-in-one/rpms/obagent-1.2.0-4.el7.x86_64.rpm to local mirror
name: obproxy-ce
version: 4.0.0
release:5.el7
arch: x86_64
md5: de53232a951184fad75b15884458d85e31d2f6c3
add /root/oceanbase-all-in-one/rpms/obproxy-ce-4.0.0-5.el7.x86_64.rpm to local mirror
name: oceanbase-ce
version: 4.0.0.0
release:100000272022110114.el7
arch: x86_64
md5: 42611dc51ca9bb28f36e60e4406ceea4a74914c7
add /root/oceanbase-all-in-one/rpms/oceanbase-ce-4.0.0.0-100000272022110114.el7.x86_64.rpm to local mirror
name: oceanbase-ce-libs
version: 4.0.0.0
release:100000272022110114.el7
arch: x86_64
md5: 188919f8128394bf9b62e3989220ded05f1d14da
add /root/oceanbase-all-in-one/rpms/oceanbase-ce-libs-4.0.0.0-100000272022110114.el7.x86_64.rpm to local mirror
name: prometheus
version: 2.37.1
release:10000102022110211.el7
arch: x86_64
md5: 58913c7606f05feb01bc1c6410346e5fc31cf263
add /root/oceanbase-all-in-one/rpms/prometheus-2.37.1-10000102022110211.el7.x86_64.rpm to local mirror
Disable remote ok
#####################################################################
Install Finished
=====================================================================
Setup Environment: source ~/.oceanbase-all-in-one/bin/env.sh
Quick Start: obd demo
More Details: obd -h
=====================================================================
[root@ceph02 bin]# source ~/.oceanbase-all-in-one/bin/env.sh
[root@ceph02 bin]# which obd
/root/.oceanbase-all-in-one/obd/usr/bin/obd
[root@ceph02 bin]# which obclient
/root/.oceanbase-all-in-one/obclient/u01/obclient/bin/obclient
[root@ceph02 bin]# obd -h
Usage: obd <command> [options]
Available commands:
cluster Deploy and manage a cluster.
demo Quickly start
mirror Manage a component repository for OBD.
repo Manage local repository for OBD.
test Run test for a running deployment.
update Update OBD.
Options:
--version show program's version number and exit
-h, --help Show help and exit.
-v, --verbose Activate verbose output.
[root@ceph02 bin]# obd demo
Package grafana-7.5.17-1 is available.
Package obagent-1.2.0-4.el7 is available.
Package prometheus-2.37.1-10000102022110211.el7 is available.
Package obproxy-ce-4.0.0-5.el7 is available.
Package oceanbase-ce-4.0.0.0-100000272022110114.el7 is available.
install grafana-7.5.17 for local ok
install obagent-1.2.0 for local ok
install prometheus-2.37.1 for local ok
install obproxy-ce-4.0.0 for local ok
install oceanbase-ce-4.0.0.0 for local ok
Cluster param config check ok
Open ssh connection ok
Generate grafana configuration ok
Generate obagent configuration ok
Generate prometheus configuration ok
Generate obproxy configuration ok
Generate observer configuration ok
install grafana-7.5.17 for local ok
install obagent-1.2.0 for local ok
install prometheus-2.37.1 for local ok
install obproxy-ce-4.0.0 for local ok
install oceanbase-ce-4.0.0.0 for local ok
+--------------------------------------------------------------------------------------------+
| Packages |
+--------------+---------+------------------------+------------------------------------------+
| Repository | Version | Release | Md5 |
+--------------+---------+------------------------+------------------------------------------+
| grafana | 7.5.17 | 1 | 1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 |
| obagent | 1.2.0 | 4.el7 | 0e8f5ee68c337ea28514c9f3f820ea546227fa7e |
| prometheus | 2.37.1 | 10000102022110211.el7 | 58913c7606f05feb01bc1c6410346e5fc31cf263 |
| obproxy-ce | 4.0.0 | 5.el7 | de53232a951184fad75b15884458d85e31d2f6c3 |
| oceanbase-ce | 4.0.0.0 | 100000272022110114.el7 | 42611dc51ca9bb28f36e60e4406ceea4a74914c7 |
+--------------+---------+------------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Open ssh connection ok
Cluster status check ok
Initializes grafana work home ok
Initializes obagent work home ok
Initializes prometheus work home ok
Initializes obproxy work home ok
Initializes observer work home ok
Remote grafana-7.5.17-1-1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 repository install ok
Remote grafana-7.5.17-1-1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 repository lib check ok
Remote obagent-1.2.0-4.el7-0e8f5ee68c337ea28514c9f3f820ea546227fa7e repository install ok
Remote obagent-1.2.0-4.el7-0e8f5ee68c337ea28514c9f3f820ea546227fa7e repository lib check ok
Remote prometheus-2.37.1-10000102022110211.el7-58913c7606f05feb01bc1c6410346e5fc31cf263 repository install ok
Remote prometheus-2.37.1-10000102022110211.el7-58913c7606f05feb01bc1c6410346e5fc31cf263 repository lib check ok
Remote obproxy-ce-4.0.0-5.el7-de53232a951184fad75b15884458d85e31d2f6c3 repository install ok
Remote obproxy-ce-4.0.0-5.el7-de53232a951184fad75b15884458d85e31d2f6c3 repository lib check ok
Remote oceanbase-ce-4.0.0.0-100000272022110114.el7-42611dc51ca9bb28f36e60e4406ceea4a74914c7 repository install ok
Remote oceanbase-ce-4.0.0.0-100000272022110114.el7-42611dc51ca9bb28f36e60e4406ceea4a74914c7 repository lib check !!
Try to get lib-repository
Package oceanbase-ce-libs-4.0.0.0-100000272022110114.el7 is available.
install oceanbase-ce-libs-4.0.0.0 for local ok
Remote oceanbase-ce-libs-4.0.0.0-100000272022110114.el7-188919f8128394bf9b62e3989220ded05f1d14da repository install ok
Remote oceanbase-ce-4.0.0.0-100000272022110114.el7-42611dc51ca9bb28f36e60e4406ceea4a74914c7 repository lib check ok
demo deployed
Get local repositories ok
Search plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start observer x
[WARN] (127.0.0.1) The recommended value of fs.aio-max-nr is 1048576 (Current value: 65536)
[ERROR] OBD-1007: (127.0.0.1) open files must not be less than 20000 (Current value: 1024)
[WARN] (127.0.0.1) clog and data use the same disk (/)
Check before start obagent ok
Check before start prometheus ok
Check before start obproxy ok
Check before start grafana ok
See https://www.oceanbase.com/product/ob-deployer/error-codes .
[root@ceph02 bin]# vi /etc/security/limits.conf
# /etc/security/limits.conf
#
#This file sets the resource limits for the users logged in via PAM.
#It does not affect resource limits of the system services.
#
#Also note that configuration files in /etc/security/limits.d directory,
#which are read in alphabetical order, override the settings in this
#file in case the domain is the same or more specific.
#That means for example that setting a limit for wildcard domain here
#can be overriden with a wildcard setting in a config file in the
#subdirectory, but a user specific setting here can be overriden only
#with a user specific setting in the subdirectory.
#
#Each line describes a limit for a user in the form:
#
#<domain> <type> <item> <value>
#
#Where:
#<domain> can be:
# - a user name
# - a group name, with @group syntax
# - the wildcard *, for default entry
# - the wildcard %, can be also used with %group syntax,
# for maxlogin limit
#
#<type> can have the two values:
# - "soft" for enforcing the soft limits
# - "hard" for enforcing hard limits
#
#<item> can be one of the following:
# - core - limits the core file size (KB)
# - data - max data size (KB)
# - fsize - maximum filesize (KB)
# - memlock - max locked-in-memory address space (KB)
# - nofile - max number of open file descriptors
# - rss - max resident set size (KB)
# - stack - max stack size (KB)
# - cpu - max CPU time (MIN)
# - nproc - max number of processes
# - as - address space limit (KB)
# - maxlogins - max number of logins for this user
# - maxsyslogins - max number of logins on the system
# - priority - the priority to run user process with
# - locks - max number of file locks the user can hold
# - sigpending - max number of pending signals
# - msgqueue - max memory used by POSIX message queues (bytes)
# - nice - max nice priority allowed to raise to values: [-20, 19]
# - rtprio - max realtime priority
#
#<domain> <type> <item> <value>
#
#* soft core 0
#* hard rss 10000
#@student hard nproc 20
#@faculty soft nproc 20
#@faculty hard nproc 50
#ftp hard nproc 0
#@student - maxlogins 4
# End of file
* soft memlock unlimited
* hard memlock unlimited
* hard memlock unlimited
* soft nofile 102400
* hard nofile 102400
"/etc/security/limits.conf" 65L, 2514C written
[root@ceph02 bin]# cat /etc/security/limits.conf
# /etc/security/limits.conf
#
#This file sets the resource limits for the users logged in via PAM.
#It does not affect resource limits of the system services.
#
#Also note that configuration files in /etc/security/limits.d directory,
#which are read in alphabetical order, override the settings in this
#file in case the domain is the same or more specific.
#That means for example that setting a limit for wildcard domain here
#can be overriden with a wildcard setting in a config file in the
#subdirectory, but a user specific setting here can be overriden only
#with a user specific setting in the subdirectory.
#
#Each line describes a limit for a user in the form:
#
#<domain> <type> <item> <value>
#
#Where:
#<domain> can be:
# - a user name
# - a group name, with @group syntax
# - the wildcard *, for default entry
# - the wildcard %, can be also used with %group syntax,
# for maxlogin limit
#
#<type> can have the two values:
# - "soft" for enforcing the soft limits
# - "hard" for enforcing hard limits
#
#<item> can be one of the following:
# - core - limits the core file size (KB)
# - data - max data size (KB)
# - fsize - maximum filesize (KB)
# - memlock - max locked-in-memory address space (KB)
# - nofile - max number of open file descriptors
# - rss - max resident set size (KB)
# - stack - max stack size (KB)
# - cpu - max CPU time (MIN)
# - nproc - max number of processes
# - as - address space limit (KB)
# - maxlogins - max number of logins for this user
# - maxsyslogins - max number of logins on the system
# - priority - the priority to run user process with
# - locks - max number of file locks the user can hold
# - sigpending - max number of pending signals
# - msgqueue - max memory used by POSIX message queues (bytes)
# - nice - max nice priority allowed to raise to values: [-20, 19]
# - rtprio - max realtime priority
#
#<domain> <type> <item> <value>
#
#* soft core 0
#* hard rss 10000
#@student hard nproc 20
#@faculty soft nproc 20
#@faculty hard nproc 50
#ftp hard nproc 0
#@student - maxlogins 4
# End of file
* soft memlock unlimited
* hard memlock unlimited
* soft nofile 102400
* hard nofile 102400
[root@ceph02 bin]# ulimit -HSn 102400
[root@ceph02 bin]# sysctl -a|grep fs.aio-max-nr
fs.aio-max-nr = 65536
sysctl: reading key "net.ipv6.conf.all.stable_secret"
sysctl: reading key "net.ipv6.conf.default.stable_secret"
sysctl: reading key "net.ipv6.conf.enp129s0f0.stable_secret"
sysctl: reading key "net.ipv6.conf.enp129s0f1.stable_secret"
sysctl: reading key "net.ipv6.conf.ib0.stable_secret"
sysctl: reading key "net.ipv6.conf.lo.stable_secret"
[root@ceph02 bin]# vi /etc/sysctl.conf
# sysctl settings are defined through files in
# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.
#
# Vendors settings live in /usr/lib/sysctl.d/.
# To override a whole file, create a new file with the same in
# /etc/sysctl.d/ and put new settings there. To override
# only specific settings, add a file with a lexically later
# name in /etc/sysctl.d/ and put new settings there.
#
# For more information, see sysctl.conf(5) and sysctl.d(5).
~
~
"/etc/sysctl.conf" 11L, 474C written
[root@ceph02 bin]# sysctl -p
fs.aio-max-nr = 10485760
[root@ceph02 bin]# obd demo
Get local repositories ok
Search plugins ok
Open ssh connection ok
Cluster status check ok
grafana work dir cleaning ok
obagent work dir cleaning ok
prometheus work dir cleaning ok
obproxy work dir cleaning ok
observer work dir cleaning ok
demo destroyed
install grafana-7.5.17 for local ok
install oceanbase-ce-4.0.0.0 for local ok
install obagent-1.2.0 for local ok
install prometheus-2.37.1 for local ok
install obproxy-ce-4.0.0 for local ok
Cluster param config check ok
Open ssh connection ok
Generate grafana configuration ok
Generate observer configuration ok
Generate obagent configuration ok
Generate prometheus configuration ok
Generate obproxy configuration ok
install grafana-7.5.17 for local ok
install oceanbase-ce-4.0.0.0 for local ok
install obagent-1.2.0 for local ok
install prometheus-2.37.1 for local ok
install obproxy-ce-4.0.0 for local ok
+--------------------------------------------------------------------------------------------+
| Packages |
+--------------+---------+------------------------+------------------------------------------+
| Repository | Version | Release | Md5 |
+--------------+---------+------------------------+------------------------------------------+
| grafana | 7.5.17 | 1 | 1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 |
| oceanbase-ce | 4.0.0.0 | 100000272022110114.el7 | 42611dc51ca9bb28f36e60e4406ceea4a74914c7 |
| obagent | 1.2.0 | 4.el7 | 0e8f5ee68c337ea28514c9f3f820ea546227fa7e |
| prometheus | 2.37.1 | 10000102022110211.el7 | 58913c7606f05feb01bc1c6410346e5fc31cf263 |
| obproxy-ce | 4.0.0 | 5.el7 | de53232a951184fad75b15884458d85e31d2f6c3 |
+--------------+---------+------------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Open ssh connection ok
Cluster status check ok
Initializes grafana work home ok
Initializes observer work home ok
Initializes obagent work home ok
Initializes prometheus work home ok
Initializes obproxy work home ok
Remote grafana-7.5.17-1-1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 repository install ok
Remote grafana-7.5.17-1-1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 repository lib check ok
Remote oceanbase-ce-4.0.0.0-100000272022110114.el7-42611dc51ca9bb28f36e60e4406ceea4a74914c7 repository install ok
Remote oceanbase-ce-4.0.0.0-100000272022110114.el7-42611dc51ca9bb28f36e60e4406ceea4a74914c7 repository lib check !!
Remote obagent-1.2.0-4.el7-0e8f5ee68c337ea28514c9f3f820ea546227fa7e repository install ok
Remote obagent-1.2.0-4.el7-0e8f5ee68c337ea28514c9f3f820ea546227fa7e repository lib check ok
Remote prometheus-2.37.1-10000102022110211.el7-58913c7606f05feb01bc1c6410346e5fc31cf263 repository install ok
Remote prometheus-2.37.1-10000102022110211.el7-58913c7606f05feb01bc1c6410346e5fc31cf263 repository lib check ok
Remote obproxy-ce-4.0.0-5.el7-de53232a951184fad75b15884458d85e31d2f6c3 repository install ok
Remote obproxy-ce-4.0.0-5.el7-de53232a951184fad75b15884458d85e31d2f6c3 repository lib check ok
Try to get lib-repository
install oceanbase-ce-libs-4.0.0.0 for local ok
Remote oceanbase-ce-libs-4.0.0.0-100000272022110114.el7-188919f8128394bf9b62e3989220ded05f1d14da repository install ok
Remote oceanbase-ce-4.0.0.0-100000272022110114.el7-42611dc51ca9bb28f36e60e4406ceea4a74914c7 repository lib check ok
demo deployed
Get local repositories ok
Search plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start observer ok
[WARN] OBD-1007: (127.0.0.1) The recommended number of open files is 655350 (Current value: 102400)
[WARN] (127.0.0.1) clog and data use the same disk (/)
Check before start obagent ok
Check before start prometheus ok
Check before start obproxy ok
Check before start grafana ok
Start observer ok
observer program health check ok
Connect to observer ok
Initialize cluster ok
Start obagent ok
obagent program health check ok
Start promethues ok
prometheus program health check ok
Connect to Prometheus ok
Initialize cluster ok
Start obproxy ok
obproxy program health check x
[WARN] failed to start 127.0.0.1 obproxy
[ERROR] obproxy-ce start failed
Wait for observer init ok
+---------------------------------------------+
| observer |
+-----------+---------+------+-------+--------+
| ip | version | port | zone | status |
+-----------+---------+------+-------+--------+
| 127.0.0.1 | 4.0.0.0 | 2881 | zone1 | ACTIVE |
+-----------+---------+------+-------+--------+
obclient -h127.0.0.1 -P2881 -uroot -Doceanbase
+-----------------------------------------------------+
| obagent |
+-----------------+-------------+------------+--------+
| ip | server_port | pprof_port | status |
+-----------------+-------------+------------+--------+
| 192.168.207.152 | 8088 | 8089 | active |
+-----------------+-------------+------------+--------+
+--------------------------------------------------------+
| prometheus |
+-----------------------------+------+----------+--------+
| url | user | password | status |
+-----------------------------+------+----------+--------+
| http://192.168.207.152:9090 | | | active |
+-----------------------------+------+----------+--------+
See https://www.oceanbase.com/product/ob-deployer/error-codes .
[root@ceph02 bin]# vi /etc/security/limits.conf
# /etc/security/limits.conf
#
#This file sets the resource limits for the users logged in via PAM.
#It does not affect resource limits of the system services.
#
#Also note that configuration files in /etc/security/limits.d directory,
#which are read in alphabetical order, override the settings in this
#file in case the domain is the same or more specific.
#That means for example that setting a limit for wildcard domain here
#can be overriden with a wildcard setting in a config file in the
#subdirectory, but a user specific setting here can be overriden only
#with a user specific setting in the subdirectory.
#
#Each line describes a limit for a user in the form:
#
#<domain> <type> <item> <value>
#
#Where:
#<domain> can be:
# - a user name
# - a group name, with @group syntax
# - the wildcard *, for default entry
# - the wildcard %, can be also used with %group syntax,
# for maxlogin limit
#
#<type> can have the two values:
# - "soft" for enforcing the soft limits
# - "hard" for enforcing hard limits
#
#<item> can be one of the following:
# - core - limits the core file size (KB)
# - data - max data size (KB)
# - fsize - maximum filesize (KB)
# - memlock - max locked-in-memory address space (KB)
# - nofile - max number of open file descriptors
# - rss - max resident set size (KB)
# - stack - max stack size (KB)
# - cpu - max CPU time (MIN)
# - nproc - max number of processes
# - as - address space limit (KB)
# - maxlogins - max number of logins for this user
# - maxsyslogins - max number of logins on the system
# - priority - the priority to run user process with
# - locks - max number of file locks the user can hold
# - sigpending - max number of pending signals
# - msgqueue - max memory used by POSIX message queues (bytes)
# - nice - max nice priority allowed to raise to values: [-20, 19]
# - rtprio - max realtime priority
#
#<domain> <type> <item> <value>
#
#* soft core 0
#* hard rss 10000
#@student hard nproc 20
#@faculty soft nproc 20
#@faculty hard nproc 50
#ftp hard nproc 0
#@student - maxlogins 4
# End of file
* soft memlock unlimited
* hard memlock unlimited
* soft nofile 102400
* hard nofile 102400
* soft nofile 1024000
* hard nofile 1024000
"/etc/security/limits.conf" 65L, 2516C written
[root@ceph02 bin]# cat /etc/security/limits.conf
# /etc/security/limits.conf
#
#This file sets the resource limits for the users logged in via PAM.
#It does not affect resource limits of the system services.
#
#Also note that configuration files in /etc/security/limits.d directory,
#which are read in alphabetical order, override the settings in this
#file in case the domain is the same or more specific.
#That means for example that setting a limit for wildcard domain here
#can be overriden with a wildcard setting in a config file in the
#subdirectory, but a user specific setting here can be overriden only
#with a user specific setting in the subdirectory.
#
#Each line describes a limit for a user in the form:
#
#<domain> <type> <item> <value>
#
#Where:
#<domain> can be:
# - a user name
# - a group name, with @group syntax
# - the wildcard *, for default entry
# - the wildcard %, can be also used with %group syntax,
# for maxlogin limit
#
#<type> can have the two values:
# - "soft" for enforcing the soft limits
# - "hard" for enforcing hard limits
#
#<item> can be one of the following:
# - core - limits the core file size (KB)
# - data - max data size (KB)
# - fsize - maximum filesize (KB)
# - memlock - max locked-in-memory address space (KB)
# - nofile - max number of open file descriptors
# - rss - max resident set size (KB)
# - stack - max stack size (KB)
# - cpu - max CPU time (MIN)
# - nproc - max number of processes
# - as - address space limit (KB)
# - maxlogins - max number of logins for this user
# - maxsyslogins - max number of logins on the system
# - priority - the priority to run user process with
# - locks - max number of file locks the user can hold
# - sigpending - max number of pending signals
# - msgqueue - max memory used by POSIX message queues (bytes)
# - nice - max nice priority allowed to raise to values: [-20, 19]
# - rtprio - max realtime priority
#
#<domain> <type> <item> <value>
#
#* soft core 0
#* hard rss 10000
#@student hard nproc 20
#@faculty soft nproc 20
#@faculty hard nproc 50
#ftp hard nproc 0
#@student - maxlogins 4
# End of file
* soft memlock unlimited
* hard memlock unlimited
* soft nofile 1024000
* hard nofile 1024000
[root@ceph02 bin]# ulimit -HSn 1024000
[root@ceph02 bin]# obd demo
Get local repositories ok
Search plugins ok
Open ssh connection ok
Cluster status check ok
[ERROR] Some of the servers in the cluster are running
127.0.0.1 oceanbase-ce is running
127.0.0.1 obagent is running
127.0.0.1 prometheus is running
127.0.0.1 obproxy-ce is running
You could try using -f to force kill process
See https://www.oceanbase.com/product/ob-deployer/error-codes .
[root@ceph02 bin]# obd demo -f
Get local repositories ok
Search plugins ok
Open ssh connection ok
Cluster status check ok
[ERROR] Some of the servers in the cluster are running
127.0.0.1 oceanbase-ce is running
127.0.0.1 obagent is running
127.0.0.1 prometheus is running
127.0.0.1 obproxy-ce is running
You could try using -f to force kill process
See https://www.oceanbase.com/product/ob-deployer/error-codes .
[root@ceph02 bin]# obclient -h127.0.0.1 -uroot -P2881
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221488805
Server version: OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov 1 2022 14:57:18)
Copyright (c) 2000, 2018, OB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| LBACSYS |
| mysql |
| oceanbase |
| ORAAUDITOR |
| SYS |
| test |
+--------------------+
7 rows in set (0.004 sec)
obclient [(none)]> use oceanbase;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
obclient [oceanbase]> show tables;
+-------------------------------------------+
| Tables_in_oceanbase |
+-------------------------------------------+
| CDB_INDEXES |
| CDB_IND_COLUMNS |
| CDB_IND_PARTITIONS |
| CDB_IND_SUBPARTITIONS |
| CDB_OBJECTS |
| CDB_OB_ARCHIVELOG |
| CDB_OB_ARCHIVELOG_PIECE_FILES |
| CDB_OB_ARCHIVELOG_SUMMARY |
| CDB_OB_ARCHIVE_DEST |
| CDB_OB_AUTO_INCREMENT |
| CDB_OB_BACKUP_DELETE_JOBS |
| CDB_OB_BACKUP_DELETE_JOB_HISTORY |
| CDB_OB_BACKUP_DELETE_POLICY |
| CDB_OB_BACKUP_DELETE_TASKS |
| CDB_OB_BACKUP_DELETE_TASK_HISTORY |
| CDB_OB_BACKUP_JOBS |
| CDB_OB_BACKUP_JOB_HISTORY |
| CDB_OB_BACKUP_PARAMETER |
| CDB_OB_BACKUP_SET_FILES |
| CDB_OB_BACKUP_STORAGE_INFO |
| CDB_OB_BACKUP_STORAGE_INFO_HISTORY |
| CDB_OB_BACKUP_TASKS |
| CDB_OB_BACKUP_TASK_HISTORY |
| CDB_OB_COLUMN_CHECKSUM_ERROR_INFO |
| CDB_OB_DATABASES |
| CDB_OB_DATABASE_PRIVILEGE |
| CDB_OB_DEADLOCK_EVENT_HISTORY |
| CDB_OB_FREEZE_INFO |
| CDB_OB_LS |
| CDB_OB_LS_LOCATIONS |
| CDB_OB_LS_REPLICA_TASKS |
| CDB_OB_MAJOR_COMPACTION |
| CDB_OB_RESTORE_HISTORY |
| CDB_OB_RESTORE_PROGRESS |
| CDB_OB_SYS_VARIABLES |
| CDB_OB_TABLEGROUPS |
| CDB_OB_TABLEGROUP_PARTITIONS |
| CDB_OB_TABLEGROUP_SUBPARTITIONS |
| CDB_OB_TABLEGROUP_TABLES |
| CDB_OB_TABLET_CHECKSUM_ERROR_INFO |
| CDB_OB_TABLET_REPLICAS |
| CDB_OB_TABLET_TO_LS |
| CDB_OB_TABLE_LOCATIONS |
| CDB_OB_USERS |
| CDB_OB_ZONE_MAJOR_COMPACTION |
| CDB_PART_INDEXES |
| CDB_PART_KEY_COLUMNS |
| CDB_PART_TABLES |
| CDB_SUBPARTITION_TEMPLATES |
| CDB_SUBPART_KEY_COLUMNS |
| CDB_TABLES |
| CDB_TAB_COLS |
| CDB_TAB_COLS_V$ |
| CDB_TAB_COL_STATISTICS |
| CDB_TAB_PARTITIONS |
| CDB_TAB_SUBPARTITIONS |
| DBA_IND_PARTITIONS |
| DBA_IND_STATISTICS |
| DBA_IND_SUBPARTITIONS |
| DBA_OBJECTS |
| DBA_OB_ARCHIVELOG |
| DBA_OB_ARCHIVELOG_PIECE_FILES |
| DBA_OB_ARCHIVELOG_SUMMARY |
| DBA_OB_ARCHIVE_DEST |
| DBA_OB_AUTO_INCREMENT |
| DBA_OB_BACKUP_DELETE_JOBS |
| DBA_OB_BACKUP_DELETE_JOB_HISTORY |
| DBA_OB_BACKUP_DELETE_POLICY |
| DBA_OB_BACKUP_DELETE_TASKS |
| DBA_OB_BACKUP_DELETE_TASK_HISTORY |
| DBA_OB_BACKUP_JOBS |
| DBA_OB_BACKUP_JOB_HISTORY |
| DBA_OB_BACKUP_PARAMETER |
| DBA_OB_BACKUP_SET_FILES |
| DBA_OB_BACKUP_STORAGE_INFO |
| DBA_OB_BACKUP_STORAGE_INFO_HISTORY |
| DBA_OB_BACKUP_TASKS |
| DBA_OB_BACKUP_TASK_HISTORY |
| DBA_OB_CONCURRENT_LIMIT_SQL |
| DBA_OB_DATABASES |
| DBA_OB_DATABASE_PRIVILEGE |
| DBA_OB_DEADLOCK_EVENT_HISTORY |
| DBA_OB_FREEZE_INFO |
| DBA_OB_LS |
| DBA_OB_LS_LOCATIONS |
| DBA_OB_LS_REPLICA_TASKS |
| DBA_OB_MAJOR_COMPACTION |
| DBA_OB_OUTLINES |
| DBA_OB_OUTLINE_CONCURRENT_HISTORY |
| DBA_OB_RESOURCE_POOLS |
| DBA_OB_RESTORE_HISTORY |
| DBA_OB_RESTORE_PROGRESS |
| DBA_OB_ROOTSERVICE_EVENT_HISTORY |
| DBA_OB_SEQUENCE_OBJECTS |
| DBA_OB_SERVERS |
| DBA_OB_SERVER_EVENT_HISTORY |
| DBA_OB_SERVER_JOBS |
| DBA_OB_TABLEGROUPS |
| DBA_OB_TABLEGROUP_PARTITIONS |
| DBA_OB_TABLEGROUP_SUBPARTITIONS |
| DBA_OB_TABLEGROUP_TABLES |
| DBA_OB_TABLET_REPLICAS |
| DBA_OB_TABLET_TO_LS |
| DBA_OB_TABLE_LOCATIONS |
| DBA_OB_TENANTS |
| DBA_OB_TENANT_JOBS |
| DBA_OB_UNITS |
| DBA_OB_UNIT_CONFIGS |
| DBA_OB_UNIT_JOBS |
| DBA_OB_USERS |
| DBA_OB_ZONES |
| DBA_OB_ZONE_MAJOR_COMPACTION |
| DBA_PART_COL_STATISTICS |
| DBA_PART_HISTOGRAMS |
| DBA_PART_INDEXES |
| DBA_PART_KEY_COLUMNS |
| DBA_PART_TABLES |
| DBA_RECYCLEBIN |
| DBA_SCHEDULER_JOBS |
| DBA_SCHEDULER_WINDOWS |
| DBA_SEQUENCES |
| DBA_SQL_MANAGEMENT_CONFIG |
| DBA_SQL_PLAN_BASELINES |
| DBA_SUBPARTITION_TEMPLATES |
| DBA_SUBPART_COL_STATISTICS |
| DBA_SUBPART_HISTOGRAMS |
| DBA_SUBPART_KEY_COLUMNS |
| DBA_TAB_COL_STATISTICS |
| DBA_TAB_HISTOGRAMS |
| DBA_TAB_MODIFICATIONS |
| DBA_TAB_PARTITIONS |
| DBA_TAB_STATISTICS |
| DBA_TAB_STATS_HISTORY |
| DBA_TAB_SUBPARTITIONS |
| GV$ACTIVE_SESSION_HISTORY |
| GV$DML_STATS |
| GV$LATCH |
| GV$OB_COMPACTION_DIAGNOSE_INFO |
| GV$OB_COMPACTION_PROGRESS |
| GV$OB_COMPACTION_SUGGESTIONS |
| GV$OB_DTL_INTERM_RESULT_MONITOR |
| GV$OB_IO_BENCHMARK |
| GV$OB_IO_CALIBRATION_STATUS |
| GV$OB_KVCACHE |
| GV$OB_LOG_STAT |
| GV$OB_MEMORY |
| GV$OB_MEMSTORE |
| GV$OB_MEMSTORE_INFO |
| GV$OB_MERGE_INFO |
| GV$OB_PARAMETERS |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN |
| GV$OB_PLAN_CACHE_PLAN_STAT |
| GV$OB_PLAN_CACHE_REFERENCE_INFO |
| GV$OB_PLAN_CACHE_STAT |
| GV$OB_PROCESSLIST |
| GV$OB_PS_ITEM_INFO |
| GV$OB_PS_STAT |
| GV$OB_PX_TARGET_MONITOR |
| GV$OB_PX_WORKER_STAT |
| GV$OB_RPC_INCOMING |
| GV$OB_RPC_OUTGOING |
| GV$OB_SERVERS |
| GV$OB_SERVER_SCHEMA_INFO |
| GV$OB_SQL_AUDIT |
| GV$OB_SQL_WORKAREA_MEMORY_INFO |
| GV$OB_SSTABLES |
| GV$OB_TABLET_COMPACTION_HISTORY |
| GV$OB_TABLET_COMPACTION_PROGRESS |
| GV$OB_TENANT_MEMORY |
| GV$OB_TRANSACTION_PARTICIPANTS |
| GV$OB_UNITS |
| GV$SESSION_EVENT |
| GV$SESSION_LONGOPS |
| GV$SESSION_WAIT |
| GV$SESSION_WAIT_HISTORY |
| GV$SESSTAT |
| GV$SQL_PLAN_MONITOR |
| GV$SQL_WORKAREA |
| GV$SQL_WORKAREA_ACTIVE |
| GV$SQL_WORKAREA_HISTOGRAM |
| GV$SYSSTAT |
| GV$SYSTEM_EVENT |
| V$ACTIVE_SESSION_HISTORY |
| V$DML_STATS |
| V$ENCRYPTED_TABLESPACES |
| V$EVENT_NAME |
| V$LATCH |
| V$OB_COMPACTION_DIAGNOSE_INFO |
| V$OB_COMPACTION_PROGRESS |
| V$OB_COMPACTION_SUGGESTIONS |
| V$OB_DTL_INTERM_RESULT_MONITOR |
| V$OB_ENCRYPTED_TABLES |
| V$OB_IO_BENCHMARK |
| V$OB_IO_CALIBRATION_STATUS |
| V$OB_KVCACHE |
| V$OB_LOG_STAT |
| V$OB_LS_REPLICA_TASK_PLAN |
| V$OB_MEMORY |
| V$OB_MEMSTORE |
| V$OB_MEMSTORE_INFO |
| V$OB_MERGE_INFO |
| V$OB_PARAMETERS |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN |
| V$OB_PLAN_CACHE_PLAN_STAT |
| V$OB_PLAN_CACHE_REFERENCE_INFO |
| V$OB_PLAN_CACHE_STAT |
| V$OB_PROCESSLIST |
| V$OB_PS_ITEM_INFO |
| V$OB_PS_STAT |
| V$OB_PX_TARGET_MONITOR |
| V$OB_PX_WORKER_STAT |
| V$OB_RPC_INCOMING |
| V$OB_RPC_OUTGOING |
| V$OB_SERVERS |
| V$OB_SERVER_SCHEMA_INFO |
| V$OB_SQL_AUDIT |
| V$OB_SQL_WORKAREA_MEMORY_INFO |
| V$OB_SSTABLES |
| V$OB_TABLET_COMPACTION_HISTORY |
| V$OB_TABLET_COMPACTION_PROGRESS |
| V$OB_TENANT_MEMORY |
| V$OB_TRANSACTION_PARTICIPANTS |
| V$OB_UNITS |
| V$SESSION_EVENT |
| V$SESSION_LONGOPS |
| V$SESSION_WAIT |
| V$SESSION_WAIT_HISTORY |
| V$SESSTAT |
| V$SQL_MONITOR_STATNAME |
| V$SQL_PLAN_MONITOR |
| V$SQL_WORKAREA |
| V$SQL_WORKAREA_ACTIVE |
| V$SQL_WORKAREA_HISTOGRAM |
| V$STATNAME |
| V$SYSSTAT |
| V$SYSTEM_EVENT |
| __all_acquired_snapshot |
| __all_auto_increment |
| __all_backup_delete_job |
| __all_backup_delete_job_history |
| __all_backup_delete_ls_task |
| __all_backup_delete_ls_task_history |
| __all_backup_delete_policy |
| __all_backup_delete_task |
| __all_backup_delete_task_history |
| __all_backup_info |
| __all_backup_job |
| __all_backup_job_history |
| __all_backup_ls_task |
| __all_backup_ls_task_history |
| __all_backup_ls_task_info |
| __all_backup_ls_task_info_history |
| __all_backup_parameter |
| __all_backup_set_files |
| __all_backup_skipped_tablet |
| __all_backup_skipped_tablet_history |
| __all_backup_storage_info |
| __all_backup_storage_info_history |
| __all_backup_task |
| __all_backup_task_history |
| __all_balance_group_ls_stat |
| __all_charset |
| __all_coll_type |
| __all_coll_type_history |
| __all_collation |
| __all_column |
| __all_column_checksum_error_info |
| __all_column_history |
| __all_column_stat |
| __all_column_stat_history |
| __all_column_usage |
| __all_constraint |
| __all_constraint_history |
| __all_context |
| __all_context_history |
| __all_core_table |
| __all_dam_cleanup_jobs |
| __all_dam_last_arch_ts |
| __all_database |
| __all_database_history |
| __all_database_privilege |
| __all_database_privilege_history |
| __all_dblink |
| __all_dblink_history |
| __all_ddl_checksum |
| __all_ddl_error_message |
| __all_ddl_id |
| __all_ddl_operation |
| __all_ddl_task_status |
| __all_deadlock_event_history |
| __all_def_sub_part |
| __all_def_sub_part_history |
| __all_disk_io_calibration |
| __all_dummy |
| __all_foreign_key |
| __all_foreign_key_column |
| __all_foreign_key_column_history |
| __all_foreign_key_history |
| __all_freeze_info |
| __all_freeze_schema_version |
| __all_func |
| __all_func_history |
| __all_global_context_value |
| __all_histogram_stat |
| __all_histogram_stat_history |
| __all_job |
| __all_job_log |
| __all_log_archive_dest_parameter |
| __all_log_archive_history |
| __all_log_archive_piece_files |
| __all_log_archive_progress |
| __all_log_restore_source |
| __all_ls |
| __all_ls_election_reference_info |
| __all_ls_log_archive_progress |
| __all_ls_meta_table |
| __all_ls_recovery_stat |
| __all_ls_replica_task |
| __all_ls_restore_history |
| __all_ls_restore_progress |
| __all_ls_status |
| __all_merge_info |
| __all_mock_fk_parent_table |
| __all_mock_fk_parent_table_column |
| __all_mock_fk_parent_table_column_history |
| __all_mock_fk_parent_table_history |
| __all_monitor_modified |
| __all_optstat_global_prefs |
| __all_optstat_user_prefs |
| __all_ori_schema_version |
| __all_outline |
| __all_outline_history |
| __all_package |
| __all_package_history |
| __all_part |
| __all_part_history |
| __all_part_info |
| __all_part_info_history |
| __all_pending_transaction |
| __all_plan_baseline |
| __all_plan_baseline_item |
| __all_privilege |
| __all_recyclebin |
| __all_region_network_bandwidth_limit |
| __all_res_mgr_consumer_group |
| __all_res_mgr_directive |
| __all_res_mgr_mapping_rule |
| __all_res_mgr_plan |
| __all_resource_pool |
| __all_restore_info |
| __all_restore_job |
| __all_restore_job_history |
| __all_restore_progress |
| __all_rootservice_event_history |
| __all_rootservice_job |
| __all_routine |
| __all_routine_history |
| __all_routine_param |
| __all_routine_param_history |
| __all_seed_parameter |
| __all_sequence_object |
| __all_sequence_object_history |
| __all_sequence_value |
| __all_server |
| __all_server_event_history |
| __all_service_epoch |
| __all_space_usage |
| __all_spm_config |
| __all_sub_part |
| __all_sub_part_history |
| __all_synonym |
| __all_synonym_history |
| __all_sys_parameter |
| __all_sys_stat |
| __all_sys_variable |
| __all_sys_variable_history |
| __all_table |
| __all_table_history |
| __all_table_privilege |
| __all_table_privilege_history |
| __all_table_stat |
| __all_table_stat_history |
| __all_tablegroup |
| __all_tablegroup_history |
| __all_tablet_checksum |
| __all_tablet_meta_table |
| __all_tablet_replica_checksum |
| __all_tablet_to_ls |
| __all_tablet_to_table_history |
| __all_temp_table |
| __all_tenant |
| __all_tenant_constraint_column |
| __all_tenant_constraint_column_history |
| __all_tenant_dependency |
| __all_tenant_directory |
| __all_tenant_directory_history |
| __all_tenant_error |
| __all_tenant_global_transaction |
| __all_tenant_history |
| __all_tenant_info |
| __all_tenant_keystore |
| __all_tenant_keystore_history |
| __all_tenant_objauth |
| __all_tenant_objauth_history |
| __all_tenant_object_type |
| __all_tenant_object_type_history |
| __all_tenant_ols_component |
| __all_tenant_ols_component_history |
| __all_tenant_ols_label |
| __all_tenant_ols_label_history |
| __all_tenant_ols_policy |
| __all_tenant_ols_policy_history |
| __all_tenant_ols_user_level |
| __all_tenant_ols_user_level_history |
| __all_tenant_profile |
| __all_tenant_profile_history |
| __all_tenant_role_grantee_map |
| __all_tenant_role_grantee_map_history |
| __all_tenant_scheduler_job |
| __all_tenant_scheduler_job_run_detail |
| __all_tenant_scheduler_program |
| __all_tenant_scheduler_program_argument |
| __all_tenant_security_audit |
| __all_tenant_security_audit_history |
| __all_tenant_security_audit_record |
| __all_tenant_sysauth |
| __all_tenant_sysauth_history |
| __all_tenant_tablespace |
| __all_tenant_tablespace_history |
| __all_tenant_time_zone |
| __all_tenant_time_zone_name |
| __all_tenant_time_zone_transition |
| __all_tenant_time_zone_transition_type |
| __all_tenant_trigger |
| __all_tenant_trigger_history |
| __all_tenant_user_failed_login_stat |
| __all_type |
| __all_type_attr |
| __all_type_attr_history |
| __all_type_history |
| __all_unit |
| __all_unit_config |
| __all_user |
| __all_user_history |
| __all_weak_read_service |
| __all_zone |
| __all_zone_merge_info |
| __tenant_parameter |
+-------------------------------------------+
448 rows in set (0.004 sec)
obclient [oceanbase]> exit
Bye
[root@ceph02 bin]# obclient -h127.0.0.1 -uroot -P2881
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221490456
Server version: OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov 1 2022 14:57:18)
Copyright (c) 2000, 2018, OB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient [(none)]> \q
Bye
[root@ceph02 bin]# obclient -h127.0.0.1 -uroot -P2881 -Doceanbase
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221490649
Server version: OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov 1 2022 14:57:18)
Copyright (c) 2000, 2018, OB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient [oceanbase]> \h
General information about OceanBase can be found at
https://www.oceanbase.com
List of all client commands:
Note that all text commands must be first on line and end with ';'
? (\?) Synonym for `help'.
clear (\c) Clear the current input statement.
connect (\r) Reconnect to the server. Optional arguments are db and host.
conn (\) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
edit (\e) Edit command with $EDITOR.
ego (\G) Send command to OceanBase server, display result vertically.
exit (\q) Exit mysql. Same as quit.
go (\g) Send command to OceanBase server.
help (\h) Display this help.
nopager (\n) Disable pager, print to stdout.
notee (\t) Don't write into outfile.
pager (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print (\p) Print current command.
prompt (\R) Change your mysql prompt.
quit (\q) Quit mysql.
rehash (\#) Rebuild completion hash.
source (\.) Execute an SQL script file. Takes a file name as an argument.
status (\s) Get status information from the server.
system (\!) Execute a system shell command.
tee (\T) Set outfile [to_outfile]. Append everything into given outfile.
use (\u) Use another database. Takes database name as argument.
charset (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
warnings (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.
For server side help, type 'help contents'
obclient [oceanbase]> \q
Bye
[root@ceph02 bin]# obclient -h127.0.0.1 -uroot -P2881 -Doceanbase
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221491738
Server version: OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov 1 2022 14:57:18)
Copyright (c) 2000, 2018, OB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient [oceanbase]> SELECT SYSDATE() FROM dual;
+---------------------+
| SYSDATE() |
+---------------------+
| 2022-11-04 10:12:26 |
+---------------------+
1 row in set (0.002 sec)
obclient [oceanbase]> select * from v$ob_cluster;
ERROR 1146 (42S02): Table 'oceanbase.v$ob_cluster' doesn't exist
obclient [oceanbase]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| LBACSYS |
| mysql |
| oceanbase |
| ORAAUDITOR |
| SYS |
| test |
+--------------------+
7 rows in set (0.004 sec)
obclient [oceanbase]> use sys;
Database changed
obclient [sys]> select * from v$ob_cluster;
ERROR 1146 (42S02): Table 'SYS.v$ob_cluster' doesn't exist
obclient [sys]> SELECT * FROM oceanbase.DBA_OB_TENANTS;
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------+-------------------+--------------------+--------+---------------+--------+
| TENANT_ID | TENANT_NAME | TENANT_TYPE | CREATE_TIME | MODIFY_TIME | PRIMARY_ZONE | LOCALITY | PREVIOUS_LOCALITY | COMPATIBILITY_MODE | STATUS | IN_RECYCLEBIN | LOCKED |
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------+-------------------+--------------------+--------+---------------+--------+
| 1 | sys | SYS | 2022-11-04 10:06:29.803630 | 2022-11-04 10:06:29.803630 | RANDOM | FULL{1}@zone1 | NULL | MYSQL | NORMAL | NO | NO |
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------+-------------------+--------------------+--------+---------------+--------+
1 row in set (0.006 sec)
obclient [sys]> SELECT * FROM oceanbase.GV$OB_UNITS;
+-----------+----------+---------+-----------+-------+---------+---------+-------------+----------+----------+-------------+---------------+-----------------+------------------+--------+----------------------------+
| SVR_IP | SVR_PORT | UNIT_ID | TENANT_ID | ZONE | MAX_CPU | MIN_CPU | MEMORY_SIZE | MAX_IOPS | MIN_IOPS | IOPS_WEIGHT | LOG_DISK_SIZE | LOG_DISK_IN_USE | DATA_DISK_IN_USE | STATUS | CREATE_TIME |
+-----------+----------+---------+-----------+-------+---------+---------+-------------+----------+----------+-------------+---------------+-----------------+------------------+--------+----------------------------+
| 127.0.0.1 | 2882 | 1 | 1 | zone1 | 1 | 1 | 2147483648 | 10000 | 10000 | 1 | 2147483648 | 81583908 | 50331648 | NORMAL | 2022-11-04 10:05:48.243295 |
+-----------+----------+---------+-----------+-------+---------+---------+-------------+----------+----------+-------------+---------------+-----------------+------------------+--------+----------------------------+
1 row in set (0.004 sec)
obclient [sys]> SELECT * FROM oceanbase.GV$OB_UNITS\G
*************************** 1. row ***************************
SVR_IP: 127.0.0.1
SVR_PORT: 2882
UNIT_ID: 1
TENANT_ID: 1
ZONE: zone1
MAX_CPU: 1
MIN_CPU: 1
MEMORY_SIZE: 2147483648
MAX_IOPS: 10000
MIN_IOPS: 10000
IOPS_WEIGHT: 1
LOG_DISK_SIZE: 2147483648
LOG_DISK_IN_USE: 81615479
DATA_DISK_IN_USE: 50331648
STATUS: NORMAL
CREATE_TIME: 2022-11-04 10:05:48.243295
1 row in set (0.001 sec)
obclient [sys]> \q
Bye
[root@ceph02 bin]# obclient -h127.0.0.1 -uroot -P2881 -Doceanbase
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221496706
Server version: OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov 1 2022 14:57:18)
Copyright (c) 2000, 2018, OB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient [oceanbase]> \q
Bye
[root@ceph02 bin]# obclient -h127.0.0.1 -uroot@obtenant -P2881 -c -Aoceanbase
ERROR 1045 (42000): Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: NO)
[root@ceph02 bin]# obclient -h127.0.0.1 -uroot@obtenant -P2881 -c -Aoceanbase -p
Enter password:
ERROR 1045 (42000): Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: NO)
[root@ceph02 bin]# obclient -h127.0.0.1 -uroot@sys -P2881 -c -Aoceanbase -p
Enter password:
[root@ceph02 bin]# obclient -h127.0.0.1 -uroot@sys -P2881 -c -Aoceanbase
[root@ceph02 bin]# obclient -h127.0.0.1 -uroot@sys -P2881 -c -Doceanbase
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221498885
Server version: OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov 1 2022 14:57:18)
Copyright (c) 2000, 2018, OB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient [oceanbase]> SHOW TENANT;
+---------------------+
| Current_tenant_name |
+---------------------+
| sys |
+---------------------+
1 row in set (0.003 sec)
obclient [oceanbase]> SELECT effective_tenant();
+--------------------+
| effective_tenant() |
+--------------------+
| sys |
+--------------------+
1 row in set (0.002 sec)
obclient [oceanbase]> SHOW TENANT STATUS;
+--------+------------+
| Tenant | Status |
+--------+------------+
| sys | read write |
+--------+------------+
1 row in set (0.005 sec)
obclient [oceanbase]> SELECT effective_tenant_id();
+-----------------------+
| effective_tenant_id() |
+-----------------------+
| 1 |
+-----------------------+
1 row in set (0.002 sec)
obclient [oceanbase]> \q
Bye
[root@ceph02 bin]# obclient -h192.168.207.151 -uroot@sys#demo -P2883 -p -c -A oceanbase
Enter password:
ERROR 2002 (HY000): Can't connect to MySQL server on '192.168.207.151' (115)
[root@ceph02 bin]# netstat -tunlp|grep 288
bash: netstat: 未找到命令
[root@ceph02 bin]# yum install net-tools -y
已加载插件：fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.bupt.edu.cn
* epel: d2lzkl7pfhq30w.cloudfront.net
* extras: mirrors.bupt.edu.cn
* updates: mirrors.bupt.edu.cn
正在解决依赖关系
--> 正在检查事务
---> 软件包 net-tools.x86_64.0.2.0-0.25.20131004git.el7 将被 安装
--> 解决依赖关系完成
依赖关系解决
======================================================================================================================================================================
Package 架构 版本 源 大小
======================================================================================================================================================================
正在安装:
net-tools x86_64 2.0-0.25.20131004git.el7 base 306 k
事务概要
======================================================================================================================================================================
安装 1 软件包
总下载量：306 k
安装大小：917 k
Downloading packages:
net-tools-2.0-0.25.20131004git.el7.x86_64.rpm | 306 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
正在安装 : net-tools-2.0-0.25.20131004git.el7.x86_64 1/1
验证中 : net-tools-2.0-0.25.20131004git.el7.x86_64 1/1
已安装:
net-tools.x86_64 0:2.0-0.25.20131004git.el7
完毕！
[root@ceph02 bin]# obclient -h192.168.207.151 -uroot@sys#demo -P2883 -p -c -A oceanbase
Enter password:
ERROR 2002 (HY000): Can't connect to MySQL server on '192.168.207.151' (115)
[root@ceph02 bin]# netstat -tunlp|grep 288
tcp 0 0 0.0.0.0:2881 0.0.0.0:* LISTEN 29059/observer
tcp 0 0 0.0.0.0:2882 0.0.0.0:* LISTEN 29059/observer
[root@ceph02 bin]# obclient -h192.168.207.151 -uroot@sys#demo -P2882 -p -c -A oceanbase
Enter password:
ERROR 2002 (HY000): Can't connect to MySQL server on '192.168.207.151' (115)
[root@ceph02 bin]# obclient -h127.0.0.1 -uroot@sys -P2881 -c -A -Doceanbase
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221501250
Server version: OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov 1 2022 14:57:18)
Copyright (c) 2000, 2018, OB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient [oceanbase]> SELECT effective_tenant_id();
+-----------------------+
| effective_tenant_id() |
+-----------------------+
| 1 |
+-----------------------+
1 row in set (0.000 sec)
obclient [oceanbase]> \q
Bye
[root@ceph02 bin]# obclient -h127.0.0.1 -uroot@sys -P2881 -c -A -Doceanbase
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221501414
Server version: OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov 1 2022 14:57:18)
Copyright (c) 2000, 2018, OB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient [oceanbase]> SELECT SYSDATE() FROM dual;
+---------------------+
| SYSDATE() |
+---------------------+
| 2022-11-04 10:25:29 |
+---------------------+
1 row in set (0.001 sec)
obclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;zone2,zone3', RESOURCE_POOL_LIST=('pool1')；
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near '；' at line 1
obclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;zone2,zone3', RESOURCE_POOL_LIST=('pool1');
ERROR 4650 (HY000): resource pool 'pool1' not exist
obclient [oceanbase]> CREATE RESOURCE UNIT unit1 MAX_CPU 1, MIN_CPU 1, MEMORY_SIZE '2G', MAX_IOPS 1024, MIN_IOPS 1024, IOPS_WEIGHT 0, LOG_DISK_SIZE '2G';
Query OK, 0 rows affected (0.085 sec)
obclient [oceanbase]> CREATE RESOURCE UNIT unit1 MAX_CPU 1, MEMORY_SIZE '2G';
ERROR 4649 (HY000): resource unit 'unit1' already exist
obclient [oceanbase]> CREATE RESOURCE POOL pool1 UNIT='unit1',UNIT_NUM=1,ZONE_LIST=('zone1','zone2','zone3');
ERROR 4530 (HY000): Zone info 'zone2' not exist
obclient [oceanbase]> CREATE RESOURCE POOL pool1 UNIT='unit1',UNIT_NUM=1,ZONE_LIST=('zone1');
Query OK, 0 rows affected (1.507 sec)
obclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;zone2,zone3', RESOURCE_POOL_LIST=('pool1');
ERROR 1210 (HY000): Incorrect arguments to primary zone
obclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;zone2,zone3', RESOURCE_POOL_obclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;zone2,zone', RESOURCE_POOL_Lobclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;zone2,zon', RESOURCE_POOL_LIobclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;zone2,zo', RESOURCE_POOL_LISobclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;zone2,z', RESOURCE_POOL_LISTobclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;zone2,', RESOURCE_POOL_LIST=obclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;zone2', RESOURCE_POOL_LIST=(obclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;zone', RESOURCE_POOL_LIST=('obclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;zon', RESOURCE_POOL_LIST=('pobclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;zo', RESOURCE_POOL_LIST=('poobclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;z', RESOURCE_POOL_LIST=('pooobclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1;', RESOURCE_POOL_LIST=('poolobclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3'), PRIMARY_ZONE='zone1', RESOURCE_POOL_LIST=('pool1obclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone3), PRIMARY_ZONE='zone1', RESOURCE_POOL_LIST=('pool1'obclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zone), PRIMARY_ZONE='zone1', RESOURCE_POOL_LIST=('pool1')obclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zon), PRIMARY_ZONE='zone1', RESOURCE_POOL_LIST=('pool1');obclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1','zone2','zo), PRIMARY_ZONE='zone1', RESOURCE_POOL_LIST=('pool1');
obclient [oceanbase]> CREATE TENANT IF NOT EXISTS test_tenant CHARSET='utf8mb4', ZONE_LIST=('zone1'), PRIMARY_ZONE='zone1', RESOURCE_POOL_LIST=('pool1');
Query OK, 0 rows affected (25.517 sec)
obclient [oceanbase]>
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_TENANTS\G
*************************** 1. row ***************************
TENANT_ID: 1
TENANT_NAME: sys
TENANT_TYPE: SYS
CREATE_TIME: 2022-11-04 10:06:29.803630
MODIFY_TIME: 2022-11-04 10:06:29.803630
PRIMARY_ZONE: RANDOM
LOCALITY: FULL{1}@zone1
PREVIOUS_LOCALITY: NULL
COMPATIBILITY_MODE: MYSQL
STATUS: NORMAL
IN_RECYCLEBIN: NO
LOCKED: NO
*************************** 2. row ***************************
TENANT_ID: 1005
TENANT_NAME: META$1006
TENANT_TYPE: META
CREATE_TIME: 2022-11-04 10:29:07.041059
MODIFY_TIME: 2022-11-04 10:29:27.300734
PRIMARY_ZONE: zone1
LOCALITY: FULL{1}@zone1
PREVIOUS_LOCALITY: NULL
COMPATIBILITY_MODE: MYSQL
STATUS: NORMAL
IN_RECYCLEBIN: NO
LOCKED: NO
*************************** 3. row ***************************
TENANT_ID: 1006
TENANT_NAME: test_tenant
TENANT_TYPE: USER
CREATE_TIME: 2022-11-04 10:29:07.233124
MODIFY_TIME: 2022-11-04 10:29:27.491458
PRIMARY_ZONE: zone1
LOCALITY: FULL{1}@zone1
PREVIOUS_LOCALITY: NULL
COMPATIBILITY_MODE: MYSQL
STATUS: NORMAL
IN_RECYCLEBIN: NO
LOCKED: NO
3 rows in set (0.004 sec)
obclient [oceanbase]> SHOW PARAMETERS LIKE 'log_disk_utilization_threshold';
+-------+----------+-----------+----------+--------------------------------+-----------+-------+--------------------------------------------------------------------------------------------------------------------------------------+------------+--------+---------+-------------------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level |
+-------+----------+-----------+----------+--------------------------------+-----------+-------+--------------------------------------------------------------------------------------------------------------------------------------+------------+--------+---------+-------------------+
| zone1 | observer | 127.0.0.1 | 2882 | log_disk_utilization_threshold | NULL | 80 | log disk utilization threshold before reuse log files, should be smaller than log_disk_utilization_limit_threshold. Range: [10, 100) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE |
+-------+----------+-----------+----------+--------------------------------+-----------+-------+--------------------------------------------------------------------------------------------------------------------------------------+------------+--------+---------+-------------------+
1 row in set (0.017 sec)
obclient [oceanbase]> SHOW VARIABLES LIKE 'ob_query_timeout';
+------------------+----------+
| Variable_name | Value |
+------------------+----------+
| ob_query_timeout | 10000000 |
+------------------+----------+
1 row in set (0.005 sec)
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_SYS_VARIABLES WHERE NAME = 'ob_query_timeout';
+----------------------------+----------------------------+-----------+------------------+----------+-----------+-----------+------------------+----------------------------------+
| CREATE_TIME | MODIFY_TIME | TENANT_ID | NAME | VALUE | MIN_VALUE | MAX_VALUE | SCOPE | INFO |
+----------------------------+----------------------------+-----------+------------------+----------+-----------+-----------+------------------+----------------------------------+
| 2022-11-04 10:06:29.832733 | 2022-11-04 10:06:29.832733 | 1 | ob_query_timeout | 10000000 | | | GLOBAL | SESSION | Query timeout in microsecond(us) |
| 2022-11-04 10:29:16.576774 | 2022-11-04 10:29:16.576774 | 1005 | ob_query_timeout | 10000000 | | | GLOBAL | SESSION | Query timeout in microsecond(us) |
| 2022-11-04 10:29:25.601409 | 2022-11-04 10:29:25.601409 | 1006 | ob_query_timeout | 10000000 | | | GLOBAL | SESSION | Query timeout in microsecond(us) |
+----------------------------+----------------------------+-----------+------------------+----------+-----------+-----------+------------------+----------------------------------+
3 rows in set (0.013 sec)
[root@ceph02 bin]# history
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
