以下的测试环境为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