| 1 |
UPDATE performance_schema.setup_instruments SET TIMED = 'NO'; |
| 2 |
UPDATE performance_schema.setup_instruments SET ENABLED = 'NO'; |
| 3 |
UPDATE performance_schema.setup_timers |
| 4 |
SET TIMER_NAME = 'NANOSECOND' WHERE NAME = 'Wait'; |
| 5 |
UPDATE performance_schema.setup_timers |
| 6 |
SET TIMER_NAME = 'CYCLE' WHERE NAME = 'Wait'; |
| 7 |
UPDATE performance_schema.setup_instruments SET TIMED = 'YES'; |
| 8 |
UPDATE performance_schema.setup_instruments SET ENABLED = 'YES' |
| 9 |
WHERE NAME IN ('wait/io/file/sql/FRM', |
| 10 |
'thread/sql/Connection', |
| 11 |
'wait/synch/cond/sql/COND_mdl', |
| 12 |
'wait/synch/rwlock/sql/LOCK_sys_init_connect', |
| 13 |
'wait/synch/mutex/sql/LOCK_mdl'); |
| 14 |
UPDATE performance_schema.setup_consumers SET ENABLED = 'NO' |
| 15 |
WHERE NAME = 'events_waits_history'; |
| 16 |
UPDATE performance_schema.setup_consumers SET ENABLED = 'YES' |
| 17 |
WHERE NAME = 'events_waits_history'; |