QAN not showing some query we know are running in database

Percona Monitoring and Management (PMM) PMM 3.x
1

Hi all.
We a facing strange issue when some of query not showing in QAN.
We can see them in perfomance_schema events tables, but not in QAN.

Environment:
PMM server: 3.2.0
PMM client: 3.2.0
Database server: percona-server 5.7.35

2

Hi svist!

QAN has some filters on the left panel and will only show certain queries depending on the time range you select at the top right.

Do you see most of the queries being displayed on QAN or just a few of them?

Regards

3

Thanks for answer!
We see most of the queries except few specific ones. There is no filters being set on the side panel and we are sure that queries we are missing run in the selected time range.

4

Hello @svist,
You did not mention how you set up the MySQL server within PMM. Did you add this server via the PMM UI? Or did you install the agent, and use command-line? Which source did you select for queries: slow log, or perfschema? If slow log, queries are added to this log based on long_query_time MySQL parameter. Check all of these, and let us know more details about your setup.

5

We installed agent and added instance to pmm through cli. Source is perfschema, shoud have been more clear about it in my fires post.

6

The perfschema agent looks at the following 2 tables: performance_schema.events_statements_history, and performance_schema.events_statements_summary_by_digest

Ensure your queries show up in one of these tables.