mysqlslap

mysqlslap is a tool for load-testing MariaDB. It allows you to emulate multiple concurrent connections, and run a set of queries multiple times.

It returns a benchmark including the following information:

• Average number of seconds to run all queries
• Minimum number of seconds to run all queries
• Maximum number of seconds to run all queries
• Number of clients running queries
• Average number of queries per client

Using mysqlslap

The command to use mysqlslap and the general syntax is:

mysqlslap [options]

Options

mysqlslap supports the following options:

Option Files

In addition to reading options from the command-line, mysqlslap can also read options from option files. If an unknown option is provided to mysqlslap in an option file, then it is ignored.

The following options relate to how MariaDB command-line tools handles option files. They must be given as the first argument on the command-line:

In MariaDB 10.2 and later, mysqlslap is linked with MariaDB Connector/C. However, MariaDB Connector/C does not yet handle the parsing of option files for this client. That is still performed by the server option file parsing code. See MDEV-19035 for more information.

Option Groups

mysqlslap reads options from the following option groups from option files:

Examples

Create a table with data, and then query it with 40 simultaneous connections 100 times each.

mysqlslap 
 --delimiter=";" 
 --create="CREATE TABLE t (a int);INSERT INTO t VALUES (5)"
 --query="SELECT * FROM t"
 --concurrency=40
 --iterations=100

Benchmark
	Average number of seconds to run all queries: 0.010 seconds
	Minimum number of seconds to run all queries: 0.009 seconds
	Maximum number of seconds to run all queries: 0.020 seconds
	Number of clients running queries: 40
	Average number of queries per client: 1

Using files to store the create and query SQL. Each file can contain multiple statements separated by the specified delimiter.

mysqlslap
 --create=define.sql
 --query=query.sql
 --concurrency=10
 --iterations=20
 --delimiter=";"

Benchmark
	Average number of seconds to run all queries: 0.002 seconds
	Minimum number of seconds to run all queries: 0.002 seconds
	Maximum number of seconds to run all queries: 0.004 seconds
	Number of clients running queries: 10
	Average number of queries per client: 1