MySQL Forums
Forum List  »  Performance

MySQL 5.7 performance schema statement digest
Posted by: bod bod
Date: February 01, 2018 11:42AM

The table performance_schema.events_statements_summary_by_digest is recording the same digest/digest_text for very different select statements that use views. Actually, the digest/digest_text of the view is being recorded.
It makes difficult to analize the performance in systems that use a lot of views, cause half the queries could be grouped under the same digest/digest_text.
Could it be a bug? Or it is the expected behavior?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL 5.7 performance schema statement digest
865
February 01, 2018 11:42AM


Sorry, you can't reply to this topic. It has been closed.

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.