MySQL Benchmark using Sysbenc

Install Sysbench
apt-get install sysbench  
Prepare Dummy Database
sysbench --test=/usr/share/doc/sysbench/tests/db/oltp.lua --oltp-table-size=1000000 --mysql-db=lukman_benchmark --mysql-host=localhost --mysql-user=root --mysql-password=<yourrootsqlpassword> prepare  
Initialize Benchmark
sysbench --test=/usr/share/doc/sysbench/tests/db/oltp.lua --oltp-table-size=1000000 --mysql-db=lukman_benchmark --mysql-host=localhost --mysql-user=root --mysql-password=<yourrootsqlpassword> --max-time=60 --oltp-read-only=on --max-requests=0 --num-threads=8 run
The Results
sysbench 0.5:  multi-threaded system evaluation benchmark

Running the test with following options:  
Number of threads: 8  
Random number generator seed is 0 and will be ignored


Initializing worker threads...

Threads started!

OLTP test statistics:  
    queries performed:
        read:                            3359496
        write:                           0
        other:                           479928
        total:                           3839424
    transactions:                        239964 (3999.27 per sec.)
    read/write requests:                 3359496 (55989.72 per sec.)
    other operations:                    479928 (7998.53 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:  
    total time:                          60.0020s
    total number of events:              239964
    total time taken by event execution: 479.5886s
    response time:
         min:                                  1.64ms
         avg:                                  2.00ms
         max:                                  5.84ms
         approx.  95 percentile:               2.20ms

Threads fairness:  
    events (avg/stddev):           29995.5000/927.09
    execution time (avg/stddev):   59.9486/0.00

Lukman

Radio astronomer pretending to be system engineer.

Bandung, Indonesia