-
-
Save lox/945244 to your computer and use it in GitHub Desktop.
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 | |
Run on my Vagrant/virtualbox dev vm
OLTP test statistics:
queries performed:
read: 140000
write: 50000
other: 20000
total: 210000
transactions: 10000 (648.24 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (12316.62 per sec.)
other operations: 20000 (1296.49 per sec.)
Test execution summary:
total time: 15.4263s
total number of events: 10000
total time taken by event execution: 154.1230
per-request statistics:
min: 2.40ms
avg: 15.41ms
max: 94.57ms
approx. 95 percentile: 21.32ms
Threads fairness:
events (avg/stddev): 1000.0000/37.03
execution time (avg/stddev): 15.4123/0.00
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
Run on my local dev vm