Modification Records of System Parameter Templates
Download
Focus Mode
Font Size
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.
June 2026
Parameter Name | MySQL 8.0 | Change Description |
binlog_transaction_dependency_history_size | ✓ | Templates involved: high-stability and high-performance templates Engine involved: InnoDB Before the change Default value: 25000 After the change Default value: 500000 |
March 2026
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.6 | MySQL 5.7 | MySQL 8.0 | Change Description |
time_zone | ✓ | ✓ | ✓ | Templates involved: high-stability, high-performance, and RocksDB default templates Engines involved: InnoDB and RocksDB Before the change Modifiable values for the parameter:  After the change Modifiable values for the parameter:  For the specific modifiable values, refer to those displayed when modifying parameters in the console. To modify parameters, see Setting Instance Parameters. |
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 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. |
March 2022
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. |
May 2021
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. |
Help and Support
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback