Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 04 Jul 2008 20:25:04 +0200
From:      Kris Kennaway <kris@FreeBSD.org>
To:        rabing@omc.net
Cc:        freebsd-performance@freebsd.org
Subject:   Re: low sysbench scores on 8 core server
Message-ID:  <486E6B00.10208@FreeBSD.org>
In-Reply-To: <486E4C20.7050102@omc.net>
References:  <486E4C20.7050102@omc.net>

next in thread | previous in thread | raw e-mail | index | archive | help
Lutz Rabing wrote:
> hi,
> 
> I did some testing an a supermicro 2 x 4 core xeon server under 64bit
> "7.0-STABLE #1: Fri Jul  4". when we first tested the system under load
> (2000 apache threads) the system performed bad compare to other dual
> core systems under the same workload.
> 
> the 8 core system had 0% idle time and almost 100% system load. I could
> not find out what the load was. disk IO was close to zero during that time.
> 
> because of that I checked the sysbench results with this test:
> 
> sysbench --test=oltp --mysql-socket=/tmp/mysql.sock --mysql-user=root \
>  --max-requests=0 --max-time=60 --oltp-read -only=on --num-threads=$1 run

See my tuning notes at:

http://people.freebsd.org/~kris/scaling/mysql.html

> software versions used:
>  - mysql-server-5.1.25

In my tests mysql 5.1 has much worse performance than 5.0.

Kris




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?486E6B00.10208>