• 久久商务网-为您的企业赋予能量!
  • 请您点击以下按钮完成验证,进行域名检索。

    取消
    231
    MySQL实例自定义参数设置

    云数据库SQL Server实例不支持修改参数,MySQL实例支持修改参数,具体参数列表见下文MySQL参数列表。

    修改参数

    1.登录控制台->云数据库->管理云数据库实例。



    2. 找到需要设置参数的目标实例,单击管理


    3. 在云数据库详情页面最右侧点击参数设置


    4. 修改参数后,点击预览,预览修改的参数


    5. 点击保存,保存参数修改

    导入参数

    1. 在参数设置页面,更多操作->导入参数


    2. 在导入参数弹出窗口,单击确定导入参数

    • 多参数导入, 请以换行形式进行
    • 导入参数值为字符时参数名与参数值之间不能有空格,如binlog_checksum=CRC32
    • 支持导入的参数见下文MySQL参数列表


    MySQL参数列表

    auto_increment_increment= 10
    auto_increment_offset= 5
    back_log= 3000
    binlog_cache_size= 2097152
    binlog_checksum=CRC32
    binlog_order_commits=ON
    binlog_rows_query_log_events=OFF
    binlog_row_image=full
    binlog_stmt_cache_size=32768
    block_encryption_mode="aes-128-ecb"
    bulk_insert_buffer_size=4194304
    character_set_client=utf8
    character_set_filesystem=binary
    character_set_server=utf8
    concurrent_insert=1
    connect_timeout=10
    default_storage_engine=InnoDB
    default_time_zone=SYSTEM
    default_week_format=0
    delayed_insert_limit=100
    delayed_insert_timeout=300
    delayed_queue_size=1000
    delay_key_write=ON
    disconnect_on_expired_password=ON
    div_precision_increment=4
    end_markers_in_json=OFF
    eq_range_index_dive_limit=10
    explicit_defaults_for_timestamp=false
    flush_time=0
    ft_max_word_len=84
    ft_min_word_len=4
    ft_query_expansion_limit=20
    group_concat_max_len=1024
    host_cache_size=643
    innodb_adaptive_flushing=ON
    innodb_adaptive_flushing_lwm=10
    innodb_adaptive_hash_index=ON
    innodb_adaptive_max_sleep_delay=150000
    innodb_additional_mem_pool_size=2097152
    innodb_autoextend_increment=64
    innodb_autoinc_lock_mode=2
    innodb_buffer_pool_dump_at_shutdown=OFF
    innodb_buffer_pool_instances=8
    innodb_buffer_pool_load_at_startup=OFF
    innodb_change_buffering=all
    innodb_change_buffer_max_size=25
    innodb_checksum_algorithm=innodb
    innodb_cmp_per_index_enabled=OFF
    innodb_commit_concurrency=0
    innodb_compression_failure_threshold_pct=5
    innodb_compression_level=6
    innodb_compression_pad_pct_max=50
    innodb_concurrency_tickets=5000
    innodb_disable_sort_file_cache=ON
    innodb_flush_method=O_DIRECT
    innodb_flush_neighbors=1
    innodb_ft_cache_size=8000000
    innodb_ft_enable_diag_print=OFF
    innodb_ft_enable_stopword=ON
    innodb_ft_max_token_size=84
    innodb_ft_min_token_size=3
    innodb_ft_num_word_optimize=2000
    innodb_ft_result_cache_limit=2000000000
    innodb_ft_sort_pll_degree=2
    innodb_ft_total_cache_size=640000000
    innodb_io_capacity=2000
    innodb_io_capacity_max=4000
    innodb_large_prefix=OFF
    innodb_lock_wait_timeout=50
    innodb_log_compressed_pages=OFF
    innodb_lru_scan_depth=1024
    innodb_max_dirty_pages_pct=75
    innodb_max_dirty_pages_pct_lwm=0
    innodb_max_purge_lag=0
    innodb_max_purge_lag_delay=0
    innodb_monitor_disable=\s
    innodb_monitor_enable=\s
    innodb_old_blocks_pct=37
    innodb_old_blocks_time=1000
    innodb_online_alter_log_max_size=134217728
    innodb_open_files=3000
    innodb_optimize_fulltext_only=OFF
    innodb_print_all_deadlocks=OFF
    innodb_purge_batch_size=300
    innodb_purge_threads=1
    innodb_random_read_ahead=OFF
    innodb_read_ahead_threshold=56
    innodb_read_io_threads=4
    innodb_rollback_on_timeout=OFF
    innodb_rollback_segments=128
    innodb_sort_buffer_size=1048576
    innodb_spin_wait_delay=6
    innodb_stats_auto_recalc=ON
    innodb_stats_method=nulls_equal
    innodb_stats_on_metadata=OFF
    innodb_stats_persistent=ON
    innodb_stats_persistent_sample_pages=20
    innodb_stats_sample_pages=8
    innodb_stats_transient_sample_pages=8
    innodb_status_output=OFF
    innodb_status_output_locks=OFF
    innodb_strict_mode=OFF
    innodb_support_xa=ON
    innodb_sync_array_size=1
    innodb_sync_spin_loops=100
    innodb_table_locks=ON
    innodb_thread_concurrency=0
    innodb_thread_sleep_delay=10000
    innodb_write_io_threads=4
    interactive_timeout=7200
    join_buffer_size=262144
    key_cache_age_threshold=300
    key_cache_block_size=1024
    key_cache_division_limit=100
    lc_time_names=en_US
    lock_wait_timeout=31536000
    log_queries_not_using_indexes=OFF
    log_throttle_queries_not_using_indexes=0
    long_query_time=1
    loose_gap_lock_raise_error=OFF
    loose_gap_lock_write_log=OFF
    loose_max_statement_time=0
    loose_optimizer_trace=enabled=off,one_line=off
    loose_optimizer_trace_features=greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
    loose_rds_indexstat=OFF
    loose_rds_max_tmp_disk_space=10737418240
    loose_rds_set_connection_id_enabled=ON
    loose_rds_tablestat=OFF
    loose_rds_threads_running_high_watermark=50000
    loose_thread_handling="one-thread-per-connection"
    loose_thread_pool_oversubscribe=10
    loose_thread_pool_size=64
    loose_thread_pool_stall_limit=30
    loose_tokudb_auto_analyze=30
    loose_tokudb_buffer_pool_ratio=0
    loose_validate_password_length=8
    low_priority_updates=0
    master_verify_checksum=OFF
    max_allowed_packet=1073741824
    max_binlog_stmt_cache_size=18446744073709547520
    max_connect_errors=100
    max_error_count=64
    max_heap_table_size=16777216
    max_join_size=18446744073709551615
    max_length_for_sort_data=1024
    max_prepared_stmt_count=16382
    max_seeks_for_key=18446744073709500000
    max_sort_length=1024
    max_sp_recursion_depth=0
    max_write_lock_count=102400
    metadata_locks_cache_size=1024
    min_examined_row_limit=0
    myisam_sort_buffer_size=262144
    net_buffer_length=16384
    net_read_timeout=30
    net_retry_count=10
    net_write_timeout=60
    old_passwords=0
    open_files_limit=65535
    optimizer_prune_level=1
    optimizer_search_depth=62
    optimizer_trace_limit=1
    optimizer_trace_max_mem_size=16384
    optimizer_trace_offset=-1
    performance_schema=OFF
    preload_buffer_size=32768
    query_alloc_block_size=8192
    query_cache_limit=1048576
    query_cache_min_res_unit=4096
    query_cache_size=3145728
    query_cache_type=0
    query_cache_wlock_invalidate=OFF
    query_prealloc_size=8192
    range_alloc_block_size=4096
    rds_reset_all_filter=0
    slave_net_timeout=60
    slow_launch_time=2
    slow_query_log=ON
    sort_buffer_size=262144
    sql_mode=\s
    stored_program_cache=256
    table_definition_cache=512
    table_open_cache=2000
    table_open_cache_instances=1
    thread_cache_size=100
    thread_stack=262144
    tls_version=TLSv1,TLSv1.1,TLSv1.2
    tmp_table_size=2097152
    transaction_alloc_block_size=8192
    transaction_isolation=READ-COMMITTED
    transaction_prealloc_size=4096
    updatable_views_with_limit=YES
    wait_timeout=86400

    这条帮助是否解决了您的问题? 已解决 未解决

    提交成功!非常感谢您的反馈,我们会继续努力做到更好! 很抱歉未能解决您的疑问。我们已收到您的反馈意见,同时会及时作出反馈处理!