mysqlslap 压力测试100并发不稳定?求解

myplease 发布于 2012/06/19 10:38
阅读 382
收藏 1

请问原因跟处理方案?

加载中
0
mahone
mahone
每次都这样?100我跑过,好像没什么问题。。。可能哪里配置的关系,请高手求解。。。
m
myplease
每次都这样。。。
0
皮总
皮总

台式机测试出来这样的结果很正常:

我在服务器拿你同样的参数也好不到哪里去

Benchmark
        Running for engine innodb
        Average number of seconds to run all queries: 0.164 seconds
        Minimum number of seconds to run all queries: 0.146 seconds
        Maximum number of seconds to run all queries: 0.208 seconds
        Number of clients running queries: 25
        Average number of queries per client: 40

Benchmark
        Running for engine innodb
        Average number of seconds to run all queries: 0.156 seconds
        Minimum number of seconds to run all queries: 0.154 seconds
        Maximum number of seconds to run all queries: 0.158 seconds
        Number of clients running queries: 50
        Average number of queries per client: 20

Benchmark
        Running for engine innodb
        Average number of seconds to run all queries: 0.990 seconds
        Minimum number of seconds to run all queries: 0.178 seconds
        Maximum number of seconds to run all queries: 4.209 seconds
        Number of clients running queries: 100
        Average number of queries per client: 10

Benchmark
        Running for engine innodb
        Average number of seconds to run all queries: 3.231 seconds
        Minimum number of seconds to run all queries: 0.075 seconds
        Maximum number of seconds to run all queries: 4.413 seconds
        Number of clients running queries: 512
        Average number of queries per client: 1


User time 0.71, System time 0.86
Maximum resident set size 0, Integral resident set size 0
Non-physical pagefaults 35464, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 46451, Involuntary context switches 23148

皮总
皮总
回复 @hellokitty1 : http://hidinga.xicp.net/download/database/Mysql/Mysql.Performance.odt
皮总
皮总
回复 @hellokitty1 : 我都能下载啊 !!!
m
myplease
回复 @皮总 : 了。。下载不了
m
myplease
回复 @皮总 : 多谢皮总再造之恩
皮总
皮总
回复 @hellokitty1 : odt 格式文档你可以使用 openoffice 或者 office 2010 打开
下一页
返回顶部
顶部