Re: COUNT_STAR, SUM_TIMER_WAIT

[Øystein Grøvlen]

Hi,

If query is correct and the necessary data collection is enabled, it means that the slave threads have never waited for any events.

However, you should verify that you have enabled what is needed to monitor the wait events.

Also, you should verify by looking at the content of the threads table, that the name of the slave threads match what you assume in this query. (The query as it is presented here, also have some errors. E.g, I assume that performance_schema,threads should actually be performance_schema).

Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway