直接将下面参数copy到你的my.ini文件中即可使用。优化得很好。
如果配置了无法启动mysql服务器,说明版本不对。可以查看报错信息,删除不需要的配置即可
max_connections=1024
auto_increment_increment = 1auto_increment_offset = 1
back_log = 3000
binlog_cache_size = 128KB
binlog_checksum = CRC32
binlog_row_image = full
binlog_stmt_cache_size = 32768
character_set_server = utf8mb4
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
div_precision_increment = 4
eq_range_index_dive_limit = 10
explicit_defaults_for_timestamp = false
ft_min_word_len = 4
ft_query_expansion_limit = 20
group_con