最新公告
  • 欢迎您光临编程知识分享网 加入我们
  • 阿里云mysql优化配置

    my.ini

    —————————————————————————————–
    loose_performance_schema_max_table_instances=1000
    innodb_buffer_pool_load_at_startup=ON
    loose_performance_schema_max_index_stat=10000
    bulk_insert_buffer_size=4194304
    show_old_temporals=OFF
    ft_query_expansion_limit=20
    innodb_old_blocks_time=1000
    innodb_stats_sample_pages=8
    thread_stack=262144
    lc_time_names=en_US
    innodb_thread_concurrency=0
    sync_master_info=10000
    default_time_zone=SYSTEM
    old_passwords=0
    optimizer_search_depth=62
    loose_innodb_data_file_purge_interval=100
    innodb_compression_level=6
    loose_innodb_log_optimize_ddl=OFF
    loose_performance_schema_max_prepared_statements_instances=1000
    max_sort_length=1024
    max_binlog_cache_size=18446744073709547520
    innodb_online_alter_log_max_size=134217728
    key_cache_block_size=1024
    mysql_native_password_proxy_users=OFF
    innodb_adaptive_max_sleep_delay=150000
    innodb_purge_rseg_truncate_frequency=128
    query_alloc_block_size=8192
    loose_performance_schema_max_socket_instances=1000
    innodb_lock_wait_timeout=50
    innodb_purge_threads=1
    loose_performance_point_iostat_interval=2
    innodb_compression_failure_threshold_pct=5
    innodb_compression_pad_pct_max=50
    loose_innodb_data_file_purge=ON
    binlog_rows_query_log_events=OFF
    loose_validate_password_check_user_name=ON
    innodb_stats_persistent_sample_pages=20
    innodb_ft_total_cache_size=640000000
    event_scheduler=OFF
    innodb_flush_method=O_DIRECT
    loose_performance_schema_accounts_size=10000
    eq_range_index_dive_limit=10
    loose_sql_safe_updates=OFF
    loose_max_execution_time=0
    loose_optimizer_trace_features=greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
    rds_reserved_connections=512
    connect_timeout=10
    innodb_purge_batch_size=300
    div_precision_increment=4
    avoid_temporal_upgrade=OFF
    innodb_sync_array_size=1
    innodb_stats_method=nulls_equal
    relay_log_recovery=OFF
    lock_wait_timeout=31536000
    net_read_timeout=30
    innodb_deadlock_detect=ON
    innodb_write_io_threads=4
    end_markers_in_json=OFF
    loose_performance_schema_hosts_size=10000
    ngram_token_size=2
    loose_innodb_numa_interleave=ON
    loose_performance_schema_max_cond_instances=10000
    max_binlog_stmt_cache_size=18446744073709547520
    loose_performance_schema_max_table_lock_stat=10000
    loose_performance_schema_max_table_handles=10000
    innodb_checksum_algorithm=crc32
    loose_innodb_data_file_purge_max_size=512
    query_cache_type=0
    innodb_ft_enable_diag_print=OFF
    innodb_ft_enable_stopword=ON
    innodb_io_capacity=20000
    slow_launch_time=2
    innodb_table_locks=ON
    innodb_stats_persistent=ON
    tmp_table_size=2097152
    loose_performance_point_lock_rwlock_enabled=ON
    disconnect_on_expired_password=ON
    default_storage_engine=InnoDB
    net_retry_count=10
    innodb_ft_cache_size=8000000
    binlog_cache_size=2048KB
    innodb_max_dirty_pages_pct=75
    query_cache_limit=1048576
    innodb_disable_sort_file_cache=ON
    innodb_lru_scan_depth=1024
    loose_performance_schema_max_mutex_instances=10000
    innodb_ft_result_cache_limit=2000000000
    long_query_time=1
    interactive_timeout=7200
    innodb_read_io_threads=4
    transaction_prealloc_size=4096
    open_files_limit=65535
    loose_performance_schema_max_metadata_locks=10000
    innodb_open_files=3000
    max_heap_table_size=67108864
    loose_performance_schema_digests_size=10000
    automatic_sp_privileges=ON
    explicit_defaults_for_timestamp=OFF
    ft_max_word_len=84
    innodb_autoextend_increment=64
    sql_mode=
    innodb_stats_transient_sample_pages=8
    innodb_random_read_ahead=OFF
    table_open_cache={LEAST(DBInstanceClassMemory/1073741824*256, 2048)}
    range_optimizer_max_mem_size=8388608
    loose_innodb_rds_faster_ddl=OFF
    innodb_status_output=OFF
    loose_validate_password_number_count=1
    innodb_log_compressed_pages=OFF
    slave_net_timeout=60
    delay_key_write=ON
    query_cache_wlock_invalidate=OFF
    max_points_in_geometry=65536
    general_log=OFF
    max_prepared_stmt_count=16382
    wait_timeout=86400
    loose_performance_schema_setup_actors_size=10000
    query_cache_min_res_unit=1024
    innodb_print_all_deadlocks=OFF
    loose_thread_pool_size=1
    binlog_stmt_cache_size=32768
    transaction_isolation=READ-COMMITTED
    innodb_buffer_pool_dump_at_shutdown=ON
    query_prealloc_size=8192
    key_cache_age_threshold=300
    loose_performance_schema_setup_objects_size=10000
    loose_rds_kill_connections=20
    transaction_alloc_block_size=8192
    optimizer_trace_limit=1
    metadata_locks_cache_size=1024
    optimizer_prune_level=1
    loose_performance_schema_max_file_instances=1000
    innodb_max_purge_lag=0
    innodb_buffer_pool_dump_pct=25
    innodb_max_dirty_pages_pct_lwm=0
    max_sp_recursion_depth=0
    innodb_status_output_locks=OFF
    updatable_views_with_limit=YES
    binlog_row_image=full
    innodb_change_buffer_max_size=25
    innodb_optimize_fulltext_only=OFF
    local_infile=ON
    loose_opt_rds_last_error_gtid=ON
    innodb_ft_max_token_size=84
    innodb_undo_log_truncate=OFF
    loose_performance_schema_users_size=10000
    innodb_max_undo_log_size=1073741824
    slave_parallel_type=LOGICAL_CLOCK
    loose_rds_check_core_file_enabled=ON
    loose_thread_pool_enabled=ON
    innodb_adaptive_hash_index=ON
    innodb_sync_spin_loops=30
    net_write_timeout=60
    flush_time=0
    lower_case_table_names=1
    sha256_password_proxy_users=OFF
    character_set_filesystem=binary
    innodb_flush_sync=ON
    tls_version=TLSv1,TLSv1.1,TLSv1.2
    key_cache_division_limit=100
    loose_performance_schema_max_rwlock_instances=10000
    delayed_insert_timeout=300
    loose_rds_audit_max_sql_size=2048
    preload_buffer_size=32768
    innodb_read_ahead_threshold=56
    loose_optimizer_switch=index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on
    concurrent_insert=1
    block_encryption_mode=”aes-128-ecb”
    slow_query_log=ON
    net_buffer_length=16384
    query_cache_size=0
    innodb_buffer_pool_size={DBInstanceClassMemory*3/4}
    delayed_insert_limit=100
    innodb_large_prefix=OFF
    innodb_monitor_disable=
    loose_performance_schema_max_program_instances=10000
    innodb_adaptive_flushing_lwm=10
    innodb_log_checksums=ON
    delayed_queue_size=1000
    session_track_gtids=OFF
    innodb_thread_sleep_delay=10000
    loose_rds_set_connection_id_enabled=ON
    innodb_old_blocks_pct=37
    innodb_ft_sort_pll_degree=2
    log_slow_admin_statements=OFF
    innodb_stats_on_metadata=OFF
    stored_program_cache=256
    group_concat_max_len=1024
    innodb_sort_buffer_size=1048576
    innodb_page_cleaners=1
    innodb_spin_wait_delay=6
    myisam_sort_buffer_size=262144
    innodb_rollback_segments=128
    innodb_commit_concurrency=0
    innodb_concurrency_tickets=5000
    table_definition_cache={LEAST(DBInstanceClassMemory/1073741824*512, 2048)}
    auto_increment_increment=1
    binlog_checksum=CRC32
    max_seeks_for_key=18446744073709500000
    autocommit=ON
    max_length_for_sort_data=1024
    back_log=3000
    max_error_count=64
    innodb_io_capacity_max=40000
    innodb_strict_mode=OFF
    binlog_order_commits=ON
    min_examined_row_limit=0
    performance_schema=OFF
    innodb_ft_min_token_size=3
    loose_validate_password_policy=1
    sync_relay_log_info=10000
    innodb_stats_auto_recalc=ON
    max_connect_errors=100
    join_buffer_size=432KB
    innodb_change_buffering=all
    optimizer_trace_max_mem_size=16384
    innodb_autoinc_lock_mode=2
    innodb_rollback_on_timeout=OFF
    loose_opt_rds_enable_show_slave_lag=ON
    loose_performance_schema_max_thread_instances=10000
    max_write_lock_count=102400
    master_verify_checksum=OFF
    innodb_ft_num_word_optimize=2000
    max_join_size=18446744073709551615
    loose_validate_password_mixed_case_count=1
    log_error_verbosity=2
    loose_validate_password_length=8
    log_throttle_queries_not_using_indexes=0
    innodb_max_purge_lag_delay=0
    loose_optimizer_trace=enabled=off,one_line=off
    default_week_format=0
    innodb_cmp_per_index_enabled=OFF
    show_compatibility_56=OFF
    host_cache_size=644
    low_priority_updates=0
    auto_increment_offset=1
    range_alloc_block_size=4096
    ft_min_word_len=4
    loose_performance_point_iostat_volume_size=10000
    sort_buffer_size=848KB
    slave_type_conversions=
    max_allowed_packet=1024M
    read_buffer_size=848KB
    thread_cache_size=256
    optimizer_trace_offset=-1
    loose_thread_pool_oversubscribe=32
    loose_validate_password_special_char_count=1
    character_set_server=utf8
    innodb_adaptive_flushing=ON
    log_queries_not_using_indexes=OFF
    innodb_monitor_enable=
    table_open_cache_instances={LEAST(DBInstanceClassMemory/1073741824, 16)}
    innodb_flush_neighbors=0
    innodb_buffer_pool_instances={LEAST(DBInstanceClassMemory/1073741824, 8)}

    赞赏

    微信赞赏支付宝赞赏

    编程知识分享网,一个有趣的平台!
    编程知识分享网|编程教程|资源下载|源码下载 » 阿里云mysql优化配置

    常见问题FAQ

    免费下载或者VIP会员专享资源能否直接商用?
    本站所有资源版权均属于原作者所有,这里所提供资源均只能用于参考学习用,请勿直接商用。若由于商用引起版权纠纷,一切责任均由使用者承担。更多说明请参考 VIP介绍。
    提示下载完但解压或打开不了?
    最常见的情况是下载不完整: 可对比下载完压缩包的与网盘上的容量,若小于网盘提示的容量则是这个原因。这是浏览器下载的bug,建议用百度网盘软件或迅雷下载。若排除这种情况,可在对应资源底部留言,或 联络我们.。
    找不到素材资源介绍文章里的示例图片?
    对于PPT,KEY,Mockups,APP,网页模版等类型的素材,文章内用于介绍的图片通常并不包含在对应可供下载素材包内。这些相关商业图片需另外购买,且本站不负责(也没有办法)找到出处。 同样地一些字体文件也是这种情况,但部分素材会在素材包内有一份字体下载链接清单。
    关于编程知识分享网(www.ittce.com)
    编程知识分享网,一个有趣的平台,小心有毒!

    发表评论

    提供最优质的资源集合

    立即查看 了解详情
    升级SVIP尊享更多特权立即升级