mysqlslap执行基准测试的代码详情介绍

-a, --auto-generate-sql 由系统自动生成SQL脚本进行测试
 Generate SQL where not supplied by file or command line.
 --auto-generate-sql-add-autoincrement 生成的表中增加自增的ID
 Add an AUTO_INCREMENT column to auto-generated tables.--auto-generate-sql-load-type=name 制定测试过程中使用的查询类型
 Specify test load type: mixed, update, write, key, or
 read; default is mixed.--auto-generate-sql-write-number=# 制定所生成的初始化数据的条数
 Number of row inserts to perform for each thread (default
 is 100).-c, --concurrency=name 制定并发线程的数量
 Number of clients to simulate for query to run.
 --create=name File or string to use create tables.
 --create-schema=name 创建一个测试数据库的schema名称
 Schema to run tests in.-T, --debug-info This is a non-debug version. Catch this and exit.指定

mysqlslap -S /tmp/mysql3306.sock --concurrency=1,50,100,200 --iterations=3 --number-int-cols=5 --number-char-cols=5 
--auto-generate-sql --auto-generate-sql-add-autoincrement --engine=innodb --number-of-queries=10
 --create-schema=test -uroot -p

Enter password: 
Benchmark
 Running for engine innodb
 Average number of seconds to run all queries: 0.097 seconds
 Minimum number of seconds to run all queries: 0.093 seconds
 Maximum number of seconds to run all queries: 0.107 seconds
 Number of clients running queries: 1
 Average number of queries per client: 10Benchmark
 Running for engine innodb
 Average number of seconds to run all queries: 0.506 seconds
 Minimum number of seconds to run all queries: 0.447 seconds
 Maximum number of seconds to run all queries: 0.570 seconds
 Number of clients running queries: 50
 Average number of queries per client: 0Benchmark
 Running for engine innodb
 Average number of seconds to run all queries: 2.204 seconds
 Minimum number of seconds to run all queries: 1.595 seconds
 Maximum number of seconds to run all queries: 3.257 seconds
 Number of clients running queries: 100
 Average number of queries per client: 0mysqlslap: Error when connecting to server: 1040 Too many connections
mysqlslap: Error when connecting to server: 1040 Too many connections
mysqlslap: Error when connecting to server: 1040 Too many connections
mysqlslap: Error when connecting to server: 1040 Too many connections

Benchmark
 Running for engine innodb
 Average number of seconds to run all queries: 0.093 seconds
 Minimum number of seconds to run all queries: 0.087 seconds
 Maximum number of seconds to run all queries: 0.098 seconds
 Number of clients running queries: 1
 Average number of queries per client: 10Benchmark
 Running for engine innodb
 Average number of seconds to run all queries: 0.514 seconds
 Minimum number of seconds to run all queries: 0.462 seconds
 Maximum number of seconds to run all queries: 0.545 seconds
 Number of clients running queries: 50
 Average number of queries per client: 0Benchmark
 Running for engine innodb
 Average number of seconds to run all queries: 1.209 seconds
 Minimum number of seconds to run all queries: 1.173 seconds
 Maximum number of seconds to run all queries: 1.241 seconds
 Number of clients running queries: 100
 Average number of queries per client: 0Benchmark
 Running for engine innodb
 Average number of seconds to run all queries: 2.174 seconds
 Minimum number of seconds to run all queries: 1.978 seconds
 Maximum number of seconds to run all queries: 2.402 seconds
 Number of clients running queries: 200
 Average number of queries per client: 0