[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-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
