This page describes the parameters of the current tenant.
Parameter list
Parameters |
Note |
|---|---|
| connect_timeout | Connection timeout period, in seconds. |
| ob_check_sys_variable | If enabled, system variables will be updated when the schema version changes. |
| writing_throttling_maximum_duration | Controls the write speed by managing memory allocation progress. Specifies the time required to allocate the remaining MemStore memory after write throttling is triggered. |
| div_precision_increment | The precision increment of the division result based on the precision of the dividend. This is a MySQL compatibility feature. |
| ob_sql_work_area_percentage | Maximum percentage of tenant memory that can be used for SQL execution. |
| tx_isolation | Transaction isolation level. |
| wait_timeout | Number of seconds the server waits for activity on a non-interactive connection before closing it. When a thread starts, the session wait_timeout value is initialized from the global wait_timeout or interactive_timeout value, depending on the client type specified by the CLIENT_INTERACTIVE option in mysql_real_connect(). See also interactive_timeout. |
| auto_increment_increment | Auto-increment step, used only for MySQL client login. |
| foreign_key_checks | Whether to check foreign key constraints. |
| autocommit | Whether to automatically commit. |
| read_only | Whether the tenant is in read-only mode. This affects all regular users under the tenant, but not users with root privileges. |
| transaction_isolation | Specifies the transaction isolation level. |
| ob_trx_timeout | Transaction timeout period, in microseconds. |
| net_read_timeout | The number of seconds to wait for other data on the connection before interrupting the read. When the server reads from the client, net_read_timeout specifies the timeout value that controls when to interrupt; when the server writes to the client, net_write_timeout specifies the timeout value that controls when to interrupt. |
| ob_enable_index_direct_select | Whether to allow users to directly query index tables. |
| ob_trx_lock_timeout | Sets the lock wait timeout for transactions, in microseconds. |
| sql_throttle_rt | Specifies the RT value in microseconds. If the query's RT value is not less than this value, the query is not allowed to be executed. |
| ob_enable_transmission_checksum | Whether to perform packet checksum verification between the proxy and the server. |
| writing_throttling_trigger_percentage | Set the threshold for write speed. |
| ob_plan_cache_evict_low_percentage | Percentage of the plan cache memory limit below which plan eviction stops. |
| ob_plan_cache_percentage | Percentage of tenant memory resources available for plan caching. |
| max_sp_recursion_depth | The number of times a given stored procedure can be recursively called. |
| sql_throttle_network | Network usage threshold. When the network usage exceeds this threshold, this SQL statement will not be executed. |
| undo_retention | Specifies the retention period for multi-version data, in seconds. |
| query_cache_type | Query cache type.
|
| sql_throttle_logical_reads | The threshold for the number of logical reads. When the number of logical reads exceeds this threshold, this SQL statement will not be executed. |
| auto_increment_cache_size | The number of cached auto-increment values. |
| sql_auto_is_null | Used by some special drivers, such as ODBC, to control whether to retrieve the auto-increment column value of the last inserted row. |
| recyclebin | This is the recycle bin switch. When enabled, database objects deleted will be moved to the recycle bin. |
| ob_enable_plan_cache | Specifies whether to enable plan cache. |
| ob_enable_aggregation_pushdown | Whether to allow pushdown of aggregate operations. |
| net_write_timeout | The number of seconds to wait before interrupting a block write to the connection. When the server reads from the client, net_read_timeout specifies the timeout value that controls when to interrupt; when the server writes to the client, net_write_timeout specifies the timeout value that controls when to interrupt. |
| ob_enable_transformation | Whether to allow SQL rewriting. |
| sql_quote_show_create | Whether to quote identifiers in the output of SHOW CREATE TABLE and SHOW CREATE DATABASE. |
| sql_throttle_io | The threshold for the number of I/O operations. When this number is exceeded, this SQL statement will not be executed. |
| ob_enable_jit | JIT execution engine mode.
|
| max_stale_time_for_weak_consistency | It is used to set the synchronization delay allowed between a standby database and primary database for weak-consistency reads. |
| ob_enable_truncate_flashback | Controls whether the objects truncated by the TRUNCATE operation are moved to the recycle bin. |
| ob_trx_idle_timeout | Transaction idle timeout, in microseconds. A transaction times out if the interval between two consecutive statements exceeds this value. |
| optimizer_capture_sql_plan_baselines | Specifies whether to enable automatic capture of SQL plan baselines. |
| auto_increment_offset | Determines the starting point for AUTO_INCREMENT column values. |
| ob_read_consistency | Read Consistency Level. |
| block_encryption_mode | Specifies the encryption algorithm to use in the aes_encrypt and aes_decrypt functions. |
| sql_throttle_cpu | When the CPU utilization exceeds this value, the SQL statement will not be executed. |
| error_on_overlap_time | Dynamic parameter that specifies whether to report an error for ambiguous times during a daylight saving time overlap. |
| interactive_timeout | Number of seconds the server waits for activity on an interactive connection before closing it. An interactive client uses the CLIENT_INTERACTIVE option in mysql_real_connect(). See also wait_timeout. |
| query_cache_size | The size of memory allocated for storing old query results (not yet in use), in bytes. |
| max_allowed_packet | Maximum packet size in bytes. Default value: 4194304. Value range: [1024, 1073741824]. |
| ob_query_timeout | Query timeout period, in microseconds. |
| sql_throttle_priority | The SQL priority threshold. SQL statements with a priority lower than this value will not be executed. |
| ob_plan_cache_evict_high_percentage | Percentage of the plan cache memory limit that triggers plan eviction. |
| explicit_defaults_for_timestamp | Specifies whether to enable non-standard behavior for the TIMESTAMP data type when processing default and null values. |
| sql_mode | Set the SQL mode. Different SQL modes have a significant impact on database behavior. |
| optimizer_use_sql_plan_baselines | Whether to enable SQL plan baselines. |
| sql_warnings | Whether a single-row INSERT statement generates an information string when warnings occur. |
| group_concat_max_len | Maximum length allowed for the result of the GROUP_CONCAT() function. Unit: bytes |
| sql_throttle_current_priority | Priority of SQL Throttling |