sys Schema Stored Procedures mysql>  CALL sys.ps_setup_enable_background_threads(); +-------------------------------+ | summary | +-------------------------------+ | Enabled 24 background threads | +-------------------------------+ +---------------------+ | summary | +---------------------+ | Enabled 4 consumers | +---------------------+ +----------------------+ | summary | +----------------------+ | Enabled 1 instrument | +----------------------+ mysql>  CALL sys.ps_setup_enable_consumer(’statement’); mysql>  CALL sys.ps_setup_enable_instrument(’wait/lock/metadata/sql/mdl’); mysql>  CALL sys.ps_setup_enable_instrument(’mutex’); +-------------------------+ 28.4.4.9 The ps_setup_enable_consumer() Procedure Parameters Example 28.4.4.10 The ps_setup_enable_instrument() Procedure Parameters Example Enable a specific instrument: Enable all mutex instruments: Enable all statement consumers: Enables Performance Schema consumers with names that contain the argument. Produces a result set indicating how many consumers were enabled. Already enabled consumers do not count. A value of  ’’  matches all consumers. • consumer VARCHAR(128) : The value used to match consumer names, which are identified by using %consumer%  as an operand for a  LIKE  pattern match. • 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. Enables Performance Schema instruments with names that contain the argument. Produces a result set indicating how many instruments were enabled. Already enabled instruments do not count. A value of  ’’  matches all instruments. 5188