This topic provides information about the parameters related to tenants.
Parameter list
| Parameter Name | Description | Default Value | Requires Restart | Valid Values |
|---|---|---|---|---|
| kv_ttl_history_recycle_interval | The interval for recycling TTL history task records. | 7d | No | [1d-180d] |
| net_write_timeout | The number of seconds to wait for a block to be written to a connection before aborting the write. When the server reads from the client, net_read_timeout controls the timeout for interruption; when the server writes to the client, net_write_timeout controls the timeout for interruption. | 60 | No | [1-31536000] |
| max_allowed_packet | Maximum network packet size in bytes. | 16777216 | No | [1024-1073741824] |
| writing_throttling_maximum_duration | Controls write speed by regulating memory allocation progress. Specifies the time needed to allocate remaining memstore memory after write throttling is triggered. | 2h | No | [1s-3h] |
| enable_kv_ttl | Whether to enable TTL functionality. | FALSE | No | [True|False] |
| writing_throttling_trigger_percentage | Sets the threshold for write speed control. | 60 | No | [1-100] |
| auto_increment_increment | Auto-increment step value, only used for MySQL client login. | 1 | No | [1-65535] |
| auto_increment_offset | Determines the starting point for AUTO_INCREMENT column values. | 1 | No | [1-65535] |
| net_read_timeout | The number of seconds to wait for more data from a connection before aborting the read. When the server reads from the client, net_read_timeout controls the timeout for interruption; when the server writes to the client, net_write_timeout controls the timeout for interruption. | 30 | No | [1-31536000] |
| sql_auto_is_null | Used by some special drivers like ODBC to control whether to retrieve the auto-increment value of the last inserted row. | OFF | No | [OFF-ON] |
| auto_increment_cache_size | The cache size for auto-increment values. | 1000000 | No | [1-100000000] |
| block_encryption_mode | Specifies the encryption algorithm used in aes_encrypt and aes_decrypt functions. | aes-128-ecb | No | [aes-128-ecb|aes-192-ecb] |
| lob_enable_block_cache_threshold | Sets the threshold for caching LOB queries stored in OUTROW. If the length is less than or equal to this threshold, it enters the micro-block cache to accelerate subsequent queries. | 256K | No | [0B-512M] |
| kv_ttl_duty_duration | The execution time period for daily TTL scheduled tasks. | Empty (task disabled) | No | [begin_time, end_time], e.g., [00:00:00, 03:00:00] |