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>:/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