FAQ¶
How can I contact the developers?¶
What are the minimum system requirements?¶
- Server:
- Disk: 1 GB per monitored database (1 week data retention)
- Memory: 2 GB per monitored database
- CPU: Supports
SSE4.2
- Client:
- Disk: 100 MB
How can I upgrade from version 1?¶
There is no direct software upgrade path.
You must set up PMM 2 and connect your existing clients to it.
When all data is registered in PMM2 and expired in PMM1, decommission your PMM1 instance.
How to control data retention?¶
Go to Configuration → Settings → Advanced Settings → Data retention to adjust the value in days.
See also
How are PMM Server logs rotated?¶
PMM Server embeds multiple components, like Victoria Metrics, Query Analytics, Grafana, managed, PostgreSQL, ClickHouse, etc. (components). All PMM Server component logs are rotated by supervisord. The components’ log rotation settings are stored in *.ini files within the /etc/supervisord.d directory. Those settings define both the maximum size of a log file and the number of log files to keep. The log rotation takes place once the log file reaches its maximum size.
What privileges are required to monitor a MySQL instance?¶
SELECT, PROCESS, SUPER, REPLICATION CLIENT, RELOAD
See also
Can I monitor multiple service instances?¶
Yes.
You can add multiple instances of MySQL or any other service to be monitored from the same PMM Client.
To do this, you provide a unique port and IP address, or a socket for each instance, and specify a unique name for each. (If a name is not provided, PMM uses the name of the PMM Client host.)
For example, to add MySQL monitoring for two local MySQL servers:
pmm-admin add mysql --username root --password root instance-01 127.0.0.1:3001
pmm-admin add mysql --username root --password root instance-02 127.0.0.1:3002
See also
Can I rename instances?¶
Yes, by removing and re-adding with a different name.
When you remove a monitoring service, previously collected data remains available in Grafana. However, the metrics are tied to the instance name. So if you add the same instance back with a different name, it will be considered a new instance with a new set of metrics. So if you are re-adding an instance and want to keep its previous data, add it with the same name.
Can I add an AWS RDS MySQL or Aurora MySQL instance from a non-default AWS partition?¶
By default, the RDS discovery works with the default aws partition. But you can switch to special regions, like the GovCloud one, with the alternative AWS partitions (e.g. aws-us-gov) adding them to the Settings via the PMM Server API.
To specify other than the default value, or to use several, use the JSON Array syntax: ["aws", "aws-cn"].
What resolution is used for metrics?¶
The default values (in seconds):
| Preset | Low | Medium | High |
|---|---|---|---|
| Rare | 300 | 180 | 60 |
| Standard | 60 | 10 | 5 |
| Frequent | 30 | 5 | 1 |
| Custom (defaults) | 60 | 10 | 5 |
See also
How do I set up Alerting?¶
When a monitored service metric reaches a defined threshold, PMM Server can trigger alerts for it using embedded Grafana Alerting functionality.
For this, you must configure alerting rules that define conditions under which an alert should be triggered, and the contact points used to send the alert (e.g. email).
Percona templated alerts enable you to create alerts based on built-in or custom templates to simplify the alert setup process. Grafana managed alerts allows attaching rules to your dashboard panel and enables you to create more sophisticated alerting rules. In addition, it can be easier to manage installations with a large number of hosts. This additional flexibility comes at the expense of simplicity.
See also
How do I use a custom Prometheus configuration file?¶
Normally, PMM Server fully manages the Prometheus configuration file.
However, some users may want to change the generated configuration to add additional scrape jobs, configure remote storage, etc.
From version 2.4.0, when pmm-managed starts the Prometheus file generation process, it tries to load the /srv/prometheus/prometheus.base.yml file first, to use it as a base for the prometheus.yml file.
The prometheus.yml file can be regenerated by restarting the PMM Server container, or by using the SetSettings API call with an empty body.
How to troubleshoot an Update?¶
See Troubleshoot update.
What are my login credentials when I try to connect to a Prometheus Exporter?¶
- User name:
pmm - Password: Agent ID
PMM protects an exporter’s output from unauthorized access by adding an authorization layer. To access an exporter, you can use pmm as a user name and the Agent ID as a password. You can find the Agent ID corresponding to a given exporter by running pmm-admin list.
See also
How to provision PMM Server with non-default admin password?¶
Currently, there is no API available to change the admin password. If you’re deploying through Docker, you can use the following code snippet to change the password after starting the Docker container:
PMM_PASSWORD="mypassword"
echo "Waiting for PMM to initialize to set password..."
until [ "`docker inspect -f {{.State.Health.Status}} pmm-server`" = "healthy" ]; do sleep 1; done
docker exec -t pmm-server bash -c "grafana-cli --homepath /usr/share/grafana admin reset-admin-password $PMM_PASSWORD"
(This example assumes your Docker container is named pmm-server.)
How to change the PMM password for a default admin user?¶
If you’re deploying through Docker, you can change the default password for an admin user after starting the Docker container as follows:
- For PMM versions 2.27.0 and later:
docker exec -t pmm-server change-admin-password <new_password>
- For PMM versions prior to 2.27.0:
docker exec -t pmm-server bash -c 'grafana-cli --homepath /usr/share/grafana --configOverrides cfg:default.paths.data=/srv/grafana admin reset-admin-password newpass'
How to use a non-default listen-port for pmm-admin?¶
If you configure the PMM agent to use a non-default listen-port, for pmm-admin to communicate with the agent, use the global flag --pmm-agent-listen-port=LISTEN_PORT.
--pmm-agent-listen-port=LISTEN_PORT
Example: To use the listen-port 8000
pmm-admin --pmm-agent-listen-port=8000 add postgresql --username=pmm-agent --password=pmm-agent-password --query-source=pgstatmonitor nameofpostgres
change-admin-password <new_password>
