How to relate performance_schema.events_statements_summary_by_digest shows "COMMIT" to specific commits

[Nimrod M]

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!