## 28.4.4.4 The ps_setup_disable_background_threads() Procedure 

Disables Performance Schema instrumentation for all background threads. Produces a result set indicating how many background threads were disabled. Already disabled threads do not count. 

## Parameters 

## 28.4.4.5 The ps_setup_disable_consumer() Procedure 

None. 

mysql> CALL sys.ps_setup_disable_background_threads(); +--------------------------------+ | summary | +--------------------------------+ | Disabled 24 background threads | +--------------------------------+ 

Disables Performance Schema consumers with names that contain the argument. Produces a result set indicating how many consumers were disabled. Already disabled consumers do not count. 

## Parameters 

• consumer VARCHAR(128) : The value used to match consumer names, which are identified by using %consumer%  as an operand for a LIKE  pattern match. 

## 28.4.4.6 The ps_setup_disable_instrument() Procedure 

A value of ’’  matches all consumers. 

Disable all statement consumers: 

mysql> CALL sys.ps_setup_disable_consumer(’statement’); +----------------------+ | summary | +----------------------+ | Disabled 4 consumers | +----------------------+ 

Disables Performance Schema instruments with names that contain the argument. Produces a result set indicating how many instruments were disabled. Already disabled instruments do not count. 

## Parameters 

• in_pattern VARCHAR(128) : The value used to match instrument names, which are identified by using %in_pattern%  as an operand for a LIKE  pattern match. 

## Example 

A value of ’’  matches all instruments. 

Disable a specific instrument: 

