查看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.指定输出额外的内存及cpu统计信息-e,
--engine=name storage engine to use for creating the table. 指定所测试的存储引擎，用逗号可以分割以便测试多个引擎
-h, --host=name connect to host. 链接远程主机的ip
-i, --iterations=# number of times to run the tests. 指定本次测试需要运行的次数
--no-drop do not drop the schema after the test. 指定测试完成后，不清理过程数据
-x, --number-char-cols=name 指定测试表中生成的varchar类型的数据数量
number of varchar columns to create in table if
specifying --auto-generate-sql.
-y, --number-int-cols=name 指定测试表中生成的int类型的数据数量
number of int columns to create in table if specifying
--auto-generate-sql.
--number-of-queries=# 指定每一个线程所执行的查询数量
limit each client to this number of queries (this is not
exact).
--only-print do not connect to the databases, but instead print out 并不运行测试脚本，而是把生成的脚本打印出来
what would have been done.
-p, --password[=name] 指定测试所用的链接数据库的密码
password to use when connecting to server. if password is
not given it's asked from the tty.-q, --query=name query to run or file containing query to run.自定义测试用的sql
-u, --user=name user for login if not current user. 指定测试所用的链接数据库的用户名
其中，完整的运行脚本如下
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
此时可以看出来，当并发达到了200的时候，出现了too many connections的异常，这是因为mysql默认配置的最大链接数为100，故需要对my.cnf做如下的修改
添加max_connections=1024，之后运行正常
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
以上就是mysqlslap执行基准测试的代码详情介绍的内容。