One 、PMM brief introduction

I've published an article before Prometheus+Grafana The article , Connect as :【DB treasure 36】 Use Docker Build beautiful... Every minute prometheus+grafana monitor , Today, let's introduce another monitoring tool :PMM.

PMM(Percona Monitoring and Management) It's a free open source platform , For managing and monitoring database performance , stay docker Running in the environment . It can actively manage and monitor MySQL(AWS RDS MySQL、Aurora MySQL、 User built MySQL example )、MariaDB、MongoDB、PostgreSQL Such as the database , It can also monitor ProxySQL middleware , It also provides many indexes and various alarm modes .

Percona Monitoring and Management (PMM) Is an open source for management and monitoring MySQL and MongoDB Open source platform for performance , adopt PMM Collected by the client DB Monitoring data using third-party software Grafana Draw a picture and show it .

PMM Provide for the right to MyISAM、InnoDB、TokuDB and PXC/Glarera Monitoring of , It also provides Query Analytics The function of , You can see what has been done SQL Instructions , And optimize the syntax with poor performance . In addition, the new version also supports MySQL Copy topology structure .Demo Official website :http://pmmdemo.percona.com

PMM Hard disk is also provided for the operating system 、 The Internet 、CPU and RAM Monitoring of , In particular, it provides Context switches、Processes and interrupts Monitoring of ,Context Switches You can see CPU Switch the status of the text up and down ,Processes It's easy to know how many programs are waiting in the system I/O.

PMM On the whole, it's a good monitoring product , in the light of MySQL、PG、Mongo There are very professional index statistics , And it's easy to deploy, package it in a container .2.0 Then the underlying persistent database starts from MySQL Replace with PG after , The performance has been greatly improved .

PMM The architecture of is as follows :

Two 、 Install and use

https://www.percona.com/software/pmm/quickstart

https://www.percona.com/doc/percona-monitoring-and-management/2.x/

https://hub.docker.com/r/percona/pmm-server/tags
docker pull percona/pmm-server:latest
--  Pull the mirror image
docker pull percona/pmm-server:2.14
--  establish PMM Data container
docker rm lhr-pmm-data
docker create --name lhr-pmm-data \
   -v /pmmdata \
   percona/pmm-server:2.14 /bin/true
--  establish PMM Server container
docker rm -f lhr-pmm-server
docker run -d --name lhr-pmm-server -h lhr-pmm-server \
  -p 280:80 -p 2443:443 \
  --volumes-from lhr-pmm-data \
  -e SERVER_USER=lhr \
  -e SERVER_PASSWORD=lhr \
  -e ORCHESTRATOR_ENABLED=true \
  -e METRICS_RETENTION=48h \
  --restart always \
  percona/pmm-server:2.14
--  visit web Interface
http://192.168.66.35:280
https://192.168.66.35:2443
admin/admin
--  Get into PMM The server
docker exec -it lhr-pmm-server bash
--  Connect to PMM The server
pmm-admin config --server-insecure-tls --server-url=https://admin:admin@127.0.0.1:443
pmm-admin list

have access to http or https visit , The port numbers are different .

After logging in, you can see the following information :

[root@lhr-pmm-server opt]# pmm-admin config --server-insecure-tls --server-url=https://admin:admin@127.0.0.1:443
Checking local pmm-agent status...
pmm-agent is running.
Registering pmm-agent on PMM Server...
Registered.
Configuration file /usr/local/percona/pmm2/config/pmm-agent.yaml updated.
Reloading pmm-agent configuration...
Configuration reloaded.
Checking local pmm-agent status...
pmm-agent is running.
[root@lhr-pmm-server opt]# pmm-admin list
Service type                Service name                        Address and port       Service ID
Agent type                  Status     Metrics Mode   Agent ID                                      Service ID
pmm_agent                   Connected    /agent_id/57124a26-ea3e-4240-b39d-ec91af80e559  
node_exporter               Running    push  /agent_id/fed6ce91-c926-49d1-8bcb-17a8e3225f78  
vmagent                     Running    push  /agent_id/cbd8515c-d655-4467-a6bd-42c9db580ff2

3、 ... and 、 monitor MySQL database

You can add multiple monitored instances , Execution process :

[root@lhr-pmm-server opt]# pmm-admin add mysql --query-source=perfschema --username=root --password=lhr  --host=192.168.66.35 --port=3317 --service-name=mysql-192.168.66.35-3317
MySQL Service added.
Service ID  : /service_id/28cd296f-597a-4043-8c87-792308b31d37
Service name: mysql-192.168.66.35-3317
Table statistics collection enabled (the limit is 1000, the actual table count is 535).
[root@lhr-pmm-server opt]# pmm-admin add mysql --query-source=perfschema --username=root --password=lhr  --host=192.168.66.35 --port=3318 --service-name=mysql-192.168.66.35-3318
MySQL Service added.
Service ID  : /service_id/aceb0ad7-86c6-4ec8-9c45-8fe7f4135721
Service name: mysql-192.168.66.35-3318
Table statistics collection disabled (the limit is 1000, the actual table count is 1042).
[root@lhr-pmm-server opt]# pmm-admin list
Service type                Service name                        Address and port       Service ID
MySQL                       mysql-192.168.66.35-3317            192.168.66.35:3317     /service_id/28cd296f-597a-4043-8c87-792308b31d37
MySQL                       mysql-192.168.66.35-3318            192.168.66.35:3318     /service_id/aceb0ad7-86c6-4ec8-9c45-8fe7f4135721
Agent type                  Status     Metrics Mode   Agent ID                                      Service ID
pmm_agent                   Connected    /agent_id/57124a26-ea3e-4240-b39d-ec91af80e559  
node_exporter               Running    push  /agent_id/fed6ce91-c926-49d1-8bcb-17a8e3225f78  
mysqld_exporter             Running    push  /agent_id/5a8f8a51-c342-4108-8f94-1779e00ed118 /service_id/aceb0ad7-86c6-4ec8-9c45-8fe7f4135721 
mysqld_exporter             Running    push  /agent_id/b8342bd9-0c20-40d6-a666-b6b79903f5e8 /service_id/28cd296f-597a-4043-8c87-792308b31d37 
mysql_perfschema_agent      Running      /agent_id/908ad693-b9a2-43a9-abd2-f0d06ca1ca09 /service_id/28cd296f-597a-4043-8c87-792308b31d37 
mysql_perfschema_agent      Running      /agent_id/f965b782-76eb-49e8-874c-df52d47c7cb7 /service_id/aceb0ad7-86c6-4ec8-9c45-8fe7f4135721 
vmagent                     Running    push  /agent_id/cbd8515c-d655-4467-a6bd-42c9db580ff2

PMM Monitoring interface :

MySQL Slow query analysis

PMM It can monitor and analyze slow queries :

Four 、 monitor PG database

PMM The server's back-end metadata store uses PG database , therefore , We can directly monitor the library :

[root@lhr-pmm-server opt]# pmm-admin add postgresql --username=pmm-managed --password=pmm-managed --host=127.0.0.1 --port=5432 --service-name=PG-127.0.0.1-5432
PostgreSQL Service added.
Service ID  : /service_id/cb3c1b6d-fea0-4a81-9dcb-2c1840fc547b
Service name: PG-127.0.0.1-5432
[root@lhr-pmm-server opt]# pmm-admin list
Service type                Service name                        Address and port       Service ID
MySQL                       mysql-192.168.66.35-3317            192.168.66.35:3317     /service_id/28cd296f-597a-4043-8c87-792308b31d37
MySQL                       mysql-192.168.66.35-3318            192.168.66.35:3318     /service_id/aceb0ad7-86c6-4ec8-9c45-8fe7f4135721
PostgreSQL                  PG-127.0.0.1-5432                   127.0.0.1:5432         /service_id/cb3c1b6d-fea0-4a81-9dcb-2c1840fc547b
Agent type                  Status     Metrics Mode   Agent ID                                      Service ID
pmm_agent                   Connected    /agent_id/57124a26-ea3e-4240-b39d-ec91af80e559  
node_exporter               Running    push  /agent_id/fed6ce91-c926-49d1-8bcb-17a8e3225f78  
mysqld_exporter             Running    push  /agent_id/5a8f8a51-c342-4108-8f94-1779e00ed118 /service_id/aceb0ad7-86c6-4ec8-9c45-8fe7f4135721 
mysqld_exporter             Running    push  /agent_id/b8342bd9-0c20-40d6-a666-b6b79903f5e8 /service_id/28cd296f-597a-4043-8c87-792308b31d37 
postgres_exporter           Running    push  /agent_id/28bfba92-4872-4cd9-b3a1-5273670a44a2 /service_id/cb3c1b6d-fea0-4a81-9dcb-2c1840fc547b 
mysql_perfschema_agent      Running      /agent_id/908ad693-b9a2-43a9-abd2-f0d06ca1ca09 /service_id/28cd296f-597a-4043-8c87-792308b31d37 
mysql_perfschema_agent      Running      /agent_id/f965b782-76eb-49e8-874c-df52d47c7cb7 /service_id/aceb0ad7-86c6-4ec8-9c45-8fe7f4135721 
postgresql_pgstatements_agent Running      /agent_id/5cf99a1b-b474-48a9-94ad-acc6bdc77efb /service_id/cb3c1b6d-fea0-4a81-9dcb-2c1840fc547b 
vmagent                     Running    push  /agent_id/cbd8515c-d655-4467-a6bd-42c9db580ff2

PMM Monitoring interface :

5、 ... and 、 monitor MongoDB database

Use PMM When monitoring a cluster , You should use pmm-admin add Command enables monitoring of each instance , This includes replica sets in fragmented clusters 、mongos And all configuration servers .

--  password-less
pmm-admin add mongodb --host=192.168.66.35 --port=27017 --service-name=mongodb-192.168.66.35-27017
--  Password
pmm-admin add mongodb --username=root --password=lhr mongodb-192.168.66.35-37017 192.168.66.35:37017
pmm-admin add mongodb --username=root --password=lhr --host=192.168.66.35 --port=37017 --service-name=mongodb-192.168.66.35-37017
--  colony 、 Replicate set
pmm-admin add mongodb --cluster lhr-mongo-cluster --replication-set=lhr_rep --username=root --password=lhr  --host=192.168.66.35 --port=37020 --service-name=mongodb-192.168.66.35-37020-lhr_rep
pmm-admin add mongodb --cluster lhr-mongo-cluster --replication-set=lhr_rep --username=root --password=lhr  --host=192.168.66.35 --port=37021 --service-name=mongodb-192.168.66.35-37021-lhr_rep
pmm-admin add mongodb --cluster lhr-mongo-cluster --replication-set=lhr_rep --username=root --password=lhr  --host=192.168.66.35 --port=37022 --service-name=mongodb-192.168.66.35-37022-lhr_rep
pmm-admin add mongodb --cluster lhr-mongo-cluster --replication-set=lhr_rep --username=root --password=lhr  --host=192.168.66.35 --port=37023 --service-name=mongodb-192.168.66.35-37023-lhr_rep
pmm-admin add mongodb --cluster lhr-mongo-cluster --replication-set=lhr_rep --username=root --password=lhr  --host=192.168.66.35 --port=37024 --service-name=mongodb-192.168.66.35-37024-lhr_rep
--  Inquire about
pmm-admin list

When I'm done :

[root@lhr-pmm-server opt]# pmm-admin list
Service type                Service name                        Address and port       Service ID
MySQL                       mysql-192.168.66.35-3317            192.168.66.35:3317     /service_id/3d97792c-928c-4475-b5f3-f619d3b976e1
MySQL                       mysql-192.168.66.35-3316            192.168.66.35:3316     /service_id/4247b3f3-0b7c-48c6-aa72-3545a07d71c9
MySQL                       mysql-192.168.66.35-3315            192.168.66.35:3315     /service_id/5318af15-e338-4628-a7ba-19e2f510239d
MySQL                       mysql-192.168.66.35-3318            192.168.66.35:3318     /service_id/e527f5f2-e6f4-4eb9-9c73-86469fbf08e8
MongoDB                     mongodb-192.168.66.35-37024-lhr_rep 192.168.66.35:37024    /service_id/04e6a8b3-cb60-4a51-ae33-d67190a1da90
MongoDB                     mongodb-192.168.66.35-27017         192.168.66.35:27017    /service_id/11d684d1-f851-48f7-aec2-809814d073d2
MongoDB                     mongodb-192.168.66.35-37021-lhr_rep 192.168.66.35:37021    /service_id/178fb790-6e89-478e-b3c3-d50cdb158bcf
MongoDB                     mongodb-192.168.66.35-37020-lhr_rep 192.168.66.35:37020    /service_id/333c1bfa-6c51-4b57-9002-9bc9cca41880
MongoDB                     mongodb-192.168.66.35-37022-lhr_rep 192.168.66.35:37022    /service_id/7f8a5062-0e78-4078-80e1-f8a70f2d2b0a
MongoDB                     mongodb-192.168.66.35-37017         192.168.66.35:37017    /service_id/924ec922-3d7d-4b53-9bfc-aa9345109dda
MongoDB                     mongodb-192.168.66.35-37023-lhr_rep 192.168.66.35:37023    /service_id/c2ee5791-9d23-41ee-af7d-d21b50c2dd77
PostgreSQL                  PG-127.0.0.1-5432                   127.0.0.1:5432         /service_id/278f216a-c3d5-43fd-9163-e7a30dd459e1
Agent type                  Status     Metrics Mode   Agent ID                                      Service ID
pmm_agent                   Connected    /agent_id/f304147a-43a6-484b-9d32-d8f3c721cb63  
node_exporter               Running    push  /agent_id/89311eaa-bf62-4730-8f3b-ebddb9ddfe57  
mysqld_exporter             Running    push  /agent_id/13bca963-69be-4313-b6b4-ed4234c0abb5 /service_id/3d97792c-928c-4475-b5f3-f619d3b976e1 
mysqld_exporter             Running    push  /agent_id/29177549-d624-43dd-ae28-f29e913587d0 /service_id/e527f5f2-e6f4-4eb9-9c73-86469fbf08e8 
mysqld_exporter             Running    push  /agent_id/ee281335-8d7b-47fd-91a9-873062beff2d /service_id/4247b3f3-0b7c-48c6-aa72-3545a07d71c9 
mysqld_exporter             Running    push  /agent_id/fc3fad17-4dd1-4ae7-aa4e-22cce69dfe02 /service_id/5318af15-e338-4628-a7ba-19e2f510239d 
mongodb_exporter            Running    push  /agent_id/690ab339-5838-43c5-978e-73bb188d434a /service_id/7f8a5062-0e78-4078-80e1-f8a70f2d2b0a 
mongodb_exporter            Running    push  /agent_id/69905494-247a-41d1-b45f-a8e31639baf9 /service_id/333c1bfa-6c51-4b57-9002-9bc9cca41880 
mongodb_exporter            Running    push  /agent_id/7d97045e-afae-4e05-8216-5fbf5f28a74b /service_id/924ec922-3d7d-4b53-9bfc-aa9345109dda 
mongodb_exporter            Running    push  /agent_id/860ed641-3599-4fdc-9f57-8137d45f06b8 /service_id/11d684d1-f851-48f7-aec2-809814d073d2 
mongodb_exporter            Running    push  /agent_id/87be410e-dd68-4ce2-80fa-05d7827b5300 /service_id/178fb790-6e89-478e-b3c3-d50cdb158bcf 
mongodb_exporter            Running    push  /agent_id/c5f4b04a-3520-4355-aca5-7e41646883c5 /service_id/c2ee5791-9d23-41ee-af7d-d21b50c2dd77 
mongodb_exporter            Running    push  /agent_id/c78247a4-1a66-410d-bb18-7032f9fa016b /service_id/04e6a8b3-cb60-4a51-ae33-d67190a1da90 
postgres_exporter           Running    push  /agent_id/e6f7e9f2-2657-48ac-9fb0-ef7e4bd5a547 /service_id/278f216a-c3d5-43fd-9163-e7a30dd459e1 
mysql_perfschema_agent      Waiting      /agent_id/100d98c1-3b3d-4dee-8bc1-843495ed529a /service_id/5318af15-e338-4628-a7ba-19e2f510239d 
mysql_perfschema_agent      Running      /agent_id/9827db00-7a69-4d05-9295-85c06fb2ebc3 /service_id/3d97792c-928c-4475-b5f3-f619d3b976e1 
mysql_perfschema_agent      Running      /agent_id/e3e3890c-cbbd-4e05-8e23-ba4e624f78a5 /service_id/4247b3f3-0b7c-48c6-aa72-3545a07d71c9 
mysql_perfschema_agent      Running      /agent_id/fa3201ca-b5d8-46aa-9e04-f1b5102e6336 /service_id/e527f5f2-e6f4-4eb9-9c73-86469fbf08e8 
mongodb_profiler_agent      Running      /agent_id/4887dbdf-e603-45d7-af74-a9067cbe56c8 /service_id/11d684d1-f851-48f7-aec2-809814d073d2 
mongodb_profiler_agent      Running      /agent_id/4e51521d-ea16-4dd5-a3e2-940c717a3e53 /service_id/c2ee5791-9d23-41ee-af7d-d21b50c2dd77 
mongodb_profiler_agent      Running      /agent_id/5cd5dee9-e158-43a0-9511-ad4c7b2d9e47 /service_id/7f8a5062-0e78-4078-80e1-f8a70f2d2b0a 
mongodb_profiler_agent      Running      /agent_id/807b4342-735c-4816-b491-e3cbbf4170bd /service_id/178fb790-6e89-478e-b3c3-d50cdb158bcf 
mongodb_profiler_agent      Running      /agent_id/c2737dd5-7ec4-47fe-aa66-68209d4f3225 /service_id/924ec922-3d7d-4b53-9bfc-aa9345109dda 
mongodb_profiler_agent      Running      /agent_id/c8511980-db30-476a-8776-7aa14a32eebf /service_id/04e6a8b3-cb60-4a51-ae33-d67190a1da90 
mongodb_profiler_agent      Running      /agent_id/fc4a0fa5-9fb4-4ba3-99d9-3d9c30d443e3 /service_id/333c1bfa-6c51-4b57-9002-9bc9cca41880 
postgresql_pgstatements_agent Running      /agent_id/e00bddb3-ef8e-4f74-9c9b-98e6b274769d /service_id/278f216a-c3d5-43fd-9163-e7a30dd459e1 
vmagent                     Running    push  /agent_id/4b564af7-7775-4337-86cf-950daeabb354

PMM Monitoring interface :

There's a lot of monitoring , You can click to see :

6、 ... and 、 monitor ProxySQL middleware

[root@lhr-pmm-server opt]# pmm-admin add proxysql --username=root --password=lhr  --host=192.168.66.35 --port=16032 --service-name=proxysql-192.168.66.35-16032
ProxySQL Service added.
Service ID  : /service_id/84d87f04-e701-4480-abc9-bde170bfd478
Service name: proxysql-192.168.66.35-16032
[root@lhr-pmm-server opt]# pmm-admin list
Service type                Service name                        Address and port       Service ID
MySQL                       mysql-192.168.66.35-3317            192.168.66.35:3317     /service_id/3d97792c-928c-4475-b5f3-f619d3b976e1
MySQL                       mysql-192.168.66.35-3316            192.168.66.35:3316     /service_id/4247b3f3-0b7c-48c6-aa72-3545a07d71c9
MySQL                       mysql-192.168.66.35-3315            192.168.66.35:3315     /service_id/5318af15-e338-4628-a7ba-19e2f510239d
MySQL                       mysql-192.168.66.35-3318            192.168.66.35:3318     /service_id/e527f5f2-e6f4-4eb9-9c73-86469fbf08e8
MongoDB                     mongodb-192.168.66.35-37024-lhr_rep 192.168.66.35:37024    /service_id/04e6a8b3-cb60-4a51-ae33-d67190a1da90
MongoDB                     mongodb-192.168.66.35-27017         192.168.66.35:27017    /service_id/11d684d1-f851-48f7-aec2-809814d073d2
MongoDB                     mongodb-192.168.66.35-37021-lhr_rep 192.168.66.35:37021    /service_id/178fb790-6e89-478e-b3c3-d50cdb158bcf
MongoDB                     mongodb-192.168.66.35-37020-lhr_rep 192.168.66.35:37020    /service_id/333c1bfa-6c51-4b57-9002-9bc9cca41880
MongoDB                     mongodb-192.168.66.35-37022-lhr_rep 192.168.66.35:37022    /service_id/7f8a5062-0e78-4078-80e1-f8a70f2d2b0a
MongoDB                     mongodb-192.168.66.35-37017         192.168.66.35:37017    /service_id/924ec922-3d7d-4b53-9bfc-aa9345109dda
MongoDB                     mongodb-192.168.66.35-37023-lhr_rep 192.168.66.35:37023    /service_id/c2ee5791-9d23-41ee-af7d-d21b50c2dd77
PostgreSQL                  PG-127.0.0.1-5432                   127.0.0.1:5432         /service_id/278f216a-c3d5-43fd-9163-e7a30dd459e1
ProxySQL                    proxysql-192.168.66.35-16032        192.168.66.35:16032    /service_id/f43ada33-f77d-4cbf-9c98-331b7ba2310e
Agent type                  Status     Metrics Mode   Agent ID                                      Service ID
pmm_agent                   Connected    /agent_id/f304147a-43a6-484b-9d32-d8f3c721cb63  
node_exporter               Running    push  /agent_id/89311eaa-bf62-4730-8f3b-ebddb9ddfe57  
mysqld_exporter             Running    push  /agent_id/13bca963-69be-4313-b6b4-ed4234c0abb5 /service_id/3d97792c-928c-4475-b5f3-f619d3b976e1 
mysqld_exporter             Running    push  /agent_id/29177549-d624-43dd-ae28-f29e913587d0 /service_id/e527f5f2-e6f4-4eb9-9c73-86469fbf08e8 
mysqld_exporter             Running    push  /agent_id/ee281335-8d7b-47fd-91a9-873062beff2d /service_id/4247b3f3-0b7c-48c6-aa72-3545a07d71c9 
mysqld_exporter             Running    push  /agent_id/fc3fad17-4dd1-4ae7-aa4e-22cce69dfe02 /service_id/5318af15-e338-4628-a7ba-19e2f510239d 
mongodb_exporter            Running    push  /agent_id/690ab339-5838-43c5-978e-73bb188d434a /service_id/7f8a5062-0e78-4078-80e1-f8a70f2d2b0a 
mongodb_exporter            Running    push  /agent_id/69905494-247a-41d1-b45f-a8e31639baf9 /service_id/333c1bfa-6c51-4b57-9002-9bc9cca41880 
mongodb_exporter            Running    push  /agent_id/7d97045e-afae-4e05-8216-5fbf5f28a74b /service_id/924ec922-3d7d-4b53-9bfc-aa9345109dda 
mongodb_exporter            Running    push  /agent_id/860ed641-3599-4fdc-9f57-8137d45f06b8 /service_id/11d684d1-f851-48f7-aec2-809814d073d2 
mongodb_exporter            Running    push  /agent_id/87be410e-dd68-4ce2-80fa-05d7827b5300 /service_id/178fb790-6e89-478e-b3c3-d50cdb158bcf 
mongodb_exporter            Running    push  /agent_id/c5f4b04a-3520-4355-aca5-7e41646883c5 /service_id/c2ee5791-9d23-41ee-af7d-d21b50c2dd77 
mongodb_exporter            Running    push  /agent_id/c78247a4-1a66-410d-bb18-7032f9fa016b /service_id/04e6a8b3-cb60-4a51-ae33-d67190a1da90 
postgres_exporter           Running    push  /agent_id/e6f7e9f2-2657-48ac-9fb0-ef7e4bd5a547 /service_id/278f216a-c3d5-43fd-9163-e7a30dd459e1 
proxysql_exporter           Running    push  /agent_id/86664e69-156a-487d-aaa0-9ab585befb99 /service_id/f43ada33-f77d-4cbf-9c98-331b7ba2310e 
mysql_perfschema_agent      Waiting      /agent_id/100d98c1-3b3d-4dee-8bc1-843495ed529a /service_id/5318af15-e338-4628-a7ba-19e2f510239d 
mysql_perfschema_agent      Running      /agent_id/9827db00-7a69-4d05-9295-85c06fb2ebc3 /service_id/3d97792c-928c-4475-b5f3-f619d3b976e1 
mysql_perfschema_agent      Running      /agent_id/e3e3890c-cbbd-4e05-8e23-ba4e624f78a5 /service_id/4247b3f3-0b7c-48c6-aa72-3545a07d71c9 
mysql_perfschema_agent      Running      /agent_id/fa3201ca-b5d8-46aa-9e04-f1b5102e6336 /service_id/e527f5f2-e6f4-4eb9-9c73-86469fbf08e8 
mongodb_profiler_agent      Running      /agent_id/4887dbdf-e603-45d7-af74-a9067cbe56c8 /service_id/11d684d1-f851-48f7-aec2-809814d073d2 
mongodb_profiler_agent      Running      /agent_id/4e51521d-ea16-4dd5-a3e2-940c717a3e53 /service_id/c2ee5791-9d23-41ee-af7d-d21b50c2dd77 
mongodb_profiler_agent      Running      /agent_id/5cd5dee9-e158-43a0-9511-ad4c7b2d9e47 /service_id/7f8a5062-0e78-4078-80e1-f8a70f2d2b0a 
mongodb_profiler_agent      Running      /agent_id/807b4342-735c-4816-b491-e3cbbf4170bd /service_id/178fb790-6e89-478e-b3c3-d50cdb158bcf 
mongodb_profiler_agent      Running      /agent_id/c2737dd5-7ec4-47fe-aa66-68209d4f3225 /service_id/924ec922-3d7d-4b53-9bfc-aa9345109dda 
mongodb_profiler_agent      Running      /agent_id/c8511980-db30-476a-8776-7aa14a32eebf /service_id/04e6a8b3-cb60-4a51-ae33-d67190a1da90 
mongodb_profiler_agent      Running      /agent_id/fc4a0fa5-9fb4-4ba3-99d9-3d9c30d443e3 /service_id/333c1bfa-6c51-4b57-9002-9bc9cca41880 
postgresql_pgstatements_agent Running      /agent_id/e00bddb3-ef8e-4f74-9c9b-98e6b274769d /service_id/278f216a-c3d5-43fd-9163-e7a30dd459e1 
vmagent                     Running    push  /agent_id/4b564af7-7775-4337-86cf-950daeabb354

PMM There is no default ProxySQL Monitoring template for , We need to download it ourselves :https://github.com/percona/grafana-dashboards/blob/master/dashboards/ProxySQL_Overview.json

Download and upload to PMM In the monitoring interface of .

The interface after monitoring :

About Me