OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase AI DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog ServiceOceanBase DataPilotOceanBase OAgent

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase AI DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog ServiceOceanBase DataPilotOceanBase OAgent
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase AI Database

V4.6.3
  • Introduction
    • Overview
    • Core features
    • System architecture
  • Get Started
    • Get started with OceanBase AI Database
  • Deploy
    • Choose an appropriate deployment plan
    • Deployment process
    • Before deployment
      • Prepare servers
      • Configure Servers
      • Prepare object storage
      • Prepare installation packages
      • Deploy OAT
    • Add a server
    • Deploy OCP
      • OCP deployment overview
      • Upload installation packages
      • Create MetaDB
      • Deploy OCP
    • Deploy OceanBase AI Database
      • Create an object storage configuration
      • Deploy a LogService cluster by using OCP
      • Deploy an OceanBase AI Database cluster using OCP
    • (Optional) Deploy OBProxy
    • Deploy Java SDK
    • Recommended configurations
  • Connect
    • Overview of connection methods
    • Clients
      • MySQL client
      • OBClient
      • ODC
    • GUI tools
      • DBeaver
      • Navicat
    • Drivers and ORMs
      • Connect via driver or ORM framework
      • Examples
        • C#
          • MySQL Connector/C
        • Go
          • Go-SQL-Driver/MySQL
          • GORM
        • Java
          • Connector/J
          • Spring JDBC
          • SpringBoot
          • SpringBatch
          • SpringDataJPA
          • Hibernate
          • MyBatis
          • TestContainers
        • PHP
          • EXT
          • MySQLi
          • PDO
        • Python
          • PyMySQL
          • mysqlclient
          • MySQL-connector-python
          • SQLAlchemy
          • Django
          • peewee
    • Connection pool
      • Database connection pool configuration
      • Tomcat
      • C3P0
      • Proxool
      • HikariCP
      • DBCP
      • Commons Pool
      • Druid
      • JDBC
    • Connect to OceanBase AI Database by using SDK
  • Design Database Schema
    • Overview of database schema design
    • Table design
    • Data distribution
    • Indexes
    • Data types
    • Logical table
      • Logical table overview
      • Agent hybrid search scenario
        • Overview
        • Quick start
        • Collection and namespace management
        • Write data
        • Search data
        • Indexes and embedding functions
        • Monitoring and maintenance
        • API reference
      • Flash application scenario
        • Overview
        • Limitations and constraints
        • Connect
        • Quick start
        • Collection and app management
        • Data operations
  • Data Pipeline
    • Data ingestion
      • Data migration
        • Data migration overview
        • Use mydumper and myloader to migrate data from a MySQL database
        • Use DBCAT to migrate table structures from a MySQL database
        • Use DataX to migrate table data from a MySQL database
        • Use DBCAT to migrate table structures from an Oracle database
        • Use DataX to migrate table data from an Oracle database
        • Use DBCAT to migrate table structures from a DB2 LUW database
        • Migrate from CSV files
          • Use DataX
          • Use LOAD DATA
        • Migrate by using SQL statements
          • Migrate data between tables
          • Migrate resource units
          • Export data using the OUTFILE statement
      • Data import
        • Data import overview
        • Import data by using the LOAD DATA statement
        • INSERT INTO SELECT
          • Use the INSERT INTO SELECT FROM FILES statement for direct load
          • Import data from external tables using INSERT INTO SELECT
        • Import data via direct load using the CREATE TABLE AS SELECT statement
        • Import data by using obloader
    • Data delivery
      • Export data
      • Data lake
        • Data lake overview
        • Data lake integration
          • Access Hive tables through HMS Catalog
          • Load an Iceberg table through Catalog
          • Read Paimon tables by using plugins
          • ODPS Catalog and external tables
          • Catalogs and external tables
          • File external tables
        • External tables via URL
    • Data sharing
      • Automatic catalog data synchronization
      • Manual catalog data synchronization
  • Data Processing
    • Structured data processing
      • In-database processing
      • Materialized views
      • Data processing tools
    • Unstructured data processing
      • Vector embedding
        • Overview of Vector Embedding Technology
        • Use the AI_EMBED function
        • Use external embedding models
  • Data Branching
    • Overview of Fork
    • Fork Table
    • Fork Database
  • AI Search
    • Vector search
      • Vector search overview
      • Perform vector search using SQL
      • Vector data types overview
      • Store vector data
      • Vector index
        • Overview of vector indexes
        • Vector index memory management
        • Dense index
          • Overview of dense indexes
          • Index type selection
          • HNSW series indexes
          • IVF series indexes
        • Sparse index
          • In-memory sparse vector index
        • Monitor and maintain indexes
        • Index performance optimization
      • Search index
      • Use SQL functions
      • Vector nearest neighbor search
      • FAQ on AI scenarios
    • Semantic search
    • Full-text search
    • Hybrid search
    • Rerank search
  • Query Acceleration
    • Statistics
    • Choose the query parallelism
    • Accelerate queries with materialized views
  • Manage
    • Log in to an user tenant
    • Manage clusters
      • Cluster overview
      • Compute service management
        • 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
          • Start a zone
          • Add a zone
          • Delete a zone
          • Modify a zone
          • Isolate a zone
          • View cluster parameters
          • Modify cluster parameters
          • Reset cluster parameters
          • Update object storage access credentials
        • Data load balancing
          • Data load balancing overview
          • Transfer a partition
          • Cancel a partition transfer task
          • Cancel a balance job
          • Stop and resume a balance job
          • Table group weight management
            • Aggregation of user tables under a database
            • Set table group weights
            • Clear a table group's weight
            • Application scenarios of table group weight balancing
          • Partition weight management
            • Set partition weights
            • Clear partition weights
          • Partition balance management
            • Configure a scheduled partition balancing task
            • Manually trigger partition balancing
            • View the configurations of a scheduled partition balancing task
            • View the trigger history of scheduled partition balancing tasks
            • View background partition balancing tasks
            • View the history of background partition balancing tasks
          • GTS exclusive application case
      • Object storage management
        • Object storage overview
        • Update object storage information
        • Object storage-related views and parameters
        • FAQ on object storage
      • LogService management
        • LogService parameters
        • LogService operations
          • View a LogService node
          • Add a LogService node
          • Delete a LogService node
          • Replace a LogService node
          • Rotate LogService access credentials
          • View LogService parameters
          • Modify LogService parameters
        • LogService load balancing
          • LogService load balancing overview
          • View the load balancing status
          • Configure the load balancing strategy
    • Manage tenants
      • Tenant introduction
      • Tenant capacity
      • Tenant types
      • User tenant introduction
      • Tenant system variables
      • Common tenant operations
        • Create a tenant
        • Resource isolation
          • Resource isolation overview
          • Configure cgroup
          • Configure global CPU resource isolation for foreground and background tasks
          • Calibrate 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
          • Resource isolation configuration examples for background tasks
        • View tenant and resource information
        • View and set the tenant allowlist
        • View tenant system variables
        • Modify tenant system variables
        • Scale in/out
          • Introduction to tenant scaling
          • Resource planning for tenant scaling
          • Tenant pre-scaling
          • Scale tenants by adjusting resource specifications
          • Scale tenants by adjusting the unit number
          • Scale tenants by adjusting the primary zone
          • Smooth scaling application scenarios
        • Modify attributes of a resource pool
        • Modify tenant attributes
        • Lock and unlock a tenant
        • Drop a tenant
        • Restore a tenant
        • Rename a tenant
        • Manage resource pools
          • View resource pools
          • Allocate a resource pool to a tenant
          • Remove resource pools from a tenant
          • Merge and split a resource pool
          • Drop a resource pool
        • Manage resource specifications
          • View resource specifications
          • Modify a unit config
          • Drop a unit config
    • Manage log streams
      • Create a log stream
      • Modify a log stream
    • Manage replicas
      • Replicas
      • Replica distribution
        • Locality
        • Common locality operations
          • View locality
          • Modify locality
          • Add a replica
          • Reduce replicas
          • Adjust the distribution of replicas
          • View the locality change history
          • Replica migration
          • Modify the quorum size of a log stream
          • Cancel a replica task
      • Traffic distribution
      • Data distribution
    • High availability
      • High availability overview
      • Multi-replica disaster recovery
        • Data link introduction
        • High availability at the proxy layer
        • High availability at the database layer
        • Disaster recovery deployment solutions
      • Manage recycle bin
        • Overview of the recycle bin
        • Enable or disable the recycle bin
        • View recycle bin objects
        • Restore objects from the recycle bin
        • Clean up the recycle bin
      • Flashback query
    • Security and permissions
      • Overview of security permissions
      • Identification and authentication
        • Identity authentication
          • Identity authentication
          • Password complexity
          • Handle login failures
      • Access control
        • Overview of access control
        • Users and permissions
          • User and permission overview
          • Permissions
            • Permission classification
            • Create a user
            • Grant privileges directly
            • Privilege delegation
            • Role management
              • Role management overview
              • Create a role
              • Add privileges to a role
              • Grant roles to users or other roles
              • Activate a role
              • View roles
              • Revoke privileges from a role
              • Revoke roles from a user or role
              • Drop a role
            • Indirect authorization
            • View user privileges
            • Revoke privileges
            • Lock or unlock a user
            • Drop a user
        • Row-level security
          • Row-level security
        • Network security access control
        • RPC connection authentication
      • Data encryption
        • Data encryption overview
        • Data transmission encryption
          • Overview of data transmission encryption
          • Transport encryption for OBServer
          • ODP transmission encryption
        • Tenant master key management
          • Overview of tenant master keys
          • Generate tenant master key
        • Data storage encryption
          • Overview of database transparent encryption
          • Set up transparent data encryption for a newly created table
          • Enable transparent data encryption for an existing table
          • Decrypt a table
        • Column encryption
          • Column encryption overview
          • Create a column encryption rule
          • Column encryption privilege management
          • FAQ on column encryption
      • Security audit
        • Security audit overview
        • Security audit
          • Enable security auditing
          • Set an auditing rule
          • View auditing records
          • Disable security auditing
    • Backup and restore
      • Overview of physical backup and restore
      • Physical backup and restore with a minimal experience
      • Log archive
        • Overview of log archiving
        • Prepare for log archiving
        • Enable archiving mode
        • Suspend archiving
        • Disable archiving mode
        • View piece information
        • View archiving progress
        • View the archiving history
        • View archive parameters
        • Change the archive destination
        • Clear the archive path configuration
        • Introduction to log archiving views
      • Data backup
        • Data backup overview
        • Prepare for backup
        • Initiate a full data backup
        • Back up parameters
        • Stop a backup
        • View the data backup progress
        • View data backup results
        • View data backup parameters
        • Change the backup destination
        • Introduction to data backup-related views
      • Update object storage key information
      • Clear backup data
        • Automatic backup cleanup
          • Automatically clean up expired backups
          • Delete a cleanup policy
        • Manual backup cleanup
          • Manually trigger expired backup cleanup
          • Manually clean up specified backup or archive data
          • Manually clear a backup or archive path
        • Cancel a cleanup task
        • View backup cleanup progress
        • View backup cleanup results
        • Introduction to backup cleanup parameters
        • Introduction to cleanup-related views
      • Restore data
        • Preparations before restore
        • Perform physical restore
        • Restore from a specified path
        • Cancel physical restore
        • View the physical restore progress
        • View the result of physical restore
        • Segment-based log replay for a standby tenant
        • Convert a standby tenant into a primary tenant
        • Upgrade a tenant after restore is complete
        • Introduction to physical restore parameters
        • Introduction to views related to physical restore
      • Backup and restore performance tuning
      • Appendix: S3 path format
    • Monitor
      • Monitoring overview
      • Metrics
        • System monitoring
          • Overview of system monitoring metrics
          • SYSSTAT metrics
          • Wait events
          • Lock events
        • SQL monitoring
          • Overview of SQL monitoring
          • SQL audit
          • Execution plans
      • Root service events
      • Cases
    • Logs
      • Log overview
      • Log levels
      • Log interpretation
      • Log stability
      • Log control methods
      • Log compression and decompression
      • Log monitoring 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 Test
    • TPC-DS
      • OceanBase AI Database TPC-DS test
      • OceanBase AI Database TPC-DS test report
    • TPC-H
      • OceanBase AI Database TPC-H test
      • OceanBase AI Database TPC-H test report
  • Reference
    • System management
      • Configuration management
        • Introduction to Configuration Management
        • Set parameters
        • Set variables
      • Storage management
        • Minor compaction management
          • Overview of minor compaction
          • Automatic minor compaction
          • Manually trigger a minor compaction
          • View minor compaction information
          • Modify minor compaction settings
        • Major compaction management
          • Overview of major compaction management
          • Automatically trigger a major compaction
          • Schedule daily tenant major compactions
          • Window compaction
          • Adaptive compaction
          • Manually trigger a major compaction
          • View major compaction information
          • Manually control a major compaction
          • Modify major compaction configuration
        • Data compression
          • Data compression overview
          • Use data encoding and compression
        • Use the TTL feature
        • Custom hot and cold data storage policies
          • Overview of custom hot/cold storage policies
          • Create a table-level hot/cold storage policy
          • Create a partition-level hot/cold storage policy
          • Modify a table-level hot/cold storage policy
          • Modify a partition-level hot/cold storage policy
          • O&M guide for custom hot/cold storage policies
      • Memory management
        • Memory management overview
        • Memory structure
        • Set the maximum memory for a database
        • Internal system memory management
        • Memory management within a tenant
        • Plan cache memory management
        • Memleak-based regular memory leak diagnostics mechanism
        • View memory usage information
        • Common memory issues
      • Process management
        • Overview of OceanBase AI Database threads
        • Multi-tenant threads
        • View thread status
        • Background threads of OceanBase AI Database
        • FAQ about multi-tenant threads
      • Disk management
        • Configure dynamic expansion of disk data files
        • View disk space usage of a tenant or table
    • Database object management
      • Overview of database object management
      • Create and manage databases
        • Create a database
        • View databases
        • Modify a database
        • Drop a database
      • Create and manage tables
        • About tables
        • Create a table
        • Column Skip Index attribute
        • Define an auto-increment column
        • Define column constraints
        • View tables
        • Modify a table
        • Change the attribute of a replicated table
        • Truncate a table
        • Drop a table
        • Lock a table
        • Create and manage external tables
          • External tables and external files
          • Create and query external tables
          • Create a partitioned external table
          • Manage external files
          • Data type mappings
      • Create and manage partitions
        • Partitioning overview
        • Create a partitioned table
        • Partition splitting
          • Overview of partition splitting
          • Manually split a partition
          • Automatic partition splitting
          • Recommended configurations for automatic partitioning
        • Dynamic partitioning
          • Overview of dynamic partitioning
          • Create a dynamic partitioned table
          • View a dynamic partitioned table
          • Modify a dynamic partitioned table
          • Dynamic partition management tasks
        • Modify partitioning rules
        • Add a partition
        • Drop a partition
        • Truncate partitions
        • Partition pruning
        • Query data from a specified partition
        • Create indexes on partitioned tables
          • Index overview
          • Local index
          • Global index
        • Partition exchange
      • Create and manage table groups
        • About table groups
        • Create a table group
        • View table group information
        • Add tables to a table group
        • Modify the SHARDING attribute of a table group
        • Manage tables within a table group
        • Delete a table group
      • Create and manage indexes
        • About indexes
        • Create an index
        • View indexes
        • Monitor indexes
        • Drop an index
        • List of system functions supported for function-based indexes
        • List of system functions not supported for function-based indexes
      • Manage views
        • Manage regular views
        • Manage materialized views
          • Overview of materialized views
          • Materialized view logs
          • Create a materialized view
          • Refresh a materialized view
          • Query rewrite using materialized views
          • Query materialized views
          • Modify materialized view attributes
          • Drop a materialized view
          • Materialized view resource isolation
      • Create and manage sequences
        • Create a sequence
        • View sequences
        • Reference a sequence
        • Modify a sequence
        • Drop a sequence
      • Create and manage triggers
        • Overview
        • Create a DML trigger
        • View trigger information
        • Drop a trigger
      • Create and manage DBLinks
        • Create a DBLink
        • View created DBLinks
        • Manage DBLinks
        • Access data in a remote database through DBLink
        • Drop a DBLink
      • Create and manage catalogs
        • Overview of Catalog
        • Create a catalog
        • View catalogs
        • Drop a catalog
    • Write and read data
      • Write data
        • Insert data
        • Update data
        • Delete data
        • Replace data
        • Generate test data in batches
      • Read data
        • Single-table query
        • Join tables
          • INNER JOIN
          • FULL JOIN
          • LEFT JOIN
          • RIGHT JOIN
          • Subqueries
          • Lateral derived table
        • Use operators and functions in queries
          • Use arithmetic operators in queries
          • Use numeric functions in queries
          • Use string concatenation operators in queries
          • Use string functions in queries
          • Use time 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
          • Lock query results with SELECT FOR UPDATE
          • Lock in share mode
          • Use regular expressions in queries
        • Query using DBLink
        • Set operations
    • Transaction management
      • Transaction management 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
    • AI Function service
      • Overview of AI Function Service
      • Get started with AI Function Service
      • AI Function Service Permissions
      • Register an AI model
      • Interaction with AI models (Batch File)
      • Syntax and examples of AI functions
      • View AI model information
    • SQL reference
      • SQL syntax
        • System tenants
          • Overview of management commands
          • ALTER SYSTEM
            • ACTIVATE STANDBY
            • ADD REPLICA
            • ADD RESTORE SOURCE
            • ARCHIVELOG
            • BOOTSTRAP
            • BACKUP KEY
            • BACKUP
            • BACKUP CLUSTER PARAMETERS
            • BALANCE TASK
            • BALANCE JOB
            • CANCEL BACKUP
            • CANCEL DELETE BACKUP
            • CANCEL MIGRATE UNIT
            • CANCEL REPLICA TASK
            • CANCEL RESTORE
            • CANCEL RECOVER TABLE
            • CANCEL TRANSFER PARTITION
            • CREATE LS
            • CLEAR RESTORE SOURCE
            • DELETE BACKUP POLICY
            • DELETE BACKUP ALL
            • DELETE BACKUPSET/ARCHIVELOG_PIECE
            • DELETE OBSOLETE BACKUP
            • LOAD MODULE DATA
            • MAJOR AND MINOR
            • MIGRATE REPLICA
            • MIGRATE UNIT
            • MODIFY LS
            • MODIFY PAXOS_REPLICA_NUM
            • MODIFY REPLICA
            • NOARCHIVELOG
            • FLUSH PLAN CACHE
            • FLUSH SEQUENCE CACHE
            • FLUSH LOCAL_CACHE
            • FLASHBACK STANDBY LOG
            • JOB
            • SET LOG_RESTORE_SOURCE
            • PARAMETER
            • RECOVER STANDBY
            • RECOVER STANDBY CANCEL
            • REMOVE REPLICA
            • REFRESH
            • RESTORE
            • RESTORE PREVIEW
            • SET DATA_BACKUP_DEST
            • SERVER
            • SERVICE_NAME
            • SWITCHOVER
            • SET LOG_ARCHIVE_DEST
            • SET LOG_ARCHIVE_DEST_STATE
            • THROTTLE
            • TRANSFER PARTITION
            • TTL
            • WASH MEMORY FRAGMENTATION
            • ZONE
          • ALTER RESOURCE POOL
          • ALTER RESOURCE TENANT
          • ALTER RESOURCE UNIT
          • ALTER TENANT
          • CREATE RESOURCE POOL
          • CREATE RESOURCE UNIT
          • CREATE TENANT
          • DROP RESOURCE POOL
          • DROP RESOURCE UNIT
          • DROP TENANT
          • SET DECRYPTION
          • SET ENCRYPTION
          • SHOW RESTORE PREVIEW
        • User tenants
          • Basic elements
            • ROWID Pseudo-Column
            • Data types
              • Overview of data types
              • Numeric types
                • Overview of numeric types
                • Integer types
                • Fixed-point types
                • Floating-point types
                • BIT-Value type
              • Datetime types
                • Overview of date and time types
                • DATE, DATETIME and TIMESTAMP types
                • TIME type
                • YEAR type
              • String types
                • Character type overview
                • CHAR and VARCHAR
                • BINARY and VARBINARY
              • Large objects and text types
                • Overview of LOB and text types
                • BLOB type
                • TEXT type
                • STRING type
                • LOB types
                • LOB_WRITEAPPEND
              • Enumeration types
              • Collection types
              • JSON data types
                • Overview of the JSON data type
                • Create a JSON value
                • Query and modify JSON values
                • JSON data type conversion
                • Update partial data in a JSON document
                • Semi-structured encoding
              • Spatial data types
                • Overview of spatial data types
                • Spatial Reference System (SRS)
                • Create a spatial column
                • Create a spatial index
                • Spatial data formats
              • Roaring bitmap types
                • Overview of Efficient Compression for Bitmap Data Types
                • Create an efficient compressed bitmap column
              • Array data types
                • Overview of Array Element Types
                • Create an array column
              • Map data types
                • Overview of mapped data types
                • Create a mapped column
            • Expressions
              • Overview of Expressions
              • Syntax of Expressions
              • Simple Expressions
              • Compound Expressions
              • Conditional Expressions
              • Column Expressions
              • Date and time expressions
              • Function Expressions
              • Interval Expressions
              • Scalar subquery expressions
              • List of Expressions
              • Data type conversion rules
            • Character set and collation
              • Overview
              • Character sets
              • Collation
              • Database-level character set and collation
              • Table-level character set and collation
              • Column-level character set and collation
              • Character expression character sets and collations
              • Character set and collation of client connections
            • Literals
              • Overview of Literals
              • String text
              • Numbers
              • Date and time values
              • Bit value
              • Boolean values
              • NULL values
            • Schema object name
            • User-defined variables
            • Annotations
              • Hints
                • Overview of hints
                • Control query optimization using the Query Block Name and QB_NAME hint
                • Hint list
                  • Global hints
                    • Optimizer Stats Hint under Global Hint Types
                    • Transform hint under global hints
                    • Other hints under global hints
                  • Optimizer hints
                    • Access path hints under the Optimized hint type
                    • Join Order Hint under Optimized Hint Type
                    • Join Operation Hint under Optimized Hint Type
                    • Subquery hint under Optimized hint type
                    • Group by hint under optimized hint type
                    • DISTINCT hint under Optimized hint type
                    • Set hint under Optimized hint type
                    • Distributed DML Hints under Optimized Hint Type
                    • Vector Index Hint under Optimized Hint Type
                  • Transform hints
                    • Stmt Transform Hint under the Transform Hint Type
                    • Cost Based Transform Hint under the Transform Hint Type
                    • Transform Hints of the Heuristics Type
                    • Other hints under the Transform hint type
                  • Outline-related hint
            • Comments
          • Operators
            • Operator overview
            • Operator precedence
            • Arithmetic operators
            • Bitwise operators
            • Comparison operators
            • Logical operators
            • Assignment operators
            • Date and time operators
            • Character concatenation operators
            • BINARY conversion operator
            • CASE Conditional Operator
          • Functions
            • Function overview
            • Single-row functions
              • Datetime functions
                • ADDDATE
                • CONVERT_TZ
                • CURDATE
                • CURRENT_DATE
                • CURRENT_TIME
                • CURRENT_TIMESTAMP
                • CURTIME
                • DATE
                • DATE_ADD
                • DATE_FORMAT
                • DATE_SUB
                • DATEDIFF
                • DAYOFMONTH
                • DAYOFWEEK
                • DAYOFYEAR
                • EXTRACT
                • FROM_DAYS
                • FROM_UNIXTIME
                • GET_FORMAT
                • HOUR
                • LAST_DAY
                • LOCALTIME
                • LOCALTIMESTAMP
                • MAKEDATE
                • MAKETIME
                • MICROSECOND
                • MINUTE
                • MONTH
                • MONTHNAME
                • NOW
                • PERIOD_ADD
                • PERIOD_DIFF
                • QUARTER
                • SEC_TO_TIME
                • SECOND
                • STR_TO_DATE
                • SUBDATE
                • SUBTIME
                • SYSDATE
                • TIME
                • TIME_FORMAT
                • TIME_TO_SEC
                • TIME_TO_USEC
                • TIMEDIFF
                • TIMESTAMP
                • TIMESTAMPADD
                • TIMESTAMPDIFF
                • TO_DAYS
                • TO_SECONDS
                • UNIX_TIMESTAMP
                • USEC_TO_TIME
                • UTC_DATE
                • UTC_TIME
                • UTC_TIMESTAMP
                • WEEK
                • WEEKDAY
                • WEEKOFYEAR
                • YEARWEEK
                • YEAR
                • ADDTIME
                • DAYNAME
                • DAY
                • DATE_TRUNC
                • MONTHS_ADD
                • FORMATDATETIME
                • TOUNIXTIMESTAMP
                • parseDateTime
              • String functions
                • ASCII
                • BIN
                • BIT_LENGTH
                • CHAR
                • CHAR_LENGTH
                • CHARACTER_LENGTH
                • CONCAT
                • CONCAT_WS
                • ELT
                • EXPORT_SET
                • FIELD
                • FIND_IN_SET
                • FORMAT
                • HEX
                • INSERT
                • INSTR
                • INT2IP
                • IP2INT
                • KEYVALUE
                • LCASE
                • LEFT
                • LENGTH
                • LOCATE
                • LOWER
                • LPAD
                • LTRIM
                • MAKE_SET
                • MAX_PT
                • MD5_CONCAT_WS
                • MID
                • OCT
                • OCTET_LENGTH
                • ORD
                • POSITION
                • QUOTE
                • REGEXP
                • REGEXP_INSTR
                • REGEXP_LIKE
                • REGEXP_REPLACE
                • REGEXP_SUBSTR
                • REPEAT
                • REPLACE
                • REVERSE
                • RIGHT
                • RLIKE
                • RPAD
                • RTRIM
                • SPACE
                • SPLIT_PART
                • STRCMP
                • SUBSTR
                • SUBSTRING
                • SUBSTRING_INDEX
                • TRIM
                • UCASE
                • UNHEX
                • UPPER
                • URL_DECODE
                • URL_ENCODE
                • WEIGHT_STRING
                • TO_BASE64
                • FROM_BASE64
                • SOUNDEX
                • EDITDISTANCE
              • Conversion functions
                • CAST
                • CONVERT
                • DECODE_TRACE_ID
                • SCN_TO_TIMESTAMP
                • TIMESTAMP_TO_SCN
                • TO_CHAR(character)
                • TO_CHAR(number)
                • TO_CHAR(datetime)
                • TO_DATE
              • Mathematical functions
                • ABS
                • ACOS
                • ASIN
                • ATAN
                • ATAN2
                • BIT_COUNT
                • CEIL
                • CEILING
                • CONV
                • COS
                • COT
                • CRC32
                • DEGREES
                • EXP
                • FLOOR
                • GENERATOR
                • LN
                • LOG
                • LOG10
                • LOG2
                • MOD
                • NEG
                • PI
                • NORMAL
                • POW
                • POWER
                • RADIANS
                • RAND
                • RANDOM
                • RANDSTR
                • ROUND
                • SIGN
                • SIN
                • SQRT
                • TAN
                • TRUNCATE
                • UNIFORM
                • ZIPF
              • Comparison functions
                • GREATEST
                • INTERVAL
                • ISNULL
                • LEAST
              • Process control functions
                • CASE
                • IF
                • IFNULL
                • NULLIF
                • ORA_DECODE
            • Aggregate functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • ARG_MAX
              • ARG_MIN
              • BIT_AND
              • BIT_OR
              • BIT_XOR
              • COUNT
              • GROUP_CONCAT
              • GROUPING
              • MAX
              • MIN
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • STRING_AGG
              • AVG_WEIGHTED
              • ARBITRARY
              • ANY
              • GROUPCONCAT
              • STDDEVSAMP
              • UNIQ
              • VARSAMP
            • Analysis functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • BIT_AND
              • BIT_OR
              • BIT_XOR
              • COUNT
              • CUME_DIST
              • DENSE_RANK
              • FIRST_VALUE
              • LAG
              • LAST_VALUE
              • LEAD
              • MAX
              • MIN
              • NTH_VALUE
              • NTILE
              • PERCENT_RANK
              • PERCENTILE_CONT
              • RANK
              • ROW_NUMBER
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • LAGINFRAME
              • LEADINFRAME
            • Encryption functions
              • AES_DECRYPT
              • AES_ENCRYPT
              • COMPRESS
              • DECODE
              • DES_DECRYPT
              • DES_ENCRYPT
              • ENCODE
              • ENCRYPT
              • ENHANCED_AES_ENCRYPT
              • ENHANCED_AES_DECRYPT
              • MD5
              • PASSWORD
              • UNCOMPRESS
              • UNCOMPRESSED_LENGTH
              • RANDOM_BYTES
              • SHA
              • SHA1
              • SHA2
              • VALIDATE_PASSWORD_STRENGTH
              • SM3
              • SM4_ENCRYPT
              • SM4_DECRYPT
            • Information functions
              • BENCHMARK
              • CATALOG
              • CHARSET
              • COERCIBILITY
              • COLLATION
              • CONNECTION_ID
              • CURRENT_ROLE
              • CURRENT_USER
              • DATABASE
              • FOUND_ROWS
              • LAST_INSERT_ID
              • LAST_INSERT_ID Behavior Description
              • ICU_VERSION
              • OB_TRANSACTION_ID
              • ROW_COUNT
              • SCHEMA
              • SESSION_USER
              • SYSTEM_USER
              • USER
              • VERSION
              • OB_VERSION
            • JSON functions
              • Overview of JSON functions
              • Functions for creating JSON text
                • JSON_ARRAY
                • JSON_OBJECT
                • JSON_QUOTE
              • Functions for searching JSON text
                • JSON_CONTAINS
                • JSON_CONTAINS_PATH
                • JSON_EXTRACT
                • JSON_KEYS
                • JSON_OVERLAPS
                • JSON_SEARCH
                • JSON_VALUE
                • MEMBER OF
              • Functions for modifying JSON text
                • JSON_ARRAY_APPEND
                • JSON_APPEND
                • JSON_ARRAY_INSERT
                • JSON_INSERT
                • JSON_MERGE
                • JSON_MERGE_PATCH
                • JSON_MERGE_PRESERVE
                • JSON_REMOVE
                • JSON_REPLACE
                • JSON_SET
                • JSON_UNQUOTE
              • Functions for returning JSON text properties
                • JSON_DEPTH
                • JSON_LENGTH
                • JSON_TYPE
                • JSON_VALID
              • JSON_TABLE function
              • JSON utility functions
                • JSON_PRETTY
                • JSON_STORAGE_SIZE
              • JSON aggregate functions
                • JSON_ARRAYAGG
                • JSON_OBJECTAGG
              • JSON schema validation functions
                • JSON_SCHEMA_VALID
                • JSON_SCHEMA_VALIDATION_REPORT
            • XML functions
              • Overview of XML functions
              • Functions for querying XML data
                • EXTRACTVALUE
              • Functions for modifying XML data
                • UPDATEXML
            • Table functions
              • Overview of TABLE FUNCTIONS
              • FILES table function
            • Spatial functions
              • Overview of Spatial Functions
              • Create a geometric value function
              • Spatial operators
              • Spatial relationship functions
              • Geometric property functions
              • Geometric format conversion functions
              • Spatial analysis functions
              • Spatial Constructors
              • Spatial accessor functions
              • Spatial format conversion functions
              • Geometric Processing Functions
              • _ST_GeoHash
            • Performance schema functions
              • FORMAT_BYTES
              • FORMAT_PICO_TIME
            • Lock functions
              • Overview of Lock Functions
              • GET_LOCK
              • IS_FREE_LOCK
              • IS_USED_LOCK
              • RELEASE_ALL_LOCKS()
              • RELEASE_LOCK
            • Bitmap functions
              • Overview of bitmap functions
              • Bitmap Constructor
              • Bitmap cardinality functions
              • Bitmap arithmetic functions
              • Bitmap predicate functions
              • Bitmap output functions
              • Bitmap aggregate functions
            • Array functions
              • Overview of array functions
              • Array constructor
              • Array comparison functions
              • Array output functions
              • Array functions
            • Text processing functions
              • TOKENIZE
            • Audit functions
              • Overview of audit functions
              • AUDIT_LOG_FILTER_REMOVE_FILTER
              • AUDIT_LOG_FILTER_REMOVE_USER
              • AUDIT_LOG_FILTER_SET_FILTER
              • AUDIT_LOG_FILTER_SET_USER
            • Map functions
              • Overview of mapping functions
              • Constructor of Map
              • Mapping judgment function
              • Mapping functions
            • Other functions
              • ANY_VALUE
              • BIN_TO_UUID
              • COALESCE
              • DEFAULT
              • NAME_CONST
              • INET_ATON
              • INET_NTOA
              • INET6_ATON
              • INET6_NTOA
              • IS_IPV4
              • IS_IPV4_COMPAT
              • IS_IPV6
              • IS_UUID
              • MATCH AGAINST
              • NVL
              • UUID_TO_BIN
              • SLEEP
              • UUID
              • UUID_SHORT
              • VALUES
              • ISNAN
          • Queries and subqueries
            • Overview
            • Subquery
            • Connections
            • Full-text query
          • SQL statements
            • General syntax
            • Generalized Table Expressions
            • ALTER COMPILE
            • ALTER DATABASE
            • ALTER LOCATION
            • ALTER MATERIALIZED VIEW
            • ALTER MATERIALIZED VIEW LOG
            • ALTER OUTLINE
            • ALTER EXTERNAL TABLE
            • ALTER SENSITIVE RULE
            • ALTER POLICY
            • ALTER SEQUENCE
            • ALTER/CHANGE/MODIFY EXTERNAL_STORAGE_DEST
            • ALTER SYSTEM FLUSH SEQUENCE CACHE
            • MAJOR AND MINOR
            • STORAGE_CACHE_POLICY_EXECUTOR
            • ALTER TABLE
            • ALTER TABLEGROUP
            • ALTER TABLESPACE
            • ALTER USER
            • ALTER VIEW
            • ALTER INSTANCE ROTATE INNODB MASTER KEY
            • ALTER EVENT
            • ANALYZE
            • CACHE INDEX
            • CREATE CONCURRENT_LIMITING_RULE
            • CREATE DATABASE
            • CREATE DATABASE LINK
            • CREATE EXTERNAL CATALOG
            • CREATE EXTERNAL TABLE
            • CREATE INDEX
            • CREATE LOCATION
            • CREATE MATERIALIZED VIEW
            • CREATE MATERIALIZED VIEW LOG
            • CREATE OUTLINE
            • CREATE POLICY
            • CREATE FORMAT OUTLINE
            • CREATE ROLE
            • CREATE SENSITIVE RULE
            • CREATE SEQUENCE
            • CREATE TABLE
            • CREATE TABLEGROUP
            • CREATE TABLESPACE
            • CREATE USER
            • CREATE VIEW
            • CHECKSUM TABLE
            • CREATE EVENT
            • DEALLOCATE PREPARE
            • DROP DATABASE LINK
            • DELETE
            • DESCRIBE
            • DROP CATALOG
            • DROP CONCURRENT_LIMITING_RULE
            • DROP DATABASE
            • DROP EVENT
            • DROP INDEX
            • DROP LOCATION
            • DROP MATERIALIZED VIEW
            • DROP MATERIALIZED VIEW LOG
            • DROP OUTLINE
            • DROP ROLE
            • DROP SENSITIVE RULE
            • DROP POLICY
            • DROP TABLE
            • DROP TABLEGROUP
            • DROP TABLESPACE
            • DROP SEQUENCE
            • DROP USER
            • DROP VIEW
            • EXECUTE
            • EXPLAIN
            • FLASHBACK
            • FLUSH TABLE
            • GRANT
            • HELP
            • INSERT
            • KILL
            • LOAD DATA
            • LOAD_FILE
            • LOAD INDEX INTO CACHE
            • LOCK TABLES
            • OPTIMIZE
            • PREPARE
            • PURGE
            • PURGE RECYCLEBIN
            • RENAME USER
            • RENAME TABLE
            • REPLACE
            • REPAIR TABLE
            • REMOVE
            • REVOKE
            • SAVEPOINT
            • SCHEMA
            • SELECT INTO
            • SET DEFAULT ROLE
            • SELECT
              • SELECT
              • JOIN clause
              • WINDOW clause
              • UNION clause
              • HYBRID_SEARCH
              • PARTITION TIER
            • SET
            • SET CATALOG
            • SET CHARSET
            • SET NAMES
            • SET PASSWORD
            • SET ROLE
            • SET TRANSACTION
            • SHOW
            • SUBMIT JOB
            • SHOW JOB STATUS
            • CANCEL JOB
            • TRANSACTION
            • TRUNCATE TABLE
            • UNLOCK TABLES
            • UPDATE
            • USE
            • VALUES
            • XA TRANSACTION
          • DDL feature
            • Overview of DDL features
            • Online DDL and Offline DDL Operations
            • Index operations
            • Primary key operations
            • Column operations
            • Generate columns
            • Foreign key operations
            • Table operations
            • Partition operations
            • Column type change rules
            • Number type conversion rules
          • Pseudo columns
            • Overview of PseudoColumns
            • PARTITIONID Pseudo Column
            • Sequence Pseudocolumns
          • Conditions
            • Overview of SQL Conditions
            • Condition priorities
            • Comparison conditions
            • Logical conditions
            • Pattern matching conditions
            • Null value conditions
            • BETWEEN condition
            • EXISTS condition
            • IN Condition
            • JSON Member Conditions
            • Boolean test conditions
      • SQL specifications and practices
        • SQL Writing Restrictions
        • SQL writing specifications
          • SELECT statement writing specifications
          • DML statement writing guidelines
          • DDL statement writing guidelines
          • Multi-table association guidelines
          • Table scan method specifications
          • Transaction specifications
          • Usage guidelines for cache
          • Guidelines for Using HINTS
          • Other related specifications
        • SQL statement examples
          • Implicit type conversion related
          • Suggestions on using JOIN tables
          • Weak-consistency read
          • Paginated query
      • Reserved keywords
      • Data type conversion behavior in strict mode
    • PL reference
      • What is PL
        • PL Overview
        • Key features of PL
        • Architecture of PL
      • PL syntax structure
      • PL stored procedures
        • Overview of stored programs
        • Variables of stored programs
        • Stored procedure
        • Stored Procedures and Privilege Management
        • Stored functions
        • External storage functions
        • Trigger
        • EVENT
        • Limitations on stored programs
        • SQL Transpiler
        • PL asynchronous commit optimization
      • PL cursors
        • Cursor overview
        • Cursor execution process
        • Limitations on server-side cursors
      • PL conditional control statements
        • CASE
        • IF
        • ITERATE
        • LEAVE
        • LOOP
        • REPEAT
        • RETURN
        • WHILE
      • PL data manipulation statements
        • CALL
        • DO
      • PL data definition statements
        • ALTER FUNCTION
        • ALTER PROCEDURE
        • CREATE FUNCTION
        • CREATE PROCEDURE
        • CREATE TRIGGER
        • DROP FUNCTION
        • DROP PROCEDURE
        • DROP TRIGGER
      • PL database management statements
        • SHOW CREATE FUNCTION
        • SHOW CREATE PROCEDURE
        • SHOW CREATE TRIGGER
        • SHOW FUNCTION STATUS
        • SHOW PROCEDURE STATUS
        • SHOW TRIGGERS
      • PL related dictionary views
        • INFORMATION_SCHEMA PARAMETERS
        • INFORMATION_SCHEMA ROUTINES
        • INFORMATION_SCHEMA TRIGGERS
      • PL exception handling
        • Overview of exception handling
        • DECLARE ... CONDITION
        • DECLARE ... HANDLER
        • GET DIAGNOSTICS
        • RESIGNAL
        • SIGNAL
        • Scope of handlers
        • Diagnostic section
        • Exception Handling and OUT/INOUT Parameters
        • Limitations on exception handling
      • PL system packages
        • Overview of system packages
        • DBMS_AI_SERVICE
          • Overview of DBMS_AI_SERVICE
          • CREATE_AI_MODEL
          • DROP_AI_MODEL
          • CREATE_AI_MODEL_ENDPOINT
          • ALTER_AI_MODEL_ENDPOINT
          • DROP_AI_MODEL_ENDPOINT
          • REGISTER_PROVIDER
          • ALTER_PROVIDER
          • UNREGISTER_PROVIDER
          • ALTER_MODEL_PROFILE
          • DROP_MODEL_PROFILE
          • CREATE_AI_GATEWAY
          • ALTER_AI_GATEWAY
          • DROP_AI_GATEWAY
        • DBMS_ASYNC_INDEX
          • Overview of DBMS_ASYNC_INDEX
          • FORCEMERGE
        • DBMS_DAILY_MAINTENANCE
          • Overview of DBMS_DAILY_MAINTENANCE
          • TRIGGER_WINDOW_COMPACTION_PROC
          • SET_THREAD_COUNT
        • DBMS_HYBRID_SEARCH
          • Overview of DBMS_HYBRID_SEARCH
          • SEARCH
          • GET_SQL
        • DBMS_MVIEW
          • Overview of DBMS_MVIEW
          • PURGE_LOG
          • REFRESH
          • KILL_REFRESH
          • REFRESH_REPORT
        • DBMS_MVIEW_STATS
          • Overview of DBMS_MVIEW_STATS
          • PURGE_REFRESH_STATS
          • SET_MVREF_STATS_PARAMS
          • SET_SYSTEM_DEFAULT
        • DBMS_PARTITION
          • Overview of DBMS_PARTITION
          • MANAGE_DYNAMIC_PARTITION
        • DBMS_RESOURCE_MANAGER
          • Overview of DBMS_RESOURCE_MANAGER
          • CREATE_CONSUMER_GROUP
          • CREATE_PLAN
          • CREATE_PLAN_DIRECTIVE
          • COPY_PLAN
          • DELETE_CONSUMER_GROUP
          • DELETE_PLAN
          • DELETE_PLAN_DIRECTIVE
          • System Packages
          • UPDATE_PLAN_DIRECTIVE
        • DBMS_STATS
          • Overview of DBMS_STATS
          • ALTER_STATS_HISTORY_RETENTION
          • CREATE_STAT_TABLE
          • DELETE_CATALOG_GLOBAL_PREFS
          • DELETE_CATALOG_TABLE_PREFS
          • DELETE_COLUMN_STATS
          • DELETE_INDEX_STATS
          • DELETE_TABLE_STATS
          • DELETE_SCHEMA_STATS
          • DELETE_SCHEMA_PREFS
          • DELETE_SYSTEM_STATS
          • DELETE_TABLE_PREFS
          • DROP_STAT_TABLE
          • EXPORT_COLUMN_STATS
          • EXPORT_INDEX_STATS
          • EXPORT_TABLE_STATS
          • EXPORT_SCHEMA_STATS
          • FLUSH_DATABASE_MONITORING_INFO
          • GATHER_CATALOG_TABLE_STATS
          • GATHER_INDEX_STATS
          • GATHER_TABLE_STATS
          • GATHER_SCHEMA_STATS
          • GATHER_SYSTEM_STATS
          • GET_CATALOG_GLOBAL_PREFS
          • GET_CATALOG_PREFS
          • GET_STATS_HISTORY_AVAILABILITY
          • GET_STATS_HISTORY_RETENTION
          • GET_PARAM
          • GET_PREFS
          • IMPORT_INDEX_STATS
          • IMPORT_COLUMN_STATS
          • IMPORT_TABLE_STATS
          • IMPORT_SCHEMA_STATS
          • LOCK_CATALOG_PARTITION_STAT
          • LOCK_CATALOG_TABLE_STAT
          • LOCK_PARTITION_STATS
          • LOCK_SCHEMA_STATS
          • LOCK_TABLE_STATS
          • RESTORE_TABLE_STATS
          • RESTORE_SCHEMA_STATS
          • RESET_GLOBAL_PREF_DEFAULTS
          • RESET_PARAM_DEFAULTS
          • PURGE_STATS
          • SET_CATALOG_GLOBAL_PREFS
          • SET_CATALOG_TABLE_PREFS
          • SET_COLUMN_STATS
          • SET_INDEX_STATS
          • SET_TABLE_STATS
          • SET_GLOBAL_PREFS
          • SET_PARAM
          • SET_SCHEMA_PREFS
          • SET_SYSTEM_STATS
          • SET_TABLE_PREFS
          • UNLOCK_CATALOG_PARTITION_STAT
          • UNLOCK_CATALOG_TABLE_STAT
          • UNLOCK_PARTITION_STATS
          • UNLOCK_SCHEMA_STATS
          • UNLOCK_TABLE_STATS
          • CANCEL_GATHER_STATS
          • COPY_TABLE_STATS
        • DBMS_TRUSTED_CERTIFICATE_MANAGER
          • Overview of DBMS_TRUSTED_CERTIFICATE_MANAGER
          • ADD_TRUSTED_CERTIFICATE
          • DELETE_TRUSTED_CERTIFICATE
          • UPDATE_TRUSTED_CERTIFICATE
        • DBMS_UDR
          • Overview of DBMS_UDR
          • CREATE_RULE
          • DISABLE_RULE
          • ENABLE_RULE
          • REMOVE_RULE
        • DBMS_VECTOR
          • Overview of DBMS_VECTOR
          • REBUILD_INDEX
          • INDEX_VECTOR_MEMORY_ESTIMATE
          • INDEX_VECTOR_MEMORY_ADVISOR
          • FLUSH_INDEX
          • COMPACT_INDEX
          • TRIGGER_ASYNC_TASK
          • ALTER_INDEX_PARAMS
        • DBMS_WORKLOAD_REPOSITORY
          • Overview of DBMS_WORKLOAD_REPOSITORY
          • ASH_REPORT
          • CREATE_SNAPSHOT
          • DROP_SNAPSHOT_RANGE
          • MODIFY_SNAPSHOT_SETTINGS
        • DBMS_SESSION
          • Overview of DBMS_SESSION
          • SET_IDENTIFIER
          • CLEAR_IDENTIFIER
        • DBMS_APPLICATION_INFO
          • Overview of DBMS_APPLICATION_INFO
          • READ_CLIENT_INFO
          • READ_MODULE
          • SET_ACTION
          • SET_CLIENT_INFO
          • SET_MODULE
        • DBMS_XPLAN
          • Overview of DBMS_XPLAN
          • DISPLAY_ACTIVE_SESSION_PLAN
          • DISPLAY_CURSOR
          • DISPLAY
          • DISABLE_OPT_TRACE
          • DISPLAY_SQL_PLAN_BASELINE
          • ENABLE_OPT_TRACE
          • SET_OPT_TRACE_PARAMETER
        • DBMS_XPROFILE
          • Overview of DBMS_XPROFILE
          • DISPLAY_PROFILE
        • DBMS_BALANCE
          • Overview of DBMS_BALANCE
          • SET_BALANCE_WEIGHT
          • CLEAR_BALANCE_WEIGHT
          • TRIGGER_PARTITION_BALANCE
          • SET_TABLEGROUP_BALANCE_WEIGHT
          • CLEAR_TABLEGROUP_BALANCE_WEIGHT
        • DBMS_OB_LIMIT_CALCULATOR
          • Overview of DBMS_OB_LIMIT_CALCULATOR
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_UNIT
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_LOGIC_RES
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_STANDBY_TENANT
        • DBMS_EXTERNAL_TABLE
          • Overview of DBMS_EXTERNAL_TABLE
          • AUTO_REFRESH_EXTERNAL_TABLE
        • DBMS_JAVA
          • Overview of DBMS_JAVA
          • LOADJAVA
          • DROPJAVA
          • GRANT_PERMISSION
          • RESTRICT_PERMISSION
          • REVOKE_PERMISSION
          • DISABLE_PERMISSION
          • ENABLE_PERMISSION
          • DELETE_PERMISSION
        • DBMS_PYTHON
          • Overview of DBMS_PYTHON
          • DROPPYTHON
          • LOADPYTHON
        • DBMS_DATA_DICT
          • DBMS_DATA_DICT
      • Reserved and Non-Reserved PL Keywords
    • System views
      • Overview of system views
      • Overview of system views
      • SYS tenant views
        • Dictionary views
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLLATIONS
          • information_schema.COLUMN_PRIVILEGES
          • information_schema.COLUMNS
          • information_schema.ENGINES
          • information_schema.events
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.QUERY_RESPONSE_TIME
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.role_table_grants
          • information_schema.role_column_grants
          • information_schema.role_routine_grants
          • information_schema.ROUTINES
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SCHEMATA
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.STATISTICS
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.TABLES
          • information_schema.TRIGGERS
          • information_schema.USER_PRIVILEGES
          • information_schema.VIEW_TABLE_USAGE
          • information_schema.VIEWS
          • mysql.columns_priv
          • mysql.db
          • mysql.default_roles
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.help_topic
          • mysql.proc
          • mysql.procs_priv
          • mysql.role_edges
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_OB_DATABASE_PRIVILEGE
          • oceanbase.CDB_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.CDB_IND_COLUMNS
          • oceanbase.CDB_IND_PARTITIONS
          • oceanbase.CDB_IND_SUBPARTITIONS
          • CDB_INDEX_USAGE
          • oceanbase.CDB_INDEXES
          • CDB_MVIEW_LOGS
          • oceanbase.CDB_MVIEW_RUNNING_JOBS
          • CDB_MVIEWS
          • CDB_MVREF_CHANGE_STATS
          • CDB_MVREF_RUN_STATS
          • CDB_MVREF_STATS
          • CDB_MVREF_STATS_PARAMS
          • CDB_MVREF_STATS_SYS_DEFAULTS
          • CDB_MVREF_STMT_STATS
          • oceanbase.CDB_OB_ACCESS_POINT
          • oceanbase.CDB_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.CDB_OB_AI_BATCH_TASKS
          • oceanbase.CDB_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.CDB_OB_AI_GATEWAYS
          • oceanbase.CDB_OB_AI_MODEL_ENDPOINTS
          • oceanbase.CDB_OB_AI_MODEL_PROFILES
          • oceanbase.CDB_OB_AI_MODEL_PROVIDERS
          • oceanbase.CDB_OB_AI_MODELS
          • oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.CDB_OB_ARCHIVE_DEST
          • oceanbase.CDB_OB_ARCHIVELOG
          • oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.CDB_OB_ARCHIVELOG_SUMMARY
          • oceanbase.CDB_OB_AUTO_INCREMENT
          • CDB_OB_AUX_STATISTICS
          • oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_JOBS
          • oceanbase.CDB_OB_BACKUP_DELETE_POLICY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASKS
          • oceanbase.CDB_OB_BACKUP_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_JOBS
          • oceanbase.CDB_OB_BACKUP_PARAMETER
          • oceanbase.CDB_OB_BACKUP_SET_FILES
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASKS
          • oceanbase.CDB_OB_BALANCE_JOB_HISTORY
          • oceanbase.CDB_OB_BALANCE_JOBS
          • oceanbase.CDB_OB_BALANCE_TASK_HISTORY
          • oceanbase.CDB_OB_BALANCE_TASKS
          • oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_CCL_RULES
          • oceanbase.CDB_OB_CS_REPLICA_STATS
          • oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.CDB_OB_DATABASES
          • oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.CDB_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_OB_FREEZE_INFO
          • oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.CDB_OB_IMPORT_TABLE_JOBS
          • oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.CDB_OB_IMPORT_TABLE_TASKS
          • oceanbase.CDB_OB_KV_TTL_TASK_HISTORY
          • oceanbase.CDB_OB_KV_TTL_TASKS
          • oceanbase.CDB_OB_LOG_RESTORE_SOURCE
          • oceanbase.CDB_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.CDB_OB_LOB_CHECK_TASKS
          • oceanbase.CDB_OB_LS
          • oceanbase.CDB_OB_LS_HISTORY
          • oceanbase.CDB_OB_LS_LOCATIONS
          • oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.CDB_OB_LS_REPLICA_TASKS
          • oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.CDB_OB_MAJOR_COMPACTION
          • oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT
          • oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.CDB_OB_RECOVER_TABLE_JOBS
          • oceanbase.CDB_OB_SERVICES
          • oceanbase.CDB_OB_RESTORE_HISTORY
          • oceanbase.CDB_OB_RESTORE_PROGRESS
          • oceanbase.CDB_OB_RSRC_DIRECTIVES
          • oceanbase.CDB_OB_SENSITIVE_COLUMNS
          • oceanbase.CDB_OB_SENSITIVE_RULE_PLAINACCESS_USERS
          • oceanbase.CDB_OB_SENSITIVE_RULES
          • oceanbase.CDB_OB_SERVER_SPACE_USAGE
          • oceanbase.CDB_OB_SPACE_USAGE
          • oceanbase.CDB_OB_STORAGE_SPACE_USAGE
          • oceanbase.CDB_OB_SYS_VARIABLES
          • oceanbase.CDB_OB_STORAGE_IO_USAGE
          • oceanbase.CDB_OB_SPM_EVO_RESULT
          • oceanbase.CDB_OB_TABLE_LOCATIONS
          • oceanbase.CDB_OB_TABLEGROUP_PARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_TABLES
          • oceanbase.CDB_OB_TABLEGROUPS
          • oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_TABLET_REPLICAS
          • oceanbase.CDB_OB_TABLET_TO_LS
          • oceanbase.CDB_OB_TABLE_SPACE_USAGE
          • oceanbase.CDB_OB_TEMP_FILES
          • oceanbase.CDB_OB_TENANT_EVENT_HISTORY
          • oceanbase.CDB_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASKS
          • oceanbase.CDB_OB_TTL_TASKS
          • oceanbase.CDB_OB_TTL_TASK_HISTORY
          • oceanbase.CDB_OB_USERS
          • oceanbase.CDB_OB_VECTOR_INDEX_TASKS
          • oceanbase.CDB_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.CDB_OBJECTS
          • oceanbase.CDB_PART_INDEXES
          • oceanbase.CDB_PART_KEY_COLUMNS
          • oceanbase.CDB_PART_TABLES
          • oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.CDB_SUBPART_KEY_COLUMNS
          • oceanbase.CDB_SUBPARTITION_TEMPLATES
          • oceanbase.CDB_TAB_COL_STATISTICS
          • oceanbase.CDB_TAB_COLS
          • oceanbase.CDB_TAB_COLS_V$
          • oceanbase.CDB_TAB_PARTITIONS
          • oceanbase.CDB_TAB_SUBPARTITIONS
          • oceanbase.CDB_TABLES
          • oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.CDB_WR_CONTROL
          • oceanbase.CDB_WR_EVENT_NAME
          • oceanbase.CDB_WR_RES_MGR_SYSSTAT
          • oceanbase.CDB_WR_SNAPSHOT
          • oceanbase.CDB_WR_SQL_PLAN
          • oceanbase.CDB_WR_SQLSTAT
          • oceanbase.CDB_WR_SQLTEXT
          • oceanbase.CDB_WR_STATNAME
          • oceanbase.CDB_WR_SYS_TIME_MODEL
          • oceanbase.CDB_WR_SYSSTAT
          • oceanbase.CDB_WR_SYSTEM_EVENT
          • oceanbase.CDB_OB_EXTERNAL_RESOURCES
          • oceanbase.DBA_DB_LINKS
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_INDEX_USAGE
          • oceanbase.DBA_MVIEW_DEPS
          • oceanbase.DBA_MVIEW_LOGS
          • oceanbase.DBA_MVIEW_RUNNING_JOBS
          • oceanbase.DBA_MVIEWS
          • oceanbase.DBA_MVREF_CHANGE_STATS
          • oceanbase.DBA_MVREF_RUN_STATS
          • oceanbase.DBA_MVREF_STATS
          • oceanbase.DBA_MVREF_STATS_PARAMS
          • oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS
          • oceanbase.DBA_MVREF_STMT_STATS
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.DBA_OB_AI_BATCH_TASKS
          • oceanbase.DBA_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.DBA_OB_AI_GATEWAYS
          • oceanbase.DBA_OB_AI_MODEL_ENDPOINTS
          • oceanbase.DBA_OB_AI_MODEL_PROFILES
          • oceanbase.DBA_OB_AI_MODEL_PROVIDERS
          • oceanbase.DBA_OB_AI_MODELS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • DBA_OB_AUX_STATISTICS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.DBA_OB_CCL_RULES
          • oceanbase.DBA_OB_CS_REPLICA_STATS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.DBA_OB_EXTERNAL_PART_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_EXTERNAL_RESOURCES
          • DBA_OB_FORMAT_OUTLINES
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_TASKS
          • oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_KV_TTL_TASKS
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.DBA_OB_LOB_CHECK_TASKS
          • oceanbase.DBA_OB_LS
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_SERVICES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOBS
          • oceanbase.DBA_OB_RESOURCE_POOLS
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_OB_RSRC_DIRECTIVES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_OB_SERVER_EVENT_HISTORY
          • oceanbase.DBA_OB_SERVER_JOBS
          • oceanbase.DBA_OB_SERVERS
          • oceanbase.DBA_OB_STORAGE_SPACE_USAGE
          • oceanbase.DBA_OB_STORAGE_IO_USAGE
          • oceanbase.DBA_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.DBA_OB_SYS_VARIABLES
          • oceanbase.DBA_OB_SPM_EVO_RESULT
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_TABLES
          • oceanbase.DBA_OB_TABLEGROUPS
          • oceanbase.DBA_OB_TABLET_REPLICAS
          • oceanbase.DBA_OB_TABLET_TO_LS
          • oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TEMP_FILES
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.DBA_OB_TENANT_JOBS
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • DBA_OB_TRUSTED_ROOT_CERTIFICATE
          • oceanbase.DBA_OB_TTL_TASKS
          • oceanbase.DBA_OB_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_UNIT_CONFIGS
          • oceanbase.DBA_OB_UNIT_JOBS
          • oceanbase.DBA_OB_UNITS
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.DBA_OB_USERS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASKS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OB_ZONES
          • oceanbase.DBA_OB_ZONE_STORAGE
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_RECYCLEBIN
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.DBA_TABLES
          • oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.DBA_WR_CONTROL
          • oceanbase.DBA_WR_EVENT_NAME
          • oceanbase.DBA_WR_RES_MGR_SYSSTAT
          • oceanbase.DBA_WR_SNAPSHOT
          • oceanbase.DBA_WR_SQL_PLAN
          • oceanbase.DBA_WR_SQLSTAT
          • oceanbase.DBA_WR_SQLTEXT
          • oceanbase.DBA_WR_STATNAME
          • oceanbase.DBA_WR_SYS_TIME_MODEL
          • oceanbase.DBA_WR_SYSSTAT
          • oceanbase.DBA_WR_SYSTEM_EVENT
        • Performance views
          • GV$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • GV$LATCH
          • GV$OB_ACTIVE_SESSION_HISTORY
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_CGROUP_CONFIG
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • GV$OB_FLT_TRACE_CONFIG
          • GV$OB_FUNCTION_IO_STAT
          • GV$OB_GROUP_IO_STAT
          • GV$OB_HMS_CLIENT_POOL_STAT
          • GV$OB_HNSW_INDEX_INFO
          • GV$OB_HNSW_INDEX_SEGMENT_INFO
          • GV$OB_IO_BENCHMARK
          • GV$OB_IO_CALIBRATION_STATUS
          • GV$OB_IVF_INDEX_INFO
          • GV$OB_KVCACHE
          • GV$OB_KV_GROUP_COMMIT_STATUS
          • GV$OB_KV_CONNECTIONS
          • GV$OB_LOG_STAT
          • GV$OB_LOG_TRANSPORT_DEST_STAT
          • GV$OB_LS_SNAPSHOTS
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_MEMSTORE_INFO
          • GV$OB_MERGE_INFO
          • GV$OB_NIC_INFO
          • GV$OB_RPC_INCOMING
          • GV$OB_RPC_OUTGOING
          • GV$OB_PARAMETERS
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PLUGINS
          • GV$OB_PROCESSLIST
          • GV$OB_PS_ITEM_INFO
          • GV$OB_PS_STAT
          • GV$OB_PX_P2P_DATAHUB
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_PX_WORKER_STAT
          • GV$OB_RES_MGR_SYSSTAT
          • GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_SERVERS
          • GV$OB_SERVER_STORAGE
          • GV$OB_SESS_TIME_MODEL
          • GV$OB_SESSION
          • GV$OB_SESSION_PS_INFO
          • GV$OB_SHARED_STORAGE_QUOTA
          • GV$OB_SINDI_INDEX_INFO
          • GV$OB_SQL_AUDIT
          • GV$OB_SQL_CCL_STATUS
          • GV$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • GV$SQL_PLAN_MONITOR
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SQLSTAT
          • GV$OB_SSTABLES
          • GV$OB_LOCAL_CACHE
          • GV$OB_LOCAL_CACHE_DIAGNOSE
          • GV$OB_OBJECT_TYPE_IO_STAT
          • GV$OB_STORAGE_CACHE_TASKS
          • GV$OB_SYS_TIME_MODEL
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TABLET_LOCAL_CACHE
          • GV$OB_TABLET_REPLICA_INFO
          • GV$OB_TENANT_MEMORY
          • GV$OB_TENANT_RESOURCE_LIMIT
          • GV$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • GV$OB_TENANT_RUNTIME_INFO
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_TRANSACTION_SCHEDULERS
          • GV$OB_UNITS
          • GV$OB_VECTOR_MEMORY
          • GV$SESSION_EVENT
          • GV$SESSION_LONGOPS
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SESSTAT
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSSTAT
          • GV$SYSTEM_EVENT
          • GV$OB_KV_CLIENT_INFO
          • GV$OB_LOCKS
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_THREAD
          • GV$OB_PL_CACHE_OBJECT
          • V$OB_PL_CACHE_OBJECT
          • V$ACTIVE_SESSION_HISTORY
          • V$DML_STATS
          • V$ENCRYPTED_TABLESPACES
          • V$EVENT_NAME
          • V$LATCH
          • V$OB_ACTIVE_SESSION_HISTORY
          • V$OB_ARCHIVE_DEST_STATUS
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_COMPATIBILITY_CONTROL
          • V$OB_CGROUP_CONFIG
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DYNAMIC_PARTITION_TABLES
          • V$OB_ENCRYPTED_TABLES
          • V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • V$OB_FUNCTION_IO_STAT
          • V$OB_GROUP_IO_STAT
          • V$OB_HMS_CLIENT_POOL_STAT
          • V$OB_IO_BENCHMARK
          • V$OB_HNSW_INDEX_SEGMENT_INFO
          • V$OB_HNSW_INDEX_INFO
          • V$OB_IO_CALIBRATION_STATUS
          • V$OB_IVF_INDEX_INFO
          • V$OB_KVCACHE
          • V$OB_KV_CLIENT_INFO
          • V$OB_KV_GROUP_COMMIT_STATUS
          • V$OB_KV_CONNECTIONS
          • V$OB_LOG_STAT
          • V$OB_LOG_TRANSPORT_DEST_STAT
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_LS_SNAPSHOTS
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$OB_MEMSTORE_INFO
          • V$OB_MERGE_INFO
          • V$OB_NIC_INFO
          • V$OB_RPC_INCOMING
          • V$OB_RPC_OUTGOING
          • V$OB_PARAMETERS
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PLUGINS
          • V$OB_PROCESSLIST
          • V$OB_PS_ITEM_INFO
          • V$OB_PS_STAT
          • V$OB_PX_P2P_DATAHUB
          • V$OB_PX_TARGET_MONITOR
          • V$OB_PX_WORKER_STAT
          • V$OB_RES_MGR_SYSSTAT
          • V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SERVERS
          • V$OB_SERVER_STORAGE
          • V$OB_SESS_TIME_MODEL
          • V$OB_SESSION
          • V$SESSION_EVENT
          • V$OB_SESSION_PS_INFO
          • V$OB_SHARED_STORAGE_QUOTA
          • V$OB_SINDI_INDEX_INFO
          • V$OB_SQL_AUDIT
          • V$OB_SQL_CCL_STATUS
          • V$SQL_JOIN_FILTER
          • V$OB_SQL_PLAN
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SQLSTAT
          • V$OB_SHARED_SSTABLES
          • V$OB_SSTABLES
          • V$OB_LOCAL_CACHE
          • V$OB_LOCAL_CACHE_DIAGNOSE
          • V$OB_OBJECT_TYPE_IO_STAT
          • V$OB_STORAGE_CACHE_TASKS
          • V$OB_SYS_TIME_MODEL
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TABLET_LOCAL_CACHE
          • V$OB_TABLET_REPLICA_INFO
          • V$OB_TENANT_MEMORY
          • V$OB_TENANT_RESOURCE_LIMIT
          • V$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • V$OB_TENANT_RUNTIME_INFO
          • V$OB_TIMESTAMP_SERVICE
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_TRANSACTION_SCHEDULERS
          • V$OB_UNITS
          • V$RSRC_PLAN
          • V$SESSION_LONGOPS
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SQL_MONITOR_STATNAME
          • V$SQL_PLAN_MONITOR
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$STATNAME
          • V$SYSSTAT
          • V$SYSTEM_EVENT
          • V$OB_LOCKS
          • V$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_THREAD
          • V$OB_VECTOR_MEMORY
      • User tenant views
        • Dictionary views
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLLATIONS
          • information_schema.COLUMN_PRIVILEGES
          • information_schema.COLUMNS
          • information_schema.ENGINES
          • information_schema.events
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.QUERY_RESPONSE_TIME
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.role_table_grants
          • information_schema.role_column_grants
          • information_schema.role_routine_grants
          • information_schema.ROUTINES
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SCHEMATA
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.ST_GEOMETRY_COLUMNS
          • information_schema.ST_SPATIAL_REFERENCE_SYSTEMS
          • information_schema.STATISTICS
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.TABLES
          • information_schema.TRIGGERS
          • information_schema.USER_PRIVILEGES
          • information_schema.VIEW_TABLE_USAGE
          • information_schema.VIEWS
          • mysql.audit_log_filter
          • mysql.audit_log_user
          • mysql.columns_priv
          • mysql.db
          • mysql.default_roles
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.help_topic
          • mysql.proc
          • mysql.procs_priv
          • mysql.role_edges
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_DB_LINKS
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_INDEX_USAGE
          • oceanbase.DBA_JAVA_POLICY
          • oceanbase.DBA_MVIEW_DEPS
          • oceanbase.DBA_MVIEW_LOGS
          • oceanbase.DBA_MVIEW_RUNNING_JOBS
          • oceanbase.DBA_MVIEWS
          • oceanbase.DBA_MVREF_CHANGE_STATS
          • oceanbase.DBA_MVREF_RUN_STATS
          • oceanbase.DBA_MVREF_STATS
          • oceanbase.DBA_MVREF_STATS_PARAMS
          • oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS
          • oceanbase.DBA_MVREF_STMT_STATS
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.DBA_OB_AI_BATCH_TASKS
          • oceanbase.DBA_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.DBA_OB_AI_GATEWAYS
          • oceanbase.DBA_OB_AI_MODEL_ENDPOINTS
          • oceanbase.DBA_OB_AI_MODEL_PROFILES
          • oceanbase.DBA_OB_AI_MODEL_PROVIDERS
          • oceanbase.DBA_OB_AI_MODELS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • DBA_OB_AUX_STATISTICS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.DBA_OB_CCL_RULES
          • oceanbase.DBA_OB_CS_REPLICA_STATS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.DBA_OB_EXTERNAL_PART_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_EXTERNAL_RESOURCES
          • DBA_OB_FORMAT_OUTLINES
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_TASKS
          • oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_KV_TTL_TASKS
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.DBA_OB_LOB_CHECK_TASKS
          • oceanbase.DBA_OB_LS
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_OBJECT_BALANCE_WEIGHT
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_RECOVER_TABLE_JOBS
          • oceanbase.DBA_OB_SERVICES
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_OB_RSRC_DIRECTIVES
          • oceanbase.DBA_OB_SENSITIVE_COLUMNS
          • oceanbase.DBA_OB_SENSITIVE_RULE_PLAINACCESS_USERS
          • oceanbase.DBA_OB_SENSITIVE_RULES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.DBA_OB_STORAGE_SPACE_USAGE
          • oceanbase.DBA_OB_STORAGE_IO_USAGE
          • oceanbase.DBA_OB_SYS_VARIABLES
          • oceanbase.DBA_OB_SPM_EVO_RESULT
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_TABLES
          • oceanbase.DBA_OB_TABLEGROUPS
          • oceanbase.DBA_OB_TABLET_REPLICAS
          • oceanbase.DBA_OB_TABLE_SPACE_USAGE
          • oceanbase.DBA_OB_TABLET_TO_LS
          • oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_TEMP_FILES
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.DBA_OB_USERS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASKS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_RECYCLEBIN
          • oceanbase.DBA_RLS_POLICIES
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.DBA_TABLES
          • oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.DBA_OB_TTL_TASKS
          • oceanbase.DBA_OB_TTL_TASK_HISTORY
          • oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.DBA_WR_CONTROL
          • oceanbase.DBA_WR_EVENT_NAME
          • oceanbase.DBA_WR_RES_MGR_SYSSTAT
          • oceanbase.DBA_WR_SNAPSHOT
          • oceanbase.DBA_WR_SQL_PLAN
          • oceanbase.DBA_WR_SQLSTAT
          • oceanbase.DBA_WR_SQLTEXT
          • oceanbase.DBA_WR_STATNAME
          • oceanbase.DBA_WR_SYS_TIME_MODEL
          • oceanbase.DBA_WR_SYSSTAT
          • oceanbase.DBA_WR_SYSTEM_EVENT
          • oceanbase.USER_JAVA_POLICY
        • Performance views
          • GV$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • GV$LATCH
          • GV$OB_ACTIVE_SESSION_HISTORY
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_CGROUP_CONFIG
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • GV$OB_FLT_TRACE_CONFIG
          • GV$OB_FUNCTION_IO_STAT
          • GV$OB_GROUP_IO_STAT
          • GV$OB_HNSW_INDEX_INFO
          • GV$OB_HMS_CLIENT_POOL_STAT
          • GV$OB_IVF_INDEX_INFO
          • GV$OB_HNSW_INDEX_SEGMENT_INFO
          • GV$OB_KVCACHE
          • GV$OB_KV_CLIENT_INFO
          • GV$OB_KV_GROUP_COMMIT_STATUS
          • GV$OB_KV_CONNECTIONS
          • GV$OB_LOG_STAT
          • GV$OB_LOG_TRANSPORT_DEST_STAT
          • GV$OB_LS_SNAPSHOTS
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_MEMSTORE_INFO
          • GV$OB_MERGE_INFO
          • GV$OB_NIC_INFO
          • GV$OB_RPC_INCOMING
          • GV$OB_RPC_OUTGOING
          • GV$OB_PARAMETERS
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PROCESSLIST
          • GV$OB_PS_ITEM_INFO
          • GV$OB_PS_STAT
          • GV$OB_PX_P2P_DATAHUB
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_PX_WORKER_STAT
          • GV$OB_RES_MGR_SYSSTAT
          • GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_SESS_TIME_MODEL
          • GV$OB_SESSION
          • GV$OB_SESSION_PS_INFO
          • GV$OB_SHARED_STORAGE_QUOTA
          • GV$OB_SINDI_INDEX_INFO
          • GV$OB_SQL_AUDIT
          • GV$OB_SQL_CCL_STATUS
          • GV$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SQLSTAT
          • GV$OB_SSTABLES
          • GV$OB_LOCAL_CACHE
          • GV$OB_LOCAL_CACHE_DIAGNOSE
          • GV$OB_OBJECT_TYPE_IO_STAT
          • GV$OB_STORAGE_CACHE_TASKS
          • GV$OB_SYS_TIME_MODEL
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TABLET_LOCAL_CACHE
          • GV$OB_TABLET_MACRO_CACHE_STAT
          • GV$OB_TENANT_MEMORY
          • GV$OB_TENANT_RESOURCE_LIMIT
          • GV$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_TRANSACTION_SCHEDULERS
          • GV$OB_UNITS
          • GV$OB_VECTOR_MEMORY
          • GV$SESSION_EVENT
          • GV$SESSION_LONGOPS
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SESSTAT
          • GV$SQL_PLAN_MONITOR
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSSTAT
          • GV$SYSTEM_EVENT
          • GV$OB_LOCKS
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_THREAD
          • GV$OB_PL_CACHE_OBJECT
          • V$OB_PL_CACHE_OBJECT
          • V$ACTIVE_SESSION_HISTORY
          • V$DML_STATS
          • V$EVENT_NAME
          • V$LATCH
          • V$OB_ACTIVE_SESSION_HISTORY
          • V$OB_ARCHIVE_DEST_STATUS
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_COMPATIBILITY_CONTROL
          • V$OB_CGROUP_CONFIG
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DYNAMIC_PARTITION_TABLES
          • V$OB_ENCRYPTED_TABLES
          • V$ENCRYPTED_TABLESPACES
          • V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • V$OB_FUNCTION_IO_STAT
          • V$OB_GROUP_IO_STAT
          • V$OB_HMS_CLIENT_POOL_STAT
          • V$OB_HNSW_INDEX_INFO
          • V$OB_HNSW_INDEX_SEGMENT_INFO
          • V$OB_IVF_INDEX_INFO
          • V$OB_KVCACHE
          • V$OB_KV_CLIENT_INFO
          • V$OB_KV_GROUP_COMMIT_STATUS
          • V$OB_KV_CONNECTIONS
          • V$OB_LOG_STAT
          • V$OB_LOG_TRANSPORT_DEST_STAT
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_LS_SNAPSHOTS
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$OB_MEMSTORE_INFO
          • V$OB_MERGE_INFO
          • V$OB_NIC_INFO
          • V$OB_RPC_INCOMING
          • V$OB_RPC_OUTGOING
          • V$OB_PARAMETERS
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PROCESSLIST
          • V$OB_PS_ITEM_INFO
          • V$OB_PS_STAT
          • V$OB_PX_P2P_DATAHUB
          • V$OB_PX_TARGET_MONITOR
          • V$OB_PX_WORKER_STAT
          • V$OB_RES_MGR_SYSSTAT
          • V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • V$RSRC_PLAN
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SESS_TIME_MODEL
          • V$OB_SESSION
          • V$SESSION_EVENT
          • V$OB_SESSION_PS_INFO
          • V$OB_SHARED_STORAGE_QUOTA
          • V$OB_SINDI_INDEX_INFO
          • V$OB_SQL_AUDIT
          • V$OB_SQL_CCL_STATUS
          • V$SQL_JOIN_FILTER
          • V$OB_SQL_PLAN
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SQLSTAT
          • V$OB_SHARED_SSTABLES
          • V$OB_SSTABLES
          • V$OB_LOCAL_CACHE
          • V$OB_LOCAL_CACHE_DIAGNOSE
          • V$OB_OBJECT_TYPE_IO_STAT
          • V$OB_STORAGE_CACHE_TASKS
          • V$OB_SYS_TIME_MODEL
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TABLET_LOCAL_CACHE
          • V$OB_TABLET_MACRO_CACHE_STAT
          • V$OB_TENANT_MEMORY
          • V$OB_TENANT_RESOURCE_LIMIT
          • V$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • V$OB_TIMESTAMP_SERVICE
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_TRANSACTION_SCHEDULERS
          • V$OB_UNITS
          • V$OB_VECTOR_MEMORY
          • V$RESTORE_POINT
          • V$SESSION_LONGOPS
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SQL_MONITOR_STATNAME
          • V$SQL_PLAN_MONITOR
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$STATNAME
          • V$SYSSTAT
          • V$SYSTEM_EVENT
          • V$OB_LOCKS
          • V$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_THREAD
      • Overview of Metrics
      • Common wait events
    • Parameters and system variables
      • Overview of parameters and system variables
      • Parameters
        • Parameter overview
        • Cluster-level parameters
          • alert_log_level
          • all_cluster_list
          • all_server_list
          • autoinc_cache_refresh_interval
          • async_ps_cursor_max_count
          • balancer_log_interval
          • balancer_task_timeout
          • system_protected_sys_variables
          • system-protected-tenant-parameters
          • balancer_tolerance_percentage
          • bf_cache_miss_count_threshold
          • bf_cache_priority
          • builtin_db_data_verify_cycle
          • cache_wash_threshold
          • clog_io_isolation_mode
          • clog_sync_time_warn_threshold
          • cluster
          • cluster_id
          • config_additional_dir
          • cpu_count
          • 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_func
          • default_row_format
          • devname
          • diag_syslog_per_error_limit
          • disk_io_thread_count
          • dtl_buffer_size
          • enable_asan_for_memory_context
          • enable_async_syslog
          • enable_cgroup
          • enable_dblink
          • enable_ddl
          • enable_global_background_resource_isolation
          • enable_logservice
          • enable_major_freeze
          • enable_ob_error_msg_style
          • enable_ob_ratelimit
          • enable_perf_event
          • enable_record_trace_id
          • enable_record_trace_log
          • enable_rereplication
          • enable_rich_error_msg
          • enable_rpc_authentication_bypass
          • 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
          • ext_plugin_config
          • fuse_row_cache_priority
          • global_background_cpu_quota
          • high_priority_net_thread_count
          • ignore_replay_checksum_error
          • index_block_cache_priority
          • internal_sql_execute_timeout
          • io_scheduler_thread_count
          • 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_refresh_min_interval
          • location_cache_refresh_rpc_timeout
          • location_cache_refresh_sql_timeout
          • location_fetch_concurrency
          • location_refresh_thread_count
          • log_disk_percentage
          • log_disk_size
          • logservice_access_point
          • log_storage_warning_trigger_percentage
          • log_storage_warning_tolerance_time
          • ls_meta_table_check_interval
          • max_string_print_length
          • max_syslog_file_count
          • memory_chunk_cache_size
          • memory_limit
          • memory_limit_percentage
          • memory_reserved
          • memstore_limit_percentage
          • micro_block_merge_verify_level
          • migration_disable_time
          • min_observer_version
          • mysql_port
          • net_thread_count
          • ob_event_history_recycle_interval
          • ob_ratelimit_stat_period
          • ob_startup_mode
          • ob_python_home
          • obconfig_url
          • observer_id
          • ob_storage_s3_url_encode_type
          • ob_enable_java_env
          • ob_java_home
          • ob_java_connector_path
          • ob_java_opts
          • ob_enable_java_udf_sandbox
          • ob_enable_utl_http
          • opt_tab_stat_cache_priority
          • plan_cache_evict_interval
          • px_task_size
          • plugins_load
          • recyclebin_object_expire_time
          • resource_hard_limit
          • rest_oauth2_credential_refresh_interval
          • rest_oauth2_credential_evict_time
          • rootservice_async_task_queue_size
          • rootservice_async_task_thread_count
          • rootservice_list
          • rootservice_ready_check_interval
          • row_compaction_update_limit
          • 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_permanent_offline_time
          • 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
          • sync_io_thread_count
          • sys_bkgd_migration_change_member_list_timeout
          • sys_bkgd_migration_retry_num
          • sys_bkgd_net_percentage
          • sys_ckpt_thread_score
          • syslog_compress_func
          • syslog_disk_size
          • syslog_file_uncompressed_count
          • syslog_io_bandwidth_limit
          • syslog_level
          • system_memory
          • tablet_ls_cache_priority
          • tablet_meta_table_check_interval
          • tablet_meta_table_scan_batch_count
          • tablet_size
          • tcp_keepcnt
          • tcp_keepidle
          • tcp_keepintvl
          • tenant_task_queue_size
          • trace_log_slow_query_watermark
          • trx_2pc_retry_interval
          • unit_gc_wait_time
          • use_large_pages
          • user_block_cache_priority
          • user_row_cache_priority
          • virtual_table_location_cache_expire_time
          • weak_read_version_refresh_interval
          • workers_per_cpu_quota
          • zone
        • Tenant-level parameters
          • agent_db_background_delete_thread_score
          • agent_db_hot_namespace_ttl
          • arbitration_timeout
          • archive_lag_target
          • approx_count_distinct_precision
          • audit_log_buffer_size
          • audit_log_compression
          • attach_shared_sstable_thread_score
          • audit_log_enable
          • audit_log_format
          • audit_log_max_size
          • audit_log_path
          • audit_log_prune_seconds
          • audit_log_query_sql
          • audit_log_rotate_on_size
          • audit_log_strategy
          • audit_sys_operations
          • audit_trail
          • auto_split_tablet_size
          • backup_data_file_size
          • balancer_idle_time
          • catalog_sync_target
          • choose_migration_source_policy
          • 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
          • ddl_thread_score
          • default_auto_increment_mode
          • default_delta_format
          • default_enable_extended_rowid
          • default_load_mode
          • default_micro_block_format_version
          • default_progressive_merge_num
          • default_skip_index_level
          • default_storage_cache_policy
          • default_table_merge_engine
          • default_table_organization
          • default_table_store_format
          • direct_load_allow_fallback
          • ddl_high_thread_score
          • document_ai_file_max_size
          • dtl_compress_func
          • dump_data_dictionary_to_log_interval
          • enable_agent_db_background_task
          • enable_adaptive_plan_cache
          • enable_auto_split
          • enable_database_sharding_none
          • enable_early_lock_release
          • enable_hbase_rowkey_ttl
          • enable_pl_rich_error_msg
          • enable_gts_standalone
          • enable_kv_group_commit
          • enable_kv_ttl
          • enable_lake_table_parallel_resolving
          • enable_lock_priority
          • enable_manual_storage_cache_policy
          • enable_mlog_auto_maintenance
          • enable_monotonic_weak_read
          • enable_mv_binlog_minimal_mode
          • enable_ls_leader_balance
          • enable_rebalance
          • enable_sql_extension
          • enable_transfer
          • enable_ttl
          • enable_user_defined_rewrite_rules
          • enable_window_compaction
          • enable_ps_parameterize
          • external_kms_info
          • external_table_io_hole_size
          • external_table_io_range_size
          • external_table_csv_max_buffer_size
          • ob_vector_search_strategy
          • freeze_trigger_percentage
          • global_index_auto_split_policy
          • ha_high_thread_score
          • ha_low_thread_score
          • ha_mid_thread_score
          • inc_sstable_upload_thread_score
          • shared_gc_executor_thread_score
          • shared_gc_generator_thread_score
          • json_document_max_depth
          • kv_ttl_duty_duration
          • kv_group_commit_batch_size
          • kv_group_commit_rw_mode
          • kv_hbase_client_scanner_timeout_period
          • kv_ttl_delete_max_ops
          • kv_ttl_history_recycle_interval
          • kv_transport_compress_threshold
          • lake_table_pruning_thread_count
          • load_data_diagnosis_log_compression
          • load_data_diagnosis_log_max_size
          • load_vector_index_on_follower
          • 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
          • ls_scale_out_factor
          • major_compact_trigger
          • major_freeze_duty_time
          • max_partition_num
          • max_stale_time_for_weak_consistency
          • mds_compaction_high_thread_score
          • mds_compaction_mid_thread_score
          • mds_minor_compact_trigger
          • merger_check_interval
          • minor_compact_trigger
          • mlog_trim_interval
          • model_max_retries
          • model_request_timeout
          • mv_refresh_concurrency
          • ob_compaction_schedule_interval
          • ob_enable_batched_multi_statement
          • ob_encoding_granularity
          • ob_enable_java_udf
          • ob_enable_python_udf
          • ob_proxy_readonly_transaction_routing_policy
          • ob_query_switch_leader_retry_timeout
          • ob_ssl_invited_common_names
          • ob_vector_index_active_segment_max_size
          • ob_vector_index_merge_trigger_percentage
          • ob_vector_memory_limit_percentage
          • open_cursors
          • optimizer_index_cost_adj
          • partition_balance_schedule_interval
          • plsql_code_type
          • plsql_debug
          • px_node_policy
          • package_state_sync_max_size
          • px_target_high_watermark
          • px_target_low_watermark
          • px_target_workers_per_cpu
          • px_workers_per_cpu_quota
          • query_memory_limit_percentage
          • query_response_time_flush
          • query_response_time_range_base
          • query_response_time_stats
          • range_optimizer_max_mem_size
          • recover_table_concurrency
          • recover_table_dop
          • replica_parallel_migration_mode
          • result_cache_max_size
          • result_cache_max_result
          • ob_result_cache_evict_percentage
          • ob_deterministic_udf_cache_max_size
          • rpc_memory_limit_percentage
          • shared_log_retention
          • shared_storage_data_check_thread_score
          • spill_compression_codec
          • sql_func_extension_mode
          • sql_work_area
          • standby_db_fetch_log_rpc_timeout
          • standby_db_preferred_upstream_log_region
          • storage_rowsets_size
          • sts_credential
          • suspend_storage_cache_task
          • kv_transport_compress_func
          • tde_method
          • tenant_sql_login_thread_count
          • tenant_sql_net_thread_count
          • temporary_file_max_disk_size
          • ttl_duty_time
          • ttl_thread_score
          • undo_retention
          • vector_index_memory_saving_mode
          • vector_index_optimization_concurrency
          • vector_index_optimize_duty_time
          • vector_task_thread_limit_percent
          • workarea_size_policy
          • writing_throttling_maximum_duration
          • writing_throttling_trigger_percentage
          • zone_deploy_mode
      • System variables
        • Overview of system variables
        • Global variables
          • ap_query_cost_threshold
          • ap_query_route_policy
          • ap_query_replica_fallback
          • 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
          • default_authentication_plugin
          • default_password_lifetime
          • default_storage_engine
          • div_precision_increment
          • error_on_overlap_time
          • event_scheduler
          • explicit_defaults_for_timestamp
          • enable_optimizer_rowgoal
          • foreign_key_checks
          • group_concat_max_len
          • init_connect
          • innodb_stats_persistent
          • innodb_strict_mode
          • interactive_timeout
          • license
          • lc_time_names
          • log_row_value_options
          • long_query_time
          • lower_case_table_names
          • max_allowed_packet
          • max_connections
          • max_sp_recursion_depth
          • max_user_connections
          • mview_refresh_dop
          • net_buffer_length
          • net_read_timeout
          • net_write_timeout
          • ob_bnl_join_cache_size
          • ob_compatibility_mode
          • ob_compatibility_control
          • ob_compatibility_version
          • ob_default_lob_inrow_threshold
          • ob_early_lock_release
          • ob_enable_ps_parameter_anonymous_block
          • ob_enable_pl_async_commit
          • ob_enable_aggregation_pushdown
          • 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_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_query_timeout
          • ob_read_consistency
          • ob_reserved_meta_memory_percentage
          • ob_route_policy
          • ob_sql_audit_percentage
          • ob_sql_work_area_percentage
          • ob_table_access_policy
          • ob_tcp_invited_nodes
          • ob_temp_tablespace_size_percentage
          • 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_min_scan_time_threshold
          • parallel_servers_target
          • partition_index_dive_limit
          • performance_schema
          • plugin_dir
          • pid_file
          • query_cache_size
          • plsql_optimize_level
          • plsql_can_transform_sql_to_assign
          • port
          • query_cache_type
          • query_rewrite_enabled
          • query_rewrite_integrity
          • read_only
          • recyclebin
          • regexp_stack_limit
          • regexp_time_limit
          • resource_manager_plan
          • socket
          • range_index_dive_limit
          • 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_transpiler
          • 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 variables
          • enable_sql_plan_monitor
          • is_result_accurate
          • identity
          • last_insert_id
          • ob_capability_flag
          • ob_enable_show_trace
          • ob_global_debug_sync
          • ob_hnsw_ef_search
          • ob_ivf_nprobes
          • ob_last_schema_version
          • ob_org_cluster_id
          • ob_proxy_global_variables_version
          • ob_sparse_drop_ratio_search
          • ob_proxy_partition_hit
          • ob_proxy_set_trx_executed
          • ob_trace_info
          • partition_index_dive_limit
          • range_index_dive_limit
          • timestamp
          • tracefile_identifier
    • Error codes
      • Overview of error messages
      • 0001 ~ 3999
      • 4000 ~ 4499
      • 4500 ~ 4999
      • 5000 ~ 5999
      • 6000 ~ 6999
      • 7000 ~ 7999
      • 8000 ~ 8999
      • 9000 ~ 9499
      • 9500 ~ 9999
      • 10000 ~ 12000
      • 22998, 30926, 38104, 38105
    • LogService reference
      • LogService commands
        • Overview of LS-CTRL
        • LS-CTRL commands
          • bootstrap
          • show az
          • show ln
          • show meta
          • show ap
          • show parameter
          • show v-table
          • add ln
          • delete ln
          • set param
          • check
          • upgrade
          • fetch
          • migrate replica
          • rotate-ak
          • param-version-status
      • LogService parameters
        • Overview of Log Service parameters
        • Cluster parameters
          • min_oblogservice_version
          • node_permanent_offline_time_sec
          • stream_replica_task_history_retention_sec
          • object_store_url
          • log_local_target_retention_sec
          • retained_remote_log_blocks
          • log_local_disk_utilization_threshold
          • max_syslog_file_count
          • enable_rebalance
          • load_balance_policy
          • rebalance_interval_sec
          • metric_sample_save_interval_sec
          • max_utilization_threshold
          • min_utilization_threshold
          • log_disk_throttling_percentage
          • log_disk_throttling_maximum_duration
          • rebuild_log_lag_threshold
        • Server parameters
          • cluster_id
          • region
          • az
          • local_ip
          • rpc_port
          • log_disk_size
          • io_worker_count
          • http_port
          • status_thread_pool_size
          • stack_size
          • net_thread_count
          • enable_heap_profile
          • log_disk_percentage
          • memory_limit
          • log_level
          • max_syslog_file_size
          • disk_max_iops
          • disk_max_bandwidth
          • upload_block_concurrency
          • log_cache_memory_percentage
          • log_cache_evict_scan_budget
          • log_cache_enable_write
          • log_cache_enable_read
          • log_cache_metrics_dump_interval_sec
          • ln_id
          • local_storage_dir
      • LogService views
        • Overview of LogService views
        • List of LogService views
        • Virtual views
          • node_load
          • az_load
          • stream_replica_io
        • Internal tables
          • t_stream_upload_mapping
          • t_resource_event
    • OBKV
      • OBKV overview
      • OBKV architecture
      • OBKV-Table
        • OBKV-Table overview
          • OBKV-Table overview
          • Core features of OBKV-Table
          • OBKV-Table deployment overview
        • Quick start with simple key-value storage (Java)
        • Use the OBKV-Table client
          • Java development guide for OBKV-Table
          • Prepare for development with OBKV-Table
          • Connect to a cluster by using the OBKV-Table Java client
          • OBKV-Table examples
            • Write data to OBKV-Table
            • Query data in OBKV-Table
            • Update data in OBKV-Table
            • Delete data from OBKV-Table
          • Set parameters for the OBKV-Table Java client
        • OBKV-Table management
          • OBKV-Table management overview
          • High availability of OBKV-Table
          • Security permissions of OBKV-Table
          • OBKV-Table monitoring metrics
        • OBKV-Table reference
          • Data model of OBKV-Table
          • OBKV-Table operations
          • Data types supported by OBKV-Table
          • Full-text indexes in OBKV-Table
          • Scope of use and examples of global indexes in OBKV-Table
          • Delete expired data from OBKV-Table
          • Group commit in OBKV-Table
          • Weak-consistency reads and near reads in OBKV-Table
          • OBKV-Table related views
        • OBKV-Table FAQ
      • OBKV-HBase
        • Overview of OBKV-HBase
        • Core features of OBKV-HBase
        • OBKV-HBase deployment
        • OBKV-HBase development
          • Overview of OBKV-HBase application development
          • Connect to a cluster by using the OBKV-HBase Java client
          • Migrate HBase business code to OBKV-HBase
          • Data operation examples
        • OBKV-HBase migration guide
        • OBKV-HBase management
          • Overview of OBKV-HBase management
          • High availability of OBKV-HBase
          • Security and permissions in OBKV-HBase
          • OBKV-HBase monitoring metrics
        • Query optimization in OBKV-HBase
        • Performance testing of OBKV-HBase
        • OBKV-HBase reference
          • OBKV-HBase data model
          • OBKV-HBase data model
          • HBase-compatible interfaces
          • HBase-compatible filters
          • Automatic partition splitting in OBKV-HBase
          • Delete expired data in OBKV-HBase
          • OBKV-HBase weak-consistency reads and near reads
          • OBKV-HBase views
        • OBKV-HBase integrations
          • Flink integration
            • Synchronize data to OBKV-HBase by using the Flink connector
            • Access OBKV-HBase by using native Flink
          • Access OBKV-HBase by using Hive
          • Access OBKV-HBase by using Spark
    • Performance tuning
      • Overview
      • Performance related tools
        • System tools
          • Top general purpose tool
          • 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
          • tenant dump info
          • trace log
        • OCP
      • System tuning
        • Operating system parameter tuning
        • Database parameter tuning
          • CPU parameters
          • I/O parameters
          • Memory-related parameters
          • Network transmission parameters
        • ODP parameter tuning
          • CPU-related parameters
          • Network transmission parameters
          • Node routing parameters
      • Performance diagnosis
        • Monitor and diagnose cluster performance
        • Diagnose tenant performance
        • Monitor OBProxy performance
        • Monitor host performance
        • WR management
          • Overview of WR
          • Manage WR
          • Monitor historical session performance
          • Clean up WR data
        • Diagnostic practice: Use TRACE_ID to diagnose materialized view refresh performance issues
        • ASH report
          • Introduction to ASH
          • Generate an ASH report
          • Analyze an ASH report
          • ASH best practices
      • Business model tuning
        • Load balancing
        • SQL diagnostics
        • Distributed transactions
      • SQL tuning
        • SQL request execution process
        • SQL execution plans
          • Introduction to SQL execution plans
          • Execution plan operators
            • TABLE SCAN
            • JOIN
            • GROUP BY
            • WINDOW FUNCTION
            • SUBPLAN FILTER
            • DISTINCT
            • SEQUENCE
            • MATERIAL
            • SORT
            • LIMIT
            • FOR UPDATE
            • SELECT INTO
            • SUBPLAN SCAN
            • UNION
            • INTERSECT
            • EXCEPT/MINUS
            • INSERT
            • DELETE
            • UPDATE
            • EXCHANGE
            • GI
          • Plan cache
          • Fast parameterization
          • Real-time execution plan display
          • SQL optimization practice with EXPLAIN
        • Distributed execution plans
          • Distributed execution and parallel query
          • Distributed plan generation
          • Distributed execution plan scheduling
          • Distributed execution plan management
          • Parallel execution enabling methods and their priority
          • Auto DOP
          • Execution of 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 the degree of parallelism for parallel execution
            • Set parallel execution parameters
          • Diagnose parallel execution issues
          • Tips for parallel execution tuning
          • Quick start of parallel execution
        • SQL tuning
          • Overview of SQL tuning
          • Basic SQL tuning process
          • SQL execution performance monitoring
            • GV$OB_SQL_AUDIT
            • SQL Trace
            • Plan cache views
            • SQL performance analysis example
              • Analyze wait events in queries by using SQL Audit
              • 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 of statistics collection methods
              • Introduction to histograms
              • Collect statistics manually
              • Automatic statistics collection
              • Online statistics collection
              • Dynamic sampling by the optimizer
            • Statistics management
              • Overview of statistics management
              • Delete statistics
              • Set statistics
              • Import and export statistics
              • Lock and unlock statistics
              • Manage statistics history
              • Manage statistics collection strategies (Prefs)
            • Partitioned table statistics collection and update strategy
            • Monitoring and diagnostics for statistics collection
            • Comprehensive example
          • Query rewrite
            • Overview
            • Rule-based query rewriting
            • Cost-based query rewriting
          • Query optimization
            • Access path
              • Overview
              • Rule-based path selection
              • Cost-based path selection
            • Join algorithm
              • Overview
              • Join algorithms
              • Runtime filter
              • Join order
          • Manage execution plans
            • Optimizer hint
            • Plan binding
            • Execution plan management
        • Related terms
        • FAQ on SQL tuning
    • Database proxy
      • Database connection and routing overview
      • OceanBase Database Proxy (ODP)
      • ODP
        • ODP management overview
        • Manage ODP clusters
          • Create an OBProxy cluster
          • Manage parameters of an OBProxy cluster
          • Delete an OBProxy cluster
          • Upgrade all OBProxies in an OBProxy cluster
          • Restart all OBProxies in an OBProxy cluster
          • Manage OceanBase AI Database clusters connected to OBProxy
          • Monitor the performance of an OBProxy cluster
        • Manage ODP
          • Add an OBProxy
          • Start OBProxy
          • Refresh OBProxy configuration
          • Stop OBProxy
          • Restart OBProxy
          • Delete an OBProxy
          • Upgrade OBProxy
        • OBProxy parameters
      • Physical connections
      • Logical connection
        • Query all sessions
        • Query the details of a session
        • Query the statistics 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
      • OceanBase Call Interface (OBCI)
      • OceanBase Connector/J
      • OceanBase Connector/C
      • OceanBase Connector/ODBC
    • Platforms
      • OceanBase Migration Assessment (OMA)
      • OceanBase Migration Service (OMS)
      • OceanBase Cloud Platform (OCP)
      • OceanBase Developer Center (ODC)
      • OceanBase Admin Toolkit (OAT)
    • Components & tools
      • ob_error
      • Data integration
        • obloader/obdumper
        • OceanBase Binlog Service
        • obcdc
          • Overview of obcdc
          • obcdc parameters
            • Sample configuration file
            • Common obcdc parameters
            • obcdc parameters
          • obcdc development instructions
          • obcdc_tailf
          • Throttling
          • obcdc allowlist and blocklist
          • obcdc supports incremental direct load
          • obcdc supports synchronizing from a standby database
          • Data dictionary support in obcdc
          • FAQ
    • OceanBase AI Database plugins
      • Overview of OceanBase AI Database plugins
      • Tokenizer plugin
      • MySQL external table plugin
  • Release Notes
    • Version number guidelines
    • OceanBase AI Database V4.6.3
    • OceanBase AI Database V4.6.2

Download PDF

Document Feedback
  1. Documentation Center
  2. OceanBase AI Database
  3. V4.6.3

Overview of system variables

Last Updated:2026-11-19 02:51:02

Global level
Security
AP-related
Version information
Debugging
Case sensitivity
Read/write and query
Scheduler-related
Replica-related
Source replication related
Recycle Bin
Cache-related
Functions
InnoDB storage engine related
Cluster-related
Directory path related
MyISAM storage engine related
Temporary files
Memory
NDB storage engine related
Full-text indexes
Runtime Filter
Upgrade related
Time zone and date related
Transactions and transaction logs
Audit-related
Data types
SQL/PL related
System logs
System servers
X Plugin related
Performance mode related
Lock-related
Foreign key related
Materialized view related
Optimizer-related
Auto-increment columns
Character sets and strings
Group Replication
Session Level
Version information
Debugging
Read/Write and Query
Replica-related
Cache-related
Cluster-related
NDB storage engine
SQL/PL
System logs
System servers
Time zone and date related
Transactions and transaction logs
Vector operations
Optimizer-related
Auto-increment columns
Group Replication Related

This topic describes the system variables of OceanBase AI Database. The system variables are categorized by their functions.

Global level

Security

Variable name
Feature description
validate_password_check_user_name Specifies whether the user password can be the same as the username.
validate_password_length The minimum length of a user password.
validate_password_mixed_case_count Specifies the minimum number of uppercase letters and the minimum number of lowercase letters that a user password must contain.
validate_password_number_count Specifies the minimum number of digits required in a user password.
validate_password_policy Used to set the password check policy.
validate_password_special_char_count Specifies the minimum number of special characters that a user password must contain.
ob_tcp_invited_nodes It is used to set the IP allowlist for a tenant. Supports percentages (%), underscores (_), and IPs (separated by commas for multiple IPs). Supports IP list matching, mask matching, and fuzzy matching.
default_password_lifetime The password expiration time.
block_encryption_mode Specifies the encryption algorithm to use in the aes_encrypt and aes_decrypt functions.
sql_safe_updates Specifies whether to enable the SQL security mode of MySQL. The default value is off.
super_read_only It is used to control the read and write permissions of the database. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

pid_file Retrieves the pathname of the file on which the server writes its process ID.
port This parameter specifies the port number on which the server listens for TCP/IP connections during OBServer deployment.
socket Used to query local client connections.SocketThe name of the file.

AP-related

Variable name
Feature description
ap_query_cost_threshold The cost threshold for adaptive selection of columnar storage replicas.
ap_query_route_policy Controls the adaptive selection strategy for AP queries to replicas.
ap_query_replica_fallback When the automatic query routing feature is enabled, this parameter controls whether queries will roll back to non-columnar replicas for execution when no available columnar replica is found.

Version information

Variable name
Feature description
version_comment This API is used to view the version information of an OBServer node.
version Used to view the server version number.
ob_last_schema_version Sets the version number of the schema most recently used in the current session.
ob_proxy_global_variables_version This API is used to set the latest version information of global variables that an OBServer node returns to OBProxy.
ob_enable_transmission_checksum This parameter specifies whether to perform packet checksum verification between the OBProxy and OBServer nodes. The setting takes effect immediately.
ob_compatibility_control It is used to control the behavior mode in case of compatibility conflicts with MySQL 5.7 and MySQL 8.0.
ob_compatibility_version The version of OceanBase AI Database that is compatible with the feature for controlling changes in product behavior.
ob_security_version Specifies the version of OceanBase AI Database that is compatible with security features. The compatibility version must be specified when creating a tenant and cannot be modified after the tenant is created.
old_alter_table It specifies whether to enable the legacy ALTER TABLE syntax and operations. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

Debugging

Variable name
Feature description
debug Used to set debugging options. The default value isd:t:i:o,/tmp/mysqld.trace.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

ob_global_debug_sync Used to set the synchronization point during debugging. Setting this variable affects all sessions.

Case sensitivity

Variable name
Feature description
lower_case_table_names Specifies whether the search is case-sensitive.

Read/write and query

Variable name
Feature description
query_cache_size This parameter specifies the memory allocated for storing historical query results, that is, the unused memory.
query_cache_type Used to query the cache type.
ob_query_timeout Sets the query timeout period.
is_result_accurate When a query containstopkWhen prompted,is_result_accurateIndicates whether the result is correct.
net_buffer_length Sets the maximum size of an SQL query that an OBServer node can accept.
read_only Specifies whether the tenant is in read-only mode.
ob_read_consistency Sets the read consistency level.
ob_max_read_stale_time Maximum latency threshold for weak read queries (in μs).
net_read_timeout The number of seconds to wait for other data on the connection before interrupting the read.
net_write_timeout Sets the number of seconds to wait for block writes to complete before interrupting the write.
ob_enable_index_direct_select Specifies whether users are allowed to directly query index tables.
ob_enable_aggregation_pushdown Specifies whether to allow pushdown of aggregate operations.
ob_enable_jit Sets the JIT execution engine mode.
sql_throttle_network Specifies the request queue time. If the request queue time is greater than or equal to this value, the query is not allowed to be executed.
parallel_servers_target Sets the queuing conditions for large queries on each server.
cte_max_recursion_depth Sets the maximum recursion depth for common table expressions (CTEs). The server terminates operations that exceed this CTE value.
regexp_stack_limit The maximum available memory for the internal stack used by regular expression matching operations.
regexp_time_limit The time limit for regular expression matching operations.
long_query_time The threshold for identifying slow queries.

Scheduler-related

Variable name
Feature description
event_scheduler Determines whether the event scheduler is enabled and running on the server.

Replica-related

Variable name
Feature description
master_info_repository Specifies whether metadata is stored as records in the mysql table of the system database InnoDB or as files in the data directory. The default value isFILE.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

replication_optimize_for_static_plugin_config Controls whether to enable shared locks to improve the performance of semi-synchronous replication. The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error being reported.

replication_sender_observe_commit_only Controls whether to enable rate-limiting callbacks to improve the performance of semi-synchronous replication. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without an error being returned.

rpl_semi_sync_slave_enabled Controls whether to enable semi-synchronous replication on the replica. Default value:OFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

rpl_semi_sync_slave_trace_level Specifies the debug tracking level for semi-synchronous replication on the primary replica. Default value:32, indicating the network wait level.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

rpl_stop_slave_timeout Specifies the amount of time to wait before stopping the slave when the STOP SLAVE command times out. The unit is seconds. Default value:31536000.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

slave_checkpoint_group Sets the maximum number of transactions that multi-threaded replication can handle before calling the checkpoint operation to update the progress status. The default value is512.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

slave_checkpoint_period Specifies the maximum amount of time allowed before calling checkpoint operations to update the status of multi-threaded replication, in milliseconds. The default value is300.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without an error being returned.

slave_compressed_protocol When both the source and replica support compression, controls whether to use compression according to the source or replica protocol. Default value:OFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

slave_exec_mode Specifies how to resolve conflicts and errors during replication by configuring the replication thread. Valid values:IDEMPOTENTErrors for duplicate keys and keys not found can be suppressed. Set toSTRICT, duplicate key errors and not found key errors will not be suppressed. The default value isSTRICT.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

slave_max_allowed_packet Sets the maximum packet size for replication SQL and I/O threads, in bytes. The default value is1073741824

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting takes effect without returning an error.

slave_net_timeout The time, in seconds, that a replica waits for more data or a heartbeat signal from the source before it considers the connection disconnected, stops reading, and attempts to reconnect. The default value is60

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting takes effect without returning an error.

slave_parallel_type Specifies the type of parallel execution to use for replicating transactions when multi-threaded replication is enabled. The default value isDATABASE

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being returned.

slave_parallel_workers Sets the number of threads for parallel execution of replicated transactions. Default value:0, which indicates to disable parallel execution of replication transactions.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

slave_pending_jobs_size_max For multi-threaded replication, specifies the maximum length of the work queue for storing unapplied events, in bytes. The default value is16777216

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

slave_preserve_commit_order For multi-threaded replication, controls whether transactions are committed in the order of transactions in the relay log. Default value:OFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting takes effect without an error being returned.

slave_rows_search_algorithms Specifies the algorithm used by the replica to search for related rows. Default value:TABLE_SCAN,INDEX_SCAN.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

slave_sql_verify_checksum Controls whether the replication SQL thread uses the checksums read from the relay logs to verify data. Default value:OFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting takes effect without an error being returned.

slave_transaction_retries When a replication SQL thread is blocked due to a deadlock or transaction execution exceeding the variableinnodb_lock_wait_timeoutThe number of times the system automatically retries a transaction when it fails due to the specified value. The default value is10.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

slave_type_conversions Controls the type conversion mode on replicas during row-based replication. The default value is empty, which prohibits type conversion between the source and replicas.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

sql_slave_skip_counter Sets the number of source events that a replica must skip. Default value:0.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

skip_slave_start Controls whether to skip starting the replication thread when the replica server starts. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

slave_load_tmpdir Specifies the directory name for creating temporary files by a replica. The default value is empty.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query it, but you cannot set it.

slave_skip_errors Specify the errors to skip during replication. Default value:OFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried but cannot be set.

sync_master_info The impact of this variable on the replica depends on the replica'smaster_info_repositorySpecifies whether to set the data type to FILE or TABLE. The default value is10000

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

init_slave This variable is similar to init_connect and is used to specify a string that the slave server executes each time a replication SQL thread starts. Its default value isnull

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error being reported.

log_slow_slave_statements Specifies whether to record slow SQL statements executed by replication threads in the slow query logs of the secondary server. If this parameter is not specified, the default value is used.OFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

report_host The hostname or IP address reported to the source during replica registration. Default value:null.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

report_password The password of the replication user account reported to the source during replica registration. The default value isnull

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

report_port The TCP/IP port number used to connect to the replica, reported to the source during replica registration. The default value isnull

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

report_user Username of the account that reports to the source during replica registration. Default value:null

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query this variable, but you cannot set it.

relay_log The name of the relay log. The default value isnull

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. It can be queried but cannot be set.

relay_log_basename The name and full path of the relay log. The default value is/usr/local/mysql/data/obrd-relay-bin.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

relay_log_index The name of the relay log index file. The default value is/usr/local/mysql/data/obrd-relay-bin.index

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried but cannot be set.

relay_log_info_file The name of the file that records relay log information. Default value:relay-log.info

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query it, but you cannot set it.

relay_log_recovery If this variable is enabled, automatic relay log recovery is enabled immediately after the slave server starts. Its default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

relay_log_space_limit The maximum capacity for all relay logs, in bytes. The default value is0.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

Source replication related

Variable name
Feature description
rpl_semi_sync_master_enabled Controls whether to enable semi-synchronous replication on the source. The default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

rpl_semi_sync_master_timeout Specifies the amount of time, in milliseconds, that the source waits for replica confirmation after a commit. The default value is10000.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

rpl_semi_sync_master_trace_level Specifies the debug tracking level for semi-synchronous replication on the source. Default value:32, indicating the network wait level.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

rpl_semi_sync_master_wait_for_slave_count Specifies the number of replica acknowledgments each transaction must receive before the source can proceed. The default value is1.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

rpl_semi_sync_master_wait_no_slave Controls whether to continue service even when the number of replicas drops below the variablerpl_semi_sync_master_wait_for_slave_countWhen configuring the quantity, whether the source will also wait for a timeout (variablerpl_semi_sync_master_timeout(The set time). Default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

rpl_semi_sync_master_wait_point Specifies the point in time that a semi-synchronous source waits for a replica to acknowledge transaction receipt before returning a status to the client committing the transaction. The default value isAFTER_SYNC

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

Recycle Bin

Variable name
Feature description
recyclebin Specifies whether to enable the recycle bin feature.
ob_enable_truncate_flashback Specifies whether to enable flashback for truncated tables.

Cache-related

Variable name
Feature description
ob_enable_plan_cache Specifies whether to enable plan cache.
ob_plan_cache_percentage Sets the percentage of memory available for plan caching from the tenant's total memory.
ob_plan_cache_evict_high_percentage Sets the percentage of the maximum memory that the plan cache eviction uses.
ob_plan_cache_evict_low_percentage Sets the percentage of the maximum memory that the cache for stop-mining plans can occupy.
ob_bnl_join_cache_size Specifies how much data is cached in a batch during batch nested loop join.
stored_program_cache Specifies the number of caches for stored procedures and functions. The default value is256.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being returned.

table_definition_cache Sets the amount of memory space used to cache table definitions. The default value is-1.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting takes effect without an error message.

table_open_cache_instances Specifies the number of instances for opening table cache. The default value is16.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

Functions

Variable name
Feature description
interactive_timeout Specifies the number of seconds the server waits for active interactions before closing interactive connections.
wait_timeout Specifies the number of seconds the server waits for active non-interactive connections before closing them.
group_concat_max_len Used to set the allowedGROUP_CONCAT()The maximum length of the function result.

InnoDB storage engine related

Variable name
Feature description
innodb_change_buffering_debug Used to set the debug level for changing the InnoDB buffer pool. The default value is0.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without returning an error.

innodb_compress_debug The debug level used to adjust and control the compression behavior. The default value is0.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

innodb_disable_resize_buffer_pool_debug Specifies whether to enable the size adjustment of the InnoDB buffer pool. The default value is1.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

innodb_fil_make_page_dirty_debug The number of dirty pages to be intentionally generated in InnoDB during debugging. Default value:0.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

innodb_limit_optimistic_insert_debug Specifies the number of records per B-tree page. The default value is0.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without an error being returned.

innodb_merge_threshold_set_all_debug Specifies the page full percentage for the index page. The default value is50.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting takes effect without an error being returned.

innodb_saved_page_number_debug Sets the number of page numbers saved during InnoDB debugging. The default value is0.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

innodb_trx_purge_view_update_only_debug This parameter specifies the debug level for controlling whether only the cleanup views are updated during transaction cleanup. The default value is0.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without an error being returned.

innodb_trx_rseg_n_slots_debug Specifies the number of slots in a transaction rollback segment. Each slot stores rollback information for transactions. The default value is0.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

innodb_stats_persistent Controls whether to persist InnoDB index statistics to disk.
innodb_force_recovery Crash recovery mode, used to repair data in the damaged InnoDB storage engine. The default value is0

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query it, but you cannot set it.

innodb_replication_delay When the variable reachesinnodb_thread_concurrencyWhen configuring the value, it indicates the delay time of the replication thread on the replica server, in milliseconds. The default value is0.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

innodb_large_prefix It specifies whether to allow index key prefixes longer than 767 bytes (up to 3,072 bytes) for InnoDB tables using the DYNAMIC or COMPRESSED row format. The default value isON.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

innodb_sort_buffer_size Specifies the buffer size for sorting operations. The default value is1048576.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

default_tmp_storage_engine Specifies the default storage engine for temporary tables. The default value isInnoDB.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

innodb_tmpdir Specifies the directory used by InnoDB to store temporary files.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error.

mecab_rc_file Specifies the configuration file path of MeCab.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query it, but you cannot set it.

innodb_temp_data_file_path Specifies the storage path for InnoDB temporary data files. The default value isibtmp1:12M:autoextend, indicating that InnoDB will use a temporary data file named ibtmp1 with an initial size of 12 MB. This file will automatically expand as needed to store additional temporary data.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query it, but you cannot set it.

innodb_data_file_path Specifies the storage path and file name of the InnoDB data file. The default value isibdata1:12M:autoextend, indicating that InnoDB will use a temporary data file named ibdata1 with an initial size of 12 MB. This file will automatically expand as needed to store additional temporary data.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query it, but you cannot set it.

innodb_data_home_dir Sets the root directory for InnoDB data files.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; queries are allowed, but settings cannot be made.

innodb_read_only Specifies whether to start InnoDB in read-only mode. The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query this variable, but you cannot set it.

innodb_rollback_on_timeout Specifies whether to abort and roll back the entire transaction when a transaction timeout occurs. The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

innodb_api_disable_rowlock Specifies whether to disable row locks when InnoDB Memcached performs DML operations. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

innodb_autoinc_lock_mode The locking mode used to generate auto-increment values. Default value:1.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

low_priority_updates It is used to specify whether to control the priorities of INSERT, UPDATE, DELETE, and REPLACE statements. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

max_error_count Specifies the maximum number of errors, warnings, and notifications that the server can store in the diagnostic context. The default value is64.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

max_insert_delayed_threads Specifies the maximum number of threads for executing INSERT DELAYED statements. The default value is20.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

innodb_monitor_disable This variable acts as a switch to control which metric counters are disabled.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

innodb_monitor_enable This variable acts as a switch to control which metric counters are enabled.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

innodb_monitor_reset This variable acts as a switch to control which metric counters have their counts reset to 0.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

innodb_monitor_reset_all This variable acts as a switch to control whether to reset all values (such as the maximum and minimum values) of which metric counters to 0.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

innodb_old_blocks_pct Specifies the approximate percentage of the old data block sub-list in the InnoDB buffer pool. The default value is37

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

innodb_old_blocks_time Specifies the duration in milliseconds that a block must be retained in the old sub-list after its first access before it can be moved to the new sub-list. The default value is1000.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

innodb_purge_batch_size Specifies the number of undo log pages to be parsed and processed from the history list at once. The default value is300.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without an error being returned.

innodb_purge_rseg_truncate_frequency Controls the frequency at which rollback segments are cleared, that is, how many times the system calls are required before a rollback segment is released. The default value is128.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error being reported.

innodb_random_read_ahead Enables random pre-read technology to optimize InnoDB I/O. Default value:OFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

innodb_read_ahead_threshold Controls the linear prefetch behavior of the InnoDB storage engine. The default value is56, indicating that InnoDB must sequentially read at least 56 pages from a segment to initiate asynchronous reading of the next segment.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

innodb_rollback_segments Specifies the number of rollback segments for the transaction used to generate undo records. The default value is128.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error being reported.

innodb_spin_wait_delay The time interval between each spinlock wait. The default value is6.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting takes effect without returning an error.

innodb_status_output Enables or disables scheduled output for the standard InnoDB monitor. The default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

innodb_status_output_locks Enables or disables InnoDB lock monitoring. The default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

innodb_sync_spin_loops The number of times a thread waits before it is suspended if an InnoDB mutual exclusion lock has not been released. The default value is30.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error message.

internal_tmp_disk_storage_engine Specifies the storage engine for internal temporary tables on disk. The default value isINNODB

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

innodb_fast_shutdown The shutdown mode of the InnoDB engine. The default value is1

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

innodb_io_capacity The approximate number of IOPS that InnoDB can perform per second for background tasks. The default value is200.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting takes effect without returning an error.

innodb_io_capacity_max The maximum number of IOPS that a background task can perform per second in an emergency. The default value is2000.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error message.

innodb_thread_concurrency The maximum number of threads allowed internally in InnoDB. The default value is0, indicating no limit.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

innodb_thread_sleep_delay The time, in microseconds, that an InnoDB thread sleeps before being added to the InnoDB wait queue. The default value is10000

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

innodb_adaptive_hash_index_parts Specifies the number of partitions for adaptive hash index searches. The default value is8

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

innodb_numa_interleave Specifies whether to enable the NUMA interleaved memory strategy for buffer pool memory allocation. The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. It can be queried but cannot be set.

innodb_open_files Specifies the maximum number of files that can be opened at a time. The default value is2000

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

innodb_page_cleaners The number of threads that refresh dirty pages in the buffer pool. The default value is1

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

innodb_purge_threads The number of background threads used for cleanup operations. Default value:4

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. It can be queried but cannot be set.

innodb_read_io_threads The number of I/O threads during read operations. The default value is4

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

innodb_sync_array_size Specifies the size of the mutex lock wait array. The default value is1

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

innodb_use_native_aio Whether to use the Linux asynchronous I/O subsystem. Default value:1

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

innodb_write_io_threads The number of I/O threads for write operations. The default value is4.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query this variable, but you cannot set it.

innodb_api_enable_binlog Specifies whether to allow the InnoDB Memcached plugin to be used together with MySQL binlogs. The default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

innodb_locks_unsafe_for_binlog This variable affects how InnoDB uses gap locking for searches and index scans. Its default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. It can be queried, but cannot be set.

innodb_log_buffer_size Specifies the size of the InnoDB transaction log cache, in bytes. The default value is16777216.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

innodb_log_files_in_group The number of log files in the log group. Default value:2.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

innodb_log_file_size The size of each log file in the log group, in bytes. Default value:50331648

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

innodb_log_group_home_dir Specifies the directory path for InnoDB redo logs. The default value is./.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query this variable, but you cannot set it.

innodb_undo_directory Specifies the directory for the undo tablespaces created by InnoDB. The default value is./.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

innodb_undo_tablespaces Specifies the number of undo tablespaces available for InnoDB. The default value is0.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

Cluster-related

Variable name
Feature description
ob_capability_flag It is a capability provided by an OBServer node for capability negotiation when connecting to a proxy, informing the proxy which features the current OBServer node supports and which it does not.
ob_compatibility_mode Specifies the compatibility mode for a tenant.
ob_route_policy It is used to set the routing strategy for selecting data replicas within an OBServer node.
performance_schema Used to indicate to the client whether performance information queries are supported. The default value isOFF.

Note

This variable is for compatibility with MySQL 8.0 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

resource_manager_plan Used to activate a resource management plan. Different plans use different CPU quotas to limit user activity within a resource group.
license Used to view the type of the license.
ob_proxy_partition_hit It specifies whether OBProxy sends the data requested by the SQL statement to the OBServer node where the data resides in the primary partition.
ob_org_cluster_id Used to set the for the OceanBase AI Database cluster.CLUSTER_ID.
server_uuid View the UUID of an OBServer node.
default_storage_engine This API is used to view the default storage engine of an OBServer node.
slave_allow_batching Controls whether to enable batch updates for replication threads. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

Directory path related

Variable name
Feature description
datadir The local disk path for data storage.
plugin_dir Used to view the path where the plugin DLL is stored.
secure_file_priv Controls the accessible paths when importing or exporting to files.

MyISAM storage engine related

Variable name
Feature description
delay_key_write Specifies whether to delay writing index keys for MyISAM tables. The default value isON.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting takes effect without an error being returned.

key_buffer_size Sets the key buffer size for the MyISAM storage engine. The default value is8388608.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

key_cache_age_threshold The threshold for controlling the downgrade of buffers from the hot sub-list to the warm sub-list in the key cache. A lower value indicates a faster downgrade. The default value is300.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

key_cache_block_size Sets the size of a single block in the MyISAM key cache. The default value is1024.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without returning an error.

key_cache_division_limit Sets the maximum number of partitions for the MyISAM key cache. The default value is100.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

max_seeks_for_key Sets the maximum number of address operations allowed in a MyISAM query. The default value is18446744073709551615.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error being reported.

skip_external_locking Specifies whether to disable the external locking mechanism for MyISAM tables. The default value isON.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

Temporary files

Variable name
Feature description
max_tmp_tables Limits the maximum number of temporary tables a user session can hold simultaneously. The default value is32

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error.

Memory

Variable name
Feature description
ob_sql_work_area_percentage The percentage of tenant memory used for SQL execution.
ob_sql_audit_percentage Sets the percentage of the current tenant's memory that the SQL audit memory limit occupies.
ob_reserved_meta_memory_percentage It specifies the percentage of reserved memory for the tenant, which is primarily used to store metadata-related structural information.
ob_temp_tablespace_size_percentage Percentage limit for the size of temporary tablespaces on a tenant's disk.

NDB storage engine related

Variable name
Feature description
ndb_allow_copying_alter_table Whether to AllowALTER TABLEstatements and other DDL statements for table replication operations. The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

ndb_autoincrement_prefetch_sz Specifies the number of prefetches for auto-increment columns. This value affects the performance and concurrent access capability of auto-increment columns. Default value:1.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

ndb_blob_read_batch_bytes Configures the maximum size for batch reading of BLOB data in an NDB cluster, in bytes. The default value is65536.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

ndb_blob_write_batch_bytes Configures the size of BLOB data that can be written in a batch in an NDB cluster. The unit is bytes. The default value is65536.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without an error being returned.

ndb_cache_check_time Specifies the time interval in milliseconds for checking whether the cache needs to be refreshed on each NDB node. The default value is0.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

ndb_clear_apply_status Specifies whether to clear the application state. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without an error message.

ndb_data_node_neighbour Defines the neighbor relationship of a data node. Default value:0.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting takes effect without an error message.

ndb_default_column_format Defines the default column format for a table, specifying whether to store data in fixed-length or variable-length format. The default value isFIXED, indicating that the data is stored in a fixed-length format.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error message.

ndb_deferred_constraints Controls whether to delay constraint checking on a table. The default value is0.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without an error message.

ndb_distribution Specifies the default distribution method for an NDB table: whether to partition by hash key value or by linear hash. The default value isKEYHASH, indicating to use hash key value partitioning.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error message.

ndb_eventbuffer_free_percent Specifies the percentage of free space in the NDB cluster event cache. The default value is20.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

ndb_eventbuffer_max_alloc Specifies the maximum memory size that can be allocated for event caching, in bytes. The default value is0, which indicates no limit.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

ndb_extra_logging Used to record information of the specified NDB storage engine in the MySQL error log. The default value is1.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

ndb_force_send Whether to forcibly send the cache to NDB immediately without waiting for other threads. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error message.

ndb_fully_replicated Determines whether the new table is fully copied. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without returning an error.

ndb_index_stat_enable Specifies whether to use the NDB index statistics collection feature. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

ndb_index_stat_option Specifies the options for generating NDB index statistics. The default value isloop_checkon=1000ms,loop_idle=1000ms,loop_busy=100ms,update_batch=1,read_batch=4,idle_batch=32,check_batch=32,check_delay=1m,delete_batch=8,clean_delay=0,error_batch=4,error_delay=1m,evict_batch=8,evict_delay=1m,cache_limit=32M,cache_lowpct=90

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

ndb_join_pushdown Controls whether to enable the connection pushdown optimization feature in the storage engine. The default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

ndb_log_binlog_index Controls whether to insert the epoch-to-binlog-position mapping into the ndb_binlog_index table. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

ndb_log_empty_epochs Controls whether unchanged epoch transactions are written to the binlog. The default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

ndb_log_empty_update Controls whether unchanged UPDATE transactions are written to the binlog. The default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

ndb_log_exclusive_reads Determines whether to use an exclusive lock to record primary key reads. Default value:OFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

ndb_log_update_as_write Controls whether updates on the source are written to the binlog as updates (OFF) or writes (ON). The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being returned.

ndb_log_update_minimal Controls the logging behavior of the NDB cluster. Valid values:ONindicates that the NDB cluster records only the minimal information for update operations; the value isOFF, indicating that the NDB cluster records changes for the entire row. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without an error being returned.

ndb_log_updated_only Controls whether MySQL will write only the updated rows or the complete rows when writing updates to the binlog. The default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

ndb_optimization_delay Specifies the wait time, in microseconds, between each group of rows when executing the OPTIMIZE TABLE statement on an NDB table. The default value is10.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

ndb_read_backup Specifies whether to allow reading data from any segment replica of any NDB table created later. The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

ndb_recv_thread_activation_threshold Specifies the activation threshold for the receiving thread. The default value is8

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error message.

ndb_recv_thread_cpu_mask Specifies the CPU mask for the thread that receives requests. The default value is an empty string.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting takes effect without returning an error.

ndb_report_thresh_binlog_epoch_slip Specifies the maximum allowed skip size before reporting a binlog timestamp skip. The default value is10.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

ndb_report_thresh_binlog_mem_usage Specifies the percentage threshold of available binlog memory before a report is sent. That is, when the remaining available binlog memory falls below this value, the system will send a report. The default value is10.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

ndb_row_checksum Specifies the checksum value of a table row. The value is1When set to yes, the checksum value of each row is calculated and stored. The value is0When this parameter is set to N, table row data verification and detection are not performed. The default value is N.1.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

ndb_show_foreign_key_mock_tables Whether to display the mock table for foreign key dependencies. The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

ndb_slave_conflict_role Specifies the role of this node in a circular replication (primary-primary) setup. The default value isNONE, indicating that the variable is undefined or not configured.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

ndb_table_no_logging Controls the logging behavior of NDB tables. The value isONWhen this parameter is set to NDB, all tables created or altered using the NDB storage engine are in a logless state. The default value is NDB.OFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error being reported.

ndb_table_temporary Specifies the behavior of temporary tables when the NDB storage engine is used. Valid values:ONWhen this parameter is set to a value less than the maximum allowed, the NDB table will not be written to disk. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

ndb_use_exact_count Specifies whether to force NDB to use the SELECT count(*) record count to accelerate such queries during query plan generation. The default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting takes effect without an error message.

ndb_use_transactions Controls whether to enable NDB transaction support. The default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

ndbinfo_max_bytes For testing and debugging only. The default value is0

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being returned.

ndbinfo_max_rows For testing and debugging only. The default value is10

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without an error being returned.

ndbinfo_offline Whether to set thendbinfoSets the database to offline. Default value:OFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

ndbinfo_show_hidden Whether to display in the MySQL clientndbinfoThe underlying internal table of the database. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

myisam_data_pointer_size Specify when unspecifiedMAX_ROWSThe default pointer size for the created MyISAM table when this option is specified, in bytes. The default value is6.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

myisam_max_sort_file_size Specifies the maximum size of temporary files allowed when recreating a MyISAM index (during REPAIR TABLE, ALTER TABLE, or LOAD DATA), in bytes. The default value is9223372036853720064.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

myisam_repair_threads Specifies the number of concurrent threads used to repair a MyISAM table. The default value is1

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

myisam_sort_buffer_size Specifies the cache size allocated for sorting MyISAM indexes during a REPAIR TABLE operation or for creating indexes using CREATE INDEX (or ALTER TABLE), in bytes. The default value is8388608.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

myisam_stats_method Specifies how the server calculates NULL values when collecting statistics on index value distributions for MyISAM tables. The default value isnulls_unequal, which means that NULL values are treated as regular values and handled in the same way as other values.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

myisam_use_mmap Whether to use memory mapping for reading from and writing to MyISAM tables. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

server_id_bits The lowest significant bit in a 32-bit server_id that actually identifies the server. The default value is32

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

Full-text indexes

Variable name
Feature description
innodb_ft_enable_diag_print This parameter specifies whether to enable or disable the debug output for InnoDB full-text indexes. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

innodb_ft_num_word_optimize Specifies the minimum number of partitions that must be operated on during an OPTIMIZE TABLE operation. The default value is2000

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error being reported.

innodb_ft_result_cache_limit Specifies the size of the result cache for InnoDB full-text indexes. The default value is2000000000, in bytes.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error.

innodb_ft_server_stopword_table It specifies the server stopword list for InnoDB full-text indexes. The default value isNULL

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

innodb_optimize_fulltext_only Controls the behavior of the OPTIMIZE TABLE statement on InnoDB tables containing FULLTEXT indexes. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

innodb_ft_cache_size Sets the cache size for InnoDB full-text indexes. The default value is8000000, in bytes.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

innodb_ft_sort_pll_degree The number of parallel threads used for full-text index sorting. The default value is2.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

innodb_ft_total_cache_size Sets the total cache size for InnoDB full-text indexes. The default value is640000000, in bytes.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

ft_stopword_file The path of the file used to specify stopwords. Default value:built-in.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. It can be queried but cannot be set.

Runtime Filter

Variable name
Feature description
runtime_filter_type Sets the runtime filter type at the tenant level.
runtime_filter_wait_time_ms Sets the maximum wait time for the runtime filter.
runtime_filter_max_in_num It is used to set the number of NDVs (the number of distinct values in a column) for Runtime In Filter.
runtime_bloom_filter_max_size Sets the maximum memory size for the runtime Bloom filter, in bytes.

Upgrade related

Variable name
Feature description
avoid_temporal_upgrade Used to manage the upgrade behavior for time-sensitive data (such as dates and times). The default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error message.

Time zone and date related

Variable name
Feature description
time_zone Sets the time zone for the current tenant session. Valid values:'+08:00'The offset format of the andAsia/ShanghaiThe region format value.
timestamp TIMESTAMPis a timestamp in seconds. This variable affectsselect now(6).
system_time_zone Sets the system time zone of the server.
error_on_overlap_time Specifies whether to report an error when ambiguity occurs in the time of daylight-saving time overlapping zones.

Transactions and transaction logs

Variable name
Feature description
autocommit Specifies whether to automatically commit transactions.
tx_isolation Sets the transaction isolation level.
ob_proxy_set_trx_executed Used to specify whether the user is sent through OBProxy.START TRANSACTION SyntaxTo the OBServer.
ob_trx_idle_timeout Sets the transaction idle timeout period, which is the duration after which a transaction times out if the execution interval between two statements exceeds this value.
transaction_isolation Sets the isolation level of a transaction.
transaction_read_only Controls whether to allow only read-only transactions.
ob_trx_lock_timeout Sets the lock wait timeout for transactions.
tx_read_only Specifies whether the transaction is read-only.
ob_trx_timeout Sets the transaction timeout period.
ob_trace_info Used to pass-through trace information, which can ultimately be persisted in the redo log.
gtid_executed A collection for storing all committed transactions and the GTIDs set by statements. Its default value is NULL.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried but cannot be set.

gtid_owned A list of all GTIDs currently in use and the IDs of the threads that hold them. The default value is NULL.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

Audit-related

Variable name
Feature description
ob_enable_sql_audit Controls whether to enable the SQL audit feature for the current tenant.

Data types

Variable name
Feature description
explicit_defaults_for_timestamp Specifies whether to enable nonstandard behavior for the TIMESTAMP data type when processing default and null values.
log_row_value_options Controls whether to use partial updates for LOB data.
ob_default_lob_inrow_threshold Specifies the default in-row storage threshold for LOB fields in a table during table creation.

SQL/PL related

Variable name
Feature description
connect_timeout Sets the connection timeout period.
ob_pl_block_timeout Sets the maximum timeout period for PL.
cursor_sharing Determines whether to parameterize SQL statements during processing.
have_profiling Used to detect whether query performance analysis is supported. Default value:NO.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query this variable, but you cannot set it.

profiling It is used to enable or disable the statement analysis feature. The default value is0.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

profiling_history_size Specifies the number of historical query performance records to retain. The default value is15.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

innodb_strict_mode Sets the SQL check mode for a specific syntax.
max_connections Sets the maximum number of connections for the entire tenant.
sql_mode It is used to set the SQL mode. Different SQL modes have a significant impact on operations such as insertion.
sql_quote_show_create Used to set whether it is aSHOW CREATE TABLEandSHOW CREATE DATABASEThe statement initiates a reference identifier.
ob_enable_rich_error_msg It is used to control whether to display information such as svr_ip, time, and trace_id when an error occurs during SQL execution.
sql_throttle_current_priority Used to set the throttling priority. Onlysql_throttle_current_priorityLess thansql_throttle_priorityOnly the requests on those sessions will be throttled.
sql_throttle_priority Used to set the throttling priority.
sql_throttle_rt Specifies the RT value.
max_allowed_packet Sets the maximum packet size.
max_user_connections Specifies the number of connections a single user can establish to an OBServer node. Set it to0indicates that the number of connections is not limited.
max_sp_recursion_depth Sets the maximum recursion depth for calling any specified stored procedure.
sql_select_limit This clause is used to set the maximum number of rows that a SELECT query is allowed to return.
max_connections Sets the maximum number of connections for the entire tenant.
ob_enable_pl_async_commit Controls whether to enable PL asynchronous commit optimization.
sql_transpiler It is used to control whether to enable the SQL Transpiler feature.
plsql_can_transform_sql_to_assign Used to control the PLselect into from dualWhether to allow rewriting toassignstatement.

System logs

Variable name
Feature description
binlog_row_image Specifies whether to record full-column logs.
ob_enable_show_trace Specifies whether to use trace logs.
ob_log_level Sets the log level for the current session. If not specified, the system log level is used.
tracefile_identifier Used to add specified content to logs, facilitating filtering and iterative tracking of log lines.
master_verify_checksum Controls whether to enable checksum verification. Default value:OFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting takes effect without an error being reported.

log_statements_unsafe_for_binlog Whether to record error code 1592 information in the error log. The default value is1.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

binlog_gtid_simple_recovery Controls how the server iterates through binlog files during GTID search upon startup or restart. The default value is1, indicatinggtid_executedandgtid_purgedThe value of this parameter will be determined at startup based on the timestamps in the oldest and newest binlog files.previous_gtids_log_eventis calculated based on its value.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

log_bin_basename The full path of the binlog file. The default value isnull

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

log_bin_index The name and path of the binlog index file. The default value isnull

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query it, but you cannot set it.

log_slave_updates Specifies whether the replica server records updates received from its primary server's binlog into its own binlog. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried but cannot be set.

System servers

Variable name
Feature description
preload_buffer_size Specifies the cache size in bytes for preloading indexes. The default value is32768.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error message.

read_buffer_size Specifies the cache size in bytes that can be used during data reading. The default value is131072.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

read_rnd_buffer_size Specifies the cache size for reading data from a MyISAM table. It is also used for multi-range read optimization for any storage engine, in bytes. The default value is262144.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

sync_frm Whether to synchronize the metadata of InnoDB tables to disks..frmfiles. The default value is1

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting takes effect without an error message.

keep_files_on_create When not in useDATA DIRECTORYorINDEX DIRECTORYWhen you use the option to specify the storage location for data files or index files, this variable controls whether the server retains existing files in the corresponding directory when creating a MyISAM table. Its default value isOFF, which means to overwrite the existing file.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

max_heap_table_size Specifies the maximum size to which a memory table created by the user is allowed to grow, in bytes. The default value is16777216.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error being reported.

bulk_insert_buffer_size Specifies the cache size for batch data insertion, in bytes per thread. The default value is8388608.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without returning an error.

general_log_file Specifies the name of the log file for regular queries. The default value format ishost_name.log.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

host_cache_size Specifies the size of the host cache. The default value is279.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

log_error_verbosity Defines the verbosity with which the server writes error, warning, and comment information to the error log. The default value is3

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

log_output Specifies the output targets for regular query logs and slow query logs. The default value isFILE

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error being reported.

log_queries_not_using_indexes Whether to log queries that do not use indexes to the slow query log. The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

log_slow_admin_statements Specifies whether to record slow management statements such as ALTER TABLE, ANALYZE TABLE, CHECK TABLE, CREATE INDEX, DROP INDEX, OPTIMIZE TABLE, and REPAIR TABLE in the slow query log. The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error being reported.

log_syslog Whether to log error logs to system logs. Default value:OFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

log_syslog_facility The tool that writes error logs to the system log. The default value isdaemon

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting takes effect without an error being reported.

log_syslog_include_pid Whether to write the service process ID in the error log output to the system log. The default value is1

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

log_syslog_tag Specifies the tag to add to the server identifier in the error log output written to the system log. The default value isnull

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

log_throttle_queries_not_using_indexes The maximum number of statements that can be written to the slow query log per minute. The default value is0, which indicates no limit.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error message.

log_timestamps Controls the time zone for the timestamps of error logs, general logs, and slow query logs written to files. The default value isUTC

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error being reported.

log_warnings Specifies the logging level for recording additional alert information in the error log. The default value is2.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting takes effect without returning an error.

max_delayed_threads Maximum number of threads allowed for creating INSERT DELAYED statements. Default value:20

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

offline_mode Whether to set the server to offline mode. Default value:0, which means not to set it to offline mode.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

require_secure_transport Whether a secure transmission method is required for the connection between the client and server. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

slow_launch_time When the time spent creating a thread exceeds this value, the value of the status variable Slow_launch_threads increases by one second. The default value is2.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

sql_log_off Enables or disables general query logging for the current session. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

thread_cache_size The maximum number of threads that can be accommodated in the thread cache. The default value is9.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without returning an error.

thread_pool_high_priority_connection Controls whether the thread pool reserves idle threads for high-priority connections. The default value is0

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

thread_pool_max_unused_threads The maximum number of unused threads allowed in the thread pool. The default value is0

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

thread_pool_prio_kickup_timer The time required for a statement to move to the high-priority queue, in milliseconds. The default value is1000

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

thread_pool_stall_limit The maximum time within which a statement must complete after it starts execution, in 10 milliseconds. The default value is6.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

have_statement_timeout Specifies whether to enable statement execution timeout. The default value isON.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

old A compatibility variable used to resolve compatibility issues. Its default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query it, but you cannot set it.

version_tokens_session_number The default value of the internally used variable is0.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error message.

back_log The maximum number of connection requests that can be queued while the server is processing them. The default value is80.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query this variable, but you cannot set it.

basedir The path name of the installation root directory. The default value is/usr/local/mysql/.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

bind_address The IP address to which the server binds when listening for TCP/IP client connections. The default value is*

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

core_file Whether to generate a core file when a fatal error occurs before the server exits. Default value:OFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

have_compress Indicates whether the zlib compression library required for the COMPRESS() and UNCOMPRESS() functions is available. The default value isON, indicating it is available.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

ignore_db_dirs A comma-separated list of names that are not considered database directories in the data directory. The default value isnull

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

init_file Specifies a file name that contains SQL statements executed by the server upon startup. The default value isnull

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query this variable, but you cannot set it.

large_files_support Indicates whether the server supports processing large files. The default value is1, indicating support.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

large_pages Specifies whether to enable large-page support. The default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query this variable, but you cannot set it.

large_page_size If the large-page support feature is enabled, this variable specifies the size of memory pages, in bytes. The default value is0

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. It can be queried but cannot be set.

locked_in_memory Whether the server is locked in memory. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

log_error Output target of error log files. Default value:./obrd.16c.vd3-s2h6-n3.err.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query it, but you cannot set it.

named_pipe Whether the server allows clients to connect using named pipes. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query it, but you cannot set it.

named_pipe_full_access_group Specifies which Windows user group has permission to use named pipe connections when named pipe connections are supported. The default value isempty string

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

open_files_limit The number of file descriptors available to the server. The default value is655360.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

shared_memory Whether the server allows clients to use shared memory connections. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

shared_memory_base_name Specifies the name of the shared memory used for the shared-memory connection. The default value isMYSQL

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

skip_name_resolve Controls whether to resolve the hostname when checking client connections. The default value isOFF, indicating that the hostname needs to be resolved.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

skip_networking Controls whether the server allows TCP/IP connections. Default value:OFF, which indicates that TCP/IP connections are disabled.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query it, but you cannot set it.

thread_handling The thread model used by the server to handle client connections. The default value isone-thread-per-connection.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

thread_pool_algorithm Controls the algorithm used by the thread pool plugin. The default value is0, indicating that the conservative low-concurrency algorithm is used.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. It can be queried but cannot be set.

thread_pool_size Specifies the number of thread groups in the thread pool. The default value is16.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

thread_stack The stack size for each thread. The default value is262144.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

tls_version The protocols allowed for encrypted connections on the server.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried but cannot be set.

X Plugin related

Variable name
Feature description
mysqlx_bind_address Specifies the network address for TCP/IP connections monitored by the X plugin. The default value is*, which indicates accepting TCP/IP connections from all server hosts.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried but cannot be set.

mysqlx_port Specifies the network port on which the X plugin listens for TCP/IP connections. The default value is33060.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. It can be queried but cannot be set.

mysqlx_port_open_timeout Specifies the time, in seconds, that the X plugin waits for a TCP/IP port to become available. The default value is0.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

mysqlx_socket Specifies the path of the Unix socket file used by the X plugin for connection. The default value is/tmp/mysqlx.sock

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

mysqlx_ssl_ca Specifies the path of the SSL certificate authority (CA) file used by the X plugin.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; queries can be performed, but settings cannot be modified.

mysqlx_ssl_capath Specifies the directory path of the SSL certificate authority (CA) certificate file used by the X plugin.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

mysqlx_ssl_cert Specifies the path of the SSL certificate file used by the X plugin.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; queries can be performed, but settings cannot be modified.

mysqlx_ssl_cipher Specifies the list of encryption algorithms used by the SSL encryption of the X plugin.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

mysqlx_ssl_crl Specifies the filename of the certificate revocation list file used by the X plugin.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; queries are possible, but settings cannot be made.

mysqlx_ssl_crlpath Specifies the directory path for the certificate revocation list files used by the X plugin.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; queries are possible, but settings cannot be made.

mysqlx_ssl_key Specifies the path of the SSL certificate key file used by the X plugin.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; queries can be performed, but settings cannot be modified.

Performance mode related

Variable name
Feature description
performance_schema_accounts_size Specified TableaccountsThe number of rows in the table. The default value is-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_digests_size Specify Tableevents_statements_summary_by_digestThe maximum number of rows in the middle. The default value is10000.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_events_stages_history_long_size Specify Tableevents_stages_history_longThe number of rows in the table. Default value:10000

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_events_stages_history_size Specify Tableevents_stages_historyThe number of rows per thread. The default value is10

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query this variable, but you cannot set it.

performance_schema_events_statements_history_long_size Specify Tableevents_statements_history_longThe number of rows in the table. The default value is10000

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_events_statements_history_size Specify Tableevents_statements_historyThe number of rows per thread. The default value is10

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_events_transactions_history_long_size Specified Tableevents_transactions_history_longThe number of rows in the table. Default value:10000.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query this variable, but you cannot set it.

performance_schema_events_transactions_history_size Specify Tableevents_transactions_historyThe number of rows per thread. Default value:10

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_events_waits_history_long_size Specify Tableevents_waits_history_longThe number of rows in the table. The default value is10000

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

performance_schema_events_waits_history_size Specify Tableevents_waits_historyThe number of rows per thread. The default value is10.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_hosts_size Specify TablehostsThe number of rows in the table. Default value:-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_cond_classes Specifies the maximum number of condition collectors. The default value is80.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

performance_schema_max_cond_instances Specifies the maximum number of condition objects that can be collected. The default value is-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_digest_length Specifies the maximum length in bytes of an SQL statement in standard format when stored in performance mode. The default value is1024

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_file_classes Specifies the maximum number of file collectors. The default value is80

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

performance_schema_max_file_handles Specifies the maximum number of file objects that can be opened. The default value is32768

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_file_instances Specifies the maximum number of file objects that can be collected. The default value is-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_index_stat Maximum number of indexes maintained by the performance mode statistics. Default value:-1, indicating automatic resizing.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; queries can be executed, but the variable cannot be set.

performance_schema_max_memory_classes Specifies the maximum number of memory collectors. The default value is320.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query it, but you cannot set it.

performance_schema_max_metadata_locks Specifies the maximum number of metadata lock collectors. The default value is-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_mutex_classes Specifies the maximum number of mutex collectors. The default value is200

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query it, but you cannot set it.

performance_schema_max_mutex_instances Specifies the maximum number of mutually exclusive objects that can be collected. The default value is-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_prepared_statements_instances Specify Tableprepared_statements_instancesThe maximum number of rows in the middle. The default value is-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_program_instances Maximum number of stored programs maintained by the performance mode statistics. Default value:-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_rwlock_classes Specifies the maximum number of rwlock collectors. The default value is50

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. It can be queried but cannot be set.

performance_schema_max_rwlock_instances Specifies the maximum number of RWLock objects that can be acquired. The default value is-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_socket_classes Specifies the maximum number of socket collectors. The default value is10

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_socket_instances Specifies the maximum number of socket objects that can be collected. The default value is-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_sql_text_length Specifies the maximum length (in bytes) of an SQL statement that can be stored in the SQL_TEXT column of event tables such as events_statements_current, events_statements_history, and events_statements_history_long. The default value is1024

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_stage_classes Specifies the maximum number of collectors allowed in a stage. The default value is150

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query it, but you cannot set it.

performance_schema_max_statement_classes Specifies the maximum number of statement collectors. The default value is193

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

performance_schema_max_statement_stack Maximum depth of nested stored program calls maintained in performance mode statistics. Default value:10

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_table_handles Specifies the maximum number of table objects that can be opened. The default value is-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_table_instances Specifies the maximum number of table objects that can be collected. The default value is-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_table_lock_stat Maximum number of tables for which lock statistics are maintained in performance mode. Default value:-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_max_thread_classes Specifies the maximum number of thread collectors. The default value is50.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. It can be queried but cannot be set.

performance_schema_max_thread_instances Specifies the maximum number of thread objects that can be collected. The default value is-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_session_connect_attrs_size The pre-allocated memory size for storing connection attribute key-value pairs retained by each thread, in bytes. The default value is512

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_setup_actors_size Specify Tablesetup_actorsThe number of rows in the table. The default value is-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_setup_objects_size Specified tablesetup_objectsThe number of rows in the table. Default value:-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

performance_schema_users_size Specify TableusersThe number of rows in the table. The default value is-1, indicating auto scaling.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

Lock-related

Variable name
Feature description
metadata_locks_cache_size Sets the cache size for metadata locks. The default value is1024, in bytes.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

metadata_locks_hash_instances Specifies the number of instances for the metadata lock hash table. The default value is8.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query this variable, but you cannot set it.

Foreign key related

Variable name
Feature description
foreign_key_checks Specifies whether to check foreign constraints during DML and DDL operations.

Materialized view related

Variable name
Feature description
mview_refresh_dop Controls the default refresh parallelism for materialized views.

Optimizer-related

Variable name
Feature description
optimizer_use_sql_plan_baselines Controls whether the optimizer uses plan baselines.
optimizer_capture_sql_plan_baselines Controls whether to automatically capture new plans to the plan baseline.
parallel_degree_policy Used to set the parallelism selection strategy.
parallel_degree_limit This parameter specifies the upper limit of the degree of parallelism (DOP) that the optimizer can select when the auto-DOP strategy is used.
parallel_min_scan_time_threshold Sets the minimum estimated execution time for parallel processing of base table scans.
optimizer_dynamic_sampling Controls the level of dynamic sampling.
optimizer_features_enable This parameter is used to enable optimizer features for different OceanBase AI Database versions.
ob_enable_transformation Specifies whether to enable the rewrite feature of the SQL optimizer.
ob_table_access_policy Controls the optimizer to prefer specific storage formats when generating base table plans.
range_index_dive_limit Specifies the maximum number of ranges allowed for row estimation at the storage layer by the optimizer.
cardinality_estimation_model Controls the correlation assumptions used by the optimizer during cardinality estimation.

Auto-increment columns

Variable name
Feature description
auto_increment_increment Sets the auto-increment step size, which is applicable only when logging in through the MySQL client.
auto_increment_offset Used to determineAUTO_INCREMENTThe starting point of the column value.
last_insert_id Retrieves the value of the auto-increment field from the last insert of the current session.
identity identityand variableslast_insert_idare synonyms and can be used interchangeably.select @@identityQuery.
sql_auto_is_null Determines whether to obtain the auto-increment column value of the last inserted row.
auto_increment_cache_size Specifies the number of auto-increment values stored in the cache.
div_precision_increment This parameter specifies the increment for the precision of the division result based on the precision of the dividend. It is a MySQL-compatible feature.

Character sets and strings

Variable name
Feature description
character_set_client Sets the character set for statements sent by the client.
character_set_connection Sets the character set to be converted after receiving a statement.
character_set_database Sets the character set of the default database.
character_set_results Sets the character set to which the server should convert the result set or error message before sending it back to the client.
character_set_server Sets the server character set.
character_set_system This view is used to view the character set used by the server.
collation_connection Sets the character set and collation for the connection.
collation_database Sets the default character set and collation for creating a database.
collation_server Sets the default character set and collation for the server.
character_set_filesystem Sets the character set type of the file system.
sql_warnings This parameter specifies whether to generate an information string for a single-row INSERT statement when an alert is triggered.
init_connect Sets the string executed by the server for each client connection. The string consists of one or more SQL statements separated by semicolons.

Group Replication

Variable name
Feature description
group_replication_allow_local_disjoint_gtids_join Specifies whether a local transaction on the server can join a group if the group does not have a transaction. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without returning an error.

group_replication_allow_local_lower_version_join Specifies whether a server with a MySQL server version lower than that of other group members is allowed to join the group. Default value:OFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

group_replication_auto_increment_increment Automatically sets the increment value for the auto-increment column of each member in the replication group, ensuring that the values in the auto-increment columns of all group members are ordered and non-overlapping in a multi-primary mode group. The default value is7.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

group_replication_bootstrap_group Specifies to use the current server to bootstrap the group. This variable can only be set on one server, and must be set on one of the servers during the initial bootstrap or during a subsequent bootstrap of the group. The default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_components_stop_timeout The timeout period for waiting for each component when group replication is disabled, in seconds. The default value is2.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

group_replication_compression_threshold The threshold for compressing messages sent between group members. When the number of messages exceeds this threshold, the messages will be compressed. The default value is1000000.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

group_replication_enforce_update_everywhere_checks Enables or disables strict consistency checking for multi-primary updates at any time. The default value isOFF, which indicates to disable the check.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error message.

group_replication_exit_state_action Sets the behavior of group replication when a server instance detaches from the group due to an exception. The default value isREAD_ONLY.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting takes effect without an error being returned.

group_replication_flow_control_applier_threshold Specifies the number of transactions waiting in the queue of the application that triggers traffic control. The default value is25000.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_flow_control_certifier_threshold Specifies the number of waiting transactions in the queue of validators that trigger flow control. The default value is25000.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

group_replication_flow_control_mode Specifies the mode used for flow control. The default value isQUOTA.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

group_replication_force_members Specify the list of member addresses in the format ofhost1:port1,host2:port2. This variable is used to force the creation of a new group. After successful setting, members that are excluded (members not specified in this variable) will not receive new view messages and will also be blocked (blocking write operations). Its default value is empty.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting does not take effect without an error message.

group_replication_group_name Specifies the group name of the replication group to which the current server belongs. The default value is empty.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

group_replication_group_seeds Specify the list of addresses for the seed members in the format ofhost1:port1,host2:port2. Its default value is empty.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_gtid_assignment_block_size Specifies the number of consecutive GTIDs retained for each member. The default value is1000000.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without returning an error.

group_replication_ip_whitelist Specifies which hosts (IP addresses or hostnames) are allowed to connect to the group. The allowed addresses are called allowlist addresses. The default value isAUTOMATIC.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being returned.

group_replication_local_address The group replication member provides the network address for other members in the group to connect and access. Its default value is empty.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_member_weight Assigns a percentage weight to group members. This weight affects the likelihood of a member being selected as the primary node during a failover (only meaningful for groups in single-primary mode). When the primary node of a group in single-primary mode leaves the group, members with higher weight values are preferentially selected as the new primary node. The default value is50

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_poll_spin_loops Specifies the number of times the group replication communication thread waits for the communication engine mutex to be released before waiting for more incoming network messages. The default value is0.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

group_replication_recovery_complete_at Specifies the strategy for caching transactions by the application after status transfer is completed during distributed recovery. Default value:TRANSACTIONS_APPLIED.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_reconnect_interval When a new server attempts to join a group and cannot find an available donor for distributed recovery for some reason, it will attempt to reconnect to find an available donor. This variable sets the interval for reconnection, in seconds. The default value is60.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_retry_count When a new server attempts to join a group and cannot find an available donor for distributed recovery for some reason, it will attempt to reconnect to find an available donor. This variable sets the number of reconnection attempts to find an available donor. Its default value is10.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting takes effect without an error being returned.

group_replication_recovery_ssl_ca Specifies the path of the file containing the list of trusted SSL certificate authorities used for distributed restore connections. The default value is empty.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_ssl_capath Specifies the directory path for trusted SSL certificates issued by a certificate authority, used for distributed restore connections. The default value is empty.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_ssl_cert Specifies the name of the SSL certificate file used to establish a secure connection for distributed recovery. The default value is empty.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_ssl_cipher Specifies the list of encryption algorithms allowed for SSL encryption. The available encryption algorithms depend on the version of the SSL library used when compiling MySQL Server, as different SSL libraries support different encryption algorithms. The default value is empty.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_ssl_crl Specifies the filename of the certificate revocation list file. The default value is empty.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_ssl_crlpath Specifies the directory path containing the certificate revocation list file. The default value is empty.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_ssl_key Specifies the name of the SSL key file used to establish a secure connection for distributed recovery. The default value is empty.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_ssl_verify_server_cert Specifies whether to verify the server common name in the donor certificate during distributed recovery. The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being returned.

group_replication_recovery_use_ssl Specifies whether to use SSL for the connection channel during distributed recovery for group replication members. The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

group_replication_single_primary_mode Specifies whether group replication runs in single-primary mode and automatically selects a server to handle read/write workloads. If set toONindicates that there is only one readable and writable primary node, and all other group members are standby nodes. If set toOFFindicates that the single-primary mode is disabled, that is, the multi-primary mode is enabled. In multi-primary mode, all group members are typically read-write primary nodes. The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting takes effect without an error being returned.

group_replication_ssl_mode Specifies the security status of SSL connections between group replication members. The default value isDISABLED.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_start_on_boot Specifies whether to enable group replication upon server startup. Default value:OFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

group_replication_transaction_size_limit Specifies the maximum size of a transaction that can be received within group replication, in bytes. The default value is150000000.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_unreachable_majority_timeout Specifies the waiting time, in seconds, before a member leaves a group when it encounters a network partition and loses connection to the majority of group members. The default value is0.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

Session Level

Version information

Variable name
Feature description
ob_last_schema_version Sets the version number of the schema most recently used in the current session.
old_alter_table Specifies whether to enable the legacy ALTER TABLE syntax and operation mode. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

Debugging

Variable name
Feature description
debug Used to set debugging options. The default value isd:t:i:o,/tmp/mysqld.trace.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

Read/Write and Query

Variable name
Feature description
is_result_accurate When the query containstopkWhen prompted,is_result_accurateIndicates whether the result is correct.
long_query_time The threshold for identifying slow queries.

Replica-related

Variable name
Feature description
master_info_repository Specifies whether metadata is stored as records in the mysql table of the system database InnoDB or as files in the data directory. The default value isFILE.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

Cache-related

Variable name
Feature description
table_definition_cache Sets the amount of memory space used to cache table definitions. The default value is-1.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

table_open_cache_instances Specifies the number of instances for opening table cache. The default value is16.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. It can be queried but cannot be set.

Cluster-related

Variable name
Feature description
ob_capability_flag It is a capability provided by an OBServer node for capability negotiation when connecting to a proxy, informing the proxy which features the current OBServer node supports and which it does not.
ob_proxy_partition_hit It specifies whether OBProxy sends the data requested by the SQL statement to the OBServer node where the data resides in the primary partition.
ob_org_cluster_id Used to set the for the OceanBase AI Database cluster.CLUSTER_ID.

NDB storage engine

Variable name
Feature description
ndb_allow_copying_alter_table Whether to AllowALTER TABLEstatements and other DDL statements for table replication operations. The default value isOFF

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

ndb_autoincrement_prefetch_sz Specifies the number of prefetches for auto-increment columns. This value affects the performance and concurrent access capability of auto-increment columns. Default value:1.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

ndb_blob_read_batch_bytes Configures the maximum size for batch reading of BLOB data in an NDB cluster, in bytes. The default value is65536.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting takes effect without returning an error.

ndb_blob_write_batch_bytes Configures the maximum size of a batch for writing BLOB data in an NDB cluster. The default value is65536.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

ndb_deferred_constraints Controls whether to delay constraint checking on tables. The default value is0.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error message.

ndb_fully_replicated Determines whether the new table is fully copied. Default value:OFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

ndb_index_stat_enable Specifies whether to use the NDB index statistics collection feature. The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

ndb_index_stat_option Specifies the options for generating NDB index statistics. The default value isloop_checkon=1000ms,loop_idle=1000ms,loop_busy=100ms,update_batch=1,read_batch=4,idle_batch=32,check_batch=32,check_delay=1m,delete_batch=8,clean_delay=0,error_batch=4,error_delay=1m,evict_batch=8,evict_delay=1m,cache_limit=32M,cache_lowpct=90

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting takes effect without returning an error.

ndb_join_pushdown Controls whether to enable the connection pushdown optimization feature in the storage engine. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

ndb_log_binlog_index Controls whether to insert the epoch-to-binlog-position mapping into the ndb_binlog_index table. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without returning an error.

ndb_log_exclusive_reads Determines whether to use an exclusive lock to record primary key reads. Default value:OFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

ndb_row_checksum Specifies the checksum value of a table row. The value is1When set to yes, the checksum value of each row is calculated and stored. If the value is0When this parameter is set to N/A, table row data verification and detection are not performed. The default value is N/A.1.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

ndb_use_exact_count Specifies whether to force NDB to use the SELECT count(*) record count to accelerate such queries during query plan generation. The default value isOFF.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting takes effect without an error being returned.

ndb_use_transactions Controls whether to enable NDB transaction support. The default value isOFF

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error message.

ndbinfo_max_bytes For testing and debugging only. The default value is0

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

ndbinfo_max_rows For testing and debugging only. The default value is10.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error being reported.

ndbinfo_show_hidden Whether to display in the MySQL client.ndbinfoThe underlying internal table of the database. The default value isOFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

myisam_repair_threads Specifies the number of concurrent threads for repairing a MyISAM table. The default value is1.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being returned.

myisam_sort_buffer_size Specifies the cache size allocated for sorting MyISAM indexes during a REPAIR TABLE operation or for creating indexes using CREATE INDEX (or ALTER TABLE), in bytes. The default value is8388608.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

myisam_stats_method Specifies the method by which the server calculates NULL values when collecting statistics on index value distribution for a MyISAM table. The default value isnulls_unequal, which means that NULL values are treated as regular values and handled in the same way as other values.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

myisam_use_mmap Whether to use memory mapping for reading from and writing to MyISAM tables. Default value:OFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting takes effect without an error message.

SQL/PL

Variable name
Feature description
have_profiling Used to detect whether query performance analysis is supported. The default value isNO.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried but cannot be set.

profiling Used to enable or disable statement analysis. The default value is0.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

profiling_history_size Specifies the number of historical query performance records to retain. The default value is15.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

enable_sql_plan_monitor Specifies whether the SQL statements of the current session are recorded in SQL Plan Monitor.

System logs

Variable name
Feature description
ob_enable_show_trace Specifies whether to use trace logs.
tracefile_identifier Used to add specified content to logs, facilitating filtering and iterative tracking of log lines.

System servers

Variable name
Feature description
pseudo_slave_mode Specifies whether to convert the server to slave simulation mode. Default value:OFF.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

pseudo_thread_id Sets the ID of the session thread. Default value:2147483647

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being returned.

rbr_exec_mode Sets the session thread mode to IDEMPOTENT or STRICT. Default value:STRICT

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being returned.

preload_buffer_size Specifies the cache size in bytes for preloading indexes. The default value is32768

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error being reported.

read_buffer_size Specifies the cache size in bytes that can be used during data reading. The default value is131072.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being reported.

read_rnd_buffer_size Specifies the cache size for reading data from a MyISAM table. It is also used for multi-range read optimization for any storage engine, in bytes. The default value is262144.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting will not take effect without an error being returned.

keep_files_on_create When not in useDATA DIRECTORYorINDEX DIRECTORYWhen you use the option to specify the storage location for data files or index files, this variable controls whether the server retains existing files in the corresponding directory when creating a MyISAM table. Its default value isOFF, which means to overwrite the existing file.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

max_heap_table_size Specifies the maximum size, in bytes, to which a memory table created by the user is allowed to grow. The default value is16777216

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

bulk_insert_buffer_size Specifies the cache size for batch data insertion, in bytes per thread. The default value is8388608.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported. You can query and set it, but the setting takes effect without returning an error.

Time zone and date related

Variable name
Feature description
timestamp TIMESTAMPis a timestamp in seconds. This variable affectsselect now(6)The result.

Transactions and transaction logs

Variable name
Feature description
ob_proxy_set_trx_executed Used to specify whether the user sends through OBProxy.START TRANSACTION SyntaxTo the OBServer.
ob_trace_info Used to pass-through trace information, which can ultimately be persisted in the redo log.

Vector operations

Variable name
Feature description
ob_hnsw_ef_search This parameter specifies the number of neighbor points searched by the HNSW algorithm in each layer of the graph during vector index queries.
ob_ivf_nprobes Specifies the number of nearest cluster centers to search for in a vector index query. This variable affects the performance and recall rate of IVF queries: a larger value results in higher recall but also longer search time.

Optimizer-related

Variable name
Feature description
ob_table_access_policy Controls the optimizer to prefer specific storage formats when generating base table plans.
partition_index_dive_limit Specifies the maximum number of partitions that the optimizer can use for row estimation at the storage layer.
range_index_dive_limit Specifies the maximum number of ranges allowed for row estimation at the storage layer by the optimizer.

Auto-increment columns

Variable name
Feature description
last_insert_id Retrieves the value of the auto-increment field from the last insert of the current session.

Group Replication Related

Variable name
Feature description
group_replication_force_members Specify the list of member addresses in the format ofhost1:port1,host2:port2. This variable is used to force the creation of a new group. After it is successfully set, members that are excluded (those not specified in this variable) will not receive new view messages and will also be blocked (blocking write operations). Its default value is empty.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting will not take effect without an error message.

group_replication_group_name Specifies the group name of the replication group to which the current server belongs. The default value is empty.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error being reported.

group_replication_gtid_assignment_block_size Specifies the number of consecutive GTIDs retained for each member. The default value is1000000.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; it can be queried and set, but the setting will not take effect without an error being reported.

group_replication_ip_whitelist Specifies which hosts (IP addresses or hostnames) are allowed to connect to the group. The allowed addresses are called allowlist addresses. The default value isAUTOMATIC.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported. You can query and set it, but the setting takes effect without an error being returned.

group_replication_local_address The group replication member provides the network address for other members in the group to connect and access. Its default value is empty.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_ssl_ca Specifies the path of the file containing the list of trusted SSL certificate authorities used for distributed restore connections. The default value is empty.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_ssl_capath Specifies the directory path for trusted SSL certificates issued by a certificate authority, used for distributed restore connections. The default value is empty.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_ssl_cert Specifies the name of the SSL certificate file used to establish a secure connection for distributed recovery. The default value is empty.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_ssl_cipher Specifies the list of encryption algorithms allowed for SSL encryption. The available encryption algorithms depend on the version of the SSL library used when compiling MySQL Server, as different SSL libraries support different encryption algorithms. The default value is empty.

Note

This variable is only for compatibility with MySQL 5.7. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_ssl_crl Specifies the filename of the certificate revocation list file. The default value is empty.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_ssl_crlpath Specifies the directory path containing the certificate revocation list file. The default value is empty.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

group_replication_recovery_ssl_key The name of the SSL key file used to establish a secure connection for distributed recovery. The default value is empty.

Note

This variable is for compatibility with MySQL 5.7 only. The related feature is not supported; you can query and set it, but the setting will not take effect without an error message.

Previous topic

zone_deploy_mode
Last

Next topic

ap_query_cost_threshold
Next
on this page
Global level
Security
AP-related
Version information
Debugging
Case sensitivity
Read/write and query
Scheduler-related
Replica-related
Source replication related
Recycle Bin
Cache-related
Functions
InnoDB storage engine related
Cluster-related
Directory path related
MyISAM storage engine related
Temporary files
Memory
NDB storage engine related
Full-text indexes
Runtime Filter
Upgrade related
Time zone and date related
Transactions and transaction logs
Audit-related
Data types
SQL/PL related
System logs
System servers
X Plugin related
Performance mode related
Lock-related
Foreign key related
Materialized view related
Optimizer-related
Auto-increment columns
Character sets and strings
Group Replication
Session Level
Version information
Debugging
Read/Write and Query
Replica-related
Cache-related
Cluster-related
NDB storage engine
SQL/PL
System logs
System servers
Time zone and date related
Transactions and transaction logs
Vector operations
Optimizer-related
Auto-increment columns
Group Replication Related