Advertisement
Queses

Sysbench Mysql Test

Apr 2nd, 2020
471
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 1.52 KB | None | 0 0
  1. sudo apt install sysbench
  2. mysql -uratt -p -e "create database sysbench;"
  3. sysbench  --table-size=1000000 --db-driver=mysql --mysql-db=sysbench --mysql-user=ratt --mysql-password=pass --threads=2 --rand-type=uniform /usr/share/sysbench/oltp_read_only.lua prepare
  4. sysbench  --table-size=1000000 --db-driver=mysql --mysql-db=sysbench --mysql-user=ratt --mysql-password=pass --threads=2 --rand-type=uniform /usr/share/sysbench/oltp_read_only.lua run
  5.  
  6. -------------------------------------------------------------------
  7.  
  8. SQL statistics:
  9.     queries performed:
  10.         read:                            327726
  11.         write:                           0
  12.         other:                           46818
  13.         total:                           374544
  14.     transactions:                        23409  (2340.37 per sec.)
  15.     queries:                             374544 (37445.92 per sec.)
  16.     ignored errors:                      0      (0.00 per sec.)
  17.     reconnects:                          0      (0.00 per sec.)
  18.  
  19. General statistics:
  20.     total time:                          10.0009s
  21.     total number of events:              23409
  22.  
  23. Latency (ms):
  24.          min:                                    0.68
  25.          avg:                                    0.85
  26.          max:                                    2.51
  27.          95th percentile:                        1.04
  28.          sum:                                19983.66
  29.  
  30. Threads fairness:
  31.     events (avg/stddev):           11704.5000/85.50
  32.     execution time (avg/stddev):   9.9918/0.00
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement