# too many connection when add mysql:queries

**URL:** <https://forums.percona.com/t/too-many-connection-when-add-mysql-queries/6524>\
**Category:** PMM 1.x\
**Created:** [August 21, 2018, 4:31am UTC](https://forums.percona.com/t/too-many-connection-when-add-mysql-queries/6524 "2018-08-21T04:31:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/fan/32/40_2.png) [@Fan](https://forums.percona.com/u/Fan)\
**Post date:** [August 21, 2018, 4:31am UTC](https://forums.percona.com/t/too-many-connection-when-add-mysql-queries/6524/1 "2018-08-21T04:31:58Z")

</div>

[root@node001147 fanboshi]# pmm-admin add mysql --user pmm --password ‘superpass’ --socket /path\_to\_sock/mysql.sock --disable-tablestats 192.168.x.xx\_3307  
[linux:metrics] OK, already monitoring this system.  
[mysql:metrics] OK, already monitoring MySQL metrics.  
[mysql:queries] Error adding MySQL queries: GET [http://user](http://user):pass@10.1.x,xx:8080/qan-api/instances/e574670ced4c43977b49f335d4315533: API returned HTTP status code 500, expected 200: Instance.Get: dbm.Open: Error 1040: Too many connections

into docker, into mysql  
show processlist  
| 5860634 | qan-api | localhost:49164 | pmm | Sleep | 2 | | NULL | 0 | 0 | 0 |  
| 5860637 | qan-api | localhost:49178 | pmm | Sleep | 2 | | NULL | 0 | 0 | 0 |  
±--------±--------±----------------±-----±--------±-----±------±-----------------±----------±--------------±----------+  
149 rows in set (0.00 sec)

mysql\> show global variables like ‘%conn%’;  
±-------------------------±------------------+  
| Variable\_name | Value |  
±-------------------------±------------------+  
| character\_set\_connection | latin1 |  
| collation\_connection | latin1\_swedish\_ci |  
| connect\_timeout | 10 |  
| extra\_max\_connections | 1 |  
| init\_connect | |  
| max\_connect\_errors | 10 |  
| max\_connections | 151 |  
| max\_user\_connections | 0 |  
±-------------------------±------------------+  
8 rows in set (0.00 sec)

mysql\> set global max\_connections=1000;  
Query OK, 0 rows affected (0.00 sec)

by the way, we monitor 208 instance  
suggest increment this variables default value

![photoid=52149](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/1/1e6432dc237af0074582cf2cc9441566f4a02454.png)

---

<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:** [August 21, 2018, 12:24pm UTC](https://forums.percona.com/t/too-many-connection-when-add-mysql-queries/6524/2 "2018-08-21T12:24:35Z")

</div>

Thanks for report [Fan](https://percona.vanillacommunities.com/profile/x/x/41523) ! Will create a Jira issue for this.

Just for information:  
Is this 1.13.0 version? and what was the previous amount of monitored instances?

---

<div class="post-metadata">

**Author:** ![Fan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/fan/32/40_2.png) [@Fan](https://forums.percona.com/u/Fan)\
**Post date:** [August 22, 2018, 8:16am UTC](https://forums.percona.com/t/too-many-connection-when-add-mysql-queries/6524/3 "2018-08-22T08:16:51Z")

</div>

> [@roma.novikov;52159](#):
>
> Thanks for report [Fan](https://percona.vanillacommunities.com/profile/x/x/41523) ! Will create a Jira issue for this.
> 
> Just for information:  
> Is this 1.13.0 version? and what was the previous amount of monitored instances?

version is 1.13.0.  
previous less than 100 instance

---

<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:** [August 29, 2018, 11:55am UTC](https://forums.percona.com/t/too-many-connection-when-add-mysql-queries/6524/4 "2018-08-29T11:55:29Z")

</div>

Thanks!  
In 1.14.0 we’ll increase this number by default