Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- root@ubuntu:~# sysbench --num-threads=8 --max-requests=800 --oltp-table-size=500000 --mysql-user=root --mysql-password=root --db-driver=mysql --test=oltp run
- sysbench 0.4.12: multi-threaded system evaluation benchmark
- Running the test with following options:
- Number of threads: 8
- Doing OLTP test.
- Running mixed OLTP 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 800
- Threads started!
- Done.
- OLTP test statistics:
- queries performed:
- read: 11200
- write: 4000
- other: 1600
- total: 16800
- transactions: 800 (245.84 per sec.)
- deadlocks: 0 (0.00 per sec.)
- read/write requests: 15200 (4671.03 per sec.)
- other operations: 1600 (491.69 per sec.)
- Test execution summary:
- total time: 3.2541s
- total number of events: 800
- total time taken by event execution: 25.9664
- per-request statistics:
- min: 9.64ms
- avg: 32.46ms
- max: 94.70ms
- approx. 95 percentile: 53.66ms
- Threads fairness:
- events (avg/stddev): 100.0000/2.35
- execution time (avg/stddev): 3.2458/0.00
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement