FreeBSD MySQL still WAY slower than Linux

Matthias Buelow mkb at incubus.de
Fri Jun 17 21:01:21 GMT 2005


David Sze <dsze at distrust.net> writes:

>I'm not sure filesystem consistency alone is "good enough".  Say your
>bank's database crashes right after you make a deposit.  When it comes
>back up it's consistent, but only up to 5 minutes before the crash due
>to the async mount.

A bank doesn't run on Unix. It runs on mainframes, with such funny
features like processors executing each instruction in parallel, 
and comparing the results. Completely different universe here.

On Unix, filesystem consistency is the best you'll normally get. You
_can_ mount filesystems synchronously, both with UFS aswell as ext2/3
etc., but the performance is abysmal. Maybe useful in particular
situations but you probably wouldn't want to run your desktop (or busy
server) with it. I mean, just try it and see (and make sure
writeback-caching on the disks is disabled, when possible.)

mkb.


More information about the freebsd-stable mailing list