MySQL Forums :: Performance :: performance_schema.events_statements_* not populating


Advanced Search

Re: performance_schema.events_statements_* not populating
Posted by: Ryan Streb ()
Date: March 17, 2017 02:26PM

Figured this out.

This output:

mysql> select * from sys.ps_check_lost_instrumentation;
+-------------------------------------------+----------------+
| variable_name | variable_value |
+-------------------------------------------+----------------+
| Performance_schema_statement_classes_lost | 193 |
+-------------------------------------------+----------------+

meant our variable 'performance_schema_max_statement_classes' was too low. I raised it to 500 and bounced server, and the statement instrumentation was resolved.

Options: ReplyQuote


Subject Views Written By Posted
performance_schema.events_statements_* not populating 110 Ryan Streb 03/14/2017 06:23PM
Re: performance_schema.events_statements_* not populating 92 Øystein Grøvlen 03/15/2017 02:00AM
Re: performance_schema.events_statements_* not populating 66 Ryan Streb 03/15/2017 01:16PM
Re: performance_schema.events_statements_* not populating 57 Ryan Streb 03/17/2017 02:26PM
Re: performance_schema.events_statements_* not populating 69 Ryan Streb 03/15/2017 01:38PM


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.