Options for mariadb-slap & mysqlslap in 10.5 ES¶

The mariadb-slap utility is the newer name for mysqlslap, though you can still run it using either name.

Option

Description

--auto-generate-sql (-a)

Generate SQL where not supplied by file or command line.

--auto-generate-sql-add-autoincrement

Add an AUTO_INCREMENT column to auto-generated tables.

--auto-generate-sql-execute-number

Set this number to generate a set number of queries to run.

--auto-generate-sql-guid-primary

Add GUID based primary keys to auto-generated tables.

--auto-generate-sql-load-type

Specify test load type: mixed, update, write, key, or read; default is mixed.

--auto-generate-sql-secondary-indexes

Number of secondary indexes to add to auto-generated tables.

--auto-generate-sql-unique-query-number

Number of unique queries to generate for automatic tests.

--auto-generate-sql-unique-write-number

Number of unique queries to generate for auto-generate-sql-write-number.

--auto-generate-sql-write-number

Number of row inserts to perform for each thread (default is 100).

--character-sets-dir

Directory for character set files.

--commit

Commit records every X number of statements.

--compress (-C)

Use compression in server/client protocol.

--concurrency (-c)

Number of clients to simulate for query to run.

--create

File or string to use create tables.

--create-schema

Schema to run tests in.

--csv

Generate CSV output to named file or to stdout if no file is named.

--debug (-#)

This is a non-debug version. Catch this and exit.

--debug-check

Check memory and open file usage at exit.

--debug-info (-T)

Print some debug info at exit.

--default-auth

Default authentication client-side plugin to use.

--defaults-extra-file

Read this file after the global files are read.

--defaults-file

Only read default options from the given file #.

--defaults-group-suffix

Additionally read default groups with # appended as a suffix.

--delimiter (-F)

Delimiter to use in SQL statements supplied in file or command line.

--detach

Detach (close and reopen) connections after X number of requests.

--engine (-e)

Comma separated list of storage engines to use for creating the table. The test is run for each engine. You can also specify an option for an engine after a `:', like memory:max_row=2300

--help (-?)

Display this help and exit.

--host (-h)

Connect to host.

--init-command

SQL Command to execute when connecting to MariaDB server. Will automatically be re-executed when reconnecting.

--iterations (-i)

Number of times to run the tests.

--no-defaults

Don't read default options from any option file.

--no-drop

Do not drop the schema after the test.

--number-char-cols (-x)

Number of VARCHAR columns to create in table if specifying --auto-generate-sql.

--number-int-cols (-y)

Number of INT columns to create in table if specifying --auto-generate-sql.

--number-of-queries

Limit each client to this number of queries (this is not exact).

--only-print

Do not connect to the databases, but instead print out what would have been done.

--password (-p)

Password to use when connecting to server. If password is not given it's asked from the tty.

--plugin-dir

Directory for client-side plugins.

--port (-P)

Port number to use for connection.

--post-query

Query to run or file containing query to execute after tests have completed.

--post-system

system() string to execute after tests have completed.

--pre-query

Query to run or file containing query to execute before running tests.

--pre-system

system() string to execute before running tests.

--print-defaults

Print the program argument list and exit.

--protocol

The protocol to use for connection (tcp, socket, pipe).

--query (-q)

Query to run or file containing query to run.

--silent (-s)

Run program in silent mode - no output.

--socket (-S)

The socket file to use for connection.

--ssl

Enable SSL for connection (automatically enabled with other flags).

--ssl-ca

CA file in PEM format (check OpenSSL docs, implies --ssl).

--ssl-capath

CA directory (check OpenSSL docs, implies --ssl).

--ssl-cert

X509 cert in PEM format (implies --ssl).

--ssl-cipher

SSL cipher to use (implies --ssl).

--ssl-crl

Certificate revocation list (implies --ssl).

--ssl-crlpath

Certificate revocation list path (implies --ssl).

--ssl-key

X509 key in PEM format (implies --ssl).

--ssl-verify-server-cert

Verify server's "Common Name" in its cert against hostname used when connecting. This option is disabled by default.

--tls-version

TLS protocol version for secure connection.

--user (-u)

User for login if not current user.

--verbose (-v)

More verbose output; you can use this multiple times to get even more verbose output.

--version (-V)

Output version information and exit.