MySQL Forums
Forum List  »  Performance

Re: How to relate performance_schema.events_statements_summary_by_digest shows "COMMIT" to specific commits
Posted by: Øystein Grøvlen
Date: October 04, 2018 03:33AM

I do not think it is possible to annotate a statement in a way that would give different digests, but you could try to poll the events_statements_history table to find commits that are slow. Based on the thread_id, you may find other queries for the same thread and use that to understand the context of this commit.

If your client send comments to the server, you will also be able to use and see annotations in the sql_text column of the history tables. E:g., "COMMIT /*commit1*/;". For the MYSQL command-line client, comment filtering is turned off with the --comments option. How other connectors behave, I do not know.

Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to relate performance_schema.events_statements_summary_by_digest shows "COMMIT" to specific commits
255
October 04, 2018 03:33AM


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.