MySQL 8 Administrator???s Guide

mysqlslap - load emulation client

This is the diagnostic client program that is used to check client load capability for the MySQL server. The program mimics multiple clients accessing the server.

The execution syntax is as follows:

shell> mysqlslap [options]

There are many options available to modify the command in execution, some of them, such as --create or --query , provide a way to specify SQL statements or files with statements with specific delimiters.

mysqlslap runs at three different stages :

1. Creating table, schema, and optionally stored programs or data to test. It uses a single client connection only.
2. Running the load test. It uses multiple client connections.
3. Cleaning up (dropping tables if specified earlier, and disconnecting). ...