Wednesday, March 2, 2011

Performance Test for mysql handlersocket(1)

Get the Handlesocket info by Yoshinori  blog,I test it by perl client and get the expected report.
a)Process=16 and request=1000000*16   

QPS:130429
Mysql server Cpu(s): 29.0%us, 20.6%sy 

b)Process=32 and request=1000000*32

QPS:268294
Mysql server Cpu(s): 58.1%us, 27.8%sy

c)Process=64 and request=1000000*64

QPS:291960
Mysql server Cpu(s): 58.8%us, 28.7%sy

my server configuration as following:
Intel(R) Xeon(R) E5620 X86-64 2.40GHz
2 CPU x 8 Cores/CPU
Linux 2.6.9
32 GB RAM
CentOS release 5.3

No comments:

Post a Comment