metrics

Monitoring S.M.A.R.T. Metrics with Prometheus and PMM

visualized using Grafana

In his excellent blog post, Pavel Trukhanov showed the value of S.M.A.R.T. metric collections, so I wondered how hard would it be to enable their collection in Percona Monitoring and Management (PMM) A quick search led me to the  text_collector plugin SmartMon, which can be easily integrated with any Prometheus Installation For PMM, Vadim Yalovets recently […]

The post Monitoring S.M.A.R.T. Metrics with Prometheus and PMM appeared first on Percona Database Performance Blog.

Percona Monitoring and Management for MongoDB: Basic Graphs for a Good System Overview

Percona Monitoring and Management for MongoDBIn this blog post, we will discuss how to use Percona Monitoring and Management for MongoDB monitoring, and how to get some key graphs to monitor your MongoDB database. All production environments need metrics and historical data for easy and fast comparison of performance, throughput in the time. Percona Monitoring and Management (PMM) can help […]

Percona Monitoring and Management 1.8.0 Is Now Available

Percona Monitoring and ManagementThe latest release of Percona Monitoring and Management (PMM) 1.8.0 is available as of February 27, 2018. Percona Monitoring and Management is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL and MongoDB servers to ensure that your data works as efficiently […]

Understand Your Prometheus Exporters with Percona Monitoring and Management (PMM)

Prometheus Exporters 2 smallIn this blog post, I will look at the new dashboards in Percona Monitoring and Management (PMM) for Prometheus exporters. Percona Monitoring and Management (PMM) uses Prometheus exporters to capture metrics data from the system it monitors. Those Prometheus exporters are an important part of your monitoring infrastructure, and understanding their performance and other operational details […]

Percona Monitoring and Management 1.7.0 (PMM) Is Now Available

Experimental Percona Monitoring and ManagementPercona announces the release of Percona Monitoring and Management 1.7.0. (PMM ) is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL and MongoDB servers to ensure that your data works as efficiently […]

Webinar Wednesday, January 24, 2018: Differences between MariaDB and MySQL

MariaDB and MySQLJoin Percona’s Chief Evangelist, Colin Charles as he presents Differences Between MariaDB and MySQL on Wednesday, January 24, 2018, at 7:00 am PDT / 10:00 am EDT (UTC-7). Register Now Tags: MariaDB, MySQL, Percona Server for MySQL, DBA, SysAdmin, DevOps Experience Level: Novice MariaDB and MySQL. Are they syntactically similar? Where do these two query languages […]

Percona Monitoring and Management (PMM) 1.6.0 Is Now Available

Percona Monitoring and ManagementPercona announces the release of Percona Monitoring and Management (PMM) 1.6.0. In this release, Percona Monitoring and Management Grafana metrics are available in the Advanced Data Exploration dashboard. We’ve improved the integration with MyRocks, and its data is now collected from SHOW GLOBAL STATUS. The MongoDB Exporter now features two new metrics: mongodb_up to inform if the MongoDB Server is […]

Troubleshooting Percona Monitoring and Management (PMM) Metrics

In this blog post, I’ll look at some helpful tips on troubleshooting Percona Monitoring and Management metrics. With any luck, Percona Monitoring and Management (PMM) works for you out of the box. Sometimes, however, things go awry and you see empty or broken graphs instead of dashboards full of insights. Before we go through troubleshooting steps, let’s […]

Webinar January 18, 2018: MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM) Part 2

Percona Monitoring and ManagementJoin Percona’s Product Manager Michael Coburn as he presents MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM) Part 2 on Thursday, January 18, 2018, at 11:00 am PST / 2:00 pm EST (UTC-8). Register Now Tags: Percona Monitoring and Management, PMM, Monitoring, MySQL, Performance, Optimization, DBA, SysAdmin, DevOps Experience Level: Expert Optimizing […]

Compare Current and Past Time Series Graphs in Percona Monitoring and Management (PMM)

In this short blog post, I will show you how you can compare current and past time series in Percona Monitoring and Management (PMM).
Recently, a support customer shared a graph with us that compared query throughput between today and yesterday as a confirmation that optimizing their server variables improved performance.
Do you want to compare workload between today and yesterday? This week and last week? Or this month and last month? You can do this by simply duplicating an existing data source of a graph, but add a time offset so it will render past data. You can specify past offsets in (s)econds, (m)inutes, (h)ours, (d)ays, (w)eeks and even (y)ears.
Say you want to graph query throughput from a certain time period and one day before that. To do this, select the “MySQL Overview” dashboard, and then click the header of “MySQL Questions” panel. The panel menu should appear:

Click the Edit option to edit this graph:

On the “Metrics” tab, click the Add Query button and copy the options as listed in the first data source, but change the “Legend format” as “Questions(yesterday)”:

Now, you’ll need to add the offset modifier right after the selector. So between, “[$interval]” and “)” and also “[5m]” and “)”, add ” offset 24h” to add offsets. For more information on selectors, you can review this link:

So, as you can see in the graph above, the query throughput is around 6.13k qps compared to yesterday’s performance of 4.42k qps (on average).
To save the changes, click the floppy disk icon located at the top of PMM, and the “Save Changes” dialog will appear. Click the Save button to save the changes.
There you have it. By duplicating data source and adding offsets to it, you can easily compare a selected time series and its past.
Do note that in this example, we’ve modified the system dashboard and so all changes made to this are overwritten when the PMM server is upgraded. To keep all of your changes, you can create your own custom dashboard and just copy the panel from the system dashboard. You can have a look at this article on the proper way of importing graphs/panels from the system dashboard.
Another thing to note is that as of this writing, the “Trends Dashboard” has this feature built-in on comparing the time series against the past day and week for CPU usage, I/O Read/Write Activity, Queries, and InnoDB Rows Read/Changed. If you need to customize this even further, you have this article to see it through.

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569