Sep 19, 2018

The most useful mysqlslap options.

OptionWhat it means
--concurrencyThe number of simultaneous client connections mysqlslap will emulate
--iterationsThe number of times the test query will be run
--create-schemaThe database where the query will be run
--queryThe query to execute. This can either be a SQL query string or a path to a SQL script file
--createThe query to create a table. Again, this can be a query string or a path to a SQL file
--delimiterThe delimiter used to separate multiple SQL statements
--engineThe MySQL database engine to use (e.g., InnoDB)
--auto-generate-sqlLets MySQL perform load testing with its own auto-generated SQL command