pmm(Percona Monitoring and Management )是一個集MySQL性能指標監(jiān)控和慢查詢查看的套件，因界面美觀囊嘉、部署方便礁扮、功能全面在業(yè)界得到廣泛運用梳侨；最近在客戶端配置慢查詢上報，使用如下命令:
pmm-admin add mysql:queries --user=XXX --password='XXX'
結果得到報錯:
Error adding MySQL queries: problem with agent registration on QAN API: exit status 1
Error adding MySQL queries: GET http://IP/qan-api/instances/XXXXXX: API returned HTTP status code 500, expected 200: Instance.Get: dbm.Open: Error 1040: Too many connections
經(jīng)排查是pmm-server自帶的MySQL配置的最大連接數(shù)才151仿荆，而我配置了幾百臺db上報，把連接數(shù)打滿了, 調整下就行了:
# 查看pmm-server的docker對應的container id
docker ps
# 進入container
docker exec -it <container id> /bin/bash
# 設置最大連接數(shù)
mysql -e "set global max_connections=10000"
