ps_setup_show_enabled_instruments() - xiaoboluo768/mysql-system-schema GitHub Wiki

• 查看当前performance_schema中启用的instruments配置，通过查询performance_schema.setup_instruments表enabled字段为YES的值实现，执行时无需任何传入参数，但返回的instruments列表可能比较长

• 定义语句

DROP PROCEDURE IF EXISTS ps_setup_show_enabled_instruments;

DELIMITER $$

CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_show_enabled_instruments ()
    COMMENT '
            Description
            -----------

            Shows all currently enabled instruments.

            Parameters
            -----------

            None

            Example
            -----------

            mysql> CALL sys.ps_setup_show_enabled_instruments();
            '
    SQL SECURITY INVOKER
    DETERMINISTIC
    READS SQL DATA
BEGIN
    SELECT name AS enabled_instruments, timed
      FROM performance_schema.setup_instruments
    WHERE enabled = 'YES'
    ORDER BY enabled_instruments;
END$$

DELIMITER ;

• 参考链接：https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-show-enabled-instruments.html

---

上一篇： ps_setup_show_enabled_consumers()存储过程 | 下一篇： ps_statement_avg_latency_histogram()存储过程