Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- itigo@soulsociety:/etc$ sysbench --num-threads=100 --test=oltp --mysql-host=127.0.0.1 --mysql-user=root --mysql-password=тут_был_пароль --oltp-table-size=500000 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
- 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: 50000
- other: 20000
- total: 210000
- transactions: 10000 (136.30 per sec.)
- deadlocks: 0 (0.00 per sec.)
- read/write requests: 190000 (2589.62 per sec.)
- other operations: 20000 (272.59 per sec.)
- Test execution summary:
- total time: 73.3699s
- total number of events: 10000
- total time taken by event execution: 7313.6824
- per-request statistics:
- min: 69.87ms
- avg: 731.37ms
- max: 2631.62ms
- approx. 95 percentile: 1258.44ms
- Threads fairness:
- events (avg/stddev): 100.0000/3.13
- execution time (avg/stddev): 73.1368/0.14
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement