Buy Percona ServicesBuy Now!

too many connection when add mysql:queries

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • too many connection when add mysql:queries

    [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:pass@10.1.x,xx:8080/qan-...9f335d4315533: 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

  • #2
    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?

    Comment


    • #3
      Originally posted by roma.novikov View Post
      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

      Comment


      • #4
        Thanks!
        In 1.14.0 we'll increase this number by default

        Comment

        Working...
        X