千家信息网

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

发表于:2024-12-01 作者:千家信息网编辑
千家信息网最后更新 2024年12月01日,完整报错信息如下:There is no data for the selected MySQL instance, time range or search query.QAN API error:
千家信息网最后更新 2024年12月01日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

0