3 ms·
Why does he use flush_method = O_DIRECT? Last time I checked that was a recipe for terrible performance. We normally leave the flush_method set to default and
by moe 15y ago
Why does he use flush_method = O_DIRECT?
Last time I checked that was a recipe for terrible performance. We normally leave the flush_method set to default and keep a couple slaves around to minimize the potential for data loss.
- spudlyo 15y agoIt gives you better performance provided: * You're not talking to a SAN or a virtual disk device. * You use a filesystem that allows concurrent updates to O_DIRECT opened files, like XFS.
- morgo 15y agoCommon myth. Real answer: it depends. I recently had a bug approved to update the manual: http://bugs.mysql.com/bug.php?id=54306 http://bugs.mysql.com/bug.php?id=54306