作者:雅白斋ab | 来源:互联网 | 2018-07-11 05:41
mysqlslap是MySQL5.1之后自带的benchmark基准测试工具,该工具可以模拟多个客户端同时并发的向服务器发出查询更新,给出了性能测试数据而且提供了多种引擎的性能
mysqlslap是MySQL5.1之后自带的benchmark基准测试工具,该工具可以模拟多个客户端同时并发的向服务器发出查询更新,给出了性能测试数据而且提供了多种引擎的性能
,
使用自定义脚本进行测试,虚拟主机, 可以是一个存储过程或者SQL语句来执行;
--only-print 只打印测试过程中涉及到的SQL语句,不真正的执行;
举例:
测试200个并发写入性能,测试20次,香港虚拟主机,自动生成SQL脚本,测试表包含35个int字段,香港虚拟主机,20个char字段,测试引擎分别为innodb,myisam;每次执行3000个query;
./bin/mysqlslap --socket=/usr/local/mysql/mysql.sock --port=3306 --cOncurrency=200 --iteratiOns=20 --auto-generate-sql --auto-generate-sql-load-type=write --auto-generate-sql-add-autoincrement --number-int-cols=35 --number-char-cols=20 --engine=innodb,myisam --create-schema=sysbench --number-of-queries=3000 --debug-info
结果为:
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 6.385 seconds
Minimum number of seconds to run all queries: 3.021 seconds
Maximum number of seconds to run all queries: 12.969 seconds
Number of clients running queries: 200
Average number of queries per client: 15
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 0.621 seconds
Minimum number of seconds to run all queries: 0.442 seconds
Maximum number of seconds to run all queries: 1.134 seconds
Number of clients running queries: 200
Average number of queries per client: 15
User time 0.66, System time 1.97
Maximum resident set size 10060, Integral resident set size 0
Non-physical pagefaults 50486, Physical pagefaults 5, Swaps 0
Blocks in 584 out 96, Messages in 0 out 0, Signals 0
Voluntary context switches 298373, Involuntary context switches 1469
自定义SQL测试脚本:
mysqlslap --create=/yourpath/test.sql --query=/yourpath/test1.sql --cOncurrency=50,100,200 --iteratiOns=20 --engine=myisam,innodb
本文出自 “技术成就梦想” 博客,请务必保留此出处