Guest User

Untitled

a guest
Apr 8th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.70 KB | None | 0 0
  1. 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
  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: 100
  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 "LOCK TABLES READ" for starting transactions
  13. Using auto_inc on the id column
  14. Maximum number of requests for OLTP test is limited to 100000
  15. Threads started!
  16. Done.
  17.  
  18. OLTP test statistics:
  19. queries performed:
  20. read: 1400056
  21. write: 0
  22. other: 200008
  23. total: 1600064
  24. transactions: 100004 (4390.98 per sec.)
  25. deadlocks: 0 (0.00 per sec.)
  26. read/write requests: 1400056 (61473.79 per sec.)
  27. other operations: 200008 (8781.97 per sec.)
  28.  
  29. Test execution summary:
  30. total time: 22.7748s
  31. total number of events: 100004
  32. total time taken by event execution: 2273.9440
  33. per-request statistics:
  34. min: 1.32ms
  35. avg: 22.74ms
  36. max: 182.68ms
  37. approx. 95 percentile: 66.94ms
  38.  
  39. Threads fairness:
  40. events (avg/stddev): 1000.0400/24.67
  41. execution time (avg/stddev): 22.7394/0.04
Add Comment
Please, Sign In to add comment