Advertisement
Guest User

sysbench mysql

a guest
Oct 21st, 2011
293
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 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
  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. Using Special distribution (12 iterations,  1 pct of values are returned in 75 pct cases)
  11. Using "BEGIN" for starting transactions
  12. Using auto_inc on the id column
  13. Maximum number of requests for OLTP test is limited to 10000
  14. Threads started!
  15. Done.
  16.  
  17. OLTP test statistics:
  18.     queries performed:
  19.         read:                            140000
  20.         write:                           50000
  21.         other:                           20000
  22.         total:                           210000
  23.     transactions:                        10000  (136.30 per sec.)
  24.     deadlocks:                           0      (0.00 per sec.)
  25.     read/write requests:                 190000 (2589.62 per sec.)
  26.     other operations:                    20000  (272.59 per sec.)
  27.  
  28. Test execution summary:
  29.     total time:                          73.3699s
  30.     total number of events:              10000
  31.     total time taken by event execution: 7313.6824
  32.     per-request statistics:
  33.          min:                                 69.87ms
  34.          avg:                                731.37ms
  35.          max:                               2631.62ms
  36.          approx.  95 percentile:            1258.44ms
  37.  
  38. Threads fairness:
  39.     events (avg/stddev):           100.0000/3.13
  40.     execution time (avg/stddev):   73.1368/0.14
  41.  
  42.  
Advertisement
RAW Paste Data Copied
Advertisement