26.4.5.11 ps_is_instrument_default_enabled()函数

返回YESNO以指示默认情况下是否启用了给定的 Performance Schema 工具。

Parameters
  • in_instrument VARCHAR(128):要检查的仪器名称。
Return Value

ENUM('YES','NO')值。

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