不同rpm 安装mysql 和手工编译之间的性能差异

 

以下的测试环境为Centos 64  位，6G内存，xen 5560 CPU 环境下测试。

 

通过super-smack 对mysql 单表压力测试结果：

 

手工编译单表性能：
手工编译5.0.77 读性能：
[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql select-script.smack 400 1000 
Query Barrel Report for client smacker
connect: max=789ms  min=4ms avg= 215ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    800000             12             0           20020.95
[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql select-script.smack 400 1000
Query Barrel Report for client smacker
connect: max=2009ms  min=2ms avg= 791ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    800000             233            4           16143.02
[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql select-script.smack 400 1000
Query Barrel Report for client smacker
connect: max=2056ms  min=3ms avg= 783ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    800000  235     0       16062.39
[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql select-script.smack 100 1000  
Query Barrel Report for client smacker
connect: max=211ms  min=3ms avg= 86ms from 100 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    200000             3               0           33004.43
[root@GZF_CCMSBAK_ALL smacks]# vim select-script.smack                          
[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql select-script.smack 400 1000 
Query Barrel Report for client smacker
connect: max=2385ms  min=2ms avg= 788ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    800000            9               0            33098.85
------------------------------------------------------------------------------------------
rpm 包读性能：
[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql select-script2.smack 400 1000
Query Barrel Report for client smacker
connect: max=1051ms  min=1ms avg= 55ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    800000            654             11           17153.47
[root@GZF_CCMSBAK_ALL smacks]# vim select-script2.smack
[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql select-script2.smack 400 1000
Query Barrel Report for client smacker
connect: max=3776ms  min=4ms avg= 154ms from 400 clients
Query_type      num_queries     max_time        min_time         q_per_s
select_index    800000            13                0           17940.27
[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql select-script2.smack 400 1000
Query Barrel Report for client smacker
connect: max=3064ms  min=3ms avg= 186ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    800000            16               0           16942.94
[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql select-script2.smack 100 1000
Query Barrel Report for client smacker
connect: max=16ms  min=1ms avg= 6ms from 100 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    200000    3         0        31295.94
[root@GZF_CCMSBAK_ALL smacks]# vim select-script2.smack
[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql select-script2.smack 400 1000
Query Barrel Report for client smacker
connect: max=1051ms  min=2ms avg= 57ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    800000   216       0        31076.90
--------------------------------------------------------------------------------------
手工编译mysql 写性能：
[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql update2.smack 400 1000
Query Barrel Report for client smacker
connect: max=8ms  min=1ms avg= 2ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
update_index    400000    757       0          10361.38

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql update.smack 400 1000
Query Barrel Report for client smacker
connect: max=8ms  min=1ms avg= 2ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
update_index    400000             728            0             10174.02

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql update.smack 200 1000
Query Barrel Report for client smacker
connect: max=7ms  min=1ms avg= 2ms from 200 clients
Query_type      num_queries     max_time        min_time        q_per_s
update_index    200000             18                0          10937.79

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql update.smack 200 1000
Query Barrel Report for client smacker
connect: max=7ms  min=1ms avg= 2ms from 200 clients
Query_type      num_queries     max_time        min_time        q_per_s
update_index    200000            19               0           10813.35

------------------------------------------------------------------------------------
rpm 包mysql 写性能：
[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql update2.smack 400 1000
Query Barrel Report for client smacker
connect: max=361ms  min=2ms avg= 185ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
update_index    400000           600              0             12161.02

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql update2.smack 400 1000
Query Barrel Report for client smacker
connect: max=429ms  min=2ms avg= 164ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
update_index     400000           100               0           12322.42

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql update2.smack 200 1000
Query Barrel Report for client smacker
connect: max=218ms  min=2ms avg= 91ms from 200 clients
Query_type      num_queries     max_time        min_time        q_per_s
update_index    200000             14              0            13951.29

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql update2.smack 200 1000
Query Barrel Report for client smacker
connect: max=161ms  min=2ms avg= 75ms from 200 clients
Query_type      num_queries     max_time        min_time        q_per_s
update_index    200000             15             0            13087.62

--------------------------------------------------------------------------------------------
手工编译5.1.48 版本，写并发

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql update2.smack 200 1000
Query Barrel Report for client smacker
connect: max=6ms  min=0ms avg= 1ms from 200 clients
Query_type      num_queries     max_time        min_time        q_per_s
update_index    200000            18               3            9919.06

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql update2.smack 200 1000
Query Barrel Report for client smacker
connect: max=6ms  min=1ms avg= 1ms from 200 clients
Query_type      num_queries     max_time        min_time        q_per_s
update_index    200000            16               2           11076.92

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql update2.smack 200 1000
Query Barrel Report for client smacker
connect: max=5ms  min=0ms avg= 1ms from 200 clients
Query_type      num_queries     max_time        min_time        q_per_s
update_index    200000             15                1       10883.03

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql update2.smack 400 1000
Query Barrel Report for client smacker
connect: max=7ms  min=0ms avg= 1ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
update_index    400000             58              0            9842.13

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql update2.smack 400 1000
Query Barrel Report for client smacker
connect: max=5ms  min=0ms avg= 1ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
update_index    400000             78             0            10004.19
--------------------------------------------------------------------------------------------
手工编译5.1.48 版本，读并发

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql select-script2.smack 400 1000             
Query Barrel Report for client smacker
connect: max=1449ms  min=0ms avg= 66ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index      800000           219             0           32229.45

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql select-script2.smack 400 1000
Query Barrel Report for client smacker
connect: max=635ms  min=1ms avg= 39ms from 400 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    800000            639             0            31731.96

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql select-script2.smack 200 1000
Query Barrel Report for client smacker
connect: max=16ms  min=1ms avg= 8ms from 200 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    400000              6             0            32315.50

[root@GZF_CCMSBAK_ALL smacks]# super-smack -d mysql select-script2.smack 200 1000
Query Barrel Report for client smacker
connect: max=18ms  min=1ms avg= 8ms from 200 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index     400000             6               0            32298.61