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
结果为：
BenchmarkRunning for engine innodbAverage number of seconds to run all queries: 6.385 secondsMinimum number of seconds to run all queries: 3.021 secondsMaximum number of seconds to run all 本文来源gaodaimacom搞#代%码@网-queries: 12.969 secondsNumber of clients running queries: 200Average number of queries per client: 15BenchmarkRunning for engine myisamAverage number of seconds to run all queries: 0.621 secondsMinimum number of seconds to run all queries: 0.442 secondsMaximum number of seconds to run all queries: 1.134 secondsNumber of clients running queries: 200Average number of queries per client: 15User time 0.66, System time 1.97Maximum resident set size 10060, Integral resident set size 0Non-physical pagefaults 50486, Physical pagefaults 5, Swaps 0Blocks in 584 out 96, Messages in 0 out 0, Signals 0Voluntary 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
本文出自 “技术成就梦想” 博客，请务必保留此出处
转载请注明原文链接：MySQL基准测试工具-mysqlslap
