Parameter | MySQL 5.6 | MySQL 5.7 | MySQL 8.0 | Change Description |
thread_pool_oversubscribe | ✓ | ✓ | ✓ | Changes in Default Value of thread_pool_oversubscribe Parameter in High-Performance Parameter Templates for MySQL 5.6, 5.7, 8.0. Previous Default Value: 10 Updated Default Value: 16 |
Parameter | MySQL 5.6 | MySQL 5.7 | MySQL 8.0 | Change Description |
thread_pool_oversubscribe | ✓ | ✓ | ✓ | The default value for the parameter 'thread_pool_oversubscribe' has been modified. Previous Default Value: 3 Updated Default Value: 10 |
Parameter | MySQL 5.7 | MySQL 8.0 | Change Description |
innodb_fast_ahi_cleanup_for_drop_table | ✓ | ✓ | The default value for the parameter 'innodb_fast_ahi_cleanup_for_drop_table' has been altered. Previous Default Value: OFF Updated Default Value: ON |
Parameter | MySQL 5.5 | MySQL 5.6 | MySQL 5.7 | MySQL 8.0 | Change Description |
time_zone | ✓ | ✓ | ✓ | ✓ | Modification of Default Value for the 'time_zone' Parameter Previous Default Value: SYSTEM Updated Default Value: +8:00 |
Parameter | MySQL 5.7 | MySQL 8.0 | Change Description |
innodb_async_truncate_work_enabled | ✓ | - | 5.7 Version Asynchronous Table Deletion Function Switch Parameter Modification The parameter has been changed from innodb_async_truncate_work_enabled to innodb_table_drop_mode. (May 15, 2023) |
innodb_parallel_ddl | - | ✓ | Parameter Deprecation (May 5, 2023) |
Parameter | MySQL 5.7 | MySQL 8.0 | Change Description |
innodb_temp_data_file_path | ✓ | ✓ | Modification of Default Value for innodb_temp_data_file_path Parameter Prior Default Value:ibtmp1:12M:autoextend Altered Default Value:ibtmp1:12M:autoextend:max:1048576M |
Parameter | MySQL 5.7 | MySQL 8.0 | Change Description |
max_execution_time | ✓ | ✓ | Dynamic setting is supported for max_execution_time Restart required: No Default value: 0 Value range: 0–4294967295 Unit: ms |
Parameter | MySQL 5.7 | MySQL 8.0 | Change Description |
innodb_buffer_pool_size | ✓ | ✓ | Dynamic setting is supported for innodb_buffer_pool_size Restart required: No Default value: {DBInitMemory * 786432} Value range: {DBInitMemory * 524288} - {DBInitMemory * 943718} DBinitMemory: An integer of instance memory size |
Parameter | MySQL 5.7 | MySQL 8.0 | Change Description |
innodb_temp_data_file_path | ✓ | ✓ | Parameter modification is supported for innodb_temp_data_file_path (temp tablespace size) and the parameter properties are as follows: Restart required: Yes Default value: ibtmp1:12M:autoextend Value range of ibtmp : 12 MB - 1024 MB. After you select autoextend , the maximum value can be set to 2097152 MB |
Parameter | MySQL 5.6 | MySQL 5.7 | MySQL 8.0 | Change Description |
innodb_open_files | ✓ | ✓ | ✓ | Removed |
innodb_stats_sample_pages | - | ✓ | ✓ | Removed |
wait_timeout | ✓ | ✓ | ✓ | New value range: 1–31536000 |
thread_cache_size | ✓ | ✓ | ✓ | New value range: 1–16384 |
Parameter | MySQL 5.6 | MySQL 5.7 | MySQL 8.0 | Change Description |
binlog_row_image | ✓ | ✓ | ✓ | Default value: FULL . For the early created instances, the default value is MINIMAL . Manual modification is supported. |
Parameter | MySQL 8.0 | Change Description |
iinnodb_flush_log_at_trx_commit | ✓ | Parameter added |
sync_binlog | ✓ | Parameter added |
local_infile | ✓ | Parameter added |
innodb_log_file_size | ✓ | Parameter added |
cdb_recycle_bin_enabled | ✓ | Parameter added |
binlog_format | ✓ | New value range: row |
innodb_autoinc_lock_mode | ✓ | New default value: 2 |
table_open_cache | ✓ | New default value: 2000 |
slave_pending_jobs_size_max | ✓ | New default value: 1073741824 |
time_zone | ✓ | New value range: [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 | ✓ | New value range: 1–100000 |
slave_rows_search_algorithms | ✓ | New default value: TABLE_SCAN,INDEX_SCAN,HASH_SCAN |
innodb_open_files | ✓ | New default value: 10240 |
slave_parallel_type | ✓ | New value range: LOGICAL_CLOCK|TABLE|DATABASE |
Parameter | MySQL 5.6 | MySQL 5.7 | Change Description |
log_warnings | ✓ | ✓ | Parameter added |
innodb_flush_log_at_trx_commit | ✓ | ✓ | Parameter added |
sync_binlog | ✓ | ✓ | Parameter added |
local_infile | ✓ | ✓ | Parameter added |
innodb_log_file_size | ✓ | ✓ | Parameter added |
binlog_format | ✓ | ✓ | New range value: row |
innodb_autoinc_lock_mode | ✓ | ✓ | New default value: 2 |
innodb_open_files | ✓ | ✓ | New value range: 1–102400 |
table_open_cache | ✓ | ✓ | New default value: 2000 |
slave_pending_jobs_size_max | ✓ | ✓ | New default value: 1 GB |
time_zone | ✓ | ✓ | New value range: [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 | ✓ | ✓ | New value range: 1–100000 |
cdb_more_gtid_feature_supported | - | ✓ | All kernel features supported |
cdb_more_gtid_feature_supported | ✓ | - | New default value: off |
slave_parallel_workers | - | ✓ | All kernel features supported |
tls_version | - | ✓ | Removed |
slave_rows_search_algorithms | ✓ | ✓ | New default value: TABLE_SCAN,INDEX_SCAN,HASH_SCAN |
innodb_open_files | ✓ | ✓ | New default value: 10240 |
Parameter | MySQL 5.5 | Change Description |
innodb_autoinc_lock_mode | ✓ | New default value: TABLE_SCAN,INDEX_SCAN,HASH_SCAN |
innodb_open_files | ✓ | New default value: 10240 |
Was this page helpful?