Benchmarking MySQL

manager Tue, 01/13/2015 - 22:26

MySQL compes with a benchmarking tool called mysqlslap since 5.1 to help DBAs.

# mysqladmin -u admin password <password>

# cd mysql_test

# sudo wget https://launchpad.net/test-db/employees-db-1/1.0.6/+download/employees_db-full-1.0.6.tar.bz2

# sudo bzip2 -dfv employees_db-full-1.0.6.tar.bz2
# sudo tar -xf employees_db-full-1.0.6.tar

# cd employees_db/

# mysql -u root -p -t < employees.sql

# sudo mysqlslap --user admin --password --concurrency=100 --iterations=20 --auto-generate-sql --verbose --number-char-cols=20 --number-int-cols=5 --debug-info