How to use sysbench" linux tool?

Here is what worked for me. I have Redhat CentOS Linux, so i installed sysbench this way:

# yum install sysbench

Then i created test mysql db:

# mysql
# create database dbtest;

Then i filled mysql database with data:

# sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=dbtest --mysql-user=root --mysql-password=YOURMYSQLROOTPASSWORD --db-driver=mysql prepare

Then run mysql benchmark:

#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=root --mysql-password=YOURMYSQLROOTPASSWORD --db-driver=mysql run

result:

OLTP test statistics:
queries performed:
read: 48118
write: 17185
other: 6874
total: 72177
transactions: 3437 (57.22 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 65303 (1087.11 per sec.)
other operations: 6874 (114.43 per sec.)

Test execution summary:
total time: 60.0700s
total number of events: 3437
total time taken by event execution: 360.3067
per-request statistics:
min: 33.45ms
avg: 104.83ms
max: 883.73ms
approx. 95 percentile: 204.15ms

Threads fairness:
events (avg/stddev): 572.8333/1.46
execution time (avg/stddev): 60.0511/0.02
result 2:
OLTP test statistics:
queries performed:
read: 26726
write: 9545
other: 3818
total: 40089
transactions: 1909 (31.72 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 36271 (602.77 per sec.)
other operations: 3818 (63.45 per sec.)

Test execution summary:
total time: 60.1736s
total number of events: 1909
total time taken by event execution: 360.9503
per-request statistics:
min: 56.09ms
avg: 189.08ms
max: 1587.16ms
approx. 95 percentile: 351.58ms

Threads fairness:
events (avg/stddev): 318.1667/1.95
execution time (avg/stddev): 60.1584/0.03
result 3 (after cleanup and database re-create):
OLTP test statistics:
queries performed:
read: 43120
write: 15400
other: 6160
total: 64680
transactions: 3080 (51.23 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 58520 (973.31 per sec.)
other operations: 6160 (102.45 per sec.)

Test execution summary:
total time: 60.1248s
total number of events: 3080
total time taken by event execution: 360.4040
per-request statistics:
min: 35.78ms
avg: 117.01ms
max: 1644.20ms
approx. 95 percentile: 221.33ms

Threads fairness:
events (avg/stddev): 513.3333/1.11
execution time (avg/stddev): 60.0673/0.02
result 4:
OLTP test statistics:
queries performed:
read: 28896
write: 10320
other: 4128
total: 43344
transactions: 2064 (34.03 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 39216 (646.54 per sec.)
other operations: 4128 (68.06 per sec.)

Test execution summary:
total time: 60.6550s
total number of events: 2064
total time taken by event execution: 363.2038
per-request statistics:
min: 41.82ms
avg: 175.97ms
max: 2430.97ms
approx. 95 percentile: 470.59ms

Threads fairness:
events (avg/stddev): 344.0000/2.58
execution time (avg/stddev): 60.5340/0.12
result 5 (after cleanup & db re-create):
OLTP test statistics:
queries performed:
read: 30870
write: 11025
other: 4410
total: 46305
transactions: 2205 (36.70 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 41895 (697.39 per sec.)
other operations: 4410 (73.41 per sec.)

Test execution summary:
total time: 60.0743s
total number of events: 2205
total time taken by event execution: 360.2575
per-request statistics:
min: 34.42ms
avg: 163.38ms
max: 1859.95ms
approx. 95 percentile: 479.98ms

Threads fairness:
events (avg/stddev): 367.5000/1.26
execution time (avg/stddev): 60.0429/0.02
result 6 (after cleanup, db re-create & setting mysql tmpdir to /deb/shm (ram)):
OLTP test statistics:
queries performed:
read: 22834
write: 8155
other: 3262
total: 34251
transactions: 1631 (27.13 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 30989 (515.47 per sec.)
other operations: 3262 (54.26 per sec.)

Test execution summary:
total time: 60.1182s
total number of events: 1631
total time taken by event execution: 360.3543
per-request statistics:
min: 69.78ms
avg: 220.94ms
max: 1392.18ms
approx. 95 percentile: 420.25ms

Threads fairness:
events (avg/stddev): 271.8333/1.07
execution time (avg/stddev): 60.0590/0.04
result 7 (after /tmp/mysqltmp tmpfs):
OLTP test statistics:
queries performed:
read: 41300
write: 14750
other: 5900
total: 61950
transactions: 2950 (49.10 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 56050 (932.92 per sec.)
other operations: 5900 (98.20 per sec.)

Test execution summary:
total time: 60.0800s
total number of events: 2950
total time taken by event execution: 360.3244
per-request statistics:
min: 33.38ms
avg: 122.14ms
max: 1141.61ms
approx. 95 percentile: 283.84ms

Threads fairness:
events (avg/stddev): 491.6667/2.43
execution time (avg/stddev): 60.0541/0.02
result 8 (/dev/shm once again after cleanup):
OLTP test statistics:
queries performed:
read: 30926
write: 11045
other: 4418
total: 46389
transactions: 2209 (36.69 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 41971 (697.20 per sec.)
other operations: 4418 (73.39 per sec.)

Test execution summary:
total time: 60.1997s
total number of events: 2209
total time taken by event execution: 360.9785
per-request statistics:
min: 41.79ms
avg: 163.41ms
max: 2356.52ms
approx. 95 percentile: 425.06ms

Threads fairness:
events (avg/stddev): 368.1667/4.34
execution time (avg/stddev): 60.1631/0.03
AS CAN BE SEEN VALUES ARE VERY VARIABLE SO I CANT UNDERSTAND HOW THIS TOOL CAN BE BENEFICIAL FOR MYSQL BENCHMARKING, except on server which is plain and all ports closed (closed environment)

remove mysql database after benchmarking:

# sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=dbtest --mysql-user=root --mysql-password=YOURMYSQLROOTPASSWORD --db-driver=mysql cleanup

-------------
Got following errors?
Code:
FATAL: no database driver specified
FATAL: failed to initialize database driver!
you need to add db driver into your command, example: "--db-driver=mysql"