本文共 7499 字,大约阅读时间需要 24 分钟。
mysqlslap是从MySQL的5.1.4版开始就开始官方提供的压力测试工具。通过模拟多个并发客户端并发访问MySQL来执行压力测试,同时提供了较详细的SQL执行数据性能报告,并且能很好的对比多个存储引擎(MyISAM,InnoDB等)在相同环境下的相同并发压力下的性能差别。
mysqlslap官方文档: https://dev.mysql.com/doc/refman/5.6/en/mysqlslap.html
Table 4.14 mysqlslap Options
Format | Description | Introduced |
---|---|---|
Generate SQL statements automatically when they are not supplied in files or using command options | ||
Add AUTO_INCREMENT column to automatically generated tables | ||
Specify how many queries to generate automatically | ||
Add a GUID-based primary key to automatically generated tables | ||
Specify the test load type | ||
Specify how many secondary indexes to add to automatically generated tables | ||
How many different queries to generate for automatic tests. | ||
How many different queries to generate for --auto-generate-sql-write-number | ||
How many row inserts to perform on each thread | ||
How many statements to execute before committing. | ||
Compress all information sent between client and server | ||
Number of clients to simulate when issuing the SELECT statement | ||
File or string containing the statement to use for creating the table | ||
Schema in which to run the tests | ||
Generate output in comma-separated values format | ||
Write debugging log | ||
Print debugging information when program exits | ||
Print debugging information, memory, and CPU statistics when program exits | ||
Authentication plugin to use | 5.6.2 | |
Read named option file in addition to usual option files | ||
Read only named option file | ||
Option group suffix value | ||
Delimiter to use in SQL statements | ||
Detach (close and reopen) each connection after each N statements | ||
Enable cleartext authentication plugin | 5.6.7 | |
Storage engine to use for creating the table | ||
Display help message and exit | ||
Connect to MySQL server on given host | ||
Number of times to run the tests | ||
Read login path options from .mylogin.cnf | 5.6.6 | |
Read no option files | ||
Do not drop any schema created during the test run | 5.6.3 | |
Number of VARCHAR columns to use if --auto-generate-sql is specified | ||
Number of INT columns to use if --auto-generate-sql is specified | ||
Limit each client to approximately this number of queries | ||
Do not connect to databases. mysqlslap only prints what it would have done | ||
Password to use when connecting to server | ||
On Windows, connect to server using named pipe | ||
Directory where plugins are installed | 5.6.2 | |
TCP/IP port number to use for connection | ||
File or string containing the statement to execute after the tests have completed | ||
String to execute using system() after the tests have completed | ||
File or string containing the statement to execute before running the tests | ||
String to execute using system() before running the tests | ||
Print default options | ||
Connection protocol to use | ||
File or string containing the SELECT statement to use for retrieving data | ||
Do not send passwords to server in old (pre-4.1) format | 5.6.17 | |
The name of shared memory to use for shared-memory connections | ||
Silent mode | ||
For connections to localhost, the Unix socket file to use | ||
Enable secure connection | ||
Path of file that contains list of trusted SSL CAs | ||
Path of directory that contains trusted SSL CA certificates in PEM format | ||
Path of file that contains X509 certificate in PEM format | ||
List of permitted ciphers to use for connection encryption | ||
Path of file that contains certificate revocation lists | 5.6.3 | |
Path of directory that contains certificate revocation list files | 5.6.3 | |
Path of file that contains X509 key in PEM format | ||
Security state of connection to server | 5.6.30 | |
Verify server certificate Common Name value against host name used when connecting to server | ||
MySQL user name to use when connecting to server | ||
Verbose mode | ||
Display version information and exit |
参数参考表: --host=host_name, -h host_name 连接到的MySQL服务器的主机名(或IP地址),默认为本机localhost
[root@mysql ~]# mysqlslap -a --concurrency=50,100 --number-of-queries 1000 --auto-generate-sql-add-autoincrement --number-char-cols=10 --number-int-cols=5 -poracle
Warning: Using a password on the command line interface can be insecure. Benchmark Average number of seconds to run all queries: 0.775 seconds Minimum number of seconds to run all queries: 0.775 seconds Maximum number of seconds to run all queries: 0.775 seconds Number of clients running queries: 50 Average number of queries per client: 20Benchmark
Average number of seconds to run all queries: 0.984 seconds Minimum number of seconds to run all queries: 0.984 seconds Maximum number of seconds to run all queries: 0.984 seconds Number of clients running queries: 100 Average number of queries per client: 10[root@mysql ~]# mysqlslap -a --concurrency=50,100 --number-of-queries 1000 --auto-generate-sql-add-autoincrement --number-char-cols=10 --number-int-cols=5 --engine=myisam,innodb -poracle
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.117 seconds Minimum number of seconds to run all queries: 0.117 seconds Maximum number of seconds to run all queries: 0.117 seconds Number of clients running queries: 50 Average number of queries per client: 20Benchmark
Running for engine myisam Average number of seconds to run all queries: 0.129 seconds Minimum number of seconds to run all queries: 0.129 seconds Maximum number of seconds to run all queries: 0.129 seconds Number of clients running queries: 100 Average number of queries per client: 10Benchmark
Running for engine innodb Average number of seconds to run all queries: 1.665 seconds Minimum number of seconds to run all queries: 1.665 seconds Maximum number of seconds to run all queries: 1.665 seconds Number of clients running queries: 50 Average number of queries per client: 20Benchmark
Running for engine innodb Average number of seconds to run all queries: 1.480 seconds Minimum number of seconds to run all queries: 1.480 seconds Maximum number of seconds to run all queries: 1.480 seconds Number of clients running queries: 100 Average number of queries per client: 10来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31383567/viewspace-2140611/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31383567/viewspace-2140611/