percona PMM Query Analytics报“ No query classes for selected instance and time range”错

千家信息网最后更新 2025年02月02日percona PMM Query Analytics报“ No query classes for selected instance and time range”错

完整报错信息如下：

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.

解决方法：

PMM使用slow log作为查询源，需要开启慢日志：

slow_query_log=ON
long_query_time=0