No idea about MySQL. I use postgresql exclusively. And it screams pretty good on ZFS. You can set the record size. The sector size. If you’re insane you can mess with fsync. You can tune ZFS so easily to handle the workload you have.