Skip to content

Instantly share code, notes, and snippets.

@lox
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.
Running a sysbench test against MySQL
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
@lox
Copy link
Author

lox commented Jul 21, 2012

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

@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