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

Unable to view Query Analytics for specific server

Hi All,
I have recently installed PMM Platform. PMM-server is setup on a standalone server and currently pmm-client is installed on 3 different MySQL DB servers.
I'm able to view Query Analytics for 2 clients and however, I get the following error for the 3rd DB :
" There is no query data because the MySQL Server is not configured for monitoring. For details about the required configuration, see Configuring MySQL for Percona Monitoring and Management in PMM documentation."

I have configured all the 3 servers in the exact same manner. Following is the output from /var/log/pmm-mysql-queries-0.log
# Version: percona-qan-agent 1.0.5

# Basedir: /usr/local/percona/qan-agent

# PID: 11803

# API: <server_ip>:<port>/qan-api

# UUID: 422dc1324e61433c4db56f0313d97fda

2019/09/18 12:15:24.474803 main.go:153: Starting agent...

2019/09/18 12:15:24.476734 main.go:321: Agent is ready

2019/09/18 12:15:24.513498 main.go:194: API is ready

{UUID: CollectFrom: Interval:60 ExampleQueries:0xc420027b70 MaxSlowLogSize:1073741824 SlowLogRotation:0xc420027b71 RetainSlowLogs:0xc420027b78 Start:[] Stop:[] ReportLimit:200}

{UUID:b0074f47a6374e4f6feb6a0a8bf98353 CollectFrom:slowlog Interval:60 ExampleQueries:0xc420027b70 MaxSlowLogSize:1073741824 SlowLogRotation:0xc420027b71 RetainSlowLogs:0xc420027b78 Start:[] Stop:[] ReportLimit:200}


I do not see any issue in this output. Requesting assistance for the same.

Thanks in advance,
Ritwik Garg
Sign In or Register to comment.

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