0

SHOW GLOBAL STATUS has Com_* variables: The Com_xxx statement counter variables indicate the number of times each xxx statement has been executed.

When I compare Com_commit to Com_rollback, both are almost equal. I do not understand how is that possible. My understanding is that you commit transactions and any rollback is done only when required. Then, why these values are so close?

We have only one database that is used for application (Jira) and it uses READ-COMMITTED Transaction Isolation. There are no other procedures in the entire mysql that does any operations.

enter image description here

1
  • I, too, have found strange values for those two counters. Even cases where Com_commit=0 but rollbacks is >0.
    – Rick James
    Aug 31, 2020 at 22:39

1 Answer 1

0

com_* status variables are a pure count of what the database server receives from the application.

As those are the numbers from JIRA, you can conclude that's what JIRA is issuing to the database.

I'd suggest a JIRA forum maybe able to diagnose why it is issuing so many rollbacks. It does look very suspicious.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.