toru okada wrote: > On Thu, 24 Feb 2005 17:45:01 +0100, Jochem van Dieten wrote: >> >> They are not reasons to stay away from MySQL, just examples of >> misconfigured systems and bad behaving OS'es. > > sorry jochem, i am going to have to resepectfully disagree with you > here. This would not happen with a fully ACID compliant database.
Even fully ACID compliant depend on the OS they run on. The Single Unix Specification is very specific about the behaviour of fsync(). If a program calls fsync() on a file, the OS has to guarantee the file is written to durable storage and should block until that condition is met. If the OS is unable to do so then the OS should return an error. If the OS lets itself be fooled by the write-back cache of a RAID controller or a harddisk, the OS is to blame, not the program that calls fsync(). Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196349 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
