| 1 |
UPDATE performance_schema.setup_instruments |
| 2 |
SET ENABLED = 'NO' |
| 3 |
WHERE NAME LIKE 'stage/innodb/%' |
| 4 |
OR NAME LIKE 'statement/com/%' |
| 5 |
OR NAME = 'idle'; |
| 6 |
CALL sys.ps_setup_show_disabled_instruments(); |
| 7 |
disabled_instruments timed |
| 8 |
idle YES |
| 9 |
stage/innodb/alter table (end) YES |
| 10 |
stage/innodb/alter table (flush) YES |
| 11 |
stage/innodb/alter table (insert) YES |
| 12 |
stage/innodb/alter table (log apply index) YES |
| 13 |
stage/innodb/alter table (log apply table) YES |
| 14 |
stage/innodb/alter table (merge sort) YES |
| 15 |
stage/innodb/alter table (read PK and internal sort) YES |
| 16 |
stage/innodb/alter tablespace (encryption) YES |
| 17 |
stage/innodb/buffer pool load YES |
| 18 |
stage/innodb/clone (file copy) YES |
| 19 |
stage/innodb/clone (page copy) YES |
| 20 |
stage/innodb/clone (redo copy) YES |
| 21 |
statement/com/Binlog Dump YES |
| 22 |
statement/com/Binlog Dump GTID YES |
| 23 |
statement/com/Change user YES |
| 24 |
statement/com/Close stmt YES |
| 25 |
statement/com/Connect YES |
| 26 |
statement/com/Connect Out YES |
| 27 |
statement/com/Create DB YES |
| 28 |
statement/com/Daemon YES |
| 29 |
statement/com/Debug YES |
| 30 |
statement/com/Delayed insert YES |
| 31 |
statement/com/Drop DB YES |
| 32 |
statement/com/Error YES |
| 33 |
statement/com/Execute YES |
| 34 |
statement/com/Fetch YES |
| 35 |
statement/com/Field List YES |
| 36 |
statement/com/Group Replication Data Stream subscription YES |
| 37 |
statement/com/Init DB YES |
| 38 |
statement/com/Kill YES |
| 39 |
statement/com/Long Data YES |
| 40 |
statement/com/Ping YES |
| 41 |
statement/com/Prepare YES |
| 42 |
statement/com/Processlist YES |
| 43 |
statement/com/Quit YES |
| 44 |
statement/com/Refresh YES |
| 45 |
statement/com/Register Replica YES |
| 46 |
statement/com/Reset Connection YES |
| 47 |
statement/com/Reset stmt YES |
| 48 |
statement/com/Set option YES |
| 49 |
statement/com/Shutdown YES |
| 50 |
statement/com/Sleep YES |
| 51 |
statement/com/Statistics YES |
| 52 |
statement/com/Table Dump YES |
| 53 |
statement/com/Time YES |
| 54 |
UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES'; |
| 55 |
TRUNCATE TABLE performance_schema.setup_actors; |
| 56 |
INSERT INTO performance_schema.setup_actors VALUES ('%', '%', '%', 'YES', 'YES'); |
| 57 |
UPDATE performance_schema.setup_consumers SET enabled = 'YES'; |
| 58 |
UPDATE performance_schema.threads SET instrumented = 'YES'; |