MySQL innodb_flush_method/innodb_use_fdatasync

最新推荐文章于 2026-03-26 03:27:24 发布

原创

最新推荐文章于 2026-03-26 03:27:24 发布 · 542 阅读

标签

#mysql

收录于

结论

8.0.26+ 配置 innodb_flush_method=O_DIRECT，innodb_use_fdatasync=ON
8.0.26- 配置 innodb_flush_method=O_DIRECT

环境

host1 Percona Server 8.0.26-16
host2 Percona Server 8.0.25-15
host3 sysbench 1.0.20

EL 7.6 4.14.35
ssd & ext4

sysbench:

--tables=30 --table_size=10000000 --time=600 --threads=64 --report-interval=10 /usr/share/sysbench/oltp_write_only.lua

MySQL:

innodb_buffer_pool_size                         = 8192M
innodb_buffer_pool_dump_at_shutdown             = OFF
innodb_buffer_pool_load_at_startup              = OFF
innodb_data_file_path                           = ibdata1:200M:autoextend
innodb_fast_shutdown                            = 0
innodb_io_capacity                              = 3000
innodb_io_capacity_max                          = 6000
innodb_log_buffer_size                          = 64M
innodb_log_file_size