content_image/714223.jpg
Displays all currently disabled Performance Schema instruments. This might be a long list. 

## Parameters 

## Example 

## 28.4.4.18 The ps_setup_show_enabled() Procedure 

## Parameters 

None. 

mysql> CALL sys.ps_setup_show_disabled_instruments()\G *************************** 1. row *************************** disabled_instruments: wait/synch/mutex/sql/TC_LOG_MMAP::LOCK_tc timed: NO *************************** 2. row *************************** disabled_instruments: wait/synch/mutex/sql/THD::LOCK_query_plan timed: NO *************************** 3. row *************************** disabled_instruments: wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_commit timed: NO ... 

Displays all currently enabled Performance Schema configuration. 

• in_show_instruments BOOLEAN : Whether to display enabled instruments. This might be a long list. 

## Example 

• in_show_threads BOOLEAN : Whether to display enabled threads. 

mysql> CALL sys.ps_setup_show_enabled(FALSE, FALSE); +----------------------------+ | performance_schema_enabled | +----------------------------+ | 1 | +----------------------------+ 1 row in set (0.01 sec) +---------------+ | enabled_users | +---------------+ | ’%’@’%’ | +---------------+ 1 row in set (0.01 sec) 

<img src='content_image/714223.jpg'>

5 rows in set (0.02 sec) +-----------------------------+ | enabled_consumers | +-----------------------------+ | events_statements_current | | events_statements_history | | events_transactions_current | 

