# SHOW DATABASES (any queries on table\_schema)  extremely slow only on 2/3 nodes

**URL:** <https://forums.percona.com/t/show-databases-any-queries-on-table-schema-extremely-slow-only-on-2-3-nodes/6565>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [September 6, 2018, 3:02pm UTC](https://forums.percona.com/t/show-databases-any-queries-on-table-schema-extremely-slow-only-on-2-3-nodes/6565 "2018-09-06T15:02:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![akang](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@akang](https://forums.percona.com/u/akang)\
**Post date:** [September 6, 2018, 3:02pm UTC](https://forums.percona.com/t/show-databases-any-queries-on-table-schema-extremely-slow-only-on-2-3-nodes/6565/1 "2018-09-06T15:02:15Z")

</div>

We have a Percona XtraDB 5.6 cluster of 3 nodes. For some reason on two nodes, it takes an abnormal amount of time to run queries that involve tables in the information\_schema database.

For ex, running “SHOW DATABASES” takes ~5min on node2 and ~3min on node3 whereas on node1, it takes ~0.02sec.

Node1 has a system memory of 8gb and innodb buffer pool size of 3gb.

Node2 and 3 have a system memory of 4gb and innodb buffer pool size of 2gb.

I know that the information\_schema tables are stored in memory. I am theorizing that because of a small innodb buffer pool size, node2 and 3 take a long time to query against information\_schema. However, when testing on a test cluster, I cannot reproduce this issue by lowering the innodb buffer pool size.

Has anyone ever experienced and know what the issue may be?