How to align(42002) the port MySQL service port in PMM?

pmm-admin add mysql --username=pmm --password=‘root’ --query-source=perfschema mysql_performschma 127.0.0.1:3306

http://192.168.0.1:42001/metrics

how to fix port for the service 42002 always.

its got change 42002 to 42001,42003,42004 not able to monitor MySQL service.

for that I need to open more port. so any suggestion can I fix a particular port for all my nodes for MySQL service.

Thanks.

Hi @lokesh123

There is no official way to bind an exporter to a specific port.

You may use a workaround by limiting range of ports for pmm-agent. But it would work if only one service is monitored on a node.

Also it could a short delay for restarting pmm-agent

e.g.

1 Like

@adivinho Thanks.

It works.
I set a limit for pmm-agent 40000 to 40002 as just want to MySQL instance and OS.

1 Like