tencent cloud

TencentDB for MySQL

DocumentationTencentDB for MySQLOperation GuideParameter ConfigurationModification Records of System Parameter Templates

Modification Records of System Parameter Templates

PDF
Focus Mode
Font Size
Last updated: 2026-04-08 14:50:10
TencentDB for MySQL provides system parameter templates for setting parameters in batches. The parameters in these templates may be optimized and updated with version iterations. This document describes the change records of parameters in the system parameter templates.
Note:
Changes to parameters in the system parameter template do not affect database instances that have already used the template. If you need to apply the new parameters to batch instances, you can reapply them by importing the template when parameters are set in batches.
Using system parameter templates, see Using Parameter Templates.

March 2026

Add new parameters
Change of parameter settings
Parameter Name
MySQL 5.7
MySQL 8.0
Change Description
txsql_json_full_precision
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
thread_pool_stall_limit
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
innodb_flush_redo_using_fdatasync
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
binlog_group_commit_sync_delay
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
binlog_group_commit_sync_no_delay_count
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
innodb_hot_update_detect
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
innodb_hot_update_threshold
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
slave_exec_mode
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
sync_relay_log
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
thread_pool_high_prio_mode
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
thread_pool_high_prio_tickets
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
thread_pool_idle_timeout
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
thread_pool_max_threads
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
binlog_transaction_dependency_history_size
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
cdb_column_compression_enabled
✓
-
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
innodb_column_compression_zlib_strategy
✓
-
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
innodb_column_compression_threshold
✓
-
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
innodb_column_compression_pct
✓
-
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
cdb_normalize_decimal_number
✓
-
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
cdb_recyle_innodb_dict_threshold
✓
-
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
innodb_dict_cache_overload_limit
✓
-
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
innodb_column_compression_zlib_wrap
✓
-
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
txsql_parallel_final_aggregate_pass_through
-
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
mysqlx_max_connections
-
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
internal_tmp_mem_storage_engine
-
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
binlog_row_metadata
-
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
sql_generate_invisible_primary_key
-
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
sql_require_primary_key
-
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
innodb_log_writer_threads
-
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
txsql_column_compression_enabled
-
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
innodb_zlib_column_compression_level
-
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
innodb_zstd_column_compression_level
-
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Adding parameters
Parameter Name
MySQL 5.7
MySQL 8.0
Change Description
binlog_row_image
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Before the change
Modifiable values for the parameter: [FULL | MINIMAL]
After the change
Modifiable values for the parameter: [FULL | MINIMAL | NOBLOB]
innodb_online_alter_log_max_size
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Before the change
Modifiable values for the parameter: [134217728 - 2147483647]
After the change
Modifiable values for the parameter: [65536 - 9223372036854770000]

December 2024

Parameter Name
MySQL 5.6
MySQL 5.7
MySQL 8.0
Change Description
innodb_stats_persistent_sample_pages
✓
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Before the change
Default value: 20
After the change
Default value: 200

November 2024

Parameter Name
MySQL 5.6
MySQL 5.7
MySQL 8.0
Change Description
explicit_defaults_for_timestamp
✓
✓
✓
Templates involved: high-stability and high-performance templates
Engines involved: InnoDB and RocksDB
Before the change
Whether to take effect after reboot: Yes
After the change
Whether to take effect after reboot: No
innodb_page_cleaners
-
✓
✓
Templates involved: high-stability and high-performance templates
Engine involved: InnoDB
Before the change
Default value: 4
After the change
Default value: 8

September 1, 2024

Parameter Name
MySQL 5.7
MySQL 8.0
Change Description
innodb_table_drop_mode
✓
✓
Templates involved: high-stability
Engine involved: InnoDB
Before the change
Default value: SYNC_DROP
After the change
Default value: ASYNC_DROP

March 2024

Parameter Name
MySQL 5.6
MySQL 5.7
MySQL 8.0
Change Description
slave_parallel_workers
✓
✓
✓
Templates involved: high-performance/high-stability
Engine involved: InnoDB/RocksDB
Before the change
Parameter range: [0 | 1 | 2 | 4 | 8 | 16 | 32 | 64]
Default value: 0
After the change
Parameter range: [0-64]
Default value: {MIN(DBInitCpu*2,64)}

January 2024

Parameter Name
MySQL 5.6
MySQL 5.7
MySQL 8.0
Change Description
thread_pool_oversubscribe
✓
✓
✓
Change to the default value of the thread_pool_oversubscribe parameter in the high-performance parameter template for MySQL 5.6, 5.7, and 8.0
Previous default value: 10
New default value: 16

December 2023

Parameter Name
MySQL 5.6
MySQL 5.7
MySQL 8.0
Change Description
thread_pool_oversubscribe
✓
✓
✓
Change to the default value of the thread_pool_oversubscribe parameter
Previous default value: 3
New default value: 10

August 2023

Parameter Name
MySQL 5.7
MySQL 8.0
Change Description
innodb_fast_ahi_cleanup_for_drop_table
✓
✓
Change to the default value of the innodb_fast_ahi_cleanup_for_drop_table parameter
Previous default value: OFF
New default value: ON

June 2023

Parameter Name
MySQL 5.5
MySQL 5.6
MySQL 5.7
MySQL 8.0
Change Description
time_zone
✓
✓
✓
✓
Change to the default value of the time_zone parameter
Previous default value: SYSTEM
New default value: +8:00

May 2023

Parameter Name
MySQL 5.7
MySQL 8.0
Change Description
innodb_async_truncate_work_enabled
✓
-
Change to the switch parameter for the asynchronous table deletion feature in version 5.7
The parameter has been changed from innodb_async_truncate_work_enabled to innodb_table_drop_mode. (May 15, 2023)
innodb_parallel_ddl
-
✓
The parameter was decommissioned (May 5, 2023).

March 2023

Parameter Name
MySQL 5.7
MySQL 8.0
Change Description
innodb_temp_data_file_path
✓
✓
Change to the default value of the innodb_temp_data_file_path parameter
Previous default value: ibtmp1:12M:autoextend
New default value: ibtmp1:12M:autoextend:max:1048576M

January 2023

Parameter Name
MySQL 5.7
MySQL 8.0
Change Description
max_execution_time
✓
✓
The max_execution_time parameter supports dynamic configuration.
Whether a restart is required: No
Default value: 0
Modifiable range of the parameter: 0 - 4294967295
Unit: ms.

August 2022

Parameter Name
MySQL 5.7
MySQL 8.0
Change Description
innodb_buffer_pool_size
✓
✓
The innodb_buffer_pool_size parameter supports dynamic configuration.
Whether a restart is required: No
Default value: {DBInitMemory * 786432}
Modifiable range of the parameter: {DBInitMemory * 524288} - {DBInitMemory * 943718}
DBinitMemory refers to the memory size of the instance specification rounded to the nearest integer.

July 2022

Parameter Name
MySQL 5.7
MySQL 8.0
Change Description
innodb_temp_data_file_path
✓
✓
The innodb_temp_data_file_path parameter (temporary tablespace size) supports modification with the following properties:
Whether a restart is required: Yes
Default value: ibtmp1:12M:autoextend
Modifiable range: ibtmp1 is 12 - 1024MB. After autoextend is selected, the maximum value that can be set for max is 2097152MB.

22-Mar

Parameter Name
MySQL 5.6
MySQL 5.7
MySQL 8.0
Change Description
innodb_open_files
✓
✓
✓
Parameter decommissioned.
innodb_stats_sample_pages
-
✓
✓
Parameter decommissioned.
wait_timeout
✓
✓
✓
Parameter range updated to: 1 - 31536000.
thread_cache_size
✓
✓
✓
Parameter range updated to: 1 - 16384.

December 2021

Parameter Name
MySQL 5.6
MySQL 5.7
MySQL 8.0
Change Description
binlog_row_image
✓
✓
✓
The default value for the parameter is uniformly set to FULL. Note that for instances created earlier, the default value of this parameter is MINIMAL, and manual modification is supported.

21-May

Parameter Name
MySQL 5.6
MySQL 5.7
MySQL 8.0
Change Description
back_log
✓
✓
✓
Templates involved: high-stability and high-performance templates
Engines involved: InnoDB and RocksDB
Before the change
Default value: 900
After the change
Default value: 3000

November 2020

Parameter Name
MySQL 8.0
Change Description
iinnodb_flush_log_at_trx_commit
✓
Parameters Added
sync_binlog
✓
Parameters Added
local_infile
✓
Parameters Added
innodb_log_file_size
✓
Parameters Added
cdb_recycle_bin_enabled
✓
Parameters Added
binlog_format
✓
Update the parameter range value to: row.
innodb_autoinc_lock_mode
✓
Parameter default value updated to: 2.
table_open_cache
✓
Parameter default value updated to: 2000.
slave_pending_jobs_size_max
✓
Parameter default value updated to: 1073741824.
time_zone
✓
Parameter range value updated to: [SYSTEM|-12:00|-11:00|-10:00|-09:00|-08:00|-07:00|-06:00|.
-05:00|-04:00|-03:00|-02:00|-01:00|+00:00|+01:00|+02:00|+03:00|+04:00|+05:00|
+05:30|+06:00|+06:30|+07:00|+08:00|+09:00|+10:00|+11:00|+12:00|+13:00]
max_connections
✓
Parameter range updated to: 1 - 100000.
slave_rows_search_algorithms
✓
Parameter default value updated to: TABLE_SCAN,INDEX_SCAN,HASH_SCAN.
innodb_open_files
✓
Parameter default value updated to: 10240.
slave_parallel_type
✓
Parameter range value updated to: LOGICAL_CLOCK|TABLE|DATABASE.

August 2020

Parameter Name
MySQL 5.6
MySQL 5.7
Change Description
log_warnings
✓
✓
Parameters Added
innodb_flush_log_at_trx_commit
✓
✓
Parameters Added
sync_binlog
✓
✓
Parameters Added
local_infile
✓
✓
Parameters Added
innodb_log_file_size
✓
✓
Parameters Added
binlog_format
✓
✓
Update the parameter range value to: row.
innodb_autoinc_lock_mode
✓
✓
Parameter default value updated to: 2.
innodb_open_files
✓
✓
Parameter range updated to: 1 - 102400.
table_open_cache
✓
✓
Parameter default value updated to: 2000.
slave_pending_jobs_size_max
✓
✓
Parameter default value updated to: 1GB.
time_zone
✓
✓
Parameter range value updated to: [SYSTEM|-12:00|-11:00|-10:00|-09:00|-08:00|-07:00|-06:00|.
-05:00|-04:00|-03:00|-02:00|-01:00|+00:00|+01:00|+02:00|+03:00|+04:00|+05:00|
+05:30|+06:00|+06:30|+07:00|+08:00|+09:00|+10:00|+11:00|+12:00|+13:00]
max_connections
✓
✓
Parameter range updated to: 1 - 100000.
cdb_more_gtid_feature_supported
-
✓
Full kernel features
cdb_more_gtid_feature_supported
✓
-
Parameter default value updated to: OFF.
slave_parallel_workers
-
✓
Full kernel features
tls_version
-
✓
Parameter decommissioned.
slave_rows_search_algorithms
✓
✓
Parameter default value updated to: TABLE_SCAN,INDEX_SCAN,HASH_SCAN.
innodb_open_files
✓
✓
Parameter default value updated to: 10240.

August 2020

Parameter Name
MySQL 5.5
Change Description
slave_rows_search_algorithms
✓
Parameter default value updated to: TABLE_SCAN,INDEX_SCAN,HASH_SCAN.
innodb_open_files
✓
Parameter default value updated to: 10240.
Previous Topic: Intelligent Parameter TuningNext Topic: Backing up Databases

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback