Tag - PMM

Beware of Unstable Query Digests in MySQL

Unstable Query Digests in MySQL

If you’re using MySQL’s Performance Schema you may use “query digests” as IDs to identify specific query patterns in the events_statements_summary_by_digest Performance Schema Table.
You might assume these hashes are stable between different versions, so, for example, when upgrading from MySQL 5.7 to MySQL 8, you can compare the query response time and other execution […]

Read more

Changing the Default Admin Password in Docker-Based Deployment of PMM2

default password pmm2

If you’re automating Percona Monitoring and Management 2 (PMM) deployment with docker, you may want to set a different admin user password upon installation instead of being required to change it upon first login. Here is how you can do it:
After following the PMM2 Docker Installation Instructions, you can run this command:

Shell

docker exec -t […]

Read more

Enable LDAP on Percona Monitoring and Management (PMM)

Percona Monitoring and Management (PMM) has been on the road for a while now, and it brings exciting new features and improvements. For those who are not familiar with the tool, PMM allows deep insight into the performance of applications and databases. The most crucial highlight: it is 100% open-source. Also, the source code is […]

Read more

Grafana Plugins and Percona Monitoring and Management

grafana percona monitoring and management

Percona Monitoring and Management (PMM) is built upon the shoulder of giants like Prometheus and Grafana. And speaking of Grafana, one of the coolest features that come with it is the ability to customize the experience through 3rd party plugins.
Plugins are an easy way to enhance the ability to have specialized graphs. One case […]

Read more

Running PMM1 and PMM2 Clients on the Same Host

Running PMM1 and PMM2 Clients

Want to try out Percona Monitoring and Management 2 (PMM 2) but you’re not ready to turn off your PMM 1 environment?  This blog is for you! Keep in mind that the methods described are not intended to be a long-term migration strategy, but rather, simply a way to deploy a few clients in […]

Read more