Home > database >  Please explain. Sysbench MySQL, testing results of TPS, QPS, lat is how to calculate?
Please explain. Sysbench MySQL, testing results of TPS, QPS, lat is how to calculate?

Time:10-30

Results of TPS, QPS, (r/w/o), lat they value calculation standards or rules such as what kind of?

` ` `
Root @ jing - OptiPlex - 5070:/usr/share/sysbench# sysbench./oltp_read_write lua - mysql - host=localhost - mysql - user=root - mysql - password=abc123 - mysql - port=3306 - mysql db=test - mysql - socket=/data/mysql. The sock - db - driver=mysql tables=10 - table - size=1000 - threads=8 - time=10 - report - interval=2 run
Sysbench 1.0.11 (using system LuaJIT 2.1.0 -beta3)

Running the test with the following options:
Number of threads: 8
Report intermediate results every 2 second (s)
The Initializing the random number generator from the current time


The Initializing the worker threads...

Threads started!

[s] 2 THDS: 8 TPS: QPS: 5754.59 120915.86 (r/w/o: 11514.68/86379.32/23021.86) lat (ms, 95%) : err/s 1.79:1.50 reconn/s: 0.00
[4] s THDS: 8 TPS: QPS: 5299.57 111333.90 (r/w/o: 10601.63/79532.00/21200.27) lat (ms, 95%) : err/s 2.11:2.50 reconn/s: 0.00
[6] s THDS: 8 TPS: QPS: 5115.51 107451.62 (r/w/o: 10232.51/76755.09/20464.02) lat (ms, 95%) : err/s 2.18:1.50 reconn/s: 0.00
` ` `