ps_setup_show_enabled_consumers()

• 查看当前启用的setup_consumers配置，通过查询performance_schema.setup_consumers表enabled字段为YES实现，执行时无需任何传入参数

• 定义语句

DROP PROCEDURE IF EXISTS ps_setup_show_enabled_consumers;

DELIMITER $$

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

            Shows all currently enabled consumers.

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

            None

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

            mysql> CALL sys.ps_setup_show_enabled_consumers();

            +---------------------------+
            | enabled_consumers        |
            +---------------------------+
            | events_statements_current |
            | global_instrumentation    |
            | thread_instrumentation    |
            | statements_digest        |
            +---------------------------+
            4 rows in set (0.05 sec)
            '
    SQL SECURITY INVOKER
    DETERMINISTIC
    READS SQL DATA
BEGIN
    SELECT name AS enabled_consumers
      FROM performance_schema.setup_consumers
    WHERE enabled = 'YES'
    ORDER BY enabled_consumers;
END$$

DELIMITER ;

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

---

上一篇： ps_setup_show_enabled()存储过程 | 下一篇： ps_setup_show_enabled_instruments()存储过程