News for hackers. Stuff that matters.
Re:Disaster: MySQL 5.5 Flushing by moe on Sunday September 18, 2011 @06:00PM (#3011391)
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.

Re:Disaster: MySQL 5.5 Flushing by morgo on Sunday September 18, 2011 @11:51PM (#3012153)
Common myth. Real answer: it depends. I recently had a bug approved to update the manual: http://bugs.mysql.com/bug.php?id=54306
Re:Disaster: MySQL 5.5 Flushing by spudlyo on Sunday September 18, 2011 @07:14PM (#3011550)
It 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.