Get the App
SLTechnology News&Howtos  ›  Database  › 

Percona PMM Query Analytics newspaper "No query classes for selected instance and time range" error

Shulou Source: shulou.com Published: 2022-06-01 14:34:34 10月04日 Update

The complete error message is as follows:

There is no data for the selected MySQL instance, time range or search query.

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.

Solution:

PMM uses slow log as the query source, and slow logs need to be enabled:

Slow_query_log=ON

Long_query_time=0

Tags: Information method log query Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Redmi Shulou Tech Info NVidia OPPO Reno Shulou Information