On Fri, Jun 17, 2005 at 10:30:25AM -0500, Greg Barniskis wrote: > I think he meant comparing 36,000 on CentOS (async) to 24,000 on > CURRENT (sync). I wondered that myself, and having searched out the > answer I find that it is declared in > > http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/configtuning-disk.html > > that async provides fast writes at the cost of "no guarantee at all > for a consistent state of the filesystem". So, you choose: fast but > not so reliable writes, or slower writes with fast, reliable > disaster recovery. > > Thanks to the FreeBSD team for choosing the sensible default, even > if it results in the occasional "Linux is faster!" debate. Dang > smirky penguins... you're flightless I tell ya, flightless. =)
Note that it's very easy to accidentally configure MySQL in such a manner that you don't have any data integrity anyway. For example, if you fat-finger 'innodb' as 'innodd' or something MySQL siletly creates a MyISAM table for you. So if you care about data integrity, you should probably look beyond MySQL in the first place. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" _______________________________________________ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "[EMAIL PROTECTED]"
