MySQL :: MySQL 5.7 Reference Manual :: 25.12.2.5 The setup_timers Table (original) (raw)

25.12.2.5 The setup_timers Table

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  |
| transaction | NANOSECOND  |
+-------------+-------------+

Note

As of MySQL 5.7.21, the Performance Schemasetup_timers table is deprecated and is removed in MySQL 8.0, as is theTICKS row in theperformance_timers table.

The setup_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 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, useTRUNCATE 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.