QAN API error: qh.Profile: No query classes for selected instance and time range.

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

Hello!

Thanks for a really nice application!

I’m using pmm 1.0.5 docker image, and 3 percona-xtradb-cluster-5.6 nodes with latest pmm client for ubuntu 14.04.

The 3 nodes are seen in qan, but I’ve always this error popup:

QAN API error: “qh.Profile: No query classes for selected instance and time range. Please check whether your MySQL settings match the recommended.”.
Check the /var/log/qan-api.log file in docker container for more information.

Here is the percona-server version:
5.6.32-78.1-56-log Percona XtraDB Cluster (GPL), Release rel78.1, Revision 979409a, WSREP version 25.17, wsrep_25.17
So, what are the “recommended MySQL settings” for having some analytics ?

2

The error is not the best but it indicates that there are no queries.

For PXC 5.6 we recommend using slowlog as query source.
Take a look at [URL=“Percona Monitoring and Management”]https://www.percona.com/doc/percona-...onf-mysql.html[/URL] (first bullet item)
At least you have to enable:
log_output=file
slow_query_log=ON
long_query_time=0