Perhaps the best FREE thing I've found for several years
Use Cases and Deployment Scope
We use PMM in both our development and IT teams to monitor our database. The tool allows us to trace performance and discover optimisation opportunities, which provides significant cost savings over upgrading the platform as we grow our business. Before we integrated PMM we were reliant on standard tools to manually investigate production state, variables and other metrics.
Pros
- Visibility of performance between cluster nodes.
- Presents less obvious metrics.
- Very customisable.
Cons
- Documentation sufficient but not outstanding.
- Almost 'too much' data presented.
- Perhaps could have alert defaults.
Likelihood to Recommend
Databases work great when fresh and clean but over the years you seem to encounter more and more performance issues. Over-enthusiastic developers brimming with confidence can quickly overload tables with indexes or make changes without thinking about scenarios outside their ticket. Business growth can lead to server strain if you aren't monitoring your infra vigilantly. Queries that once worked well can suffer over time and you need a good tool to dig in to the data. PMM is excellent for these kinds of use-cases.
I initially found the vast quantity of data presented to be overwhelming, but that is where I needed to raise my knowledge to understand the DB internals better. If you feel you don't know enough about your database performance the dashboards will keep you busy for a while. The Query Analytics tool may also be insightful. My only gripe is I wish there was more documentation on explaining some of the data for less experienced MySQL users.