To optimize the performance and security of ApsaraDB RDS for MySQL databases, Alibaba Cloud changes the default parameter templates of RDS for MySQL. This topic describes the changed parameter templates.
MySQL 8.0
New parameters
Parameter | Default value | Dynamic | Value range | Value type | Minor engine version | Release date |
loose_ssl_cipher | "ALL:@SECLEVEL=0" | No | [""|"ALL:@SECLEVEL=0"] | Text | 20230930 or later | From January 08, 2024 |
loose_slave_parallel_workers | {GREATEST(DBInstanceClassCPU, 8)} | Yes | [0-1024] | Integer | Not limited | From November 10, 2023 |
loose_innodb_log_writer_threads | ON | Yes | [ON|OFF] | Text | 20201231 or later | From March 19, 2024 |
loose_log_error_suppression_list | MY-010520,MY-013360 | Yes | .* | Text | Not limited | From March 19, 2024 |
loose_oss_max_connections | 64 | Yes | [1-2048] | Integer | [20240131,99999999) | From April 15, 2024 |
loose_kill_idle_transaction_timeout | 0 | Yes | [0-31536000] | Integer | [20190601, 99999999) | From March 13, 2024 |
loose_xa_detach_on_prepare | ON | Yes | [ON|OFF] | Text | [20230630,99999999) | From April 01, 2024 |
loose_session_track_system_variables | No default value | Yes | .* | Text | Not limited | From July 07, 2024 |
loose_rpl_semi_sync_master_timeout | 1000 | Yes | [0-18446744073709551615] | Integer | Not limited | From July 19, 2024 |
Changed parameters
Parameter | Change item | Before | After | Release date |
tls_version | Value range | [TLSv1,TLSv1.1,TLSv1.2|TLSv1,TLSv1.1|TLSv1.2] | [TLSv1,TLSv1.1,TLSv1.2|TLSv1,TLSv1.1,TLSv1.2,TLSv1.3|TLSv1,TLSv1.1|TLSv1.2|TLSv1.2,TLSv1.3] | From December 22, 2023 |
innodb_buffer_pool_size | Dynamic parameter | No | Yes | From December 14, 2023 |
init_connect | Value range | [''|'set names utf8mb4'|'set names utf8'|'set default_collation_for_utf8mb4=utf8mb4_general_ci'|'set default_collation_for_utf8mb4=utf8mb4_general_ci;set names utf8mb4'|'set names utf8mb4 collate utf8mb4_general_ci'] | [''|'set names utf8mb4'|'set names utf8'|'set default_collation_for_utf8mb4=utf8mb4_general_ci'|'set default_collation_for_utf8mb4=utf8mb4_general_ci;set names utf8mb4'|'set names utf8mb4 collate utf8mb4_general_ci'|'set names utf8mb4 COLLATE utf8mb4_bin'] | From December 14, 2023 |
character_set_server | Dynamic parameter | No | Yes | From October 18, 2023 |
innodb_open_files | Value range | [1-8192] | [10-2147483647] | From October 17, 2023 |
collation_server | Dynamic parameter | No | Yes | From September 18, 2023 |
innodb_purge_batch_size | Restart required | Yes | No | From March 19, 2024 |
Dynamic parameter | No | Yes | ||
innodb_segment_reserve_factor | Data alignment required | 0 | 2 | From March 13, 2024 |
loose_binlog_parallel_flush | Default value | OFF | {LEAST(DBInstanceClassCPU/16, 1)} | From April 18, 2024 |
Minor engine version | [20230324,99999999) | [20230930,99999999) | From April 18, 2024 | |
innodb_max_dirty_pages_pct_lwm | Default value | 0 | 10 | From June 21, 2024 |
performance_schema | Default value | {LEAST(DBInstanceClassMemory/8589934592, 1)} | {LEAST(DBInstanceClassMemory/68719476736, 1)} | From June 26, 2024 |
loose_thread_pool_size | Default value | {GREATEST(DBInstanceClassCPU/2, 1)} | {LEAST(DBInstanceClassCPU*2, 64)} | From June 27, 2024 |
innodb_sync_array_size | Default value | 1 | 128 | From June 27, 2024 |
Value range | [1-64] | [1-1024] | From June 27, 2024 | |
tmp_table_size | Value range | [262144-134217728] | [262144-268435456] | From July 15, 2024 |
MySQL 5.7
New parameters
Parameter | Default value | Dynamic | Value range | Value type | Minor engine version | Release date |
loose_slave_parallel_workers | {GREATEST(DBInstanceClassCPU, 8)} | Yes | [0-1024] | Integer | Not limited | From November 10, 2023 |
loose_ssl_cipher | "ALL:@SECLEVEL=0" | No | [""|"ALL:@SECLEVEL=0"] | Text | 20231215 or later | From January 08, 2024 |
loose_session_track_system_variables | No default value | Yes | .* | Text | Not limited | From July 07, 2024 |
loose_rpl_semi_sync_master_timeout | 1000 | Yes | [0-18446744073709551615] | Integer | Not limited | From July 19, 2024 |
Changed parameters
Parameter | Change item | Before | After | Release date |
tls_version | Valid values | [TLSv1,TLSv1.1,TLSv1.2|TLSv1,TLSv1.1|TLSv1.2 | [TLSv1,TLSv1.1,TLSv1.2|TLSv1,TLSv1.1,TLSv1.2,TLSv1.3|TLSv1,TLSv1.1|TLSv1.2|TLSv1.2,TLSv1.3] | From December 22, 2023 |
Value range | [TLSv1,TLSv1.1,TLSv1.2|TLSv1,TLSv1.1,TLSv1.2,TLSv1.3|TLSv1,TLSv1.1|TLSv1.2|TLSv1.2,TLSv1.3] | [TLSv1,TLSv1.1,TLSv1.2|TLSv1,TLSv1.1|TLSv1.2] | From March 26, 2024 | |
innodb_buffer_pool_size | Dynamic parameter | No | Yes | From December 14, 2023 |
init_connect | Value range | [''|'set names utf8mb4'|'set names utf8'|'set default_collation_for_utf8mb4=utf8mb4_general_ci'|'set default_collation_for_utf8mb4=utf8mb4_general_ci;set names utf8mb4'|'set names utf8mb4 collate utf8mb4_general_ci'] | [''|'set names utf8mb4'|'set names utf8'|'set default_collation_for_utf8mb4=utf8mb4_general_ci'|'set default_collation_for_utf8mb4=utf8mb4_general_ci;set names utf8mb4'|'set names utf8mb4 collate utf8mb4_general_ci'|'set names utf8mb4 COLLATE utf8mb4_bin'] | From December 14, 2023 |
character_set_server | Dynamic parameter | No | Yes | From September 20, 2023 |
innodb_open_files | Value range | [1-8192] | [10-2147483647] | From October 17, 2023 |
innodb_purge_batch_size | Restart required | Yes | No | From March 19, 2024 |
innodb_max_dirty_pages_pct_lwm | Default value | 0 | 10 | From June 21, 2024 |
innodb_sync_array_size | Default value | 1 | 128 | From June 27, 2024 |
Value range | [1-64] | [1-1024] | From June 27, 2024 | |
loose_rds_auto_increment_consistency | Default value | ON | OFF | From July 10, 2024 |
tmp_table_size | Value range | [262144-134217728] | [262144-268435456] | From July 15, 2024 |
MySQL 5.6
New parameters
Parameter | Default value | Dynamic | Value range | Value type | Minor engine version | Release date |
loose_session_track_state_change | OFF | Yes | [ON|OFF] | Text | Not limited | From July 04, 2024 |
loose_session_track_system_variables | No default value | Yes | .* | Text | Not limited | From July 07, 2024 |
Changed parameters
Parameter | Change item | Before | After | Release date |
innodb_max_dirty_pages_pct_lwm | Default value | 0 | 10 | From June 21, 2024 |
innodb_sync_array_size | Default value | 1 | 128 | From June 27, 2024 |
Value range | [1-64] | [1-1024] | From June 27, 2024 | |
tmp_table_size | Value range | [262144-134217728] | [262144-268435456] | From July 15, 2024 |
open_files_limit | Default value | 65535 | 655350 | From July 19, 2024 |