Not able to see app queries in PMM

Percona Monitoring and Management (PMM)
1

Description:

I am not able to see queries that i fired from dbeaver or any user queries in query analytics.
I just installed PMM

Steps to Reproduce:

Create a user monitor_user. give the required privileges.

Version:

[Insert the version number of the software]

Logs:

[If applicable, include any relevant log files or error messages]

Expected Result:

[What the user expected to see or happen before the issue occurred]

Actual Result:

[What actually happened when the user encountered the issue]

Additional Information:

[Include any additional information that could be helpful to diagnose the issue, such as browser or device information]

1 Like
2

Please provide the exact command used to install the pmm-client package and enable the MySQL-PMM Agent. Verify that your slow log is enabled, and long-query-time=0, or verify that your performance_schema is enabled with defaults.

3

This is a Postgresql ec2 instance.

Here are the commands used
yum -y install docker
sudo service docker start
wget -O - https://www.percona.com/get/pmm | /bin/bash

Change database parameters

shared_preload_libraries=pg_stat_statements

https://XX.XX.XX.190:443/

Thanks for all the assistance

Regards
Siddharth

4

Hello @siddharth0204,
It looks like you’ve only installed the PMM Server. You must also install the PMM Client agents on each server you want to monitor/collect queries.

5

thanks Matthew for your response.
Just for us to know i have installed PMM on the same server as the EC2 instance is.

Seems I may still require PMM client to be installed.
I will try this and get back to you.

Thank you for your assistance

Regards,
Siddharth

6

You should install PMM Server on a dedicated monitoring server; do not install PMM server on the same machine as your database.

Yes, you install the client agent on your database machine.

Please review the PMM architecture if you need additional info.