table_io_waits_summary_by_index_usage

[Jamie Downs]

Hello,

I am trying to review index usage using the performance_schema.table_io_waits_summary_by_index_usage table.

It looks to be enabled as the instrument is enabled:

+---------------------------+---------+-------+
| NAME | ENABLED | TIMED |
+---------------------------+---------+-------+
| wait/io/table/sql/handler | YES | YES |
+---------------------------+---------+-------+

I can see the inserts incrementing the count_star and count_insert. However. When I run a select query that returns records none of the numbers increment.

Is there something else I need to configure?
Thanks.

+------------------------------+------------+----------------+----------------+----------------+------------+----------------+----------------+----------------+--------------+------------------+------------------+------------------+
| index_name | COUNT_STAR | SUM_TIMER_WAIT | AVG_TIMER_WAIT | MAX_TIMER_WAIT | COUNT_READ | SUM_TIMER_READ | AVG_TIMER_READ | MAX_TIMER_READ | COUNT_INSERT | SUM_TIMER_INSERT | AVG_TIMER_INSERT | MAX_TIMER_INSERT |
+------------------------------+------------+----------------+----------------+----------------+------------+----------------+----------------+----------------+--------------+------------------+------------------+------------------+
| NULL | 272474 | 17.23 s | 63.24 us | 26.53 ms | 0 | 0 ps | 0 ps | 0 ps | 272474 | 17.23 s | 63.24 us | 26.53 ms |
| event | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps |
| event_time_user_object_event | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps |
| external_grouping_id | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps |
| grouping_id | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps |
| object | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps |
| object_key | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps |
| object_property | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps |
| PRIMARY | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps |
| user | 140881288 | 1.19 m | 507.50 ns | 1.19 m | 140881288 | 1.19 m | 507.50 ns | 1.19 m | 0 | 0 ps | 0 ps | 0 ps |
| user_object | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps | 0 | 0 ps | 0 ps | 0 ps |
+------------------------------+------------+----------------+----------------+----------------+------------+----------------+----------------+----------------+--------------+------------------+------------------+------------------+