--number-of-queries=N 每個客戶端執行SQL語句的次數。需要注意的是，每條SQL之間的;都會算作一次，例如--query="use test;insert into t values(null)"就是2次。 mysqlslap --delimiter=";" --number-of-queries=10 --query="use test;insert into t values(null)" 這個語句會執行5次INSERT操作
--concurrency=N, -c N 模擬客戶端的并行度
--iterations=N, -i N 執行壓力測試的次數
--create-schema=value 在哪個用戶下執行壓力測試
--commit=N 執行多少條SQL進行提交，默認沒有提交
--auto-generate-sql, -a 當沒有指定SQL語句的時候，自動生成SQL語句
--number-char-cols=N, -x N 自動生成SQL語句中，VARCHAR字段的個數
[root@localhost ~]# /software/bin/mysqlslap -h 192.168.78.141 --user=system --password=system --query="use fire;select * from test2" --number-of-queries=100000 -c 30 -i 10 --create-schema=neo --執行結果 Benchmark Average number of seconds to run all queries: 6.779 seconds Minimum number of seconds to run all queries: 6.607 seconds Maximum number of seconds to run all queries: 7.310 seconds Number of clients running queries: 30 Average number of queries per client: 3333
[root@localhost ~]# /software/bin/mysqlslap -h 192.168.78.141 --user=system --password=system --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-execute-number=100000 -- commit=10000 --create-schema=neo Benchmark Average number of seconds to run all queries: 16.332 seconds Minimum number of seconds to run all queries: 16.332 seconds Maximum number of seconds to run all queries: 16.332 seconds Number of clients running queries: 1 Average number of queries per client: 100000
