# MySQL DB filter in Query Analytics

**URL:** <https://forums.percona.com/t/mysql-db-filter-in-query-analytics/14775>\
**Category:** PMM 2.x\
**Tags:** mysql, closed-no-reply\
**Created:** [March 17, 2022, 12:22am UTC](https://forums.percona.com/t/mysql-db-filter-in-query-analytics/14775 "2022-03-17T00:22:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![hj.choi](https://avatars.discourse-cdn.com/v4/letter/h/7feea3/32.png) [@hj.choi](https://forums.percona.com/u/hj.choi)\
**Post date:** [March 17, 2022, 12:22am UTC](https://forums.percona.com/t/mysql-db-filter-in-query-analytics/14775/1 "2022-03-17T00:22:39Z")

</div>

hello cool people  
I am trying to apply mysql DB filter, but only ‘n/a’ is displayed as the default filter  
I don’t know what to set in Variables  
can you help me?

---

<div class="post-metadata">

**Author:** ![Jiri\_Ctvrtka](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jiri_ctvrtka/32/8302_2.png) [@Jiri\_Ctvrtka](https://forums.percona.com/u/Jiri_Ctvrtka)\
**Post date:** [March 14, 2023, 2:50pm UTC](https://forums.percona.com/t/mysql-db-filter-in-query-analytics/14775/2 "2023-03-14T14:50:36Z")

</div>

Hi @hj.choi, do you have some load running in your MySQL? Because based on queries and its tables/databases etc we parsing values into this filter. So without queries contains for example some table you will have filter empty. Also could you share your PMM server and PMM client version? Thank you.

---

<div class="post-metadata">

**Author:** ![Mauricio\_Cacho](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mauricio_cacho/32/5859_2.png) [@Mauricio\_Cacho](https://forums.percona.com/u/Mauricio_Cacho)\
**Post date:** [March 22, 2023, 2:50am UTC](https://forums.percona.com/t/mysql-db-filter-in-query-analytics/14775/3 "2023-03-22T02:50:24Z")

</div>

Hi @hj.choi

As Jiri mentioned, one thing to confirm is if you’re already having load in your MySQL instances.  
Also, as for the variables, you may also confirm you configured the proper source for PMM (Slow Query Log or Performance Schema), and depending on your source you may need to set a couple of variables; please refer to this [Documentation section](https://docs.percona.com/percona-monitoring-and-management/setting-up/client/mysql.html#choose-and-configure-a-source) from PMM and choosing your source, there you can compare / validate if you’re missing something.