How can I calculate MySQL Transactions per second.
I tried to use formula (global com_commit+global com_rollback)/uptime since flush.
I had also tried (global insert+ global delete+ global update)/uptime since flush.
The outcome of inserts+deletes+updates is less than commits+rollback. The outcome of commits+rollbacks is 8 times larger than inserts+deletes+updates. So confused on the formulas which one to take.