In the last episode (Jun 15), Heikki Tuuri said:
> of course InnoDB could catch the error and send the error message to
> the client. But the problem is that we have to get NFS to flush the
> files, otherwise we may very easily get database corruption in case
> of a crash.
> MyISAM does not call f(data)sync at all, but then you may have to run
> repair if it crashes.
> I looked at FreeBSD manuals at www.freebsd.org and did not find any
> notice that fdatasync would not work for NFS. Presumably with some
> settings it should work, or maybe there is a bug in the OS/hardware
fsync (FreeBSD doesn't have fdatasync) definitely does work with NFS.
Knowing the errno that fsync() returned when it failed might help the
debugging process, though.