MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
Returns YES
or NO
to
indicate whether a given Performance Schema instrument is
enabled by default.
mysql>SELECT sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf');
+-------------------------------------------------------------------+ | sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf') | +-------------------------------------------------------------------+ | NO | +-------------------------------------------------------------------+ mysql>SELECT sys.ps_is_instrument_default_enabled('statement/sql/alter_user');
+------------------------------------------------------------------+ | sys.ps_is_instrument_default_enabled('statement/sql/alter_user') | +------------------------------------------------------------------+ | YES | +------------------------------------------------------------------+