mysql压力测试及优化

环境

硬件环境：

软件环境：

经测试， innodb_flush_log_at_trx_commit影响较大，

innodb_flush_log_at_trx_commit = 1(默认)时的测试情况：

Benchmark
Running for engine innodb
Average number of seconds to run all queries: 43.718 seconds
Minimum number of seconds to run all queries: 43.718 seconds
Maximum number of seconds to run all queries: 43.718 seconds
Number of clients running queries: 2000
Average number of queries per client: 10


User time 0.10, System time 0.19
Maximum resident set size 0, Integral resident set size 0
Non-physical pagefaults 15784, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 63228, Involuntary context switches 1499

innodb_flush_log_at_trx_commit = 0(改动后)的测试情况：

Benchmark
Running for engine innodb
Average number of seconds to run all queries: 4.469 seconds
Minimum number of seconds to run all queries: 4.469 seconds
Maximum number of seconds to run all queries: 4.469 seconds
Number of clients running queries: 2000
Average number of queries per client: 10


User time 0.18, System time 0.19
Maximum resident set size 0, Integral resident set size 0
Non-physical pagefaults 15480, Physical pagefaults 5, Swaps 0
Blocks in 736 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 61984, Involuntary context switches 2991