Permitted Values (Unix) Type string NULL O_DSYNC littlesync nosync O_DIRECT O_DIRECT_NO_FSYNC
Permitted Values (Windows) Type string NULL normal unbuffered
Win10 下测试这两个都没问题，NULL 就是不指定，试了下无法在配置文件中指定 NULLinnodb_flush_method=normalinnodb_flush_method=unbuffered
log-bin=my.binbinlog_format=mixedserver-id=1 max_connect_errors = 3000 wait_timeout=2880000interactive_timeout=2880000#关闭缓冲query_cache_size = 0query_cache_type = 0#int类型可以为空sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
max_allowed_packet =256MBread_buffer_size = 8Mread_rnd_buffer_size = 16Mlower_case_table_names = 1 key_buffer_size = 15M table_open_cache = 400table_definition_cache = 400table_open_cache_instances = 64metadata_locks_hash_instances=64
sort_buffer_size = 16Mjoin_buffer_size = 16Mthread_cache_size = 768query_cache_size = 0query_cache_type = 0tmp_table_size = 96Mperformance_schema=OFFopen_files_limit = 65535back_log = 1024
innodb_buffer_pool_size=512MBinnodb_buffer_pool_instances = 8innodb_buffer_pool_load_at_startup = 1innodb_buffer_pool_dump_at_shutdown = 1innodb_io_capacity = 4000innodb_io_capacity_max = 8000innodb_flush_neighbors = 0innodb_write_io_threads = 8innodb_read_io_threads = 8innodb_purge_threads = 4# not start innodb_page_cleaners = 4#ib_logfile0 or 1 sizeinnodb_log_file_size=512MB# 4MB-8MB okinnodb_log_buffer_size = 32Minnodb_flush_log_at_trx_commit = 1innodb_file_per_table = 1 external-locking = FALSE#skip-external-lockingexpire_logs_days=90max_binlog_size=500Mskip-name-resolve=OFF