Parameters
| Name | Type | Mode |
|---|---|---|
| in_connection_id | bigint | IN |
Disable the given connection/thread in Performance Schema.
in_connection_id (BIGINT): The connection ID (PROCESSLIST_ID from performance_schema.threads or the ID shown within SHOW PROCESSLIST)
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)
| Name | Type | Mode |
|---|---|---|
| in_connection_id | bigint | IN |