mysql如何配置参数_mysql配置参数

16G 8核 mysql 配置参数

automatic_sp_privileges=ON

auto_increment_increment= 1auto_increment_offset= 1avoid_temporal_upgrade=OFF

back_log= 3000binlog_cache_size=128KB

binlog_checksum=CRC32

binlog_order_commits=ON

binlog_rows_query_log_events=OFF

binlog_row_image=full

binlog_stmt_cache_size= 32768block_encryption_mode= "aes-128-ecb"bulk_insert_buffer_size= 4194304character_set_filesystem=binary

character_set_server=utf8

concurrent_insert= 1connect_timeout= 10default_storage_engine=InnoDB

default_time_zone=SYSTEM

default_week_format= 0delayed_insert_limit= 100delayed_insert_timeout= 300delayed_queue_size= 1000delay_key_write=ON

disconnect_on_expired_password=ON

div_precision_increment= 4end_markers_in_json=OFF

eq_range_index_dive_limit= 10event_scheduler=OFF

explicit_defaults_for_timestamp=OFF

flush_time= 0ft_max_word_len= 84ft_min_word_len= 4ft_query_expansion_limit= 20group_concat_max_len= 1024host_cache_size= 644innodb_adaptive_flushing=ON

innodb_adaptive_flushing_lwm= 10innodb_adaptive_hash_index=ON

innodb_adaptive_max_sleep_delay= 150000innodb_autoextend_increment= 64innodb_autoinc_lock_mode= 2innodb_buffer_pool_dump_at_shutdown=ON

innodb_buffer_pool_dump_pct= 25innodb_buffer_pool_instances= 1innodb_buffer_pool_load_at_startup=ON

innodb_change_buffering=all

innodb_change_buffer_max_size= 25innodb_checksum_algorithm=crc32

innodb_cmp_per_index_enabled=OFF

innodb_commit_concurrency= 0innodb_compression_failure_threshold_pct= 5innodb_compression_level= 6innodb_compression_pad_pct_max= 50innodb_concurrency_tickets= 5000innodb_data_file_purge=ON

innodb_data_file_purge_interval= 100innodb_data_file_purge_max_size= 128innodb_deadlock_detect=ON

innodb_disable_sort_file_cache=ON

innodb_flush_method=O_DIRECT

innodb_flush_neighbors= 1innodb_flush_sync=ON

innodb_ft_cache_size= 8000000innodb_ft_enable_diag_print=OFF

innodb_ft_enable_stopword=ON

innodb_ft_max_token_size= 84innodb_ft_min_token_size= 3innodb_ft_num_word_optimize= 2000innodb_ft_result_cache_limit= 2000000000innodb_ft_sort_pll_degree= 2innodb_ft_total_cache_size= 640000000innodb_io_capacity= 2000innodb_io_capacity_max= 4000innodb_lock_wait_timeout= 50innodb_log_checksums=ON

innodb_log_compressed_pages=OFF

innodb_lru_scan_depth= 1024innodb_max_dirty_pages_pct= 75innodb_max_dirty_pages_pct_lwm= 0innodb_max_purge_lag= 0innodb_max_purge_lag_delay= 0innodb_max_undo_log_size= 1073741824innodb_monitor_disable=innodb_monitor_enable=innodb_old_blocks_pct= 37innodb_old_blocks_time= 1000innodb_online_alter_log_max_size= 134217728innodb_open_files= 3000innodb_optimize_fulltext_only=OFF

innodb_page_cleaners= 1innodb_print_all_deadlocks=OFF

innodb_purge_batch_size= 300innodb_purge_rseg_truncate_frequency= 128innodb_purge_threads= 1innodb_random_read_ahead=OFF

innodb_read_ahead_threshold= 56innodb_read_io_threads= 4innodb_rollback_on_timeout=OFF

innodb_rollback_segments= 128innodb_sort_buffer_size= 1048576innodb_spin_wait_delay= 6innodb_stats_auto_recalc=ON

innodb_stats_method=nulls_equal

innodb_stats_on_metadata=OFF

innodb_stats_persistent=ON

innodb_stats_persistent_sample_pages= 20innodb_stats_transient_sample_pages= 8innodb_status_output=OFF

innodb_status_output_locks=OFF

innodb_strict_mode=OFF

innodb_sync_array_size= 1innodb_sync_spin_loops= 100innodb_table_locks=ON

innodb_thread_concurrency= 0innodb_thread_sleep_delay= 10000innodb_write_io_threads= 4interactive_timeout= 7200join_buffer_size=352KB

key_cache_age_threshold= 300key_cache_block_size= 1024key_cache_division_limit= 100lc_time_names=en_US

local_infile=OFF

lock_wait_timeout= 31536000log_queries_not_using_indexes=OFF

log_slow_admin_statements=OFF

log_throttle_queries_not_using_indexes= 0long_query_time= 1loose_ignore_index_hint_error=OFF

loose_innodb_numa_interleave=ON

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_opt_rds_enable_show_slave_lag=ON

loose_opt_rds_last_error_gtid=ON

loose_rds_kill_connections= 20loose_validate_password_length= 8low_priority_updates= 0master_verify_checksum=OFF

max_allowed_packet=1024M

max_binlog_stmt_cache_size= 18446744073709547520max_connect_errors= 100max_error_count= 64max_heap_table_size= 67108864max_join_size= 18446744073709551615max_length_for_sort_data= 1024max_points_in_geometry= 65536max_prepared_stmt_count= 16382max_seeks_for_key= 18446744073709500000max_sort_length= 1024max_sp_recursion_depth= 0max_write_lock_count= 102400min_examined_row_limit= 0myisam_sort_buffer_size= 262144mysql_native_password_proxy_users=OFF

net_buffer_length= 16384net_read_timeout= 30net_retry_count= 10net_write_timeout= 60ngram_token_size= 2open_files_limit= 65535optimizer_prune_level= 1optimizer_search_depth= 62optimizer_trace_limit= 1optimizer_trace_max_mem_size= 16384optimizer_trace_offset= -1opt_indexstat=ON

opt_tablestat=ON

performance_point_iostat_interval= 2performance_point_iostat_volume_size= 10000performance_point_lock_rwlock_enabled=ON

preload_buffer_size= 32768query_alloc_block_size= 8192query_prealloc_size= 8192range_alloc_block_size= 4096range_optimizer_max_mem_size= 8388608session_track_gtids=OFF

session_track_schema=ON

session_track_state_change=OFF

sha256_password_proxy_users=OFF

show_old_temporals=OFF

slave_net_timeout= 60slave_parallel_type=LOGICAL_CLOCK

slow_launch_time= 2slow_query_log=ON

sort_buffer_size=704KB

sql_mode=stored_program_cache= 256table_definition_cache= 512table_open_cache= 2000table_open_cache_instances= 1thread_cache_size= 100thread_stack= 262144tls_version= TLSv1,TLSv1.1,TLSv1.2tmp_table_size= 2097152transaction_alloc_block_size= 8192transaction_isolation= READ-COMMITTED

transaction_prealloc_size= 4096updatable_views_with_limit=YES

wait_timeout= 86400