The setup_timers
table shows the currently selected event timers.
It contains the following columns:
Column | Description |
---|---|
NAME |
Type of instrument the timer is used for. |
TIMER_NAME |
Timer applying to the instrument type. Can be modified. |
The TIMER_NAME
value can be changed to choose a different timer, and can be any non-NULL value in the performance_timers.TIMER_NAME column.
If you modify the table, monitoring is immediately affected, and currently monitored events would use a combination of old and new timers, which is probably undesirable. It is best to reset the Performance Schema statistics if you make changes to this table.
SELECT * FROM setup_timers; +-----------+-------------+ | NAME | TIMER_NAME | +-----------+-------------+ | idle | MICROSECOND | | wait | CYCLE | | stage | NANOSECOND | | statement | NANOSECOND | +-----------+-------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/performance-schema-setup_timers-table/