v-thomp4/gist:eac6d89cc889b7512b4c

Created September 6, 2014 02:43

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/v-thomp4/eac6d89cc889b7512b4c.js"></script>
Save v-thomp4/eac6d89cc889b7512b4c to your computer and use it in GitHub Desktop.

BENCHMARK MYSQL SERVER PERFORMANCE WITH SYSBENCH

Raw

apt-get install sysbench  
create database dbtest;

sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=dbtest --mysql-user=[USER] --mysql-password=[PASSWORD] prepare  
sysbench --test=oltp --oltp-table-size=1000000 --oltp-test-mode=complex --oltp-read-only=off --num-threads=6 --max-time=60 --max-requests=0 --mysql-db=dbtest --mysql-user=[USER] --mysql-password=[PASSWORD] run