28.4.5.11 The ps_is_instrument_default_enabled() Function

Returns YES or NO to indicate whether a given Performance Schema instrument is enabled by default.

Parameters

  • in_instrument VARCHAR(128): The name of the instrument to check.

Return Value

An ENUM('YES','NO') value.

Example
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                                                              |
+------------------------------------------------------------------+