mysq
创新互联公司是一家集网站建设,三台企业网站建设,三台品牌网站建设,网站定制,三台网站建设报价,网络营销,网络优化,
三台网站推广为一体的创新建站企业,帮助传统企业提升企业形象加强企业竞争力。可充分满足这一群体相比中小企业更为丰富、高端、多元的互联网需求。同时我们时刻保持专业、时尚、前沿,时刻以成就客户成长自我,坚持不断学习、思考、沉淀、净化自己,让我们为更多的企业打造出实用型网站。lslap是官方的一款做压力测试的工具,可以模拟多个客户端进行并发测试。
比如可以模拟多少并发,执行多少次,针对某个存储引擎……等等
比如对myisam引擎做并发量为100,查询次数为1000
--concurrency用于指定并发量,--number-of-queries=1000用于指定查询次数,--engine用于指定存储引擎
-a则是自动生成SQL(当未提供file或command时)
- [op@sAno1y ~]$ mysqlslap -a --concurrency=100 --number-of-queries=1000 --engine=myisam -uroot -proot
- Warning: Using a password on the command line interface can be insecure.
- Benchmark
- Running for engine myisam
- Average number of seconds to run all queries: 0.167 seconds
- Minimum number of seconds to run all queries: 0.167 seconds
- Maximum number of seconds to run all queries: 0.167 seconds
- Number of clients running queries: 100
- Average number of queries per client: 10
-
- Benchmark
- Running for engine myisam
- Average number of seconds to run all queries: 0.170 seconds
- Minimum number of seconds to run all queries: 0.170 seconds
- Maximum number of seconds to run all queries: 0.170 seconds
- Number of clients running queries: 200
- Average number of queries per client: 5
名称栏目:官方压测工具mysqlslap介绍及使用-创新互联
网页地址:
http://cdxtjz.cn/article/cegphi.html