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@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-current
To unsubscribe, send any mail to "freebsd-current-unsubscribe@xxxxxxxxxxx"



Relevant Pages

  • Re: mysql performance test results under FreeBSD-7.0-CURRENT
    ... I did make some mysql performance tests under FreeBSD-7.0-CURRENT with various ... scheduler and compile time options. ... I didn't make test with Poul-Henning's CPU accounting patch. ... What is the default malloc in CURRENT? ...
    (freebsd-current)
  • Re: mysql performance test results under FreeBSD-7.0-CURRENT
    ... scheduler and compile time options. ... I didn't make test with Poul-Henning's CPU accounting patch. ... I did make tests with default malloc in CURRENT. ... I think it would be equally interesting if you posted benchmarks for MySQL 4.1.x ...
    (freebsd-current)
  • Re: mysql performance test results under FreeBSD-7.0-CURRENT
    ... You need to use the 80 core conductor cables instead of the old standard ... mysql performance test results under FreeBSD-7.0-CURRENT ... I didn't make test with Poul-Henning's CPU accounting patch. ... I did make tests with default malloc in CURRENT. ...
    (freebsd-current)
  • RE: mysql performance test results under FreeBSD-7.0-CURRENT
    ... A couple of things I have noticed in the kernel messages: ... You need to use the 80 core conductor cables instead of the old standard ... I didn't make test with Poul-Henning's CPU accounting patch. ... I did make tests with default malloc in CURRENT. ...
    (freebsd-current)
  • Re: [RFC][PATCH] inline a few tiny functions in init/initramfs.c
    ... > the patch makes sense, but the malloc() is not clear cut. ... Send instant messages to your online friends http://au.messenger.yahoo.com ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)