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>
next in thread | previous in thread | raw e-mail | index | archive | help
--=-txlcpLehz5KxV5pljZD4 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi, Marian, =E5=9C=A8 2005-10-26=E4=B8=89=E7=9A=84 11:14 +0200=EF=BC=8CMarian Hettwer= =E5=86=99=E9=81=93=EF=BC=9A > Hi Folks, >=20 > I'm using RC1 on some of my test servers and workstations. So far, it=20 > runs very good (as in stable and fast) :) > However, I thought of doing a small benchmark of MySQL in comparison to=20 > Linux 2.6.8 (Debian Sarge) and the results are kinda... shocking. [...] > Any Ideas where this huge difference comes from? Did I oversee some=20 > 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, --=20 Xin LI <delphij delphij net> http://www.delphij.net/ --=-txlcpLehz5KxV5pljZD4 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (FreeBSD) iD8DBQBDX1Mc/cVsHxFZiIoRAnmpAJ9pRiNMFA2kGhPYaQS7qia4C85BkACgkGAx jiipPcMlglt+rebE/K4Ir8c= =+mFn -----END PGP SIGNATURE----- --=-txlcpLehz5KxV5pljZD4--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1130320668.810.87.camel>