mysqlslap工具使用.docVIP

mysqlslap工具使用工具运行分为4个步骤：创建数据库和表插入数据执行查询更新 等操作 query（测试的主要内容）以下称为查询删除数据库1.使用自动生成的脚本测试mysqlslap --help可以查看具体的参数的用法例子：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=/usr/local/mysql1/var/mysql.sock -u root -p123使用系统自带的脚本测试，增 加auto_increment一列，int4列char35列，测试2种引擎myisam,innodb读的性能分别用50，100，200个客户端对 服务器进行测试总共200个查询语句 执行20次查询加个--only-print不连接数据库只打印要做什么 BenchmarkRunning for engine myisamAverage number of seconds to run all queries: 0.897 secondsMinimum number of seconds to run all queries: 0.081 secondsMaximum number of seconds to run all queries: 1.239 secondsNumber of clients running queries: 50Average number of queries per client: 4###### 50个并发客户端 平均每个客户端4个查询 20次查询中最少的时间是0.081秒、 最多1.239秒、平均0.897秒。BenchmarkRunning for engine myisamAverage number of seconds to run all queries: 1.544 secondsMinimum number of seconds to run all queries: 0.000 secondsMaximum number of seconds to run all queries: 4.174 secondsNumber of clients running queries: 100Average number of queries per client: 2BenchmarkRunning for engine myisamAverage number of seconds to run all queries: 1.671 secondsMinimum number of seconds to run all queries: 0.005 secondsMaximum number of seconds to run all queries: 5.724 secondsNumber of clients running queries: 200Average number of queries per client: 1BenchmarkRunning for engine innodbAverage number of seconds to run all queries: 1.074 secondsMinimum number of seconds to run all queries: 0.000 secondsMaximum number of seconds to run all queries: 1.994 secondsNumber of clients running queries: 50Average number of queries per client: 4BenchmarkRunning for engine innodbAverage number of seconds to run all queries: 1.088 secondsMinimum number of seconds to run all queries: 0.000 secondsMaximum number of seconds to