文章连接在这mysql自带的性能和压力测试工具:mysqlslap 里面的参数及结果是什么含义?User time 6.50, System time 4.95
Maximum resident set size 0, Integral resident set size 0
Non-physical pagefaults 130258, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 122508, Involuntary context switches 49407
ps:单台mysql一般支持多达的并发?
Maximum resident set size 0, Integral resident set size 0
Non-physical pagefaults 130258, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 122508, Involuntary context switches 49407
ps:单台mysql一般支持多达的并发?
Bench
Running for engine myisam
Average number of seconds to run all queries: 1.039 seconds
Minimum number of seconds to run all queries: 0.919 seconds
Maximum number of seconds to run all queries: 1.162 seconds
Number of clients running queries: 100
Average number of queries per client: 10
=============================================================================
以上面的为例子,100个用户,总1000次查询,每个用户10次。测试5次
Average number of seconds to run all queries: 1.039 seconds 这个时间指的是什么?是每条sql语句的时间还是,每次查询sql的总时间?
这个蛮清楚