mysql自帶壓力測試工具：mysqlslap taobao dba團隊

作者： 陶方 | 【轉載時請務必以超連結形式标明文章原始出處和作者資訊及本聲明】

位址： http://rdc.taobao.com/blog/dba/html/200_mysql%e5%8e%8b%e5%8a%9b%e6%b5%8b%e8%af%95%e5%b7%a5%e5%85%b7%ef%bc%9amysqlslap.html

mysqlslap是一個mysql官方提供的壓力測試工具。以下是比較重要的參數：

–defaults-file，配置檔案存放位置

–concurrency，并發數

–engines，引擎

–iterations，疊代的實驗次數

–socket，socket檔案位置

自動測試：

–auto-generate-sql，自動産生測試SQL

–auto-generate-sql-load-type，測試SQL的類型。類型有mixed，update，write，key，read。

–number-of-queries，執行的SQL總數量

–number-int-cols，表内int列的數量

–number-char-cols，表内char列的數量

例如：

shell>mysqlslap –defaults-file=/u01/mysql1/mysql/my.cnf –concurrency=50,100 –iterations=1 –number-int-cols=4 –auto-generate-sql –auto-generate-sql-load-type=write –engine=myisam –number-of-queries=200 -S/tmp/mysql1.sock

Benchmark

Running for engine myisam

Average number of seconds to run all queries: 0.016 seconds

Minimum number of seconds to run all queries: 0.016 seconds

Maximum number of seconds to run all queries: 0.016 seconds

Number of clients running queries: 50

Average number of queries per client: 4

Benchmark

Running for engine myisam

Average number of seconds to run all queries: 0.265 seconds

Minimum number of seconds to run all queries: 0.265 seconds

Maximum number of seconds to run all queries: 0.265 seconds

Number of clients running queries: 100

Average number of queries per client: 2

指定資料庫的測試：

–create-schema，指定資料庫名稱

–query，指定SQL語句，可以定位到某個包含SQL的檔案

例如：

shell>mysqlslap –defaults-file=/u01/mysql1/mysql/my.cnf –concurrency=25,50 –iterations=1 –create-schema=test –query=/u01/test.sql -S/tmp/mysql1.sock

Benchmark

Average number of seconds to run all queries: 0.018 seconds

Minimum number of seconds to run all queries: 0.018 seconds

Maximum number of seconds to run all queries: 0.018 seconds

Number of clients running queries: 25

Average number of queries per client: 1

Benchmark

Average number of seconds to run all queries: 0.011 seconds

Minimum number of seconds to run all queries: 0.011 seconds

Maximum number of seconds to run all queries: 0.011 seconds

Number of clients running queries: 50

Average number of queries per client: 1

--EOF--