3 Features I Love in Percona Monitoring and Management 2.10

Percona Monitoring and Management 2.10 shipped a few days ago and while it is a minor release, it introduces some features which I absolutely love. In this blog post, I will talk about those features – what they are and why they are worth loving. 🙂

1. Query Search

This is a great feature if you have many queries and you want to find a particular query or set of queries quickly.  Want to find which DELETE queries cause the most load on the database?  Or maybe queries which access a particular table or column? You got it!

2. Crosshair in Query Analytics

While Grafana has had the Crosshair feature for ages, it was not available in Query Analytics until now.  When looking at multiple time series, this is a super helpful feature to visually align multiple data points corresponding to the same point in time.

Crosshair does not only work in the query view, but also in the metrics view, where it is especially helpful. Some of the metrics can be very volatile, so having the Crosshair view to see how events align is super helpful.

3. System Information

Percona Monitoring and Management captures thousands of metrics about system configuration and operation parameters.  In some cases, though, it is more helpful to see the system configuration information on the same page, for example as pt-summary from Percona Toolkit. This is exactly what this new feature does – integrating pt-summary output into the Node Summary dashboard in Percona Monitoring and Management.

Which one of those features do you like best? 

Whatever feature it is, you can check it out in action on our Percona Monitoring and Management Demo site or learn more information about Percona Monitoring and Management including how to easily install or upgrade it.

by Peter Zaitsev via Percona Database Performance Blog