Date: Mon, 03 Jul 2006 14:17:51 +0800 From: David Xu <davidxu@freebsd.org> To: Hugo Silva <hugo@barafranca.com> Cc: freebsd-performance@freebsd.org Subject: Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark Message-ID: <44A8B68F.5060802@freebsd.org> In-Reply-To: <44A894B0.3010506@barafranca.com> References: <44A894B0.3010506@barafranca.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Hugo Silva wrote: > > Today I decided to benchmark MySQL 5 performance on FreeBSD 6.1-STABLE. > This server is a Dual Xeon 2.8GHz, 4GB of RAM and 2x73GB SCSI disks that > do 320MB/s > > For all the tests, I restarted mysqld prior to starting the test, > waited for about 1 minute for it to settle down, and ran super smack. > For the consecutive runs, I executed super-smack right after the > previous run ended. > > Switching from HTT to no HTT was achieved by > machdep.hyperthreading_allowed, and switching from/to libpthread/libthr > was done via libmap.conf. > > System: > > FreeBSD ?? 6.1-STABLE FreeBSD 6.1-STABLE #3: Mon Jul 3 03:10:35 UTC > 2006 ??@??:/usr/obj/usr/src/sys/DATABASE i386 > > Here are the results: > > > MySQL 5.0.22, built with BUILD_OPTIMIZED=yes and WITH_PROC_SCOPE_PTH=yes > > Please don't run mysql in PROC_SCOPE with libthr, it has no benefit and can only hurt performance, you can forcely turn it off by: sysctl kern.threads.thr_scope=2 the proc scope support may be dropped near future in libthr, thanks for your evaluation. David Xu
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?44A8B68F.5060802>