Create test DB:
mysql -u root -p mysql> create database test; exit;
Prepare the database:
sysbench --test=oltp --oltp-table-size=100000 --mysql-db=test --mysql-user=root --mysql-password=mysqlpassword prepare
Run the test:
sysbench --test=oltp --oltp-table-size=100000 --mysql-db=test --mysql-user=root --mysql-password=mysqlpassword --max-time=60 --oltp-read-only=on --max-requests=0 --num-threads=8 run
Pi Output:
OLTP test statistics: queries performed: read: 28364 write: 0 other: 4052 total: 32416 transactions: 2026 (33.76 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 28364 (472.67 per sec.) other operations: 4052 (67.52 per sec.) Test execution summary: total time: 60.0080s total number of events: 2026 total time taken by event execution: 59.8767 per-request statistics: min: 12.90ms avg: 29.55ms max: 76.67ms approx. 95 percentile: 50.34ms Threads fairness: events (avg/stddev): 2026.0000/0.00 execution time (avg/stddev): 59.8767/0.00
UDOO output:
OLTP test statistics: queries performed: read: 287532 write: 0 other: 41076 total: 328608 transactions: 20538 (342.19 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 287532 (4790.71 per sec.) other operations: 41076 (684.39 per sec.) Test execution summary: total time: 60.0186s total number of events: 20538 total time taken by event execution: 479.3667 per-request statistics: min: 7.26ms avg: 23.34ms max: 196.47ms approx. 95 percentile: 32.59ms Threads fairness: events (avg/stddev): 2567.2500/50.73 execution time (avg/stddev): 59.9208/0.01
the important bit is the transactions line:
UDOO: transactions: 20538 (342.19 per sec.)
PI: transactions: 2026 (33.76 per sec.)
Last step – drop the test database:
mysql -u root -p mysql> drop database test; exit;