low sysbench scores on 8 core server
Lutz Rabing
rabing at omc.net
Mon Jul 7 08:45:46 UTC 2008
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)
thanks,
lutz
More information about the freebsd-performance
mailing list