A toolset for running, analyzing benchmarks.
# Run sysbench for one hour
bench-toolset bench sysbench --tables 16 --table-size 10000 --time 1h
# Run tpcc for two hours
bench-toolset bench tpcc --warehouses 1000 --time 2h
By default, it uses root@tcp(127.0.0.1:4000)/test as the default dsn address, you can override it by setting below flags:
--db string Database name (default "test")
--host string Database host (default "127.0.0.1")
--password string Database password
--port int Database port (default 4000)
--user string Database user (default "root")
After the benchmark finished, it analyzes the benchmark logs and metrics, outputs the results to terminal and an optional record database, you can use following flags to control behaviours of analyzing:
--warmup int Time for warming up in seconds
--cut-tail int Time for cutting tail in seconds
--interval int Sampling interval of logs
--json Output results to terminal in json
--record-dsn DSN of database for storing test record
See more details with bench-toolset bench --help.
# Analyze results of sysbench
bench-toolset analyze log --benchmark sysbench --log sysbench.log --interval 1,2 --warmup 10 --cut-tail 10 -k 2 --percent 10
# Analyze results of tpcc
bench-toolset analyze log --benchmark tpcc --log tpcc.log --interval 1,2 -k 2 --percent 10
See more details with bench-toolset analyze --help