Skip to content

Instantly share code, notes, and snippets.

@sergeycherepanov

sergeycherepanov/mysql sysbench

Created September 7, 2015 13:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sergeycherepanov/0c45abbd2b395f5d87e2 to your computer and use it in GitHub Desktop.
Save sergeycherepanov/0c45abbd2b395f5d87e2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql sysbench
For Debian, sysbench is hard to beat. It's a simple 1-2-3:
Install
sudo apt-get install sysbench
Prepare
sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=test --mysql-user=root --mysql-password=yourrootsqlpassword prepare
Benchmark
sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=test --mysql-user=root --mysql-password=yourrootsqlpassword --max-time=60 --oltp-read-only=on --max-requests=0 --num-threads=8 run
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment