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

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

• 定义语句

DROP PROCEDURE IF EXISTS ps_setup_show_disabled_consumers;

DELIMITER $$

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

            Shows all currently disabled consumers.

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

            None

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

            mysql> CALL sys.ps_setup_show_disabled_consumers();

            +---------------------------+
            | disabled_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 disabled_consumers
      FROM performance_schema.setup_consumers
    WHERE enabled = 'NO'
    ORDER BY disabled_consumers;
END$$

DELIMITER ;

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

---

上一篇： ps_setup_show_disabled()存储过程 | 下一篇： ps_setup_show_disabled_instruments()存储过程