# Percona monitoring and management not showing query from databases

**URL:** <https://forums.percona.com/t/percona-monitoring-and-management-not-showing-query-from-databases/17276>\
**Category:** Other MySQL® Questions\
**Tags:** pmm, mysql, percona\
**Created:** [September 2, 2022, 12:21pm UTC](https://forums.percona.com/t/percona-monitoring-and-management-not-showing-query-from-databases/17276 "2022-09-02T12:21:08Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![joseph\_lama](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/joseph_lama/32/7655_2.png) [@joseph\_lama](https://forums.percona.com/u/joseph_lama)\
**Post date:** [September 2, 2022, 12:21pm UTC](https://forums.percona.com/t/percona-monitoring-and-management-not-showing-query-from-databases/17276/1 "2022-09-02T12:21:08Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\
**Post date:** [September 2, 2022, 12:59pm UTC](https://forums.percona.com/t/percona-monitoring-and-management-not-showing-query-from-databases/17276/2 "2022-09-02T12:59:59Z")

</div>

Hi Joseph,

What source of SQL queries is used? By default it’s slowlog.  
Here are [recommended settings](https://docs.percona.com/percona-monitoring-and-management/setting-up/client/mysql.html#slow-query-log) for a monitored mysql server.

---

<div class="post-metadata">

**Author:** ![joseph\_lama](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/joseph_lama/32/7655_2.png) [@joseph\_lama](https://forums.percona.com/u/joseph_lama)\
**Post date:** [September 4, 2022, 3:48pm UTC](https://forums.percona.com/t/percona-monitoring-and-management-not-showing-query-from-databases/17276/3 "2022-09-04T15:48:10Z")

</div>

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

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/f/f10fa78aeab6f90a8e5d3d1e031f209dbdac85c8.png). 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.

---

<div class="post-metadata">

**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\
**Post date:** [September 5, 2022, 12:09pm UTC](https://forums.percona.com/t/percona-monitoring-and-management-not-showing-query-from-databases/17276/4 "2022-09-05T12:09:43Z")

</div>

Hi Joseph,

> [@joseph\_lama](#):
>
> 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.

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

---

<div class="post-metadata">

**Author:** ![joseph\_lama](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/joseph_lama/32/7655_2.png) [@joseph\_lama](https://forums.percona.com/u/joseph_lama)\
**Post date:** [September 9, 2022, 7:29am UTC](https://forums.percona.com/t/percona-monitoring-and-management-not-showing-query-from-databases/17276/5 "2022-09-09T07:29:46Z")

</div>

![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/c/c86d8fc74ef257f4c8d02a8d73bcfe17c7abe9bf.png)  
can anyone tell me,what does this mean?

---

<div class="post-metadata">

**Author:** ![joseph\_lama](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/joseph_lama/32/7655_2.png) [@joseph\_lama](https://forums.percona.com/u/joseph_lama)\
**Post date:** [September 9, 2022, 9:37am UTC](https://forums.percona.com/t/percona-monitoring-and-management-not-showing-query-from-databases/17276/6 "2022-09-09T09:37:51Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\
**Post date:** [September 9, 2022, 2:14pm UTC](https://forums.percona.com/t/percona-monitoring-and-management-not-showing-query-from-databases/17276/7 "2022-09-09T14:14:28Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![joseph\_lama](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/joseph_lama/32/7655_2.png) [@joseph\_lama](https://forums.percona.com/u/joseph_lama)\
**Post date:** [September 21, 2022, 11:33am UTC](https://forums.percona.com/t/percona-monitoring-and-management-not-showing-query-from-databases/17276/8 "2022-09-21T11:33:47Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\
**Post date:** [September 21, 2022, 12:16pm UTC](https://forums.percona.com/t/percona-monitoring-and-management-not-showing-query-from-databases/17276/9 "2022-09-21T12:16:05Z")

</div>

Could you provide more details regarding “not adequately”?
