oceanbase的部署及obd的简单使用
环境
单机部署
| – | 资源 |
|---|---|
| cpu | 2c |
| memory | 10G |
| 磁盘 | 共20G, /redo路径单独存放日志文件给了4G |
| ip | 10.0.2.15 |
obd
OceanBase Deployer 简称 OBD, 用来快速部署oceanbase的工具
obd的安装
命令如下
sudo yum install -y yum-utils sudo yum-config-manager --add-repo https://mirrors.aliyun.com/oceanbase/OceanBase.repo sudo yum install -y ob-deploy
日志
[root@oceanbase_test ~]# sudo yum install -y yum-utils
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.ustc.edu.cn
* extras: mirrors.ustc.edu.cn
* updates: mirrors.cn99.com
Resolving Dependencies
--> Running transaction check
---> Package yum-utils.noarch 0:1.1.31-54.el7_8 will be installed
--> Processing Dependency: python-kitchen for package: yum-utils-1.1.31-54.el7_8.noarch
--> Processing Dependency: libxml2-python for package: yum-utils-1.1.31-54.el7_8.noarch
--> Running transaction check
---> Package libxml2-python.x86_64 0:2.9.1-6.el7_9.6 will be installed
--> Processing Dependency: libxml2 = 2.9.1-6.el7_9.6 for package: libxml2-python-2.9.1-6.el7_9.6.x86_64
---> Package python-kitchen.noarch 0:1.1.1-5.el7 will be installed
--> Processing Dependency: python-chardet for package: python-kitchen-1.1.1-5.el7.noarch
--> Running transaction check
---> Package libxml2.x86_64 0:2.9.1-6.el7.5 will be updated
---> Package libxml2.x86_64 0:2.9.1-6.el7_9.6 will be an update
---> Package python-chardet.noarch 0:2.2.1-3.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
===================================================================================================================================================================================
Package Arch Version Repository Size
===================================================================================================================================================================================
Installing:
yum-utils noarch 1.1.31-54.el7_8 base 122 k
Installing for dependencies:
libxml2-python x86_64 2.9.1-6.el7_9.6 updates 247 k
python-chardet noarch 2.2.1-3.el7 base 227 k
python-kitchen noarch 1.1.1-5.el7 base 267 k
Updating for dependencies:
libxml2 x86_64 2.9.1-6.el7_9.6 updates 668 k
Transaction Summary
===================================================================================================================================================================================
Install 1 Package (+3 Dependent packages)
Upgrade ( 1 Dependent package)
Total download size: 1.5 M
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
(1/5): python-chardet-2.2.1-3.el7.noarch.rpm | 227 kB 00:00:00
(2/5): libxml2-python-2.9.1-6.el7_9.6.x86_64.rpm | 247 kB 00:00:00
(3/5): libxml2-2.9.1-6.el7_9.6.x86_64.rpm | 668 kB 00:00:00
(4/5): yum-utils-1.1.31-54.el7_8.noarch.rpm | 122 kB 00:00:00
(5/5): python-kitchen-1.1.1-5.el7.noarch.rpm | 267 kB 00:00:00
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 2.2 MB/s | 1.5 MB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Updating : libxml2-2.9.1-6.el7_9.6.x86_64 1/6
Installing : libxml2-python-2.9.1-6.el7_9.6.x86_64 2/6
Installing : python-chardet-2.2.1-3.el7.noarch 3/6
Installing : python-kitchen-1.1.1-5.el7.noarch 4/6
Installing : yum-utils-1.1.31-54.el7_8.noarch 5/6
Cleanup : libxml2-2.9.1-6.el7.5.x86_64 6/6
Verifying : python-chardet-2.2.1-3.el7.noarch 1/6
Verifying : libxml2-2.9.1-6.el7_9.6.x86_64 2/6
Verifying : libxml2-python-2.9.1-6.el7_9.6.x86_64 3/6
Verifying : python-kitchen-1.1.1-5.el7.noarch 4/6
Verifying : yum-utils-1.1.31-54.el7_8.noarch 5/6
Verifying : libxml2-2.9.1-6.el7.5.x86_64 6/6
Installed:
yum-utils.noarch 0:1.1.31-54.el7_8
Dependency Installed:
libxml2-python.x86_64 0:2.9.1-6.el7_9.6 python-chardet.noarch 0:2.2.1-3.el7 python-kitchen.noarch 0:1.1.1-5.el7
Dependency Updated:
libxml2.x86_64 0:2.9.1-6.el7_9.6
Complete!
[root@oceanbase_test ~]# sudo yum-config-manager --add-repo https://mirrors.aliyun.com/oceanbase/OceanBase.repo
Loaded plugins: fastestmirror
adding repo from: https://mirrors.aliyun.com/oceanbase/OceanBase.repo
grabbing file https://mirrors.aliyun.com/oceanbase/OceanBase.repo to /etc/yum.repos.d/OceanBase.repo
repo saved to /etc/yum.repos.d/OceanBase.repo
[root@oceanbase_test ~]# sudo yum install -y ob-deploy
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.ustc.edu.cn
* extras: mirrors.ustc.edu.cn
* updates: mirrors.cn99.com
oceanbase.community.stable | 3.0 kB 00:00:00
oceanbase.development-kit | 3.0 kB 00:00:00
(1/2): oceanbase.community.stable/7/x86_64/primary_db | 23 kB 00:00:00
(2/2): oceanbase.development-kit/7/x86_64/primary_db | 16 kB 00:00:01
Resolving Dependencies
--> Running transaction check
---> Package ob-deploy.x86_64 0:1.2.1-9.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
===================================================================================================================================================================================
Package Arch Version Repository Size
===================================================================================================================================================================================
Installing:
ob-deploy x86_64 1.2.1-9.el7 oceanbase.community.stable 32 M
Transaction Summary
===================================================================================================================================================================================
Install 1 Package
Total download size: 32 M
Installed size: 78 M
Downloading packages:
warning: /var/cache/yum/x86_64/7/oceanbase.community.stable/packages/ob-deploy-1.2.1-9.el7.x86_64.rpm: Header V4 RSA/SHA1 Signature, key ID e9b4a7aa: NOKEY | 32 MB 00:00:00 ETA
Public key for ob-deploy-1.2.1-9.el7.x86_64.rpm is not installed
ob-deploy-1.2.1-9.el7.x86_64.rpm | 32 MB 00:00:01
Retrieving key from http://mirrors.aliyun.com/oceanbase/RPM-GPG-KEY-OceanBase
Importing GPG key 0xE9B4A7AA:
Userid : "OceanBase"
Fingerprint: ef7d e8e3 6987 b60c acf9 9a53 2ff8 45a6 e9b4 a7aa
From : http://mirrors.aliyun.com/oceanbase/RPM-GPG-KEY-OceanBase
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : ob-deploy-1.2.1-9.el7.x86_64 1/1
Installation of obd finished successfully
Please source /etc/profile.d/obd.sh to enable it
Verifying : ob-deploy-1.2.1-9.el7.x86_64 1/1
Installed:
ob-deploy.x86_64 0:1.2.1-9.el7
Complete!
obd部署模板
obd需要根据模板定义的集群的配置来部署集群
[root@oceanbase_test ~]# vi deployee.yaml
配置如下， 遵循yaml格式
## Only need to configure when remote login is required
user:
username: root
password: password
key_file:
port: 22
# timeout: ssh connection timeout (second), default 30
oceanbase-ce:
servers:
# Please don't use hostname, only IP can be supported
- 10.0.2.15
global:
# The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field.
home_path: /root/observer
# The directory for data storage. The default value is $home_path/store.
data_dir: /data
# The directory for clog, ilog, and slog. The default value is the same as the data_dir value.
redo_dir: /redo
# Please set devname as the network adaptor's name whose ip is in the setting of severs.
# if set severs as "127.0.0.1", please set devname as "lo"
# if current ip is 192.168.1.10, and the ip's network adaptor's name is "eth0", please use "eth0"
devname: enp0s3
# External port for OceanBase Database. The default value is 2881. DO NOT change this value after the cluster is started.
# mysql_port: 2881
# Internal port for OceanBase Database. The default value is 2882. DO NOT change this value after the cluster is started.
# rpc_port: 2882
# Defines the zone for an observer. The default value is zone1.
# zone: zone1
# The maximum running memory for an observer. When ignored, autodeploy calculates this value based on the current server available resource.
memory_limit: 8G
# The percentage of the maximum available memory to the total memory. This value takes effect only when memory_limit is 0. The default value is 80.
# memory_limit_percentage: 80
# The reserved system memory. system_memory is reserved for general tenants. The default value is 30G. Autodeploy calculates this value based on the current server available resource.
# system_memory: 22G
# The size of a data file. When ignored, autodeploy calculates this value based on the current server available resource.
datafile_size: 10G
# The percentage of the data_dir space to the total disk space. This value takes effect only when datafile_size is 0. The default value is 90.
# datafile_disk_percentage: 90
# System log level. The default value is INFO.
# syslog_level: INFO
# Print system logs whose levels are higher than WARNING to a separate log file. The default value is true. The default value for autodeploy mode is false.
# enable_syslog_wf: false
# Enable auto system log recycling or not. The default value is false. The default value for autodeploy mode is on.
# enable_syslog_recycle: true
# The maximum number of reserved log files before enabling auto recycling. When set to 0, no logs are deleted. The default value for autodeploy mode is 4.
# max_syslog_file_count: 4
# Cluster name for OceanBase Database. The default value is obcluster. When you deploy OceanBase Database and obproxy, this value must be the same as the cluster_name for obproxy.
# appname: obcluster
# Password for root. The default value is empty.
# root_password:
# Password for proxyro. proxyro_password must be the same as observer_sys_password. The default value is empty.
# proxyro_password:
配置粗略解释
user:
username: os账号
password: os密码
key_file: 密钥（与密码一起使用，也可以留空只使用密码）
port: 22
timeout: ssh超时时间,默认30s
global: 公共
data_dir: 存放数据文件路径
redo_dir: 存放日志文件路径， 如 clog, ilog, and slog
devname: 网卡名字
mysql_port: oceanbase连接端口
rpc_port: rpc交互端口
zone: zone名字
memory_limit: observer内存的限制(多少G)
memory_limit_percentage: observer内存的限制(百分比%)
system_memory: ob集群占用的内存
datafile_size: ob集群初始化占用数据文件的大小（多少G）
datafile_disk_percentage: ob集群初始化占用数据文件的大小(百分比%)
syslog_level: 系统日志的级别
enable_syslog_wf: 是否允许级别高于警告的日志单独打印一个日志文件
enable_syslog_recycle: 允许是否系统日志回收，以免日志过大
max_syslog_file_count: 回收时保留的系统日志数量
appname: 集群名字
root_password: 默认空
proxyro_password: 默认空
odb 部署
部署命令
obd cluster autodeploy <deploy_name> -c <deploy_config_file> -A obd cluster autodeploy ob-test -c deployee.yaml -A
部署报错及解决
# [ERROR] (10.0.2.15) open files number must not be less than 20000 (Current value: 1024)
cat >> /etc/security/limits.conf << EOF
* soft nofile 65535
* hard nofile 65535
EOF
# [WARN] (10.0.2.15) The recommended value of fs.aio-max-nr is 1048576 (Current value: 65536)
cat >> /etc/sysctl.conf << EOF
fs.aio-max-nr = 1048576
EOF
# [ERROR] Deploy "ob-test" is deployed. You could not deploy an deployed cluster
# destroy 重新部署
obd cluster destroy ob-test
obd cluster autodeploy ob-test -c deployee.yaml -A
部署日志
[root@oceanbase_test ~]# obd cluster redeploy ob-test
Get local repositories and plugins ok
Open ssh connection ok
Cluster status check ok
observer work dir cleaning ok
ob-test destroyed
oceanbase-ce-3.1.2 already installed.
+-------------------------------------------------------------------------------------------+
| Packages |
+--------------+---------+-----------------------+------------------------------------------+
| Repository | Version | Release | Md5 |
+--------------+---------+-----------------------+------------------------------------------+
| oceanbase-ce | 3.1.2 | 10000392021123010.el7 | 7fafba0fac1e90cbd1b5b7ae5fa129b64dc63aed |
+--------------+---------+-----------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Open ssh connection ok
Remote oceanbase-ce-3.1.2-7fafba0fac1e90cbd1b5b7ae5fa129b64dc63aed repository install ok
Remote oceanbase-ce-3.1.2-7fafba0fac1e90cbd1b5b7ae5fa129b64dc63aed repository lib check ok
Cluster status check ok
Initializes observer work home ok
ob-test deployed
Get local repositories and plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start observer ok
[WARN] (127.0.0.1) The recommended number of open files is 655350 (Current value: 65535)
Start observer ok
observer program health check ok
Connect to observer ok
Initialize cluster
Cluster bootstrap ok
Create tenant test ok
Wait for observer init ok
+---------------------------------------------+
| observer |
+-----------+---------+------+-------+--------+
| ip | version | port | zone | status |
+-----------+---------+------+-------+--------+
| 127.0.0.1 | 3.1.2 | 2881 | zone1 | active |
+-----------+---------+------+-------+--------+
ob-test running
obd help
[root@oceanbase_test ~]# obd --help
Usage: obd <command> [options]
Available commands:
cluster Deploy and manage a cluster.
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.
obd mirror
[root@oceanbase_test ~]# obd mirror
You need to give some commands.
Try `obd --help` for more information.
Usage: obd mirror <command> [options]
Available commands:
clone Clone an RPM package to the local mirror repository.
create Create a local mirror by using the local binary file.
disable Disable remote mirror repository.
enable Enable remote mirror repository.
list List mirrors.
update Update remote mirror information.
Options:
-h, --help Show help and exit.
-v, --verbose Activate verbose output.
[root@oceanbase_test ~]# obd mirror list
+------------------------------------------------------------------+
| Mirror Repository List |
+----------------------------+--------+---------+------------------+
| SectionName | Type | Enabled | Update Time |
+----------------------------+--------+---------+------------------+
| oceanbase.community.stable | remote | True | 2022-03-07 23:01 |
| oceanbase.development-kit | remote | True | 2022-03-07 23:01 |
| local | local | - | 2022-03-07 23:24 |
+----------------------------+--------+---------+------------------+
[root@oceanbase_test ~]# obd repo list
+-------------------+---------+-----------------------+--------+------------------------------------------+-------------------+
| name | version | release | arch | md5 | tags |
+-------------------+---------+-----------------------+--------+------------------------------------------+-------------------+
| oceanbase-ce | 3.1.2 | 10000392021123010.el7 | x86_64 | 7fafba0fac1e90cbd1b5b7ae5fa129b64dc63aed | oceanbase-ce |
| oceanbase-ce-libs | 3.1.2 | 10000392021123010.el7 | x86_64 | 94fff0ab31de053051dba66039e3185fa390cad5 | oceanbase-ce-libs |
+-------------------+---------+-----------------------+--------+------------------------------------------+-------------------+
obd test
[root@oceanbase_test ~]# obd test
You need to give some commands.
Try `obd --help` for more information.
Usage: obd test <command> [options]
Available commands:
mysqltest Run a mysqltest for a deployment.
sysbench Run sysbench for a deployment.
tpch Run a TPC-H test for a deployment.
Options:
-h, --help Show help and exit.
-v, --verbose Activate verbose output.
obd cluster
[root@oceanbase_test ~]# obd cluster
You need to give some commands.
Try `obd --help` for more information.
Usage: obd cluster <command> [options]
Available commands:
autodeploy Deploy a cluster automatically by using a simple configuration file.
deploy Deploy a cluster by using the current deploy configuration or a deploy yaml file.
destroy Destroy a deployed cluster.
display Display the information for a cluster.
edit-config Edit the configuration file for a specific deployment.
list List all the deployments.
redeploy Redeploy a started cluster.
reload Reload a started cluster.
restart Restart a started cluster.
start Start a deployed cluster.
stop Stop a started cluster.
tenant Create or drop a tenant.
upgrade Upgrade a cluster.
Options:
-h, --help Show help and exit.
-v, --verbose Activate verbose output
obd cluster display
[root@oceanbase_test ~]# obd cluster display ob-test
Get local repositories and plugins ok
Open ssh connection ok
Cluster status check ok
Connect to observer ok
Wait for observer init ok
+---------------------------------------------+
| observer |
+-----------+---------+------+-------+--------+
| ip | version | port | zone | status |
+-----------+---------+------+-------+--------+
| 127.0.0.1 | 3.1.2 | 2881 | zone1 | active |
+-----------+---------+------+-------+--------+
obd cluster list
[root@oceanbase_test ~]# obd cluster list
+--------------------------------------------------------+
| Cluster List |
+---------+----------------------------+-----------------+
| Name | Configuration Path | Status (Cached) |
+---------+----------------------------+-----------------+
| ob-test | /root/.obd/cluster/ob-test | running |
+---------+----------------------------+-----------------+
obd cluster edit-config
[root@oceanbase_test ~]# obd cluster edit-config ob-test
## Only need to configure when remote login is required
user:
username: root
password: password
key_file:
port: 22
# timeout: ssh connection timeout (second), default 30
oceanbase-ce:
servers:
# Please don't use hostname, only IP can be supported
- 127.0.0.1
global:
# The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field.
home_path: /root/observer
# The directory for data storage. The default value is $home_path/store.
data_dir: /data
# The directory for clog, ilog, and slog. The default value is the same as the data_dir value.
redo_dir: /redo
# Please set devname as the network adaptor's name whose ip is in the setting of severs.
# if set severs as "127.0.0.1", please set devname as "lo"
# if current ip is 192.168.1.10, and the ip's network adaptor's name is "eth0", please use "eth0"
devname: enp0s3
# External port for OceanBase Database. The default value is 2881. DO NOT change this value after the cluster is started.
# mysql_port: 2881
# Internal port for OceanBase Database. The default value is 2882. DO NOT change this value after the cluster is started.
# rpc_port: 2882
# Defines the zone for an observer. The default value is zone1.
# zone: zone1
# The maximum running memory for an observer. When ignored, autodeploy calculates this value based on the current server available resource.
memory_limit: 8G
# The percentage of the maximum available memory to the total memory. This value takes effect only when memory_limit is 0. The default value is 80.
# memory_limit_percentage: 80
# The reserved system memory. system_memory is reserved for general tenants. The default value is 30G. Autodeploy calculates this value based on the current server available resource.
# system_memory: 22G
# The size of a data file. When ignored, autodeploy calculates this value based on the current server available resource.
datafile_size: 8G
# The percentage of the data_dir space to the total disk space. This value takes effect only when datafile_size is 0. The default value is 90.
# datafile_disk_percentage: 90
# System log level. The default value is INFO.
# syslog_level: INFO
# Print system logs whose levels are higher than WARNING to a separate log file. The default value is true. The default value for autodeploy mode is false.
# enable_syslog_wf: false
# Enable auto system log recycling or not. The default value is false. The default value for autodeploy mode is on.
# enable_syslog_recycle: true
# The maximum number of reserved log files before enabling auto recycling. When set to 0, no logs are deleted. The default value for autodeploy mode is 4.
# max_syslog_file_count: 4
# Cluster name for OceanBase Database. The default value is obcluster. When you deploy OceanBase Database and obproxy, this value must be the same as the cluster_name for obproxy.
# appname: obcluster
# Password for root. The default value is empty.
# root_password:
# Password for proxyro. proxyro_password must be the same as observer_sys_password. The default value is empty.
# proxyro_password:
appname: obcluster
127.0.0.1:
devname: lo
syslog_level: INFO
enable_syslog_recycle: true
enable_syslog_wf: true
max_syslog_file_count: 4
system_memory: 4G
cpu_count: 16
auto_create_tenant: true
简单使用
mysql客户端连接
[root@oceanbase_test ~]# mysql -uroot -p -h 127.0.0.1 -P2881
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3221488011
Server version: 5.7.25 OceanBase 3.1.2 (r10000392021123010-d4ace121deae5b81d8f0b40afbc4c02705b7fc1d) (Built Dec 30 2021 02:47:29)
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> 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
mysql> select * from gv$tenant;
+-----------+-------------+-----------+--------------+----------------+---------------+-----------+---------------+
| tenant_id | tenant_name | zone_list | primary_zone | collation_type | info | read_only | locality |
+-----------+-------------+-----------+--------------+----------------+---------------+-----------+---------------+
| 1 | sys | zone1 | zone1 | 0 | system tenant | 0 | FULL{1}@zone1 |
| 1001 | test | zone1 | RANDOM | 0 | | 0 | FULL{1}@zone1 |
+-----------+-------------+-----------+--------------+----------------+---------------+-----------+---------------+
2 rows in set (0.01 sec)
mysql> show tables;
+------------------------------------------------+
| Tables_in_oceanbase |
+------------------------------------------------+
| CDB_CKPT_HISTORY |
| CDB_OB_BACKUP_ARCHIVELOG |
| CDB_OB_BACKUP_ARCHIVELOG_PROGRESS |
| CDB_OB_BACKUP_ARCHIVELOG_SUMMARY |
| CDB_OB_BACKUP_BACKUPPIECE_JOB |
| CDB_OB_BACKUP_BACKUPPIECE_JOB_HISTORY |
| CDB_OB_BACKUP_BACKUPPIECE_TASK |
| CDB_OB_BACKUP_BACKUPPIECE_TASK_HISTORY |
| CDB_OB_BACKUP_BACKUPSET_JOB |
| CDB_OB_BACKUP_BACKUPSET_JOB_HISTORY |
| CDB_OB_BACKUP_BACKUPSET_TASK |
| CDB_OB_BACKUP_BACKUPSET_TASK_HISTORY |
| CDB_OB_BACKUP_BACKUP_ARCHIVELOG |
| CDB_OB_BACKUP_BACKUP_ARCHIVELOG_SUMMARY |
| CDB_OB_BACKUP_CLEAN_HISTORY |
| CDB_OB_BACKUP_JOB_DETAILS |
| CDB_OB_BACKUP_PIECE_FILES |
| CDB_OB_BACKUP_PROGRESS |
| CDB_OB_BACKUP_SET_DETAILS |
| CDB_OB_BACKUP_SET_EXPIRED |
| CDB_OB_BACKUP_SET_FILES |
| CDB_OB_BACKUP_SET_OBSOLETE |
| CDB_OB_BACKUP_TASK_CLEAN_HISTORY |
| CDB_OB_BACKUP_VALIDATION_JOB |
| CDB_OB_BACKUP_VALIDATION_JOB_HISTORY |
| CDB_OB_BACKUP_VALIDATION_TASK_HISTORY |
| CDB_OB_RESTORE_HISTORY |
| CDB_OB_RESTORE_PROGRESS |
| CDB_OB_TENANT_BACKUP_VALIDATION_TASK |
| __all_acquired_snapshot |
| __all_backup_backup_log_archive_status_history |
| __all_backup_backup_log_archive_status_v2 |
| __all_backup_backuppiece_job |
| __all_backup_backuppiece_job_history |
| __all_backup_backuppiece_task |
| __all_backup_backuppiece_task_history |
| __all_backup_backupset_job |
| __all_backup_backupset_job_history |
| __all_backup_backupset_task_history |
| __all_backup_clean_info_history |
| __all_backup_info |
| __all_backup_log_archive_status_history |
| __all_backup_log_archive_status_v2 |
| __all_backup_piece_files |
| __all_backup_set_files |
| __all_backup_task_clean_history |
| __all_backup_task_history |
| __all_backup_validation_job |
| __all_backup_validation_job_history |
| __all_backup_validation_task_history |
| __all_build_index_param |
| __all_charset |
| __all_clog_history_info |
| __all_clog_history_info_v2 |
| __all_coll_type |
| __all_coll_type_history |
| __all_collation |
| __all_column |
| __all_column_history |
| __all_column_stat |
| __all_column_statistic |
| __all_constraint |
| __all_constraint_history |
| __all_core_table |
| __all_database |
| __all_database_history |
| __all_database_privilege |
| __all_database_privilege_history |
| __all_datafile_recovery_status |
| __all_dblink |
| __all_dblink_history |
| __all_ddl_helper |
| __all_ddl_id |
| __all_ddl_operation |
| __all_def_sub_part |
| __all_def_sub_part_history |
| __all_dummy |
| __all_election_event_history |
| __all_foreign_key |
| __all_foreign_key_column |
| __all_foreign_key_column_history |
| __all_foreign_key_history |
| __all_freeze_schema_version |
| __all_frozen_map |
| __all_func |
| __all_func_history |
| __all_global_index_data_src |
| __all_gts |
| __all_histogram_stat |
| __all_immediate_effect_index_sstable |
| __all_index_build_stat |
| __all_index_checksum |
| __all_index_schedule_task |
| __all_index_wait_transaction_status |
| __all_local_index_status |
| __all_meta_table |
| __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_partition_member_list |
| __all_privilege |
| __all_recyclebin |
| __all_res_mgr_consumer_group |
| __all_res_mgr_directive |
| __all_res_mgr_mapping_rule |
| __all_res_mgr_plan |
| __all_resource_pool |
| __all_restore_history |
| __all_restore_info |
| __all_restore_job |
| __all_restore_job_history |
| __all_restore_progress |
| __all_restore_task |
| __all_root_table |
| __all_rootservice_event_history |
| __all_rootservice_job |
| __all_routine |
| __all_routine_history |
| __all_routine_param |
| __all_routine_param_history |
| __all_seed_parameter |
| __all_sequence |
| __all_sequence_object |
| __all_sequence_object_history |
| __all_sequence_v2 |
| __all_sequence_value |
| __all_server |
| __all_server_event_history |
| __all_server_recovery_status |
| __all_sql_execute_task |
| __all_sstable_checksum |
| __all_sstable_column_checksum |
| __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_v2 |
| __all_table_v2_history |
| __all_tablegroup |
| __all_tablegroup_history |
| __all_temp_table |
| __all_tenant |
| __all_tenant_backup_backup_log_archive_status |
| __all_tenant_backup_backupset_task |
| __all_tenant_backup_clean_info |
| __all_tenant_backup_info |
| __all_tenant_backup_log_archive_status |
| __all_tenant_backup_task |
| __all_tenant_backup_validation_task |
| __all_tenant_constraint_column |
| __all_tenant_constraint_column_history |
| __all_tenant_dependency |
| __all_tenant_error |
| __all_tenant_gc_partition_info |
| __all_tenant_global_transaction |
| __all_tenant_gts |
| __all_tenant_history |
| __all_tenant_keystore |
| __all_tenant_keystore_history |
| __all_tenant_meta_table |
| __all_tenant_objauth |
| __all_tenant_objauth_history |
| __all_tenant_object_type |
| __all_tenant_object_type_history |
| __all_tenant_partition_meta_table |
| __all_tenant_pg_backup_backupset_task |
| __all_tenant_pg_backup_task |
| __all_tenant_pg_backup_validation_task |
| __all_tenant_plan_baseline |
| __all_tenant_plan_baseline_history |
| __all_tenant_profile |
| __all_tenant_profile_history |
| __all_tenant_resource_usage |
| __all_tenant_restore_pg_info |
| __all_tenant_role_grantee_map |
| __all_tenant_role_grantee_map_history |
| __all_tenant_security_audit |
| __all_tenant_security_audit_history |
| __all_tenant_security_audit_record |
| __all_tenant_sstable_column_checksum |
| __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_time_zone |
| __all_time_zone_name |
| __all_time_zone_transition |
| __all_time_zone_transition_type |
| __all_type |
| __all_type_attr |
| __all_type_attr_history |
| __all_type_history |
| __all_unit |
| __all_unit_config |
| __all_unit_load_history |
| __all_user |
| __all_user_history |
| __all_weak_read_service |
| __all_zone |
| __tenant_parameter |
| gv$concurrent_limit_sql |
| gv$database |
| gv$latch |
| gv$lock |
| gv$lock_wait_stat |
| gv$memory |
| gv$memstore |
| gv$memstore_info |
| gv$merge_info |
| gv$minor_merge_info |
| gv$ob_sql_workarea_memory_info |
| gv$ob_trans_table_status |
| gv$obrpc_incoming |
| gv$obrpc_outgoing |
| gv$outline |
| gv$partition |
| gv$partition_audit |
| gv$plan_cache_plan_explain |
| gv$plan_cache_plan_stat |
| gv$plan_cache_reference_info |
| gv$plan_cache_stat |
| gv$ps_item_info |
| gv$ps_stat |
| gv$server_memstore |
| gv$server_schema_info |
| gv$session_event |
| gv$session_longops |
| gv$session_wait |
| gv$session_wait_history |
| gv$sesstat |
| gv$sql |
| gv$sql_audit |
| gv$sql_monitor |
| gv$sql_plan_monitor |
| gv$sql_plan_statistics |
| gv$sql_workarea |
| gv$sql_workarea_active |
| gv$sql_workarea_histogram |
| gv$sstable |
| gv$sysstat |
| gv$system_event |
| gv$table |
| gv$tenant |
| gv$tenant_memstore_allocator_info |
| gv$tenant_px_worker_stat |
| gv$tenant_sequence_object |
| gv$unit |
| gv$unit_load_balance_event_history |
| v$event_name |
| v$latch |
| v$lock |
| v$lock_wait_stat |
| v$memory |
| v$memstore |
| v$memstore_info |
| v$merge_info |
| v$ob_all_clusters |
| v$ob_cluster |
| v$ob_sql_workarea_memory_info |
| v$ob_timestamp_service |
| v$ob_trans_table_status |
| v$obrpc_incoming |
| v$obrpc_outgoing |
| v$partition |
| v$partition_audit |
| v$plan_cache_plan_explain |
| v$plan_cache_plan_stat |
| v$plan_cache_reference_info |
| v$plan_cache_stat |
| v$ps_item_info |
| v$ps_stat |
| v$restore_point |
| v$server_schema_info |
| v$session_event |
| v$session_longops |
| v$session_wait |
| v$session_wait_history |
| v$sesstat |
| v$sql |
| v$sql_audit |
| v$sql_monitor |
| v$sql_monitor_statname |
| v$sql_plan_monitor |
| v$sql_plan_statistics |
| v$sql_workarea |
| v$sql_workarea_active |
| v$sql_workarea_histogram |
| v$sstable |
| v$statname |
| v$sysstat |
| v$system_event |
| v$tenant_memstore_allocator_info |
| v$tenant_px_worker_stat |
| v$unit |
+------------------------------------------------+
316 rows in set (0.00 sec)
最后修改时间：2022-03-08 00:13:01
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
