March 19, 2024

Daniel Guzmán Burgos

Percona Monitoring and Management (PMM) overview dashboards were always meant to be a starting point for DBAs to check the overall health of the databases. Current overview dashboards can be a little overwhelming, based on an approach of “full visibility.” 

Now, we present a redesigned dashboard focused on simplicity:

Where is the simplicity coming from? At first, the idea of a single dashboard for all three database technologies that PMM can monitor was achieved. Now, from the same place, one can easily navigate between MySQL, PostgreSQL, and MongoDB overviews, contrary to the current way of an overview dashboard per tech.

Secondly, the ultimate reason for being in a database is to execute queries as quickly as possible. With that in mind, the information being decided to show is Execution times and Executed queries per unit of time. One can easily spot anomalies by looking at the graphs for these metrics.

However, we wanted to go beyond and make it easy to figure out a basic metric: How many queries are taking more than X time in the last Y time range? 

For that purpose, a preset group of thresholds is available to check queries taking more than 1mS, 10mS, 100mS, 1 Second, or 10 seconds. 

Thirdly, the queries are available in the same dashboard for quick reference. The queries shown are executed during the time range set for the dashboard and ordered by Execution Time (descending) instead of timestamp, so one can easily spot slow queries.

The table can be filtered by different dimensions, such as Service Name.

Finally, a panel showing the UPTIME value of the databases, ordered by smallest to largest, so that one can spot DB instances that had been subject to a restart (either by a manual operation or a crash)

This new Overview Dashboard will be available initially as an experimental piece of PMM in the release version 2.41.2 and is also available on the PMM Demo: https://pmmdemo.percona.com/graph/d/ywQr8WtSk/databases-overview?orgId=1&refresh=30s

This is because we want to hear from everyone before making it to GA, so make sure to add comments and suggestions right here in the comment section or in the Percona Forum!

Percona Monitoring and Management is a best-of-breed open source database monitoring solution tool for use with MySQL, PostgreSQL, MongoDB, and the servers on which they run. Monitor, manage, and improve the performance of your databases no matter where they are located or deployed.

Download Percona Monitoring and Management Today

Subscribe

Connect with

Login

Label

0 Comments