ps_is_account_enabled

This function checks whether a specific user account is enabled for instrumentation in the Performance Schema setup_actors table.

Sys Schema is available from MariaDB 10.6.

Syntax

sys.ps_is_account_enabled(host,user)

Description

ps_is_account_enabled is a stored function available with the Sys Schema.

It takes host and user arguments, and returns an ENUM('YES','NO') depending on whether Performance Schema instrumentation for the given account is enabled.

Examples

SELECT sys.ps_is_account_enabled('localhost', 'root');
+------------------------------------------------+
| sys.ps_is_account_enabled('localhost', 'root') |
+------------------------------------------------+
| YES                                            |
+------------------------------------------------+

_{This page is licensed: CC BY-SA / Gnu FDL}