Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sudo apt install sysbench
- mysql -uratt -p -e "create database sysbench;"
- 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
- 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
- -------------------------------------------------------------------
- SQL statistics:
- queries performed:
- read: 327726
- write: 0
- other: 46818
- total: 374544
- transactions: 23409 (2340.37 per sec.)
- queries: 374544 (37445.92 per sec.)
- ignored errors: 0 (0.00 per sec.)
- reconnects: 0 (0.00 per sec.)
- General statistics:
- total time: 10.0009s
- total number of events: 23409
- Latency (ms):
- min: 0.68
- avg: 0.85
- max: 2.51
- 95th percentile: 1.04
- sum: 19983.66
- Threads fairness:
- events (avg/stddev): 11704.5000/85.50
- execution time (avg/stddev): 9.9918/0.00
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement