Databases Reference
In-Depth Information
(last message repeated 7 times)
Done.
OLTP test statistics:
queries performed:
read: 179606
write: 0
other: 25658
total: 205264
transactions: 12829 (213.07 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 179606 (2982.92 per sec.)
other operations: 25658 (426.13 per sec.)
Test execution summary:
total time: 60.2114s
total number of events: 12829
total time taken by event execution: 480.2086
per-request statistics:
min: 0.0030s
avg: 0.0374s
max: 1.9106s
approx. 95 percentile: 0.1163s
Threads fairness:
events (avg/stddev): 1603.6250/70.66
execution time (avg/stddev): 60.0261/0.06
As before, there's quite a bit of information in the results. The most interesting parts are:
• The transaction count
• The rate of transactions per second
• The timing statistics (minimal, average, maximal, and 95th percentile time)
• The thread-fairness statistics, which show how fair the simulated workload was
The example we've given is applicable to version 4 of
sysbench
, which is available in
prebuilt binaries from SourceForge.net. However, if you're willing to compile
sys-
bench
from the source code on Launchpad (it's easy and tastes great!), you can take
advantage of a lot of improvements in version 5. You can run benchmarks against
multiple tables instead of a single table, and you can observe throughput and response
time at regular intervals, such as every 10 seconds. These metrics are very important
for understanding system behavior.
Other sysbench features
The
sysbench
tool can run several other system benchmarks that don't measure a
database server's performance directly:
memory
Exercises sequential memory reads or writes.
