MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
The setup_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 |
+-----------+-------------+
The setup_timers.TIMER_NAME
value can be
changed to select a different timer. The value can be any of
the values in the
performance_timers.TIMER_NAME
column. For
an explanation of how event timing occurs, see
Section 22.4.1, “Performance Schema Event Timing”.
Modifications to the setup_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, use
TRUNCATE TABLE
to reset
Performance Schema statistics.
The setup_timers
table has these
columns:
NAME
The type of instrument the timer is used for.
TIMER_NAME
The timer that applies to the instrument type. This column can be modified.
TRUNCATE TABLE
is not permitted
for the setup_timers
table.