# Performance Schema setup\_timers Table

## Description

The `setup_timers` table shows the currently selected event timers. Deprecated since 10.5, removed in 12.0.

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](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-performance_timers-table) 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.

## Example

```sql
SELECT * FROM setup_timers;
+-----------+-------------+
| NAME      | TIMER_NAME  |
+-----------+-------------+
| idle      | MICROSECOND |
| wait      | CYCLE       |
| stage     | NANOSECOND  |
| statement | NANOSECOND  |
+-----------+-------------+
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}