Date: Wed, 26 Oct 2005 17:57:48 +0800 From: Xin LI <delphij@frontfree.net> To: Marian Hettwer <MH@kernel32.de> Cc: current@freebsd.org Subject: Re: MySQL Performance 6.0rc1 Message-ID: <1130320668.810.87.camel@spirit> In-Reply-To: <435F48DA.6060009@kernel32.de> References: <435F48DA.6060009@kernel32.de>
index | next in thread | previous in thread | raw e-mail
[-- Attachment #1 --] Hi, Marian, 在 2005-10-26三的 11:14 +0200，Marian Hettwer写道： > Hi Folks, > > I'm using RC1 on some of my test servers and workstations. So far, it > runs very good (as in stable and fast) :) > However, I thought of doing a small benchmark of MySQL in comparison to > Linux 2.6.8 (Debian Sarge) and the results are kinda... shocking. [...] > Any Ideas where this huge difference comes from? Did I oversee some > debugging features still active in RC1 ? There are many factors that can affect the performance of MySQL. Would you please post the output of "dumpfs /var | head -n 21" on your server? (Replace /var with whatever mountpoint that your database is stored in). Some observations that I think can affect MySQL performance: - Our malloc(3) implementation might be sub-optimal for the workload. - Lack of some POSIX system call which was implemented in other ways (e.g. we do not have fsyncdata yet) - Some detailed implementation difference between our and Linux's threading library, or MySQL itself. I think David (davidxu@) had worked on performance of MySQL and he may have some suggestions. BTW. What file system are you using on your Debian test? What's the mount options? Cheers, -- Xin LI <delphij delphij net> http://www.delphij.net/ [-- Attachment #2 --] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (FreeBSD) iD8DBQBDX1Mc/cVsHxFZiIoRAnmpAJ9pRiNMFA2kGhPYaQS7qia4C85BkACgkGAx jiipPcMlglt+rebE/K4Ir8c= =+mFn -----END PGP SIGNATURE-----help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1130320668.810.87.camel>