Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

too many connection when add mysql:queries

FanFan ContributorCurrent User Role Patron
[[email protected] 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:[email protected],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

Comments

  • roma.novikovroma.novikov Percona Percona Staff Role
    Thanks for report Fan ! 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?
  • FanFan Contributor Current User Role Patron
    Thanks for report Fan ! 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
  • roma.novikovroma.novikov Percona Percona Staff Role
    Thanks!
    In 1.14.0 we'll increase this number by default
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.