| |||||||||||||
This is a regressionThis is a regressionPosted Mar 16, 2009 14:09 UTC (Mon) by ikm (subscriber, #493)In reply to: This is a regression by alexl Parent article: Ts'o: Delayed allocation and the zero-length file problem
> That would break ACID guarantees for all databases, etc.
Once I had MySQL running on an XFS filesystem, and the system has hanged for some reason. The database got broken so horribly I had to restore it from backups. I wouldn't really count on any 'ACID guarantees' here :) An UPS and a ventilated dust-free environment is our only ACID guarantee :)
(Log in to post comments)
This is a regression Posted Mar 17, 2009 5:41 UTC (Tue) by efexis (guest, #26355) [Link]
Note that mysql isn't always acid compliant and clearly states that fact, eg, when using myisam tables. Converting to innodb should fix that for you. If you were running innodb tables... then shut me up! Hehe never done any testing of this myself. Which storage engine are you using?
This is a regression Posted Mar 17, 2009 11:59 UTC (Tue) by ikm (subscriber, #493) [Link]
Yep, it was myisam.
|
|||||||||||||