# Getting this error "Connection check failed: timeout (context deadline exceeded)" while trying to add mysql using pmm-admin

**URL:** <https://forums.percona.com/t/getting-this-error-connection-check-failed-timeout-context-deadline-exceeded-while-trying-to-add-mysql-using-pmm-admin/25277>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [September 19, 2023, 2:06pm UTC](https://forums.percona.com/t/getting-this-error-connection-check-failed-timeout-context-deadline-exceeded-while-trying-to-add-mysql-using-pmm-admin/25277 "2023-09-19T14:06:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Harish\_m.r](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/harish_m.r/32/12825_2.png) [@Harish\_m.r](https://forums.percona.com/u/Harish_m.r)\
**Post date:** [September 19, 2023, 2:06pm UTC](https://forums.percona.com/t/getting-this-error-connection-check-failed-timeout-context-deadline-exceeded-while-trying-to-add-mysql-using-pmm-admin/25277/1 "2023-09-19T14:06:23Z")

</div>

When we are trying to add mysql using pmm-admin getting this error “Connection check failed: timeout (context deadline exceeded)”.  
We tried checking the mysql command used by pmm-admin “SELECT /\* agent=‘connectionchecker’ _/ COUNT(_) FROM information\_schema.tables;” .  
This is taking around 6-8 seconds since the number of tables are more in our case.

PMM server is running with docker and Mysql nodes are running individually in cluster.

---

<div class="post-metadata">

**Author:** ![Roma\_Novikov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roma_novikov/32/1161_2.png) [@Roma\_Novikov](https://forums.percona.com/u/Roma_Novikov)\
**Post date:** [September 19, 2023, 2:22pm UTC](https://forums.percona.com/t/getting-this-error-connection-check-failed-timeout-context-deadline-exceeded-while-trying-to-add-mysql-using-pmm-admin/25277/2 "2023-09-19T14:22:43Z")

</div>

Hi @Harish_m.r , try to use the flag `--disable-tablestats` [pmm-admin - PMM Administration Tool - Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/details/commands/pmm-admin.html#mysql) to disable this data collector at all

---

<div class="post-metadata">

**Author:** ![Harish\_m.r](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/harish_m.r/32/12825_2.png) [@Harish\_m.r](https://forums.percona.com/u/Harish_m.r)\
**Post date:** [September 19, 2023, 2:31pm UTC](https://forums.percona.com/t/getting-this-error-connection-check-failed-timeout-context-deadline-exceeded-while-trying-to-add-mysql-using-pmm-admin/25277/3 "2023-09-19T14:31:24Z")

</div>

Hi @Roma_Novikov we tried as you suggested and we are still getting the same error.

sudo pmm-admin add mysql --username=pmm --password=‘XXXXXXXX’ --host=127.0.0.1 --port=3366 --query-source=slowlog --disable-tablestats=0  
Connection check failed: timeout (context deadline exceeded).

pmm-admin add mysql --query-source=perfschema --username=pmm --password=‘xxxxxxx’ MYSQL\_NODE --port=3366 --disable-tablestats  
Connection check failed: timeout (context deadline exceeded).

Please note we are running MySQL on different port and we were able to see successful pmm user connection in mysql general log.

---

<div class="post-metadata">

**Author:** ![Roma\_Novikov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roma_novikov/32/1161_2.png) [@Roma\_Novikov](https://forums.percona.com/u/Roma_Novikov)\
**Post date:** [September 27, 2023, 9:05am UTC](https://forums.percona.com/t/getting-this-error-connection-check-failed-timeout-context-deadline-exceeded-while-trying-to-add-mysql-using-pmm-admin/25277/4 "2023-09-27T09:05:10Z")

</div>

@Harish_m.r, thanks! It looks strange then and sounds like a bug. Can you submit a bug to [https://jira.percona.com/](https://jira.percona.com/) so our engineering team can closely examine your case? Thanks