sysbench icon indicating copy to clipboard operation
sysbench copied to clipboard

why the tps is quite different from qps

Open ayamzh opened this issue 3 years ago • 1 comments

i have made a read only test by sysbench, the tps is 700 per sec,the qps is 10000 per sec. why it has such a big difference in this case

ayamzh avatar Sep 14 '22 06:09 ayamzh

tps == transactions per second (begin; insert; update; delete; commit) <-- that is 1 transaction qps == queries per second (select) That is why they are different

utdrmac avatar May 31 '23 18:05 utdrmac