Percona monitoring and management not showing query from databases

I have set up pmm-server in docker , and pmm2 agent from apt repositories , pmm agent is running at the background but the database queries from the applicatoin are not being displayed in the query analytics of percona monitoring and management, but the queries from manual cli queries is being displayed.

1 Like

Hi Joseph,

What source of SQL queries is used? By default it’s slowlog.
Here are recommended settings for a monitored mysql server.

1 Like

Thank you for the reply, Vadim. mysql distribution is 5.7.39, and i have been using performance_schema.

. when i manually use the mysql cli, the query is being displayed over QAN, but the queries from the web application, is not being displayed.

1 Like

Hi Joseph,

It means that web application queries are not stored by The Performance Schema. You should investigate the reason of it.

1 Like


can anyone tell me,what does this mean?

1 Like

guys my investigation lead me to nowhere , would you guys help? I have followed the exact procedure for configuring the pmm-client and pmm-server through documentation.

1 Like

Hi Joseph,

You could check if queries from your web application are caught by slowlog and if it’s so then switch pmm-agent to use it.

1 Like

i did try with slow_log schema, it feel like its catching the query, but not adequately as it was meant to be.Could you guys suggest what could i be missing?

1 Like

Could you provide more details regarding “not adequately”?

1 Like