INSERT INTO performance_schema.setup_actors VALUES ('localhost', 'foo', '%', 'YES', 'YES'), ('localhost', 'bar', '%', 'NO', 'NO'); UPDATE performance_schema.setup_instruments SET ENABLED = 'NO' WHERE NAME LIKE 'stage/innodb/%' OR NAME LIKE 'statement/com/%' OR NAME = 'idle'; UPDATE performance_schema.setup_consumers SET ENABLED = 'NO' WHERE NAME LIKE '%\_history\_long'; UPDATE performance_schema.threads SET INSTRUMENTED = 'NO' WHERE NAME LIKE 'thread/innodb/srv\_%'; CALL sys.ps_setup_show_disabled(FALSE, FALSE); performance_schema_enabled 1 object_type objects enabled timed EVENT information_schema.% NO NO EVENT mysql.% NO NO EVENT performance_schema.% NO NO FUNCTION information_schema.% NO NO FUNCTION mysql.% NO NO FUNCTION performance_schema.% NO NO PROCEDURE information_schema.% NO NO PROCEDURE mysql.% NO NO PROCEDURE performance_schema.% NO NO TABLE information_schema.% NO NO TABLE mysql.% NO NO TABLE performance_schema.% NO NO TRIGGER information_schema.% NO NO TRIGGER mysql.% NO NO TRIGGER performance_schema.% NO NO disabled_consumers events_stages_history_long events_statements_history_long events_transactions_history_long events_waits_history_long CALL sys.ps_setup_show_disabled(TRUE, FALSE); performance_schema_enabled 1 object_type objects enabled timed EVENT information_schema.% NO NO EVENT mysql.% NO NO EVENT performance_schema.% NO NO FUNCTION information_schema.% NO NO FUNCTION mysql.% NO NO FUNCTION performance_schema.% NO NO PROCEDURE information_schema.% NO NO PROCEDURE mysql.% NO NO PROCEDURE performance_schema.% NO NO TABLE information_schema.% NO NO TABLE mysql.% NO NO TABLE performance_schema.% NO NO TRIGGER information_schema.% NO NO TRIGGER mysql.% NO NO TRIGGER performance_schema.% NO NO disabled_consumers events_stages_history_long events_statements_history_long events_transactions_history_long events_waits_history_long disabled_instruments timed idle YES stage/innodb/alter table (end) YES stage/innodb/alter table (insert) YES stage/innodb/alter table (log apply index) YES stage/innodb/alter table (log apply table) YES stage/innodb/alter table (merge sort) YES stage/innodb/alter table (read PK and internal sort) YES stage/innodb/buffer pool load YES statement/com/Binlog Dump YES statement/com/Bulk_execute YES statement/com/Change user YES statement/com/Close stmt YES statement/com/Connect YES statement/com/Connect Out YES statement/com/Create DB YES statement/com/Daemon YES statement/com/Debug YES statement/com/Delayed insert YES statement/com/Drop DB YES statement/com/Error YES statement/com/Execute YES statement/com/Fetch YES statement/com/Field List YES statement/com/Init DB YES statement/com/Kill YES statement/com/Long Data YES statement/com/Ping YES statement/com/Prepare YES statement/com/Processlist YES statement/com/Quit YES statement/com/Refresh YES statement/com/Register Slave YES statement/com/Reset connection YES statement/com/Reset stmt YES statement/com/Set option YES statement/com/Shutdown YES statement/com/Slave_IO YES statement/com/Slave_SQL YES statement/com/Slave_worker YES statement/com/Sleep YES statement/com/Statistics YES statement/com/Table Dump YES statement/com/Time YES statement/com/Unimpl get tid YES CALL sys.ps_setup_show_disabled(FALSE, TRUE); performance_schema_enabled 1 object_type objects enabled timed EVENT information_schema.% NO NO EVENT mysql.% NO NO EVENT performance_schema.% NO NO FUNCTION information_schema.% NO NO FUNCTION mysql.% NO NO FUNCTION performance_schema.% NO NO PROCEDURE information_schema.% NO NO PROCEDURE mysql.% NO NO PROCEDURE performance_schema.% NO NO TABLE information_schema.% NO NO TABLE mysql.% NO NO TABLE performance_schema.% NO NO TRIGGER information_schema.% NO NO TRIGGER mysql.% NO NO TRIGGER performance_schema.% NO NO disabled_consumers events_stages_history_long events_statements_history_long events_transactions_history_long events_waits_history_long disabled_threads thread_type CALL sys.ps_setup_show_disabled(TRUE, TRUE); performance_schema_enabled 1 object_type objects enabled timed EVENT information_schema.% NO NO EVENT mysql.% NO NO EVENT performance_schema.% NO NO FUNCTION information_schema.% NO NO FUNCTION mysql.% NO NO FUNCTION performance_schema.% NO NO PROCEDURE information_schema.% NO NO PROCEDURE mysql.% NO NO PROCEDURE performance_schema.% NO NO TABLE information_schema.% NO NO TABLE mysql.% NO NO TABLE performance_schema.% NO NO TRIGGER information_schema.% NO NO TRIGGER mysql.% NO NO TRIGGER performance_schema.% NO NO disabled_consumers events_stages_history_long events_statements_history_long events_transactions_history_long events_waits_history_long disabled_threads thread_type disabled_instruments timed idle YES stage/innodb/alter table (end) YES stage/innodb/alter table (insert) YES stage/innodb/alter table (log apply index) YES stage/innodb/alter table (log apply table) YES stage/innodb/alter table (merge sort) YES stage/innodb/alter table (read PK and internal sort) YES stage/innodb/buffer pool load YES statement/com/Binlog Dump YES statement/com/Bulk_execute YES statement/com/Change user YES statement/com/Close stmt YES statement/com/Connect YES statement/com/Connect Out YES statement/com/Create DB YES statement/com/Daemon YES statement/com/Debug YES statement/com/Delayed insert YES statement/com/Drop DB YES statement/com/Error YES statement/com/Execute YES statement/com/Fetch YES statement/com/Field List YES statement/com/Init DB YES statement/com/Kill YES statement/com/Long Data YES statement/com/Ping YES statement/com/Prepare YES statement/com/Processlist YES statement/com/Quit YES statement/com/Refresh YES statement/com/Register Slave YES statement/com/Reset connection YES statement/com/Reset stmt YES statement/com/Set option YES statement/com/Shutdown YES statement/com/Slave_IO YES statement/com/Slave_SQL YES statement/com/Slave_worker YES statement/com/Sleep YES statement/com/Statistics YES statement/com/Table Dump YES statement/com/Time YES statement/com/Unimpl get tid YES UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES'; TRUNCATE TABLE performance_schema.setup_actors; INSERT INTO performance_schema.setup_actors VALUES ('%', '%', '%', 'YES', 'YES'); UPDATE performance_schema.setup_consumers SET enabled = 'YES'; UPDATE performance_schema.threads SET instrumented = 'YES';