This function checks whether a specific user account is enabled for instrumentation in the Performance Schema setup_actors table.
sys.ps_is_account_enabled(host,user)ps_is_account_enabled is a available with the .
It takes host and user arguments, and returns an ENUM('YES','NO') depending on whether Performance Schema instrumentation for the given account is enabled.
This page is licensed: CC BY-SA / Gnu FDL
SELECT sys.ps_is_account_enabled('localhost', 'root');
+------------------------------------------------+
| sys.ps_is_account_enabled('localhost', 'root') |
+------------------------------------------------+
| YES |
+------------------------------------------------+