生产库测试

mysqlslap --no-defaults --debug-info -uroot -p \
--number-int-cols=5 --number-char-cols=10 --auto-generate-sql --auto-generate-sql-add-autoincrement \
--concurrency=100 --number-of-queries=100000 --iterations=3 --engine=innodb

Benchmark
        Running for engine innodb
        Average number of seconds to run all queries: 42.369 seconds
        Minimum number of seconds to run all queries: 27.982 seconds
        Maximum number of seconds to run all queries: 70.434 seconds
        Number of clients running queries: 100
        Average number of queries per client: 1000

User time 7.32, System time 5.95
Maximum resident set size 6384, Integral resident set size 0
Non-physical pagefaults 3046, Physical pagefaults 48, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 581216, Involuntary context switches 5034