2、Demo2：指定数据库和sql语句
mysqlslap -h192.168.202.84 -P3309 --concurrency=100 --iterations=1 --create-schema='mms_sdmtv' --query='select * from role;' --number-of-queries=10 --debug-info -uroot -p123abc
#备注使用mysqlslap指定sql语句进行测试
3、Demo3：测试用例
|
[root@localhost /]# mysqlslap --concurrency=50,100,200 --iterations=20 --number-int-cols=4 --number-char-cols=35 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=read --engine=myisam,innodb --number-of-queries=200 --verbose --socket=/var/lib/mysql/mysql.sock -uroot -p123abc
#系统脚本测试，增加int型 4列char 型35列，测试2种引擎myisam,innodb读的性能，分别用50，100，200个客户端对服务器进行测试总共200个查询语句 执行20次查询
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 0.666 seconds
Minimum number of seconds to run all queries: 0.223 seconds
Maximum number of seconds to run all queries: 4.889 seconds
Number of clients running queries: 50
Average number of queries per client: 4
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 0.620 seconds
Minimum number of seconds to run all queries: 0.231 seconds
Maximum number of seconds to run all queries: 4.898 seconds
Number of clients running queries: 100
Average number of queries per client: 2
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 0.503 seconds
Minimum number of seconds to run all queries: 0.257 seconds
Maximum number of seconds to run all queries: 4.269 seconds
Number of clients running queries: 200
Average number of queries per client: 1
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 1.049 seconds
Minimum number of seconds to run all queries: 0.244 seconds
Maximum number of seconds to run all queries: 5.292 seconds
Number of clients running queries: 50
Average number of queries per client: 4
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 0.712 seconds
Minimum number of seconds to run all queries: 0.246 seconds
Maximum number of seconds to run all queries: 6.585 seconds
Number of clients running queries: 100
Average number of queries per client: 2
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 0.269 seconds
Minimum number of seconds to run all queries: 0.175 seconds
Maximum number of seconds to run all queries: 0.328 seconds
Number of clients running queries: 200
Average number of queries per client: 1 |
4、自建SQL测试用例
mysqlslap --create=/yourpath/Test1.sql --query=/yourpath/Test2.sql --concurrency=50,100,200 --iterations=20 --engine=myisam,innodb -u root -p123abc
#在设定的yourpath目录下创建你的测试sql文Test1及Test2并进行50、100及200的模拟并发测试
