The setup timers Table-opracowanie

The setup timers Table
The setup_timers table shows the currently selected event timers:
mysql SELECT * FROM setup_timers;
+-----------+-------------+
| NAME | TIMER_NAME |
+-----------+-------------+
| idle | MICROSECOND |
| wait | CYCLE |
| stage | NANOSECOND |
| statement | NANOSECOND |
+-----------+-------------+
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.
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 21.2.3.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, which may lead to
unpredictable results. If you make timer changes, you may want to use TRUNCATE TABLE to reset
Performance Schema statistics.
... zobacz całą notatkę