Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sysbench --test=oltp --mysql-password='****' --mysql-user='root' --mysql-db='test' --mysql-table-engine=myisam --num-threads=100 --max-requests=100000 --oltp-read-only=on 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: 100
- 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 "LOCK TABLES READ" for starting transactions
- Using auto_inc on the id column
- Maximum number of requests for OLTP test is limited to 100000
- Threads started!
- Done.
- OLTP test statistics:
- queries performed:
- read: 1400056
- write: 0
- other: 200008
- total: 1600064
- transactions: 100004 (4390.98 per sec.)
- deadlocks: 0 (0.00 per sec.)
- read/write requests: 1400056 (61473.79 per sec.)
- other operations: 200008 (8781.97 per sec.)
- Test execution summary:
- total time: 22.7748s
- total number of events: 100004
- total time taken by event execution: 2273.9440
- per-request statistics:
- min: 1.32ms
- avg: 22.74ms
- max: 182.68ms
- approx. 95 percentile: 66.94ms
- Threads fairness:
- events (avg/stddev): 1000.0400/24.67
- execution time (avg/stddev): 22.7394/0.04
Add Comment
Please, Sign In to add comment