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.
Subject
Views
Written By
Posted
1362
March 14, 2017 06:23PM
810
March 15, 2017 02:00AM
786
March 15, 2017 01:16PM
Re: performance_schema.events_statements_* not populating
717
March 17, 2017 02:26PM
801
March 15, 2017 01:38PM
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.