QAN shows throttle message as a slow query
Description
How to test
Configure MySQL like below
Create a table and and load some data on it.
Select the field that has not been indexed several times.
Please try the older MySQL version because, in the latest one, there is another bug report related to the throttling message that does not appear.
How to document
AFFECTED CS IDs
Attachments
Activity
Marco Tusa May 6, 2024 at 2:05 PM
I am little bit confused here.
The information about if a Query is NOT using index is very important and we should have it in PMM…
and we do:
In QUAN, however when I try to filter the Queries by “No Index Used” I get empty set.
Anyhow … about the throttle that as it is should NOT be in the query list, but the information about the Query should be.
That is my 2 cent.
Nurlan Moldomurov May 1, 2024 at 8:43 AM
can you check this and provide your expertise?
Nurlan Moldomurov April 24, 2024 at 2:28 PM
Hi that’s not so simple since we don’t know how to differentiate queries from warnings.
Aaditya Dubey April 24, 2024 at 2:04 PM
Hi
Basically, we should skip warnings; in this case, throttle: 91 'index not used' warning(s) was suppressed, since this is just one kind of case and maybe we have other related scenarios as well so this should be tackled broadly.
yunus.uyanik April 24, 2024 at 2:00 PM
Hey indeed, the throttle record should be skipped and not necessarily show in PMM. But, if you have another idea, that would be admissible.
Details
Details
Assignee
Reporter
Priority
Medium
The throttle message provided by using this variable log_throttle_queries_not_using_indexes is shown as a slow query in QAN.