Movatterモバイル変換

Thesetup_timers table shows the currently selected event timers:

mysql> SELECT * FROM performance_schema.setup_timers;+-------------+-------------+| NAME        | TIMER_NAME  |+-------------+-------------+| idle        | MICROSECOND || wait        | CYCLE       || stage       | NANOSECOND  || statement   | NANOSECOND  || transaction | NANOSECOND  |+-------------+-------------+

Thesetup_timers.TIMER_NAME value can be changed to select a different timer. The value can be any of the values in theperformance_timers.TIMER_NAME column. For an explanation of how event timing occurs, seeSection 25.4.1, “Performance Schema Event Timing”.

Modifications to thesetup_timers table affect monitoring immediately. Events already in progress may use the original timer for the begin time and the new timer for the end time. To avoid unpredictable results after you make timer changes, useTRUNCATE TABLE to reset Performance Schema statistics.

Thesetup_timers table has these columns:

TRUNCATE TABLE is not permitted for thesetup_timers table.