ps_setup_disable_thread()

• 禁用指定线程的检测功能，通过修改performance_schema.threads表，调用时传入值作为processlist_id字段值（或者是show processlist;输出的id字段值），修改instrumented字段为NO实现，返回一个被关闭的线程数量（已经处于关闭状态的线程不会计数，因为是使用ROW_COUNT()函数作为返回值，该函数只记录发生变更的行）

• 参数：

  • in_connection_id BIGINT：连接ID(进程ID)，为performance_schema.theads表的PROCESSLIST_ID列或SHOW PROCESSLIST输出的id列值

• 定义语句

DROP PROCEDURE IF EXISTS ps_setup_disable_thread;

DELIMITER $$

CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_disable_thread (
        IN in_connection_id BIGINT
    )
    COMMENT '
            Description
            -----------

            Disable the given connection/thread in Performance Schema.

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

            in_connection_id (BIGINT):
              The connection ID (PROCESSLIST_ID from performance_schema.threads
              or the ID shown within SHOW PROCESSLIST)

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

            mysql> CALL sys.ps_setup_disable_thread(3);
            +-------------------+
            | summary          |
            +-------------------+
            | Disabled 1 thread |
            +-------------------+
            1 row in set (0.01 sec)

            To disable the current connection:

            mysql> CALL sys.ps_setup_disable_thread(CONNECTION_ID());
            +-------------------+
            | summary          |
            +-------------------+
            | Disabled 1 thread |
            +-------------------+
            1 row in set (0.00 sec)
            '
    SQL SECURITY INVOKER
    NOT DETERMINISTIC
    MODIFIES SQL DATA
BEGIN
    UPDATE performance_schema.threads
      SET instrumented = 'NO'
    WHERE processlist_id = in_connection_id;

    SELECT CONCAT('Disabled ', @rows := ROW_COUNT(), ' thread', IF(@rows != 1, 's', '')) AS summary;
END$$

DELIMITER ;

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

---

上一篇： ps_setup_disable_instrument()存储过程 | 下一篇： ps_setup_enable_background_threads()存储过程