Parameters
| Name | Type | Mode |
|---|---|---|
| in_connection_id | bigint | IN |
Enable 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_enable_thread(3); +——————+ | summary | +——————+ | Enabled 1 thread | +——————+ 1 row in set (0.01 sec)
To enable the current connection:
mysql> CALL sys.ps_setup_enable_thread(CONNECTION_ID()); +——————+ | summary | +——————+ | Enabled 1 thread | +——————+ 1 row in set (0.00 sec)
| Name | Type | Mode |
|---|---|---|
| in_connection_id | bigint | IN |