ps_setup_enable_instrument

Description

Enables instruments within Performance Schema matching the input pattern.

Parameters

in_pattern (VARCHAR(128)): A LIKE pattern match (using “%in_pattern%”) of events to enable

Example

To enable all mutex instruments:

mysql> CALL sys.ps_setup_enable_instrument(‘wait/synch/mutex’); +————————-+ | summary | +————————-+ | Enabled 155 instruments | +————————-+ 1 row in set (0.02 sec)

Query OK, 0 rows affected (0.02 sec)

To enable just a specific TCP/IP based network IO instrument:

mysql> CALL sys.ps_setup_enable_instrument(‘wait/io/socket/sql/server_tcpip_socket’); +———————–+ | summary | +———————–+ | Enabled 1 instruments | +———————–+ 1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

To enable all instruments:

mysql> CALL sys.ps_setup_enable_instrument(''); +————————-+ | summary | +————————-+ | Enabled 547 instruments | +————————-+ 1 row in set (0.01 sec)

Query OK, 0 rows affected (0.01 sec)