Jul 27, 2017

How to benchmark with Auto-generated SQL and Data

When we use auto-generated SQL, mysqlslap will create a separate temporary database - aptly called mysqlslap. This database will have a simple table in it with one integer and one varchar type column populated with sample data. This can be a quick and easy way to check the overall performance of the database server.
mysqlslap --login-path=root --auto-generate-sql --verbose

mysqlslap --login-path=root --auto-generate-sql --verbose --concurrency=300 --iterations=10 --number-int-cols=5 --number-char-cols=20

auto-generate-sql is convenient for testing physical capability.