ps_is_instrument_default_timed()函数

返回YES或NO指示默认情况下给定的Performance Schema仪器是否计时。

参量

• in_instrument VARCHAR(128)：要检查的仪器名称。

返回值

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

例

mysql> SELECT sys.ps_is_instrument_default_timed('memory/innodb/row_log_buf');
+-----------------------------------------------------------------	+
| sys.ps_is_instrument_default_timed('memory/innodb/row_log_buf')	|
+-----------------------------------------------------------------	+
| NO	|
+-----------------------------------------------------------------	+
mysql> SELECT sys.ps_is_instrument_default_timed('statement/sql/alter_user');
+----------------------------------------------------------------	+
| sys.ps_is_instrument_default_timed('statement/sql/alter_user')	|
+----------------------------------------------------------------	+
| YES	|
+----------------------------------------------------------------	+