Oceanbase Database Documentation - Deploy A Distributed Database

OceanBase Database

V4.3.3

What is OceanBase Database
- Overview
- Differences between Enterprise Edition and Community Edition
- System architecture
- Compatibility with Oracle
  - Overview
  - SQL data types
  - Built-in functions
  - System views
- Compatibility with MySQL
- Limitations
Get Started
- Quick start with OceanBase Database Community Edition
- Learn OceanBase SQL
  - Before you begin
  - Basic SQL operations (MySQL mode)
  - Basic SQL operations (Oracle mode)
- Build a sample application (Oracle mode)
  - Build a Java application
  - Build a C application
- Build a sample application (MySQL mode)
  - Build a Python application
  - Build a Java application
  - Build a C application
  - Build a Go application
- Try out advanced features of OceanBase Database
  - Scalable OLTP
    - Run the TPC-C benchmark in OceanBase Database
    - Try out the hot row update capability of OceanBase Database
  - Try out operational OLAP
  - Try out parallel import and data compression
  - Try out the multi-tenant feature
- Video tutorial
Develop
- Develop applications (MySQL mode)
  - Connect to OceanBase Database
    - Overview
    - Connect to an OceanBase tenant by using the mysql client
    - Connect to an OceanBase tenant by using OBClient
    - Connect to OceanBase Database by using ODC
    - Connect to OceanBase Database by using DBeaver
    - Connect to OceanBase Database by using Navicat
    - Use database connection pool
      - Database connection pool configuration
      - Tomcat
      - c3p0
      - Proxool
      - HikariCP
      - DBCP
      - Commons Pool
      - Druid
      - # Configuration example of JDBC connections
  - Sample applications
    - Java
      - Spring Boot
      - Spring Batch
      - Spring Data JDBC
      - Spring Data JPA
      - Hibernate
      - MyBatis
      - Connector/J
      - TestContainers
    - Python
      - mysqlclient
      - PyMySQL
      - MySQL-connector-python
    - C
      - MySQL Connector/C
    - Go
      - Go-SQL-Driver/MySQL
      - GORM
    - PHP
      - EXT
      - MySQLi
      - PDO
  - Plan database objects
    - Create a database
    - Create a table group
    - Create a table
    - Create an index
    - Create an external table
  - Write data
    - Insert data
    - Update data
    - Delete data
    - Replace data
    - Generate test data in batches
  - Read data
    - Single-table queries
    - Join tables
      - INNER JOIN queries
      - FULL JOIN queries
      - LEFT JOIN queries
      - RIGHT JOIN queries
      - Subqueries
      - Lateral derived table
    - Use operators and functions in queries
      - Use arithmetic operators in queries
      - Use numerical functions in queries
      - Use string concatenation operators in queries
      - Use string functions in queries
      - Use datetime functions in queries
      - Use type conversion functions in queries
      - Use aggregate functions in queries
      - Use NULL-related functions in queries
      - Use the CASE conditional operator in queries
      - Use the SELECT ... FOR UPDATE statement to lock query results
      - Use the SELECT ... LOCK IN SHARE MODE statement to lock query results
    - Use a DBLink in queries
    - Set operations
  - Transactions
    - Overview
    - Start a transaction
    - Savepoints
      - Mark a savepoint
      - Roll back a transaction to a savepoint
      - Release a savepoint
    - Commit a transaction
    - Roll back a transaction
  - Application errors
    - Troubleshooting guidelines
      - About error codes
      - Error handling specifications for MySQL-compatible applications
    - Common errors and troubleshooting practices
      - Disconnected from the server, with ERROR 2013 reported
      - Idle transaction timed out, with ERROR 6002 reported
      - Transaction timed out, with ERROR 4012 reported
      - User locked, with ERROR 3118 reported
      - Incorrect user password, with ERROR 1045 reported
      - Table already exists, with ERROR 1050 reported
      - Table does not exist, with ERROR 1146 reported
      - Duplicate data inserted, with ERROR 1062 reported
      - ERROR 1215 reported in foreign key addition
      - Data truncated while being inserted, with ERROR 1265 reported
- Develop applications (Oracle mode)
  - Connect to OceanBase Database
    - Overview
    - Connect to an OceanBase tenant by using OBClient
    - Connect to OceanBase Database by using ODC
    - Use database connection pool
      - Database connection pool configuration
      - Tomcat
      - c3p0
      - Proxool
      - HikariCP
      - DBCP
      - Commons Pool
      - Druid
  - Sample applications
    - Java
      - OceanBase Connector/J
      - Spring Boot
      - Spring Batch
      - Spring Data JDBC
      - Spring Data JPA
      - Hibernate
      - MyBatis
      - JFinal
    - C/C++
      - OceanBase Connector/C
      - OceanBase Connector/ODBC
      - SqlSugar
  - Plan database objects
    - Create a table group
    - Create a table
    - Create an index
    - Create an external table
  - Write data
    - Insert data
    - Update data
    - Delete data
    - Replace data
    - Generate test data in batches
  - Read data
    - Single-table queries
    - Join tables
      - INNER JOIN queries
      - FULL JOIN queries
      - LEFT JOIN queries
      - RIGHT JOIN queries
      - Subqueries
      - Lateral derived tables
    - Use operators and functions in queries
      - Use arithmetic operators in queries
      - Use numerical functions in queries
      - Use string concatenation operators in queries
      - Use string functions in queries
      - Use datetime functions in queries
      - Use type conversion functions in queries
      - Use aggregate functions in queries
      - Use NULL-related functions in queries
      - Use CASE functions in queries
      - Use the SELECT...FOR UPDATE statement to lock query results
    - Use a DBLink in queries
    - Set operations
  - Transactions
    - Overview
    - Start a transaction
    - Savepoints
      - Mark a savepoint
      - Roll back a transaction to a savepoint
    - Commit a transaction
    - Roll back a transaction
  - Application errors
    - Troubleshooting guidelines
      - About error codes
      - Error handling specifications for Oracle-compatible applications
    - Common errors and troubleshooting practices
      - Idle transaction timed out, with Error OBE-24761 reported
      - Transaction timed out, with Error OBE-00600 reported
      - User locked, with ERROR 3118 reported
      - Incorrect user password, with ERROR 1045 reported
      - Table already exists, with Error OBE-00955 reported
      - Table does not exist, with Error OBE-04043 reported
      - Duplicate data inserted, with Error OBE-00001 reported
      - Error OBE-00600 reported in foreign key addition
      - Inconsistent data types, with Error OBE-00932 reported
Deploy
- Overview
- HA deployment solutions for OceanBase clusters
- Deploy OceanBase Database Enterprise Edition
  - Deployment process
  - Before deployment
    - Prepare servers
    - Configure servers
    - Prepare installation packages
    - Deploy OAT
  - Deploy through GUI
    - Configure deployment environment using OAT
      - Add a server
    - Deploy OCP
      - Overview
      - Upload installation packages
      - Create MetaDB
      - Deploy OCP
    - Deploy OceanBase clusters using OCP
      - Deploy a standalone OceanBase database by using OCP
      - Deploy a two-replica OceanBase cluster with the arbitration service by using OCP
      - Deploy a single-replica OceanBase cluster by using OCP
      - Deploy a three-replica OceanBase cluster by using OCP
    - (Optional) Deploy ODP
  - Deploy through CLI
    - Configure deployment environment
      - Initialize an OBServer node by using oatcli
      - (Optional) Configure the clock source
    - Deploy OceanBase clusters using CLI
      - Deploy a standalone OceanBase database by using the CLI
      - Deploy a two-replica OceanBase cluster with the arbitration service by using the CLI
      - Deploy a single-replica OceanBase cluster by using the CLI
      - Deploy a three-replica OceanBase cluster by using the CLI
    - (Optional) Deploy ODP
- Deploy OceanBase Database Community Edition
  - Overview
  - Deploy locally
    - Software and hardware requirements
    - Before deployment
      - (Optional) Check resources
      - (Optional) Set password-free SSH logon
      - (Optional) Configure the clock source
      - (Optional) Perform disk planning
      - (Optional) Configure limits.conf
      - (Optional) Configure sysctl.conf
      - (Optional) Disable the firewall and SELinux
      - (Optional) Create a user
    - Deploy through GUI
      - Deploy an OceanBase cluster through the GUI of obd
      - Deploy an OceanBase cluster through the GUI of OCP
    - Deploy OceanBase Database in a production environment by using the CLI
    - Deploy OceanBase Database by using systemd
  - Deploy an OceanBase cluster in a Kubernetes environment
- Clear an OceanBase cluster
- Recommended configurations
Migrate
- Overview
- Migrate from MySQL databases to OceanBase Database
  - Use OMS to migrate data from a MySQL database to a MySQL tenant of OceanBase Database
  - Use mydumper and myloader to migrate data from a MySQL database to OceanBase Database
  - Use DBCAT to migrate schemas from a MySQL database to OceanBase Database
  - Use DataX to migrate table data from a MySQL database to OceanBase Database
  - Use CloudCanal to migrate data from a MySQL database to OceanBase Database
  - Use Canal to synchronize data from a MySQL database to OceanBase Database
  - Use Flink CDC to synchronize data from a MySQL database to OceanBase Database
  - Use ChunJun to migrate data from a MySQL database to OceanBase Database
- Migrate from OceanBase Database to MySQL databases
  - Use OMS to migrate data from a MySQL tenant of OceanBase Database to a MySQL database
  - Use OMS to migrate incremental data from an Oracle tenant of OceanBase Database to a MySQL database
  - Use DBCAT to migrate schemas from OceanBase Database to a MySQL database
  - Use DataX to migrate table data from OceanBase Database to a MySQL database
  - Use Canal to synchronize data from OceanBase Database to a MySQL database
  - Use CloudCanal to migrate data from OceanBase Database to a MySQL database
  - Use Flink CDC to migrate data from OceanBase Database to a MySQL database
  - Use ChunJun to migrate data from OceanBase Database to a MySQL database
- Migrate from Oracle databases to OceanBase Database
  - Use OMS to migrate data from an Oracle database to a MySQL tenant of OceanBase Database
  - Use OMS to migrate data from an Oracle database to an Oracle tenant of OceanBase Database
  - Use DBCAT to migrate schemas from an Oracle database to OceanBase Database
  - Use DataX to migrate table data from an Oracle database to OceanBase Database
- Migrate from OceanBase Database to Oracle databases
  - Use OMS to migrate data from an Oracle tenant of OceanBase Database to an Oracle database
  - Use DBCAT to migrate schemas from OceanBase Database to an Oracle database
  - Use DataX to migrate table data from OceanBase Database to an Oracle database
- Migrate from DB2 databases to OceanBase Database
  - Use OMS to migrate data from a DB2 LUW database to a MySQL tenant of OceanBase Database
  - Use OMS to migrate data from a DB2 LUW database to an Oracle tenant of OceanBase Database
  - Use DBCAT to migrate table schemas from a DB2 LUW database to OceanBase Database
- Migrate from OceanBase Database to DB2 databases
  - Use OMS to migrate data from a MySQL tenant of OceanBase Database to a DB2 LUW database
  - Use OMS to migrate data from an Oracle tenant of OceanBase Database to a DB2 LUW database
- Migrate from TiDB databases to OceanBase Database
  - Use OMS to migrate data from a TiDB database to a MySQL tenant of OceanBase Database
- Migrate from PostgreSQL databases to OceanBase Database
  - Use OMS to migrate data from a PostgreSQL database to a MySQL tenant of OceanBase Database
- Migrate from CSV files to OceanBase Database
  - Use DataX to migrate CSV files to OceanBase Database
  - Import data by using the LOAD DATA statement
- Import data from SQL files to OceanBase Database
- Migrate data between OceanBase Database
  - Use OMS to migrate data from an OceanBase tenant to another of the same type
  - Use OMS to migrate data from an OceanBase tenant to another of the same type in active-active disaster recovery scenarios
  - Use obloader & obdumper to migrate data between MySQL tenants in OceanBase Database
  - Use obloader & obdumper to migrate data from a MySQL tenant to an Oracle tenant in OceanBase Database
  - Use obloader & obdumper to migrate data between Oracle tenants in OceanBase Database
  - Use obloader & obdumper to migrate data from an Oracle tenant to a MySQL tenant in OceanBase Database
- Migrate data using SQL statements
  - Migrate data between tables
  - Migrate resource units
  - Export data by using the SELECT INTO OUTFILE statement
- Direct load
  - Overview
  - Full direct load
  - Incremental direct load
  - # Import data in direct load mode by using :obloader
Manage
- Log on to an OceanBase tenant
- Manage clusters
  - Overview
  - Cluster parameters
  - Common cluster operations
    - View a zone
    - View a node
    - Restart a node
    - Add a node
    - Delete a node
    - Isolate a node
    - Replace a node
    - Add a zone
    - Start a zone
    - Delete a zone
    - Modify a zone
    - Isolate a zone
    - View cluster parameters
    - Modify cluster parameters
    - Reset cluster parameters
    - Online upgrade from standalone deployment to distributed deployment
    - Upgrade a cluster
      - OceanBase Database Enterprise Edition
        Overview
        Upgrade an arbitration service
        Upgrade an OceanBase cluster
        Check upgrade results
      - OceanBase Database Community Edition
        Upgrade OceanBase Database by using obd
  - Troubleshoot common problems
    - Failures of a minority of nodes
    - Failures of the majority of nodes
- Manage tenants
  - Tenant introduction
  - Tenant capacity
  - Tenant types
  - User tenant introduction
  - Tenant system variables
  - Common tenant operations
    - Create a tenant
    - Resource isolation
      - Overview
      - Manage resource isolation (Oracle mode)
        Configure cgroups
        Configure global CPU resource isolation for frontend and backend tasks
        Calibrate the disk performance
        Configure resource isolation within a tenant
        Update a plan directive
        Delete a plan directive
        Delete a resource management plan
        Delete a resource group
        Clear cgroup configurations
      - Manage resource isolation (MySQL mode)
        Configure cgroups
        Configure global CPU resource isolation for foreground and background tasks
        Calibrate the disk performance
        Configure resource isolation within a tenant
        Update a plan directive
        Delete a plan directive
        Delete a resource management plan
        Delete a resource group
        Clear cgroup configurations
    - View tenant and resource information
    - View and set the tenant allowlist
    - View system variables of a tenant
    - Modify system variables of a tenant
    - Scale in/out
      - Introduction to scaling in/out
      - Plan resources
      - Modify the unit config for a tenant
      - Modify the number of resource units for a tenant
      - Modify the number of primary zones for a tenant
    - Modify attributes of a resource pool
    - Modify attributes of a tenant
    - Lock and unlock a tenant
    - Clone a tenant
    - Cancel tenant cloning
    - Drop a tenant
    - Restore a tenant
    - Rename a tenant
    - Manage resource pools
      - View resource pool information
      - Allocate a resource pool to a tenant
      - Remove resource pools from a tenant
      - Merge and split resource pools
      - Drop a resource pool
    - Manage unit configs
      - Query unit configs
      - Modify a unit config
      - Drop a unit config
    - Manage services
      - Create a service
      - Query the service status
      - Start a service
      - Stop a service
      - Delete a service
- Manage replicas
  - Overview
  - Replica distribution
    - Locality
    - Common locality operations
      - View locality
      - Modify locality
      - Add replicas
      - Remove replicas
      - Convert the type of a replica
      - Adjust the distribution of replicas
      - View the locality change history
      - Migrate replicas
      - Modify the number of Paxos replicas of a log stream
      - Cancel a replica task
  - Traffic distribution
  - Data distribution
  - Data load balancing
    - Overview
    - Transfer a partition
    - Cancel a partition transfer task
    - Cancel a load balancing job
- High availability
  - High availability overview
  - Multi-replica disaster recovery
    - Data link introduction
    - ODP high availability
    - Database-level high availability
    - Disaster recovery architecture and levels
  - Physical standby database disaster recovery
    - Overview
    - Limitations
    - Create a standby tenant
      - Preparations
      - Create an empty standby tenant
      - Create a standby tenant by using the backup and restore (with complete logs) feature
      - Create a standby tenant by using the BACKUP DATABASE PLUS ARCHIVELOG feature
    - Log transmission service
      - Overview
      - Configure log transmission service
        Specify a log restore source
        Specify a log restore endpoint
      - View log restore source information
      - View the log synchronization progress
      - Pause or resume log synchronization
      - Optimize the log synchronization performance
      - Set the log synchronization bandwidth limit
      - Specify log compression
    - Log storage service
    - Switch roles
      - Overview of tenant roles
      - Switchover
      - Failover
    - Drop primary and standby tenants
  - Arbitration high availability
    - Overview
    - Enable the arbitration service for a tenant
    - Disable the arbitration service for a tenant
    - Modify the log stream downgrade control time
    - Query log stream upgrade/downgrade information
    - Replace the arbitration service for a cluster
    - Remove the arbitration service for a cluster
    - Clear residual cluster information
  - Manage recycle bin
    - Overview
    - Enable or disable the recycle bin
    - View objects in the recycle bin
    - Restore objects from the recycle bin
    - Purge the recycle bin
  - Flashback queries
- Security and permissions
  - Overview
  - Identification and authentication
    - MySQL mode
      - Identity authentication
      - Password complexity
      - Logon failure processing
    - Oracle mode
      - Identity authentication
      - Password complexity
      - Logon failure processing
  - Access control
    - Overview
    - Users and permissions
      - Overview
      - MySQL mode
        Privilege types in MySQL mode
        Create a user
        Grant direct privileges
        Privilege delegation
        Role management
        Overview
        Create a role
        Grant privileges to a role
        Grant a role to a user or another role
        Activate a role
        View roles
        Revoke privileges from a role
        Revoke a role from a user or another role
        Drop a role
        Grant indirect privileges
        View user privileges
        Revoke privileges
        Lock or unlock a user
        Drop a user
      - Oracle mode
        Privilege types in Oracle mode
        Create a user
        View the information of a user
        Grant direct privileges
        Privilege delegation
        Manage roles
        Overview
        Create a role
        Grant a role to another role
        Grant a role to a user
        Activate or deactivate roles for a user
        View roles
        Modify a role
        Revoke a role
        Drop a role
        Grant indirect privileges
        View user privileges
        Revoke privileges
        Use a proxy user
        Lock or unlock a user
        Drop a user
    - Network security access control
    - Row-level access control
    - RPC connection authentication
  - Data transmission encryption
    - Overview
    - OBServer transmission encryption
    - ODP transmission encryption
  - Transparent data encryption
    - Overview
    - MySQL mode
      - Enable TDE for new tables
      - Enable TDE for existing tables
      - Decrypt a table
    - Oracle mode
      - Enable TDE for new tables
      - Enable TDE for existing tables
      - Decrypt a table
  - Security audit
    - Overview
    - Enable security audit
    - Set and view audit rules
    - View audit records
    - Audit user logon operations
    - Audit user operations
    - Audit specified database objects
- Backup and restore
  - Introduction to physical backup and restore
  - Experience physical backup and restore with simplified deployment
  - Deploy NFS
  - Log archive
    - Overview
    - Preparations
    - Enable ARCHIVELOG
    - Suspend archiving
    - Disable ARCHIVELOG
    - View information about pieces
    - View the archiving progress
    - View the archiving history
    - View archiving parameter settings
    - Change the log archive destination
    - Clear the archive path setting
    - Views related to log archiving
  - Data backup
    - Preparations
    - Initiate a full data backup job
    - Initiate an incremental data backup job
    - Stop a backup job
    - View the data backup progress
    - View the data backup history
    - View data backup parameter settings
    - Change the backup destination
    - Views related to data backup
  - Clear backup data
    - Automatically clean up expired backup data
    - Stop backup cleanup
    - Query the backup cleanup progress
    - Query the backup cleanup history
    - Backup cleanup parameter
    - Views related to backup cleanup
  - Restore data
    - Preparations
    - Perform physical restore
    - Perform restore from the specified paths
    - Cancel physical restore
    - View the physical restore progress
    - View physical restore results
    - Replay logs to a standby tenant
    - Convert a standby tenant into primary tenant
    - Upgrade a tenant after restore
    - Parameters related to physical restore
    - Views related to physical restore
  - Restore by table
    - Preparations
    - Perform table restore
    - Cancel table restore
    - View the table restore progress
    - View the table restore result
    - Parameters related to table restore
    - Views related to table restore
- Monitor
  - Overview
  - Metrics
    - System monitoring
      - Overview
      - Metrics
      - Wait events
      - Latch events
    - SQL monitoring
      - Overview
      - SQL audit
      - Execution plans
  - Cases
- Logs
  - Overview
  - Log levels
  - Log stability
  - Log control
  - Log compression and decompression
  - Log metrics
  - Alert logs
  - View logs
    - Search for the logs of a specific SQL request
    - Query the log of a previous SQL request by using the SQL Trace feature
- Performance tuning
  - Overview
  - Identify bottlenecks on the data link
  - Identify bottlenecks within components
    - ODP performance bottlenecks
    - ODP performance analysis
    - OBServer performance bottlenecks
      - Overview
      - Non-optimal plan
        Non-optimal plans
        Buffer tables
        Cardinality
      - Hard parsing
      - Capacity issues
      - Internal wait events
  - SQL tuning
    - SQL tuning system
    - Execution plan optimization
      - Statistical information and row estimation
        Overview
        Statistical information
        Overview
        Collect statistical information
        Overview
        Manually collect statistics
        Automatically collect statistics
        Query statistics
        Manage statistical information
        Overview
        Delete and set statistics
        Import and export statistics
        Lock statistics
        Query historical versions of statistics and roll back to a specified version
        Configure statistics collection strategies
        Row estimation
        Overview
        Row estimation based on the selectivity
        Row estimation based on the storage layer
        Use statistical information and row estimation
      - Plan management
        Plan cache
        Disadvantages of the plan cache and countermeasures
        Views related to the plan cache
      - Index selection
        Overview
        Reduce row reads
        Avoid table access by index primary key
        Avoid sorting
      - Join order and join algorithm
        Joins
        Join algorithm
        Nested loop joins
        Hash joins
        Merge joins
        Common business issues
        Join types
        Join order
      - Order and limit optimization
        Overview
        SORT assignment and optimization
        Optimization in ORDER BY + LIMIT scenarios
    - Business logic optimization
      - SQL specifications
      - Schema specifications
    - Locate and analyze slow queries I
    - Locate and analyze slow queries II
    - Typical scenarios and cases
- Daily inspection
  - Overview
  - Check cluster parameters
  - Check the host status
  - Check tenant resource usage
  - Check cluster resource usage
  - Check the OBServer node status
  - Check the NTP offset
  - Deadlock detection
  - End-to-end tracing
    - Overview
    - Process
    - Methods
    - Show end-to-end tracing information
    - Quick start: End-to-end diagnosis with obdiag
- Troubleshooting
  - Overview
  - Bootstrap
  - Storage
    - Minor compaction and major compaction
    - Memory-related errors
    - Migration, replication, and rebuild tasks
  - Election
    - Election
    - Leader switchover exceptions
    - Absence of the leader
  - Transaction
    - Transaction-related errors
    - Transaction rollbacks
    - Long-running transactions
    - Suspended transactions
    - Idle transactions
  - Log synchronization-related errors
  - Physical standby database
    - Log synchronization stuck for the physical standby database
    - Switchover and failover issues
    - Other issues
  - Backup and restore
    - Data backup failures
    - Physical restore failures
  - Arbitration server process startup failures
- Emergency response
  - Emergency response overview
  - Analysis, diagnosis, and decision-making procedure
  - Common emergency problem handling
    - Hardware issues
      - Node failure
      - Network failure
      - ODP failure
      - Other hardware and network issues
    - Capacity issues
      - Exceptions of SQL queries
      - Node disk I/O high
      - Node network card overload
      - Tenant memory full
      - obproxy thread exhaustion
      - Node clog disk full
      - Node data disk full
      - Tenant request queue backlog
    - Other cluster issues
      - sys tenant or RootService exceptions
      - Insufficiency or leakage of system memory
OceanBase AP
- Overview
- Core features
- Deployment
  - Overview
  - Recommended parameter configurations for AP scenarios
- Get started with OceanBase AP
- Data table design
  - Overview
  - Data distribution
  - Best practices
- Import data
  - Overview
  - Strategies and best practices
  - ETL acceleration
- Export data
- Query acceleration
  - Statistics
  - Materialized views
  - Hints
  - Auto DOP
  - Full direct load
  - Table groups
  - Hybrid row-column storage
- Performance diagnosis and tuning
  - Use the DBMS_XPLAN package for performance diagnostics
  - Use the GV$SQL_PLAN_MONITOR view for performance analysis
  - Views related to AP performance analysis
- Performance test
  - TPC-H benchmark
  - TPC-H benchmark report
  - TPC-DS benchmark
  - TPC-DS benchmark report
- Ecosystem integration
OBKV
- Overview
- Architecture
- OBKV-Table
  - Introduction
    - Overview
    - OBKV-Table operation types
    - Differences between replace and insert_or_update
    - Supported value types
    - OBKV-Table data models
  - Use the OBKV-Table Java client
    - Use the OBKV-Table Java client to connect to a cluster
    - Set client parameters
    - Supported client interfaces
    - Use the OBKV-Table Java client
  - Use the OBKV-Table GO client
    - Use the OBKV-Table Go client to connect to a cluster
    - Overview of the Go client
    - Individual API operations
    - Batch operations
    - About queries
    - Aggregation API
    - Filters
  - FAQ
- OBKV-HBase
  - Overview
  - Core features
  - Compatibility with HBase
  - Deployment
  - Use OBKV-HBase
    - Overview
    - Data model
    - Data model design
    - Connect to a cluster by using the OBKV-HBase client
    - Data operation examples
    - Delete expired data
  - OBKV-HBase management
    - Overview
    - High availability
    - Security and permissions
    - Monitoring metrics
  - Performance test
  - OBKV-HBase integration
    - Synchronize data to OBKV-HBase by using Flink
  - Views
  - FAQ
Tutorials
- Build an image search application with OceanBase Database
- Build an intelligent Q&A robot with OceanBase Database
Reference
- OceanBase concepts
  - Architecture of OceanBase Database
  - Development of OceanBase Database
  - Multi-tenant architecture
    - Overview
    - Compatibility modes
    - Tenants
    - Tenants and resource management
      - Tenant resource management
      - Multi-tenant resource isolation
      - Resource unit balancing
  - Database objects
    - Oracle mode
      - Introduction
        Overview
        Database object types
        Database object storage
        Dependencies between database objects
      - Tables
        Overview
        Data type
        Overview
        Character data types
        Numeric data types
        Datetime data types
        ROWID data types
        LOB data types
        Multi-model data types
        Format model
        Overview
        Number format models
        Datetime format models
        Integrity constraints
        Table storage
        Table compression
        Partitioned table
        Replicated table
        Tables with and without a primary key
        Temporary table
      - Indexes
        About indexes
        Local and global indexes
        Unique and non-unique indexes
        Use indexes
        Index storage
      - Partitions
        Overview
        Partitioning keys
        Partitioning types
        Partitioned indexes
        External table partitions
      - Views
        Views in a database
        Standard views
        Standard views
        Overview
        OceanBase-specific views
        Oracle-compatible views
        View operations and data access
        Materialized views
        Materialized views
        Materialized view logs
        Creation and update strategies for materialized views
      - Other objects
        Sequences
        Synonyms
      - System views
        Dictionary views
        Performance views
      - Data integrity
        Overview
        Integrity constraint type
        Overview
        NOT NULL constraints
        UNIQUE KEY constraints
        PRIMARY KEY constraints
        FOREIGN KEY constraints
        CHECK constraints
        Use of integrity constraints
    - MySQL mode
      - Introduction
        Overview
        Database object types
        Database object storage
        Dependencies between database objects
      - Tables
        Overview
        Data type
        Overview
        Numeric data types
        Datetime data types
        Character data types
        LOB data types
        Multi-model data types
        Spatial data types
        JSON data types
        Integrity constraints
        Table storage
        Table compression
        Partitioned table
        Replicated table
        Tables with and without a primary key
      - Indexes
        About indexes
        Local and global indexes
        Unique and non-unique indexes
        Spatial indexes
        Full-text index
        Use indexes
        Index storage
      - Partitions
        Overview
        Partitioning keys
        Partitioning types
        Partitioned indexes
        External table partitions
      - Views
        Views in a database
        Standard views
        Overview
        Overview
        OceanBase-specific views
        MySQL-compatible views
        Oracle-compatible views in MySQL tenants
        Oracle-compatible views in the sys tenant
        View operations and data access
        Materialized views
        Materialized views
        Materialized view logs
        Creation and update strategies for materialized views
      - System views
        Dictionary views
        Performance views
      - Data integrity
        Overview
        Integrity constraint type
        Overview
        NOT NULL constraints
        UNIQUE KEY constraints
        PRIMARY KEY constraints
        FOREIGN KEY constraints
        Use of integrity constraints
  - Distributed database objects
    - Overview
    - Cluster architecture
    - Data partitions and replicas
      - Overview
      - Log streams
      - Partition replica type
        Overview
        Full-featured replica
        Read-only replicas
        Columnstore replica
      - Multi-replica consensus protocols
      - Data balancing
        Intra-tenant balancing
        Views and parameters related to data balancing
    - Dynamic scaling
      - Cluster scaling
      - Tenant resource scaling
        Overview
        Horizontal scaling of tenant resources
        Vertical scaling of tenant resources
        Cross-zone management of tenant resources
  - Data link
    - Overview
    - Database proxy
      - Overview
      - SQL routing
      - Connection management
      - ODP configuration management
      - Logs and monitoring
    - Database connector
      - Overview
      - OBCI
      - OceanBase Connector/J
      - OceanBase Connector/C
  - User interface and query language
    - SQL
      - Introduction
        Overview
        SQL data access
        SQL standards
      - SQL statements
        Overview
        DDL statements
        DML statements
        DCL statements
      - Execution process of SQL queries
      - Query SQL execution plans
      - Distributed execution plan
        Perform distributed execution and parallel queries
        Generate distributed execution plans
        Run and disable a parallel query
        Manage distributed execution plans
        Perform parameter tuning for PX
    - PL
      - PL concepts
        Oracle mode
        Subprograms
        Stored procedures
        Functions
        Triggers
        Packages
        MySQL mode
        Subprograms
        Stored procedures
        Functions
        Triggers
      - PL subprogram execution mechanism
    - Client programming languages
  - Transaction management
    - Transaction
      - Overview
      - Transaction structure
      - Statement-level atomicity
      - GTS
      - Transaction control
        Overview
        Active transactions
        Savepoint
        Transaction control statements
        MySQL transaction control
        Oracle transaction control
      - Redo logs
      - Local transactions
      - Distributed transaction
        Overview
        Two-phase commit
      - XA transactions
    - Transaction concurrency and consistency
      - Overview
      - Multi-version read consistency
      - Concurrency control
        Overview
        Lock mechanism
      - Transaction isolation level
        Overview
        Transaction isolation levels in Oracle mode
        Transaction isolation levels in MySQL mode
      - Weak-consistency read
  - Storage architecture
    - Overview
    - Data storage
      - Overview
      - MemTables
      - SSTables
      - Columnar storage
      - Compression and encoding
    - Compaction
      - Overview
      - Minor compaction
      - Major compaction
    - Multi-level caches
    - Query processing
    - Data integrity
      - Detect silent data corruption
  - Data reliability and high availability
    - High availability architecture
      - Overview
      - ODP high availability
      - Leader election in distributed systems
      - Multi-replica log synchronization
      - Paxos protocol
      - Automatic handling of node failures
    - Deployment solutions for disaster recovery
    - Data protection
      - Overview
      - Flashback queries
      - Recycle bin
    - Backup and restore
      - Overview
      - Backup directory structures
      - Backup architecture
      - Restore process
    - Arbitration-based high availability solution
    - Physical Standby Database solution
  - Database security
    - Overview
    - Authentication
    - Access control
    - Data transmission encryption
    - Data storage encryption
    - Monitoring and alerting
    - Security audit
  - OBServer node architecture
    - Structure of the OBServer node installation directory
    - Configuration file
    - observer thread model
      - Threads
      - Worker threads
      - Background threads
    - Logs
    - Memory management
      - Overview
      - Memory-related parameters
      - Memory-related views
      - Memory usage logs
      - Diagnose memory errors
- System management
  - Configuration management
    - Overview
    - Set parameters
    - Set variables
  - Storage management
    - Minor compaction management
      - Overview
      - Automatically trigger a minor compaction
      - Manually initiate a minor compaction
      - View minor compaction information
      - Modify minor compaction settings
    - Major compaction management
      - Overview
      - Automatically trigger a major compaction
      - Configure scheduled major compactions
      - # Adaptive major compactions
      - Manually initiate a major compaction
      - View major compaction information
      - Manually control a major compaction
      - Modify major compaction settings
    - Data compression
      - Overview
      - Data encoding and compression
  - Memory management
    - Overview
    - Memory structure
    - Set the maximum memory for an OceanBase database
    - Manage internal system memory
    - Manage internal tenant memory
    - Manage the memory of the plan cache
    - Memleak-based regular memory leak diagnostics mechanism
    - Query memory usage information
    - FAQ about memory
  - Process management
    - Overview
    - Multi-tenant threads of OceanBase Database
    - View the thread status
    - Background threads of OceanBase Database
    - FAQ about multi-tenant threads
  - Disk management
    - Configure automatic scale-out of disk space for data files
- Database object management
  - Overview
  - MySQL mode
    - Create and manage databases
      - Create a database
      - View databases
      - Modify a database
      - Drop a database
    - Create and manage tables
      - Overview
      - Create a table
      - Column skip index attribute
      - Define an auto-increment column
      - Define column constraints
      - Query tables
      - Modify a table
      - Empty a table
      - Drop a table
      - Lock a table
      - Create and manage external tables
        Overview
        Create an external table
        Add partitions for an external table
        Manage external files
    - Create and manage partitions
      - Overview
      - Create a partitioned table
      - Modify partitioning rules
      - Add a partition
      - Drop a partition
      - Truncate a partition
      - Partition pruning
      - Query data in specified partitions
      - Create indexes on partitioned tables
        Overview
        Local indexes
        Global indexes
      - Exchange partitions
    - Create and manage table groups
      - Overview
      - Create a table group
      - Query information about a table group
      - Add tables to a table group
      - Modify the SHARDING attribute of a table group
      - Manage tables in a table group
      - Drop a table group
    - Create and manage indexes
      - Overview
      - Create an index
      - Query indexes
      - Monitor indexes
      - Drop an index
      - System functions supported for function-based indexes
      - System functions not supported for function-based indexes
    - Manage views
      - Manage standard views
      - Manage materialized views
        Materialized views
        Overview
        Create a materialized view
        Query materialized views
        Drop a materialized view
        Refresh a materialized view
        Rewrite queries based on materialized views
        Materialized view logs
        Overview
        Create a materialized view log
        Drop a materialized view log
    - Create and manage sequences
      - Create a sequence
      - Query sequences
      - Reference a sequence
      - Modify a sequence
      - Drop a sequence
    - Create and manage triggers
      - Overview
      - Create a DML trigger
      - Query trigger information
      - Drop a trigger
    - Create and manage DBLinks
      - Create a DBLink
      - Query existing DBLinks
      - Manage DBLinks
      - Use a DBLink to access data in a remote database
      - Drop a DBLink
  - Oracle mode
    - Create and manage tables
      - Overview
      - Create a table
      - Column skip index attribute
      - Define column constraints
      - Query the definition of a table
      - Modify a table
      - Empty a table
      - Drop a table
      - Lock a table
      - Create and manage external tables
        Overview
        Create an external table
        Add partitions for an external table
        Manage external files
    - Create and manage partitions
      - Overview
      - Create a partitioned table
      - Modify partitioning rules
      - Rename a partition
      - Add a partition
      - Drop a partition
      - Truncate a partition
      - Partition pruning
      - Query data in specified partitions
      - Create indexes on partitioned tables
        Overview
        Local indexes
        Global indexes
      - Exchange partitions
    - Create and manage table groups
      - Overview
      - Create a table group
      - Query information about a table group
      - Add tables to a table group
      - Modify the SHARDING attribute of a table group
      - Manage tables in a table group
      - Drop a table group
    - Create and manage indexes
      - Overview
      - Create an index
      - Query indexes
      - Monitor indexes
      - Drop an index
      - System functions supported for function-based indexes
      - System functions not supported for function-based indexes
    - Manage views
      - Manage standard views
      - Manage materialized views
        Materialized views
        Overview
        Create a materialized view
        Query materialized views
        Drop a materialized view
        Refresh a materialized view
        Rewrite queries based on materialized views
        Materialized view logs
        Overview
        Create a materialized view log
        Drop a materialized view log
    - Manage sequences
    - Manage synonyms
    - Create and manage triggers
      - Overview
      - Create a DML trigger
      - Create an INSTEAD OF trigger
      - Create a composite trigger
      - Modify and drop a trigger
      - Disable or enable a trigger
      - Query trigger information
    - Manage directory objects
    - Create and manage DBLinks
      - Create a DBLink
      - Query existing DBLinks
      - Manage DBLinks
      - Use a DBLink to access data in a remote database
      - Use a DBLink to modify the data in a remote database
      - Drop a DBLink
      - Install and configure OCI
- Database design specifications and practices
  - Object naming conventions
    - Overview
    - Tenant naming conventions
    - User naming conventions
    - Table naming conventions
    - Field naming conventions
    - Other naming conventions
  - Object structure design specifications
    - Field design
    - Table structure design
    - Partitioned table design
    - Index design
    - Other structural designs
  - Character set specifications
  - Database connection specifications
  - Comments
  - ORM conventions
  - Exception handling
- Parameters and system variables
  - Overview
  - Parameters
    - Overview
    - Cluster-level parameters
      - alert_log_level
      - all_cluster_list
      - all_server_list
      - auto_broadcast_location_cache_rate_limit
      - auto_leader_switch_interval
      - auto_refresh_location_cache_rate_limit
      - autoinc_cache_refresh_interval
      - backup_backup_dest
      - backup_backup_dest_option
      - backup_concurrency
      - backup_dest
      - backup_dest_option
      - backup_log_archive_option
      - backup_net_limit
      - backup_recovery_window
      - backup_region
      - backup_zone
      - balance_blacklist_failure_threshold
      - balance_blacklist_retry_interval
      - balancer_emergency_percentage
      - balancer_log_interval
      - balancer_task_timeout
      - balancer_timeout_check_interval
      - balancer_tolerance_percentage
      - bf_cache_miss_count_threshold
      - bf_cache_priority
      - builtin_db_data_verify_cycle
      - cache_wash_threshold
      - clog_cache_priority
      - clog_disk_usage_limit_percentage
      - clog_disk_utilization_threshold
      - clog_expire_days
      - clog_sync_time_warn_threshold
      - clog_transport_compress_func
      - cluster
      - cluster_id
      - config_additional_dir
      - cpu_count
      - cpu_reserved
      - data_copy_concurrency
      - data_dir
      - data_disk_usage_limit_percentage
      - data_disk_write_limit_percentage
      - data_storage_error_tolerance_time
      - data_storage_warning_tolerance_time
      - datafile_disk_percentage
      - datafile_maxsize
      - datafile_next
      - datafile_size
      - dead_socket_detection_timeout
      - debug_sync_timeout
      - default_compress
      - default_compress_func
      - default_row_format
      - default_transport_compress_func
      - devname
      - diag_syslog_per_error_limit
      - disk_io_thread_count
      - dtl_buffer_size
      - election_blacklist_interval
      - election_cpu_quota
      - enable_asan_for_memory_context
      - enable_async_syslog
      - enable_auto_leader_switch
      - enable_auto_refresh_location_cache
      - enable_cgroup
      - enable_dblink
      - enable_ddl
      - enable_election_group
      - enable_global_background_resource_isolation
      - enable_global_freeze_trigger
      - enable_log_archive
      - enable_major_freeze
      - enable_manual_merge
      - enable_merge_by_turn
      - enable_ob_esi_process
      - enable_ob_ratelimit
      - enable_one_phase_commit
      - enable_perf_event
      - enable_pg
      - enable_record_trace_id
      - enable_record_trace_log
      - enable_rereplication
      - enable_rich_error_msg
      - enable_rootservice_standalone
      - enable_rpc_authentication_bypass
      - enable_separate_sys_clog
      - enable_smooth_leader_switch
      - enable_sql_audit
      - enable_sql_operator_dump
      - enable_sys_table_ddl
      - enable_sys_unit_standalone
      - enable_syslog_recycle
      - enable_syslog_wf
      - enable_tcp_keepalive
      - enable_upgrade_mode
      - fast_recovery_concurrency
      - flush_log_at_trx_commit
      - fuse_row_cache_priority
      - gc_wait_archive
      - get_leader_candidate_rpc_timeout
      - global_background_cpu_quota
      - global_index_build_single_replica_timeout
      - global_major_freeze_residual_memory
      - global_write_halt_residual_memory
      - high_priority_net_thread_count
      - ignore_replay_checksum_error
      - ignore_replica_checksum_error
      - ilog_index_expire_time
      - index_block_cache_priority
      - index_cache_priority
      - index_clog_cache_priority
      - index_info_block_cache_priority
      - internal_sql_execute_timeout
      - large_query_threshold
      - large_query_worker_percentage
      - leak_mod_to_check
      - lease_time
      - local_ip
      - location_cache_cpu_quota
      - location_cache_expire_time
      - location_cache_priority
      - location_cache_refresh_min_interval
      - location_cache_refresh_rpc_timeout
      - location_cache_refresh_sql_timeout
      - location_fetch_concurrency
      - location_refresh_thread_count
      - log_archive_batch_buffer_limit
      - log_archive_checkpoint_interval
      - log_disk_percentage
      - log_disk_size
      - log_storage_warning_tolerance_time
      - ls_meta_table_check_interval
      - max_kept_major_version_number
      - max_px_worker_count
      - max_string_print_length
      - max_syslog_file_count
      - memory_chunk_cache_size
      - memory_limit
      - memory_limit_percentage
      - memory_reserved
      - memstore_limit_percentage
      - merge_stat_sampling_ratio
      - merge_thread_count
      - merger_completion_percentage
      - merger_switch_leader_duration_time
      - merger_warm_up_duration_time
      - micro_block_merge_verify_level
      - migrate_concurrency
      - migration_disable_time
      - min_observer_version
      - minor_deferred_gc_time
      - minor_freeze_times
      - minor_merge_concurrency
      - minor_warm_up_duration_time
      - multiblock_read_gap_size
      - multiblock_read_size
      - mysql_port
      - net_thread_count
      - ob_esi_io_concurrency
      - ob_esi_max_syslog_file_count
      - ob_esi_memory_limit
      - ob_esi_rpc_port
      - ob_esi_session_timeout
      - ob_esi_syslog_level
      - ob_event_history_recycle_interval
      - ob_ratelimit_stat_period
      - ob_startup_mode
      - obconfig_url
      - observer_id
      - ofs_list
      - opt_tab_stat_cache_priority
      - partition_table_check_interval
      - plan_cache_evict_interval
      - plan_cache_high_watermark
      - plan_cache_low_watermark
      - px_task_size
      - px_workers_per_cpu_quota
      - rdma_io_thread_count
      - rebuild_replica_data_lag_threshold
      - recyclebin_object_expire_time
      - replica_safe_remove_time
      - resource_hard_limit
      - resource_soft_limit
      - restore_concurrency
      - rootservice_async_task_queue_size
      - rootservice_async_task_thread_count
      - rootservice_list
      - rootservice_memory_limit
      - rootservice_ready_check_interval
      - row_compaction_update_limit
      - row_purge_thread_count
      - rpc_client_authentication_method
      - rpc_port
      - rpc_server_authentication_method
      - rpc_timeout
      - schema_history_expire_time
      - schema_history_recycle_interval
      - server_balance_cpu_mem_tolerance_percent
      - server_balance_critical_disk_waterlevel
      - server_balance_disk_tolerance_percent
      - server_check_interval
      - server_cpu_quota_max
      - server_cpu_quota_min
      - server_data_copy_in_concurrency
      - server_data_copy_out_concurrency
      - server_permanent_offline_time
      - sql_audit_memory_limit
      - sql_login_thread_count
      - sql_net_thread_count
      - sql_protocol_min_tls_version
      - ssl_client_authentication
      - ssl_external_kms_info
      - stack_size
      - standby_fetch_log_bandwidth_limit
      - storage_meta_cache_priority
      - strict_check_os_params
      - switchover_process_thread_count
      - sys_bkgd_io_high_percentage
      - sys_bkgd_io_low_percentage
      - sys_bkgd_migration_change_member_list_timeout
      - sys_bkgd_migration_retry_num
      - sys_bkgd_net_percentage
      - sys_cpu_limit_trigger
      - syslog_compress_func
      - syslog_disk_size
      - syslog_file_uncompressed_count
      - syslog_io_bandwidth_limit
      - syslog_level
      - system_cpu_quota
      - system_memory
      - system_trace_level
      - tableapi_transport_compress_func
      - tablet_ls_cache_priority
      - tablet_meta_table_check_interval
      - tablet_meta_table_scan_batch_count
      - tablet_size
      - tcp_keepcnt
      - tcp_keepidle
      - tcp_keepintvl
      - tenant_cpu_variation_per_server
      - tenant_groups
      - tenant_task_queue_size
      - token_reserved_percentage
      - trace_log_sampling_interval
      - trace_log_slow_query_watermark
      - trx_2pc_retry_interval
      - trx_force_kill_threshold
      - trx_try_wait_lock_timeout
      - unit_balance_resource_weight
      - use_large_pages
      - user_block_cache_priority
      - user_iort_up_percentage
      - user_row_cache_priority
      - user_tab_col_stat_cache_priority
      - virtual_table_location_cache_expire_time
      - wait_leader_batch_count
      - weak_read_version_refresh_interval
      - workers_per_cpu_quota
      - zone
      - zone_merge_concurrency
      - zone_merge_order
      - zone_merge_timeout
    - Tenant-level parameters
      - arbitration_timeout
      - archive_lag_target
      - audit_sys_operations
      - audit_trail
      - backup_data_file_size
      - balancer_idle_time
      - choose_migration_source_policy
      - clog_max_unconfirmed_log_count
      - clog_persistence_compress_func
      - compaction_dag_cnt_limit
      - compaction_high_thread_score
      - compaction_low_thread_score
      - compaction_mid_thread_score
      - compaction_schedule_tablet_batch_cnt
      - compatible
      - connection_control_failed_connections_threshold
      - connection_control_max_connection_delay
      - connection_control_min_connection_delay
      - cpu_quota_concurrency
      - default_auto_increment_mode
      - default_enable_extended_rowid
      - default_progressive_merge_num
      - default_table_store_format
      - dump_data_dictionary_to_log_interval
      - enable_clog_persistence_compress
      - enable_early_lock_release
      - enable_kv_ttl
      - enable_monotonic_weak_read
      - enable_rebalance
      - enable_sql_extension
      - enable_transfer
      - enable_user_defined_rewrite_rules
      - external_kms_info
      - freeze_trigger_percentage
      - ha_high_thread_score
      - ha_low_thread_score
      - ha_mid_thread_score
      - io_category_config
      - job_queue_processes
      - kv_ttl_duty_duration
      - kv_ttl_history_recycle_interval
      - lob_enable_block_cache_threshold
      - log_archive_concurrency
      - log_disk_throttling_maximum_duration
      - log_disk_throttling_percentage
      - log_disk_utilization_limit_threshold
      - log_disk_utilization_threshold
      - log_restore_concurrency
      - log_storage_compress_all
      - log_storage_compress_func
      - log_transport_compress_all
      - log_transport_compress_func
      - ls_gc_delay_time
      - major_compact_trigger
      - major_freeze_duty_time
      - max_partition_num
      - max_stale_time_for_weak_consistency
      - merger_check_interval
      - minor_compact_trigger
      - ob_compaction_schedule_interval
      - ob_enable_batched_multi_statement
      - ob_proxy_readonly_transaction_routing_policy
      - ob_query_switch_leader_retry_timeout
      - ob_ssl_invited_common_names
      - open_cursors
      - optimizer_index_cost_adj
      - partition_balance_schedule_interval
      - plsql_code_type
      - plsql_debug
      - plsql_optimize_level
      - plsql_v2_compatibility
      - query_response_time_flush
      - query_response_time_range_base
      - query_response_time_stats
      - range_optimizer_max_mem_size
      - rpc_memory_limit_percentage
      - spill_compression_codec
      - sql_work_area
      - standby_db_fetch_log_rpc_timeout
      - standby_db_preferred_upstream_log_region
      - tde_method
      - tenant_sql_login_thread_count
      - tenant_sql_net_thread_count
      - storage_rowsets_size
      - ttl_thread_score
      - undo_retention
      - workarea_size_policy
      - writing_throttling_maximum_duration
      - writing_throttling_trigger_percentage
  - System variables
    - System variable summary
    - Global variables
      - activate_all_roles_on_login
      - auto_increment_cache_size
      - auto_increment_increment
      - auto_increment_offset
      - autocommit
      - automatic_sp_privileges
      - binlog_row_image
      - block_encryption_mode
      - character_set_client
      - character_set_connection
      - cardinality_estimation_model
      - character_set_database
      - character_set_filesystem
      - character_set_results
      - character_set_server
      - character_set_system
      - collation_connection
      - collation_database
      - collation_server
      - connect_timeout
      - cte_max_recursion_depth
      - cursor_sharing
      - datadir
      - debug_sync
      - default_password_lifetime
      - default_storage_engine
      - div_precision_increment
      - error_on_overlap_time
      - event_scheduler
      - explicit_defaults_for_timestamp
      - foreign_key_checks
      - group_concat_max_len
      - identity
      - init_connect
      - innodb_stats_persistent
      - innodb_strict_mode
      - interactive_timeout
      - license
      - lc_time_names
      - log_row_value_options
      - lower_case_table_names
      - max_allowed_packet
      - max_connections
      - max_sp_recursion_depth
      - max_user_connections
      - net_buffer_length
      - net_read_timeout
      - net_write_timeout
      - nls_calendar
      - nls_characterset
      - nls_comp
      - nls_currency
      - nls_date_format
      - nls_date_language
      - nls_dual_currency
      - nls_iso_currency
      - nls_length_semantics
      - nls_nchar_characterset
      - nls_nchar_conv_excp
      - nls_numeric_characters
      - nls_sort
      - nls_territory
      - nls_timestamp_format
      - nls_timestamp_tz_format
      - ob_bnl_join_cache_size
      - ob_compatibility_mode
      - ob_compatibility_control
      - ob_compatibility_version
      - ob_create_table_strict_mode
      - ob_default_lob_inrow_threshold
      - ob_default_replica_num
      - ob_early_lock_release
      - ob_enable_aggregation_pushdown
      - ob_enable_blk_nestedloop_join
      - ob_enable_hash_group_by
      - ob_enable_index_direct_select
      - ob_enable_jit
      - ob_enable_pl_cache
      - ob_enable_plan_cache
      - ob_enable_rich_error_msg
      - ob_enable_sql_audit
      - ob_enable_transformation
      - ob_enable_transmission_checksum
      - ob_enable_truncate_flashback
      - ob_global_debug_sync
      - ob_log_level
      - ob_max_read_stale_time
      - ob_pl_block_timeout
      - ob_plan_cache_evict_high_percentage
      - ob_plan_cache_evict_low_percentage
      - ob_plan_cache_percentage
      - ob_proxy_global_variables_version
      - ob_query_timeout
      - ob_read_consistency
      - ob_reserved_meta_memory_percentage
      - ob_route_policy
      - ob_sql_audit_percentage
      - ob_sql_work_area_percentage
      - ob_tcp_invited_nodes
      - ob_temp_tablespace_size_percentage
      - ob_timestamp_service
      - ob_trx_idle_timeout
      - ob_trx_lock_timeout
      - ob_trx_timeout
      - optimizer_capture_sql_plan_baselines
      - ob_security_version
      - optimizer_dynamic_sampling
      - optimizer_features_enable
      - optimizer_use_sql_plan_baselines
      - parallel_degree_limit
      - parallel_degree_policy
      - parallel_max_servers
      - parallel_min_scan_time_threshold
      - parallel_servers_target
      - performance_schema
      - plugin_dir
      - plsql_ccflags
      - query_cache_size
      - query_cache_type
      - query_rewrite_enabled
      - query_rewrite_integrity
      - read_only
      - recyclebin
      - regexp_stack_limit
      - regexp_time_limit
      - resource_manager_plan
      - runtime_bloom_filter_max_size
      - runtime_filter_max_in_num
      - runtime_filter_type
      - runtime_filter_wait_time_ms
      - secure_file_priv
      - server_uuid
      - sql_auto_is_null
      - sql_mode
      - sql_quote_show_create
      - sql_safe_updates
      - sql_select_limit
      - sql_throttle_current_priority
      - sql_throttle_network
      - sql_throttle_priority
      - sql_throttle_rt
      - sql_warnings
      - system_time_zone
      - time_zone
      - transaction_isolation
      - transaction_read_only
      - tx_isolation
      - tx_read_only
      - validate_password_check_user_name
      - validate_password_length
      - validate_password_mixed_case_count
      - validate_password_number_count
      - validate_password_policy
      - validate_password_special_char_count
      - version
      - version_comment
      - wait_timeout
    - Session-level variables
      - is_result_accurate
      - last_insert_id
      - nls_language
      - ob_capability_flag
      - ob_enable_show_trace
      - ob_last_schema_version
      - ob_max_read_stale_time
      - ob_org_cluster_id
      - ob_proxy_partition_hit
      - ob_proxy_set_trx_executed
      - ob_trace_info
      - optimizer_dynamic_sampling
      - parallel_degree_limit
      - parallel_degree_policy
      - parallel_min_scan_time_threshold
      - runtime_bloom_filter_max_size
      - runtime_filter_max_in_num
      - runtime_filter_type
      - runtime_filter_wait_time_ms
      - timestamp
      - tracefile_identifier
- Performance tuning
  - Overview
  - Performance related tools
    - System tools
      - Top
      - CPU tools
      - Memory tools
      - Disk I/O tools
      - Network tools
    - Internal tables
      - GV$SYSSTAT
      - GV$OB_SQL_AUDIT
      - GV$OB_TRANSACTION_PARTICIPANTS
    - Logs
      - slow trans
      - dump tenant info
      - Trace logs
    - OCP
  - System tuning
    - OS parameter tuning
    - Database parameter tuning
      - CPU parameters
      - I/O parameters
      - Memory-related parameters
      - Network transmission parameters
    - ODP parameter tuning
      - CPU parameters
      - Network transmission parameters
      - Routing parameters on nodes
  - Performance diagnosis
    - Monitor and diagnose the cluster performance
    - Diagnose tenant performance
    - Monitor ODP performance
    - Monitor host performance
    - WR management
      - Overview
      - Manage WR
      - Monitor historical session performance
      - Clean up WR data
    - ASH report
      - ASH
      - Generate ASH reports
      - Analyze ASH reports
  - Business model tuning
    - Load balancing
    - SQL diagnostics
    - Distributed transactions
  - SQL tuning
    - Execution process of SQL queries
    - SQL execution plans
      - Introduction to SQL execution plans
      - Execution plan operators
        # TABLE SCAN
        JOIN
        COUNT
        # GROUP BY
        WINDOW FUNCTION
        SUBPLAN FILTER
        DISTINCT
        SEQUENCE
        MATERIAL
        SORT
        # LIMIT
        FOR UPDATE
        SELECT INTO
        SUBPLAN SCAN
        UNION
        INTERSECT
        EXCEPT/MINUS
        INSERT
        DELETE
        UPDATE
        MERGE
        # EXCHANGE
        GI
      - Plan cache
      - Fast parameterization
      - # Real-time execution plan display
      - SQL optimization practice with EXPLAIN
    - Distributed execution plans
      - Perform distributed execution and parallel queries
      - Generate a distributed plan
      - Schedule distributed execution plans
      - Manage distributed execution plans
      - Parallel execution enabling methods and their priority
      - # Auto DOP
      - Execute parallel queries
      - Perform parameter tuning for a parallel query
      - # Parallel DML
      - Parallel DDL
    - Parallel execution plans
      - # Introduction to parallel execution
      - # Classification and optimization of parallel execution
      - Set concurrent execution
        Concurrency control and queuing
        Set a DOP for parallel execution
        Set parallel execution parameters
      - Parallel execution diagnostics
      - Parallel execution tuning tips
      - Quick start
    - SQL tuning
      - Overview
      - General procedure
      - SQL execution performance monitoring
        # GV$OB_SQL_AUDIT
        SQL Trace
        # Plan cache views
        SQL performance analysis example
        Use SQL Audit to analyze wait events in a query
        Analyze SQL queries that cause an abrupt RT jitter
        View and analyze the shape of an execution plan
        Analyze slow SQL queries
        Query SQL traffic distribution and QPS
        Check whether SQL queries are balanced across servers in a cluster
        Find the TOP N SQL queries
        Analyze whether an unusually large number of remote execution requests exist in the system or the execution of an SQL statement
        Find full table scan SQL statements in a tenant
        Find the TOP N queries with the longest execution time within a certain period
        Analyze queries related to distributed plans
        Check whether the RPC execution count of a distributed subplan is balanced across servers in a cluster
      - Optimizer statistics
        Overview of statistics
        Statistics collection methods
        Overview
        # Histograms
        # Manual statistics collection
        Automatic statistics collection
        # Online statistics collection
        Dynamic sampling
        Statistics management
        Overview
        Delete statistics
        # Set statistics
        Import and export statistics
        Lock and unlock statistics
        Manage statistics history
        # Manage statistics preferences
        # Monitoring and diagnostics for statistics collection
        # Examples
      - Query rewrite
        Overview
        Rule-based query rewrite
        Cost-based query rewrite
      - Query optimization
        Access path
        Overview
        Rule-based path selection
        Cost-based path selection
        Join algorithm
        Overview
        Join algorithms
        Runtime filters
        Join order
      - Manage execution plans
        # Optimizer hints
        Plan binding
        SQL plan management
    - Glossary
    - General issues in SQL tuning
- Database proxy
  - Connection and routing
  - OceanBase Database Proxy
  - ODP
    - Overview
    - Manage ODP clusters
      - Create an ODP cluster
      - Manage ODP cluster parameters
      - Delete an ODP cluster
      - Upgrade all ODPs in an ODP cluster
      - Restart all ODPs in an ODP cluster
      - Manage OceanBase clusters connected to an ODP cluster
      - Monitor ODP cluster performance
    - Manage ODP
      - Add an ODP
      - Start an ODP
      - Refresh ODP configurations
      - Stop an ODP
      - Restart an ODP
      - Delete an ODP
      - Upgrade one or more ODPs
    - ODP startup parameters
  - Physical connections
  - Logical connection
    - Query all sessions
    - Query the details of a session
    - Query the metrics of a session
    - Query session variables
    - Terminate a server session
  - Route management
    - Table-based routing of ODP
    - LDC-based routing
    - ODP routing policy
      - Read/Write splitting
      - Follower-first read
      - Blocklist mechanism
      - Transaction routing
  - View tenant sessions
  - Terminate a tenant session
  - Set the maximum number of connections for a tenant
- Drivers
  - ECOB
  - OBCI
  - OceanBase Connector/J
  - OceanBase Connector/C
  - OceanBase Connector/ODBC
- Platforms
  - OMA
  - OMS
  - OCP
  - ODC
  - OCP Express
    - OCP Express
    - View cluster overview information
    - Tenant management
    - Monitor a cluster
    - Diagnostic analysis
    - Log service
  - OAT
FAQ
- Products
- SQL statements
- Deployment
- Cluster management
- High availability
- FAQ about columnstores
Release Notes
- Version number guidelines
- OceanBase Database Enterprise Edition
  - V4.3
    - OceanBase Database Enterprise Edition V4.3.0
    - OceanBase Database V4.3.1
    - OceanBase Database Enterprise Edition V4.3.2
    - OceanBase Database Enterprise Edition V4.3.3
  - V4.2
    - OceanBase Database Enterprise Edition V4.2.1
    - OceanBase Database Enterprise Edition V4.2.0
  - V4.1
    - OceanBase Database Enterprise Edition V4.1.0
  - V3.2
    - OceanBase Database Enterprise Edition V3.2.4
    - OceanBase Database Enterprise Edition V3.2.3
    - OceanBase Database Enterprise Edition V3.2.2
    - OceanBase Database Enterprise Edition V3.2.1
    - OceanBase Database Enterprise Edition V3.2.0
  - V3.1
    - OceanBase Database Enterprise Edition V3.1.2
    - OceanBase Database Enterprise Edition V3.1.1
  - V2.2
    - OceanBase Database Enterprise Edition V2.2.77
    - OceanBase Database Enterprise Edition V2.2.76
    - OceanBase Database Enterprise Edition V2.2.30
- OceanBase Database Community Edition
  - V4.3
    - OceanBase Database Community Edition V4.3.0
    - OceanBase Database Community Edition V4.3.1
    - OceanBase Database Community Edition V4.3.2
    - OceanBase Database Community Edition V4.3.3
  - V4.2
    - OceanBase Database Community Edition V4.2.1
    - OceanBase Database Community Edition V4.2.0
  - V4.1
    - OceanBase Database Community Edition V4.1.0
  - V4.0
    - OceanBase Database Community Edition V4.0.0
  - V3.1
    - OceanBase Database Community Edition V3.1.5
    - OceanBase Database Community Edition V3.1.4
    - OceanBase Database Community Edition V3.1.3
    - OceanBase Database Community Edition V3.1.2
    - OceanBase Database Community Edition V3.1.1
Glossary

Download PDF

Build a Business System

Dive Deep into OceanBase Database

OceanBase Reference

OceanBase SQL