> Also, this test goes a bit faster with sync turned off, if mysql isn't
> using sync that would be why it's so much faster. Anyone know what the
> default for mysql is?
For InnoDB I think it's like Postgres (only slower) ; for MyISAM it's no
fsync, no transactions, no crash tolerance of any kind, and it's not a
default value (in the sense that you could tweak it) it's just the way
it's coded.