# I cannot see all the Schemas in the database MySQL

**URL:** <https://forums.percona.com/t/i-cannot-see-all-the-schemas-in-the-database-mysql/8018>\
**Category:** PMM 2.x\
**Created:** [September 9, 2020, 8:32am UTC](https://forums.percona.com/t/i-cannot-see-all-the-schemas-in-the-database-mysql/8018 "2020-09-09T08:32:10Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Flux](https://avatars.discourse-cdn.com/v4/letter/f/ce7236/32.png) [@Flux](https://forums.percona.com/u/Flux)\
**Post date:** [September 9, 2020, 8:32am UTC](https://forums.percona.com/t/i-cannot-see-all-the-schemas-in-the-database-mysql/8018/1 "2020-09-09T08:32:10Z")

</div>

Hi,When I execute Query Analytics, I cannot see all the current Schemas&nbsp; from the database MySQL in the filter on the left.Could you explain me the reason, or how can I enable all schemas in in the filter on the left QAN table.  
RegardsGabriel.

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [September 15, 2020, 7:12am UTC](https://forums.percona.com/t/i-cannot-see-all-the-schemas-in-the-database-mysql/8018/2 "2020-09-15T07:12:43Z")

</div>

How is Query Analytics configured - are you using Slow Query Log or Performance Schema ?

---

<div class="post-metadata">

**Author:** ![Flux](https://avatars.discourse-cdn.com/v4/letter/f/ce7236/32.png) [@Flux](https://forums.percona.com/u/Flux)\
**Post date:** [September 15, 2020, 7:23am UTC](https://forums.percona.com/t/i-cannot-see-all-the-schemas-in-the-database-mysql/8018/3 "2020-09-15T07:23:19Z")

</div>

Hi, Im using Performance Schema configuration

---

<div class="post-metadata">

**Author:** ![kalyan\_rajput](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kalyan_rajput/32/6375_2.png) [@kalyan\_rajput](https://forums.percona.com/u/kalyan_rajput)\
**Post date:** [November 16, 2020, 2:55am UTC](https://forums.percona.com/t/i-cannot-see-all-the-schemas-in-the-database-mysql/8018/4 "2020-11-16T02:55:38Z")

</div>

@Peter If we use Perf schema, then how can we find slow queries and what parameters we need to enable.

Regards,

Kalyan

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [November 17, 2020, 4:26am UTC](https://forums.percona.com/t/i-cannot-see-all-the-schemas-in-the-database-mysql/8018/5 "2020-11-17T04:26:15Z")

</div>

Performance Schema should work without additional tuning, it however does not do the same breakdown by Schema as MySQL Slow Query Log does