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 [EMAIL PROTECTED]:/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
_______________________________________________
freebsd-performance@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
