Percona monitoring and management not showing query from databases

MySQL & MariaDB Other MySQL® Questions
, ,
1

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.

2 Likes
2

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
3

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

image
image1265×359 58.6 KB
. 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
4

Hi Joseph,

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

1 Like
5

image
image870×231 25.1 KB

can anyone tell me,what does this mean?

1 Like
6

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
7

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
8

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
9

Could you provide more details regarding “not adequately”?

1 Like