tencent cloud

Feedback

Modification Records of System Parameter Templates

Last updated: 2022-06-13 15:37:16

    TencentDB for MySQL provides system parameter templates for batch parameter settings. The parameters in system parameter templates may be optimized and updated with MySQL iteration. This document describes the update history of the parameters in system parameter templates.

    Note:

    • If the parameters in the template are updated, the instance parameters are not updated unless they are manually re-applied to the instances. You can apply the parameter changes to single or multiple instances by importing a template.
    • For directions on how to use system parameter templates, see Managing Parameter Template.

    March 2022

    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

    November 2020

    Parameter MySQL 8.0 Change Description
    iinnodb_flush_log_at_trx_commit New parameter
    sync_binlog New parameter
    local_infile New parameter
    innodb_log_file_size New parameter
    cdb_recycle_bin_enabled New parameter
    binlog_format New valid value: 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 valid values: [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 valid values: LOGICAL_CLOCK|TABLE|DATABASE

    August 2020

    Parameter MySQL 5.6 MySQL 5.7 Change Description
    log_warnings New parameter
    innodb_flush_log_at_trx_commit New parameter
    sync_binlog New parameter
    local_infile New parameter
    innodb_log_file_size New parameter
    binlog_format New valid 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 valid values: [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 (including the parameter)
    cdb_more_gtid_feature_supported - New default value: OFF
    slave_parallel_workers - All kernel features supported (including the parameter)
    tls_version - Removed
    slave_rows_search_algorithms New default value: TABLE_SCAN,INDEX_SCAN,HASH_SCAN
    innodb_open_files New default value: 10240

    August 2020

    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
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support