low sysbench scores on 8 core server

Kris Kennaway kris at FreeBSD.org
Mon Jul 7 09:43:20 UTC 2008


Lutz Rabing wrote:
> Kris Kennaway schrieb:
>> 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
>>
>>
>> .
>>
> 
> 
> hi kris,
> 
> thanks for your response. going back to mysql-5.0.51a the 8core server
> performed as expected. (sysbench oltp: 4335 with 8 threads)

Good to know.  Let's hope mysql get their act together with the next 
release ;-)

Kris



More information about the freebsd-performance mailing list