Not the answer you need?
Register and ask your own question!

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

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 ?

Comments

  • weberweber Advisor Inactive User Role Beginner
    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 https://www.percona.com/doc/percona-...onf-mysql.html (first bullet item)
    At least you have to enable:
    log_output=file
    slow_query_log=ON
    long_query_time=0
This discussion has been closed.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.