johnmichaellowe

Untitled

Sep 6th, 2013
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.66 KB | None | 0 0
  1. 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
  2. sysbench 0.4.12: multi-threaded system evaluation benchmark
  3.  
  4. No DB drivers specified, using mysql
  5. Running the test with following options:
  6. Number of threads: 16
  7.  
  8. Doing OLTP test.
  9. Running mixed OLTP test
  10. Doing read-only test
  11. Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
  12. Using "BEGIN" for starting transactions
  13. Using auto_inc on the id column
  14. Maximum number of requests for OLTP test is limited to 10000
  15. Threads started!
  16. Done.
  17.  
  18. OLTP test statistics:
  19. queries performed:
  20. read: 140000
  21. write: 0
  22. other: 20000
  23. total: 160000
  24. transactions: 10000 (664.81 per sec.)
  25. deadlocks: 0 (0.00 per sec.)
  26. read/write requests: 140000 (9307.32 per sec.)
  27. other operations: 20000 (1329.62 per sec.)
  28.  
  29. Test execution summary:
  30. total time: 15.0419s
  31. total number of events: 10000
  32. total time taken by event execution: 240.4125
  33. per-request statistics:
  34. min: 11.37ms
  35. avg: 24.04ms
  36. max: 124.91ms
  37. approx. 95 percentile: 31.63ms
  38.  
  39. Threads fairness:
  40. events (avg/stddev): 625.0000/17.08
  41. execution time (avg/stddev): 15.0258/0.01
Advertisement
Add Comment
Please, Sign In to add comment