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?