Bencher, alat za merenje brzine MySQL Cluster-a .. odlicna alatka koja daje mogucnost da
- specificirate jednostavan upit za merenje brzine direktno iz komandne linije
- implementirate kompleksne testove
- testirate NDB API
Primer:
./src/bencher -s /tmp/mysql.sock.3306 -t 2 -l 10000 -q "select * from t1 limit 1"
——- Starting Benchmark ———-
Thread 1 – 638 qps (average qps measured after 5 secs)
Thread 0 – 631 qps (average qps measured after 5 secs)
Thread 1 – 680 qps (average qps measured after 10 secs)
Thread 0 – 679 qps (average qps measured after 10 secs)
——- Benchmark Finished ———-
Thread 0 – max: 83091 us, min 668 us, less than 5 ms: 9761 of 10000, avg: 1485 us, total time: 14949 ms, qps: 668.91
Thread 1 – max: 43743 us, min 578 us, less than 5 ms: 9770 of 10000, avg: 1475 us, total time: 14767 ms, qps: 677.16
Total throughput = 1346.08 qps
Average exec time per thread = 14.86 secs