Re: MyISAM updates synchronous or not ?

[Stephen Collyer]

>I'm a little unclear what you mean by this. Are you intending to simply issue an fsync() after completing each
>write? If so, I think you would be better off using transactions and InnoDB...

>Am I missing something?

The only thing you're missing is that I needed to do a quick hack at the app. level
to ensure a consumer process got the data written by a producer process, as I
didn't have the time to convert it to InnoDB just then.

You're correct, however, and I'll will be converting it to use InnoDB when I've got
the time. I screwed up originally as it didn't occur to me that I'd get a race condition
due to asynchronous writes with MyISAM.

Steve Collyer