RE: mysql performance test results under FreeBSD-7.0-CURRENT

A couple of things I have noticed in the kernel messages:

	WARNING: WITNESS option enabled, expect reduced performance.

You need to remove the WITNESS and the INVARIANTS options from your
kernel when benchmarking.

	ad0: DMA limited to UDMA33, controller found non-ATA66 cable
	ad0: 28629MB <Seagate ST330630A 3.17> at ata0-master UDMA33
	ad1: DMA limited to UDMA33, controller found non-ATA66 cable
	ad1: 28629MB <Seagate ST330630A 3.17> at ata0-slave UDMA33
	ad3: 38166MB <Seagate ST340810A 3.99> at ata1-slave UDMA100

You need to use the 80 core conductor cables instead of the old standard
40 core conductor IDE cables to get the best performance from your hard
drives.  Just use another cable like you already have connected to the
40GB drive.

-----Original Message-----
From: owner-freebsd-current_at_freebsd.org
[mailto:owner-freebsd-current_at_freebsd.org] On Behalf Of Ganbold
Sent: Thursday, 30 March 2006 4:55 PM
To: freebsd-current_at_freebsd.org
Cc: jasone_at_freebsd.org; deischen_at_freebsd.org; phk_at_phk.freebsd.dk;
rwatson_at_freebsd.org; davidxu_at_freebsd.org; grog_at_freebsd.org
Subject: mysql performance test results under FreeBSD-7.0-CURRENT

Hi all,

I did make some mysql performance tests under FreeBSD-7.0-CURRENT with 
various
scheduler and compile time options.
It seems like mysql(BUILD_OPTIMIZED=yes, BUILD_STATIC=yes, 
WITH_PROC_SCOPE_PTH=yes)-libpthread-tsc-sched_4bsd+preemption gives
better performance.

The test results are at:

http://www.mnbsd.org/ftp/mysql_test_results.txt

There are several things I didn't test and this leads to some questions:

1. I didn't make test with Poul-Henning's CPU accounting patch. Somehow 
I can't apply it (http://phk.freebsd.dk/patch/cpu_acct_2.patch) cleanly.

Where can I find latest patch?
When this patch will be included in CURRENT?

2. I didn't make test with Robert Watson's patch 
(http://www.watson.org/~robert/freebsd/clock/)? Does CURRENT src tree 
include it? If not when this patch will be included in CURRENT?

3. I did make tests with default malloc in CURRENT. I'm confused what 
malloc options should try (jemalloc? phkmalloc?) What is the default 
malloc in CURRENT? How to use these different mallocs?

thanks in advance,

Ganbold


_______________________________________________
freebsd-current_at_freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-current
To unsubscribe, send any mail to
"freebsd-current-unsubscribe_at_freebsd.org"