MySQL Forums
Forum List  »  Performance

How to relate performance_schema.events_statements_summary_by_digest shows "COMMIT" to specific commits
Posted by: Nimrod M
Date: October 03, 2018 02:48AM

Hi all,

We're on AWS RDS (MySQL 5.7.21) and are using the performance_schema.events_statements_summary_by_digest table to determine which statements/queries consume most of the server time.

After some optimizations, we now see a single "COMMIT" entry taking most of the server time (80%). These commits may come from multiple places in our app where we commit batches of insert/updates.

Is it possible to annotate this "COMMIT" at the application side so that we have the distribution of time spent per commit source? If we had somehow managed to add a comment to the COMMIT command, would it be possible to avoid mysql stripping it before adding to the by_digest table?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
How to relate performance_schema.events_statements_summary_by_digest shows "COMMIT" to specific commits
456
October 03, 2018 02:48AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.