Poor fsync performance on DO Block Storage
I have noticed very poor MySQL (InnoDB) performance on my droplet.
I am running MySQL (Percona Server) 5.6 with fine tuned config.
Database directory placed on BlockStorage.
I used fio utility to test BlockStorage disk performance and everything is ok, if I running fio as described here https://www.digitalocean.com/community/tutorials/how-to-benchmark-digitalocean-volumes . Burst performance approximately near 7500 iops, after 1 minute test it slow down to approx. 5000 iops.
As InnoDB using fsync for each commit operation to compliant data consistency I tested fio performance with fsync for each IO operation (—fsync=1). In test with fsync=1 I noticed only 50-100 iops!
Can anybody answer me why performance so poor in my case?