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.
Post a Comment

Featured Post

Updated Coupons / promo codes for Google Apps for Work / Business

To redeem: 1. Sign up for Google Apps   2. Go to your billing settings  3. Choose your payment plan  4. Enter your promo code ...