# Innodb-flush-method

**URL:** <https://forums.percona.com/t/innodb-flush-method/13267>\
**Category:** MySQL & MariaDB\
**Created:** [November 29, 2021, 8:47pm UTC](https://forums.percona.com/t/innodb-flush-method/13267 "2021-11-29T20:47:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![meyerder](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/meyerder/32/16994_2.png) [@meyerder](https://forums.percona.com/u/meyerder)\
**Post date:** [November 29, 2021, 8:47pm UTC](https://forums.percona.com/t/innodb-flush-method/13267/1 "2021-11-29T20:47:18Z")

</div>

I have used my google search methods and not found a good answer. I know I have SSD SAN storage but for the life of me I cant figure out which option to use…

I have about 60% write and 40% reads in a PXC 8 cluster on Centos 8.

Why I am looking at this is according to PMM my log fsync is about 5.12 and the Fsync Rate is 580.64. the Pending Fsyncs are I think pretty low with a avg of 0.22 I am attempting to figure out which option on my storage is best but cant determine which one to actually use… fsync/0\_Direct or no fsync or or or… I have tried some trial and error but honestly cant figure which is best… Any hints on how to determine this?

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [November 30, 2021, 11:50am UTC](https://forums.percona.com/t/innodb-flush-method/13267/2 "2021-11-30T11:50:19Z")

</div>

Really the best option is to run some benchmarks on your actual hardware to determine the best option. To get started I suggest configuring O\_DIRECT for most cases.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [December 1, 2021, 5:58pm UTC](https://forums.percona.com/t/innodb-flush-method/13267/3 "2021-12-01T17:58:05Z")

</div>

How is your SAN mounted? NFS? FibreChannel? What are the mount options?
