Performance_schema Monitoring Filter Is Not Working
(Doc ID 2889414.1)
Last updated on AUGUST 17, 2022
Applies to:MySQL Server - Version 5.7 to 5.7 [Release 5.7]
Information in this document applies to any platform.
On : 5.7 version, Performance Schema
Performance_schema monitoring filter is not working
Here I want to monitor only specific stored procedures via performance_schema, for it I have disabled all existing/default rows in performance_schema.setup_objects table and added new entries in this table to monitor only specific stored procedures as per below:
But after analyze data in performance_schema.events_statements_history_long and performance_schema.events_stages_history_long tables then getting other stored procedures also while I have disabled all stored procedures except sp_demo_1 which is enabled.
Only the execution of the procedure 'sp_demo_1' from 'demo_db' should be registered on the views.
The issue has the following business impact:
Due to this issue, all procedure objects execution are been logged on the performance_schema.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document