My Oracle Support Banner

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.

Symptoms

On : 5.7 version, Performance Schema

ACTUAL BEHAVIOR
---------------
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.



EXPECTED BEHAVIOR
-----------------------
Only the execution of the procedure 'sp_demo_1' from 'demo_db' should be registered on the views.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, all procedure objects execution are been logged on the performance_schema.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.