Parameters for tenants|OceanBase Cloud| docs|Distributed Database

Parameters for tenants

Last Updated：2025-06-24 11:54:40 Updated

This topic provides information about the parameters related to tenants.

Parameter list

Parameter	Description
autocommit	Determines whether to enable automatic commit.
auto_increment_cache_size	The number of auto-increment values to cache.
auto_increment_increment	The increment step for auto-increment, applicable only to MySQL client connections.
auto_increment_offset	Defines the starting point for the `AUTO_INCREMENT` column values.
block_encryption_mode	Specifies the encryption algorithm to use with the `aes_encrypt` and `aes_decrypt` functions.
connect_timeout	Connection timeout period in microseconds.
div_precision_increment	The increment for division precision based on the precision of the dividend, compatible with MySQL.
error_on_overlap_time	A dynamic parameter that specifies whether to return an error when an ambiguity occurs due to daylight saving time overlap.
explicit_defaults_for_timestamp	Specifies whether to enable non-standard behavior for handling default and null values in the `timestamp` data type.
foreign_key_checks	Determines whether to check foreign key constraints.
group_concat_max_len	The maximum length, in bytes, allowed for the result of the `GROUP_CONCAT()` function.
interactive_timeout	The number of seconds the server waits for activity before closing an interactive connection. Interactive clients are defined as those using the `CLIENT_INTERACTIVE` option in `mysql_real_connect()`. See also `wait_timeout`.
max_sp_recursion_depth	The maximum number of times any stored procedure can be recursively called.
net_read_timeout	The number of seconds to wait for additional data before aborting a read operation. When reading from a client, this controls when the read timeout occurs; when writing to a client, `net_write_timeout` controls the write timeout.
net_write_timeout	The number of seconds to wait before aborting a write operation to a connection. When reading from a client, `net_read_timeout` controls the timeout, while this controls the write timeout.
ob_check_sys_variable	When enabled, system variables are updated when the schema version changes.
ob_create_table_strict_mode	If enabled, replica creation strictly follows locality rules. If any replica creation fails, the `CREATE TABLE` operation fails; otherwise, it succeeds when there is at least one full-featured replica and a majority in the Paxos member group.
ob_default_replica_num	The default number of replicas for tables in each instance.
ob_early_lock_release	Determines whether to enable ELR (Early Lock Release) optimization for transactions.
ob_enable_aggregation_pushdown	Specifies whether to allow aggregation operations to be pushed down.
ob_enable_blk_nestedloop_join	Determines whether to enable block nested loop joins.
ob_enable_hash_group_by	Specifies whether to enable the Hash Group By execution path.
ob_enable_index_direct_select	Allows users to directly query index tables.
ob_enable_jit	Controls the JIT (Just-In-Time) execution engine mode: `OFF` - JIT is disabled for the session; `AUTO` - JIT is enabled if the average execution time of SQL exceeds 1 second; `FORCE` - JIT is always enabled for the session.
ob_enable_plan_cache	Determines whether to enable the Plan Cache.
ob_enable_trace_log	Specifies whether to use trace logs.
ob_enable_transformation	Determines whether SQL rewrite is allowed.
ob_enable_transmission_checksum	Specifies whether to perform checksum validation between the proxy and the server.
ob_enable_truncate_flashback	Controls whether objects truncated by the `TRUNCATE` operation are moved to the recycle bin.
ob_plan_cache_evict_high_percentage	The memory usage percentage at which plan cache eviction is triggered.
ob_plan_cache_evict_low_percentage	The memory usage percentage at which plan cache eviction stops.
ob_plan_cache_percentage	The percentage of tenant memory resources allocated for the plan cache.
ob_query_timeout	Query timeout period, in microseconds.
ob_read_consistency	The level of read consistency.
ob_sql_work_area_percentage	The percentage of tenant memory allocated for SQL execution.
ob_trx_idle_timeout	Transaction idle timeout, in microseconds, which triggers when the interval between two consecutive statements exceeds this value.
ob_trx_timeout	Transaction timeout period, in microseconds.
optimizer_capture_sql_plan_baselines	Specifies whether to enable automatic capture of SQL plan baselines.
optimizer_use_sql_plan_baselines	Specifies whether to use SQL plan baselines.
query_cache_size	The amount of unused memory allocated for storing old query results, in bytes.
query_cache_type	The type of query caching: `OFF` - no caching; `ON` - cache all queries except those with `SELECT SQL_NO_CACHE`; `DEMAND` - only cache queries with `SELECT SQL_CACHE`.
read_only	Specifies whether the tenant is in read-only mode. Affects all regular users except those with root privileges.
sql_auto_is_null	Refer to MySQL Server System Variables
sql_quote_show_create	Specifies whether to quote identifiers in the `SHOW CREATE TABLE` and `SHOW CREATE DATABASE` statements.
sql_throttle_cpu	The CPU usage threshold beyond which SQL statements will not be executed.
sql_throttle_current_priority	The current priority level for SQL throttling.
sql_throttle_io	The threshold for the number of I/O operations, beyond which SQL statements will not be executed.
sql_throttle_logical_reads	The threshold for the number of logical reads, beyond which SQL statements will not be executed.
sql_throttle_network	The network usage threshold, beyond which SQL statements will not be executed.
sql_throttle_priority	The SQL priority threshold, below which SQL statements will not be executed.
sql_throttle_rt	The specified response time (RT) threshold, in microseconds; queries with an RT greater than or equal to this value will not be executed.
sql_warnings	Specifies whether to generate an informational string for single-row `INSERT` statements that trigger warnings.
tx_isolation	The transaction isolation level.
undo_retention	Specifies the retention period for multi-version data, in seconds.
wait_timeout	The number of seconds the server waits before closing a non-interactive connection due to inactivity. The session `wait_timeout` is initialized based on either the global `wait_timeout` or `interactive_timeout` value, depending on the client type (as defined by the `CLIENT_INTERACTIVE` option in `mysql_real_connect()`). See also `interactive_timeout`.
recyclebin	Enables or disables the recycle bin. When enabled, deleted database objects are moved to the recycle bin.
sql_plan_management_mode	Specifies the working mode of SQL Plan Management (SPM).
compaction_low_thread_score	The CPU time slice weight allocated to low-priority compaction threads.
ob_trx_lock_timeout	The lock wait timeout period for transactions, in microseconds.
transaction_isolation	Specifies the transaction isolation level.
max_stale_time_for_weak_consistency	Specifies the synchronization delay allowed between the primary and standby databases for weak consistency reads.
writing_throttling_trigger_percentage	The threshold for write throttling, which controls the write speed.
writing_throttling_maximum_duration	Controls the write speed by managing the memory allocation progress and specifies the time required to allocate the remaining MEMStore memory after write throttling is triggered.
max_allowed_packet	The maximum allowed size for network packets, in bytes. The default value is 4,194,304, and the range is between 1,024 and 1,073,741,824.
undo_retention	Specifies the retention period for multi-version data, in seconds.