Date: Tue, 16 Oct 2007 20:59:13 +0200 From: Kris Kennaway <kris@FreeBSD.org> To: Stefan Lambrev <stefan.lambrev@moneybookers.com> Cc: Attilio Rao <attilio@freebsd.org>, freebsd-current@freebsd.org, Peter Schuller <peter.schuller@infidyne.com> Subject: Re: Status of MySQL on 7 w/o patches applied Message-ID: <47150A01.2040100@FreeBSD.org> In-Reply-To: <4714D2F5.1060206@moneybookers.com> References: <20071016110642.GB54457@hyperion.scode.org> <ff27tu$k01$1@ger.gmane.org> <20071016114323.GA36300@eos.sc1.parodius.com> <20071016120143.GA57926@hyperion.scode.org> <3bbf2fe10710160747q51b065gcbf0cd4ef2224945@mail.gmail.com> <4714D2F5.1060206@moneybookers.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Stefan Lambrev wrote: > Hi, > > Attilio Rao wrote: >> 2007/10/16, Peter Schuller <peter.schuller@infidyne.com>: >> >>>>> Just in case you missed some debugging knobs: can you retest with >>>>> RELENG_7? (not -current). >>>>> >>> I will, but I did disable INVARIANTS/WITNESS. I was afraid I had >>> missed something else that I am not aware of; diffing the kernel conf >>> did not indicate this was the case. >>> >> >> Recent NetBSD benchmarks, showed that malloc debugging is a very big >> bottleneck for sybench, so you should remove it as well. >> Also, benchmarks posted where just in regard of cached datas, so >> without any need to do I/O from disks. >> >> Attilio >> >> >> > If you run real RELENG_7 it have to be without debug in kernel, and in > malloc, > nothing really to tune here :) > > Just update your source tree to the latest RELENG_7 recompile and etc. > > http://lists.freebsd.org/pipermail/freebsd-performance/2007-May/002664.html > - here are my results with mysql with FreeBSD 6.2, > you can use it to see what I did and when I reach best performance. > > From what I remember to achieve good results you have to: > 1) cp /usr/local/share/mysql/my-large.cnf /var/db/mysql/my.cnf > (or use huge if you have more one dual core CPUs) I don't know what settings this has, but I use http://people.freebsd.org/~kris/scaling/my.cnf Kris
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?47150A01.2040100>