Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- root@gwbmgmt:/srv/salt# sysbench --num-threads=16 --max-requests=10000 --test=oltp --oltp-table-size=1000000 --oltp-read-only=on --mysql-host=192.168.1.1 run
- sysbench 0.4.12: multi-threaded system evaluation benchmark
- No DB drivers specified, using mysql
- Running the test with following options:
- Number of threads: 16
- Doing OLTP test.
- Running mixed OLTP test
- Doing read-only test
- Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
- Using "BEGIN" for starting transactions
- Using auto_inc on the id column
- Maximum number of requests for OLTP test is limited to 10000
- Threads started!
- Done.
- OLTP test statistics:
- queries performed:
- read: 140000
- write: 0
- other: 20000
- total: 160000
- transactions: 10000 (664.81 per sec.)
- deadlocks: 0 (0.00 per sec.)
- read/write requests: 140000 (9307.32 per sec.)
- other operations: 20000 (1329.62 per sec.)
- Test execution summary:
- total time: 15.0419s
- total number of events: 10000
- total time taken by event execution: 240.4125
- per-request statistics:
- min: 11.37ms
- avg: 24.04ms
- max: 124.91ms
- approx. 95 percentile: 31.63ms
- Threads fairness:
- events (avg/stddev): 625.0000/17.08
- execution time (avg/stddev): 15.0258/0.01
Advertisement
Add Comment
Please, Sign In to add comment