List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:June 15 2001 6:27pm
Subject:Re: mysql died with innodb
View as plain text  
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
> combination.

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.  

-- 
	Dan Nelson
	dnelson@stripped
Thread
mysql died with innodbSven Huster15 Jun
  • Why not use indexes?Andrey Kotrekhov15 Jun
Re:mysql died with innodbHeikki Tuuri15 Jun
  • Re: mysql died with innodbDan Nelson15 Jun
    • RE: mysql died with innodbSven Huster15 Jun
Re: mysql died with innodbHeikki Tuuri15 Jun
  • Re: mysql died with innodbDan Nelson15 Jun
Re: mysql died with innodbHeikki Tuuri15 Jun