mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. It works as if multiple clients are accessing the server. mysqlslap is available as of MySQL 5.1.4.
--auto-generate-sql-write-number
--auto-generate-sql-guid-primary
--number-of-queries=50000
--concurrency=10,50,100
-i, --iterations
--number-char-cols=10
--number-int-cols=10
下面是一个完整的例子:
mysqlslap -hlocalhost -uroot --engine=innodb --auto-generate-sql-write-number=100000 \ --auto-generate-sql-guid-primary --concurrency=10,50,100 --number-of-queries=500000 \ --iterations=2 --number-char-cols=10 --number-int-cols=10 --auto-generate-sql \ --create-schema=sbtest --auto-generate-sql-load-type=mixed
本文出自 “MySQL中文网”博客 http://www.imysql.cn/