Skip to content

Instantly share code, notes, and snippets.

@lox

lox/sysbench.sh

Created April 27, 2011 21:24
Show Gist options
  • Save lox/945244 to your computer and use it in GitHub Desktop.
Save lox/945244 to your computer and use it in GitHub Desktop.
Download ZIP
Running a sysbench test against MySQL
Raw
sysbench.sh
sudo aptitude install sysbench
echo "create database sbtest; grant all on sbtest.* to 'sbtest'@'localhost';" | mysql
sysbench --test=oltp --num-threads=10 prepare
sysbench --test=oltp --num-threads=10 run
@ilyassatch
Copy link

running on my dev server

OLTP test statistics:
queries performed:
read: 140000
write: 50000
other: 20000
total: 210000
transactions: 10000 (381.89 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (7255.96 per sec.)
other operations: 20000 (763.79 per sec.)

Test execution summary:
total time: 26.1854s
total number of events: 10000
total time taken by event execution: 261.6367
per-request statistics:
min: 2.88ms
avg: 26.16ms
max: 58.43ms
approx. 95 percentile: 26.76ms

Threads fairness:
events (avg/stddev): 1000.0000/0.77
execution time (avg/stddev): 26.1637/0.01

I have a question about those statistics , what are the minimum and what are the measures that I need to do for a better performance ?

Thank you

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment