Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.59 KB | None | 0 0
  1. 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
  2. sysbench 0.4.12: multi-threaded system evaluation benchmark
  3.  
  4. Running the test with following options:
  5. Number of threads: 8
  6.  
  7. Doing OLTP test.
  8. Running mixed OLTP test
  9. Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
  10. Using "BEGIN" for starting transactions
  11. Using auto_inc on the id column
  12. Maximum number of requests for OLTP test is limited to 800
  13. Threads started!
  14. Done.
  15.  
  16. OLTP test statistics:
  17. queries performed:
  18. read: 11200
  19. write: 4000
  20. other: 1600
  21. total: 16800
  22. transactions: 800 (245.84 per sec.)
  23. deadlocks: 0 (0.00 per sec.)
  24. read/write requests: 15200 (4671.03 per sec.)
  25. other operations: 1600 (491.69 per sec.)
  26.  
  27. Test execution summary:
  28. total time: 3.2541s
  29. total number of events: 800
  30. total time taken by event execution: 25.9664
  31. per-request statistics:
  32. min: 9.64ms
  33. avg: 32.46ms
  34. max: 94.70ms
  35. approx. 95 percentile: 53.66ms
  36.  
  37. Threads fairness:
  38. events (avg/stddev): 100.0000/2.35
  39. execution time (avg/stddev): 3.2458/0.00
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement