This topic describes the parameters of the current tenant.
Parameter list
| Parameter | Description |
|---|---|
| connect_timeout | The connection timeout, in seconds. |
| ob_check_sys_variable | If this parameter is enabled, the system variables are updated when the schema version changes. |
| writing_throttling_maximum_duration | The time required to allocate the remaining memory in the memstore after write throttling is triggered. This parameter is used to control the write speed by controlling the memory allocation progress. |
| div_precision_increment | The increment of the precision of the result of a division operation based on the precision of the dividend. This is a MySQL compatible feature. |
| ob_sql_work_area_percentage | The percentage of tenant memory that can be used for SQL execution. |
| tx_isolation | The transaction isolation level. |
| wait_timeout | The number of seconds that the server waits for activity before closing a noninteractive connection. When a thread is started, the session wait_timeout value is initialized based on the global wait_timeout value or the global interactive_timeout value, depending on the client type (defined by the CLIENT_INTERACTIVE option in mysql_real_connect()). See also interactive_timeout. |
| auto_increment_increment | The increment of the auto-increment column. This parameter is used only for MySQL clients. |
| foreign_key_checks | Specifies whether to check foreign key constraints. |
| autocommit | Specifies whether to automatically commit. |
| read_only | Specifies whether the tenant is in read-only mode. This affects all regular users in the tenant but does not affect users with root privileges. |
| transaction_isolation | The transaction isolation level. |
| ob_trx_timeout | The transaction timeout, in microseconds. |
| net_read_timeout | The number of seconds that the server waits for other data on the connection before interrupting a read. When the server reads data from the client, the net_read_timeout parameter specifies the timeout value that determines when to interrupt the read. When the server writes data to the client, the net_write_timeout parameter specifies the timeout value that determines when to interrupt the write. |
| ob_enable_index_direct_select | Specifies whether to allow users to directly query the index table. |
| ob_trx_lock_timeout | The lock wait timeout for a transaction, in microseconds. |
| sql_throttle_rt | The threshold value of the response time (RT) in microseconds. If the RT of a query is greater than or equal to this value, the query is not executed. |
| ob_enable_transmission_checksum | Specifies whether to enable packet checksums between the proxy and the server. |
| writing_throttling_trigger_percentage | The threshold for controlling the write speed. |
| ob_plan_cache_evict_low_percentage | The percentage of memory usage at which the plan cache is stopped from being evicted. |
| ob_plan_cache_percentage | The percentage of tenant memory resources that can be used for the plan cache. |
| max_sp_recursion_depth | The maximum number of times a given stored procedure can be recursively called. |
| sql_throttle_network | The network usage threshold. If the network usage exceeds this threshold, the SQL statement is not executed. |
| undo_retention | The time for which multiple versions of data are retained, in seconds. |
| query_cache_type | The type of query cache.
|
| sql_throttle_logical_reads | The threshold for the number of logical reads. If the number of logical reads exceeds this threshold, the SQL statement is not executed. |
| auto_increment_cache_size | The number of entries in the auto-increment cache. |
| sql_auto_is_null | Specifies whether to retrieve the value of the auto-increment column in the last inserted row. This parameter is used by some special drivers, such as ODBC. |
| recyclebin | The recycle bin switch. If this parameter is enabled, deleted database objects are moved to the recycle bin. |
| ob_enable_plan_cache | Specifies whether to enable the Plan Cache. |
| ob_enable_aggregation_pushdown | Specifies whether to allow aggregation operations to be pushed down. |
| net_write_timeout | The number of seconds that the server waits for a block to be written to the connection before interrupting a write. When the server reads data from the client, the net_read_timeout parameter specifies the timeout value that determines when to interrupt the read. When the server writes data to the client, the net_write_timeout parameter specifies the timeout value that determines when to interrupt the write. |
| ob_enable_transformation | Specifies whether to allow SQL rewriting. |
| sql_quote_show_create | Specifies whether to quote identifiers in the SHOW CREATE TABLE and SHOW CREATE DATABASE statements. |
| sql_throttle_io | The threshold for the number of I/O operations. If the number of I/O operations exceeds this threshold, the SQL statement is not executed. |
| ob_enable_jit | The mode of the Just-In-Time (JIT) execution engine.
|
| max_stale_time_for_weak_consistency | The maximum allowed synchronization delay between the standby database and the primary database for weak-consistency reads. |
| ob_enable_truncate_flashback | Specifies whether to move the objects of a TRUNCATE operation to the recycle bin. |
| ob_trx_idle_timeout | The transaction idle timeout, in microseconds. A transaction is considered idle if the execution interval between two statements in the transaction exceeds this value. |
| optimizer_capture_sql_plan_baselines | Specifies whether to automatically capture SQL plan baselines. |
| auto_increment_offset | The starting value of the AUTO_INCREMENT column. |
| ob_read_consistency | The read consistency level. |
| block_encryption_mode | The encryption algorithm used in the aes_encrypt and aes_decrypt functions. |
| sql_throttle_cpu | The CPU usage threshold. If the CPU usage exceeds this threshold, the SQL statement is not executed. |
| error_on_overlap_time | A dynamic parameter that specifies whether to return an error when there is ambiguity in the overlap time zone. |
| interactive_timeout | The number of seconds that the server waits for activity before closing an interactive connection. An interactive client is defined as a client that uses the CLIENT_INTERACTIVE option in mysql_real_connect(). See also wait_timeout. |
| query_cache_size | The size of memory allocated for storing unused query results, in bytes. |
| max_allowed_packet | The maximum size of a network packet, in bytes. Default value: 4194304. Value range: [1024, 1073741824]. |
| ob_query_timeout | The query timeout, in microseconds. |
| sql_throttle_priority | The SQL priority threshold. SQL statements with a priority lower than this threshold are not executed. |
| ob_plan_cache_evict_high_percentage | The percentage of memory usage at which the plan cache is evicted. |
| explicit_defaults_for_timestamp | Specifies whether to enable non-standard behavior for the timestamp data type when handling default values and NULL values. |
| sql_mode | The SQL mode. Different SQL modes significantly affect database behavior. |
| optimizer_use_sql_plan_baselines | Specifies whether to use SQL plan baselines. |
| sql_warnings | Specifies whether to generate an information string for each INSERT statement when an alert occurs. |
| group_concat_max_len | Specifies the maximum length of the result of the GROUP_CONCAT() function. The unit is bytes. |
| sql_throttle_current_priority | Specifies the current priority of SQL throttling. |