## 28.4.4.11 The ps_setup_enable_thread() Procedure 

| summary | +-------------------------+ | Enabled 177 instruments | +-------------------------+ 

Given a connection ID, enables Performance Schema instrumentation for the thread. Produces a result set indicating how many threads were enabled. Already enabled threads do not count. 

## Parameters 

• in_connection_id BIGINT : The connection ID. This is a value of the type given in the PROCESSLIST_ID  column of the Performance Schema threads  table or the Id  column of SHOW PROCESSLIST  output. 

## Example 

## 28.4.4.12 The ps_setup_reload_saved() Procedure 

Enable a specific connection by its connection ID: 

mysql> CALL sys.ps_setup_enable_thread(225); +------------------+ | summary | +------------------+ | Enabled 1 thread | +------------------+ 

Enable the current connection: 

mysql> CALL sys.ps_setup_enable_thread(CONNECTION_ID()); +------------------+ | summary | +------------------+ | Enabled 1 thread | +------------------+ 

Reloads a Performance Schema configuration saved earlier within the same session using ps_setup_save() . For more information, see the description of ps_setup_save() . 

This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin  system variable. That is a restricted operation, so the procedure requires privileges sufficient to set restricted session variables. See Section 5.1.9.1, “System Variable Privileges” . 

## Parameters 

## 28.4.4.13 The ps_setup_reset_to_default() Procedure 

## Parameters 

None. 

Resets the Performance Schema configuration to its default settings. 

• in_verbose BOOLEAN : Whether to display information about each setup stage during procedure execution. This includes the SQL statements executed. 

