Buy Percona ServicesBuy Now!

Prometheus 2 Times Series Storage Performance Analyses

 | September 20, 2018 |  Posted In: Benchmarks, MySQL, Percona Monitoring and Management, PMM, Prometheus

cpu saturation and max core usage

Prometheus 2 time series database (TSDB) is an amazing piece of engineering, offering a dramatic improvement compared to “v2” storage in Prometheus 1 in terms of ingest performance, query performance and resource use efficiency. As we’ve been adopting Prometheus 2 in Percona Monitoring and Management (PMM), I had a chance to look into the performance […]

Read More

Monitoring Processes with Percona Monitoring and Management

 | September 18, 2018 |  Posted In: MySQL, Percona Monitoring and Management, Performance Tuning, PMM

Memory utilization during compaction process

A few months ago I wrote a blog post on How to Capture Per Process Metrics in PMM. Since that time, Nick Cabatoff has made a lot of improvements to Process Exporter and I’ve improved the Grafana Dashboard to match. I will not go through installation instructions, they are well covered in original blog post.  This […]

Read More

How To Deploy PMM on Linode With StackScripts

 | September 11, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona Monitoring and Management, PMM

rebuiild from a StackScript

In my previous blog post, I showed how to deploy Percona Monitoring and Management (PMM) on Linode manually. It is pretty simple, but with a little coding it can be done even more easily using StackScripts Here’s how: 1. Click on the “Add a Linode” and pick a Linode type you want to deploy. 2. Click on […]

Read More

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

 | September 3, 2018 |  Posted In: MySQL, Percona Monitoring and Management, PMM, Prometheus

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 […]

Read More

Webinar Wed 9/5: Choosing the Right Open Source Database

 | August 31, 2018 |  Posted In: MariaDB, MongoDB, MySQL, PostgreSQL, Technical Webinars

open source database

Please join Percona’s CEO, Peter Zaitsev as he presents Choosing the Right Open Source Database on Wednesday, September 5th, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4).   Register Now   The world of open-source databases is overwhelming. There are dozens of types of databases – relational DBMS, time-series, graph, document, etc. – not to […]

Read More

Is It a Read Intensive or a Write Intensive Workload?

 | August 30, 2018 |  Posted In: Database Monitoring, Insight for DBAs, Insight for Developers, MySQL, Percona Monitoring and Management, Percona Server for MySQL, Performance Tuning, PMM

innodb row operations featured

One of the common ways to classify database workloads is whether it is  “read intensive” or “write intensive”. In other words, whether the workload is dominated by reads or writes. Why should you care? Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as […]

Read More

Webinar Tuesday, 8/28: Forking or Branching – Lessons from the MySQL Community

 | August 27, 2018 |  Posted In: Insight for DBAs, MySQL, Performance Tuning, Technical Webinars

forking or branching

Please join Percona’s CEO, Peter Zaitsev as he presents Forking or Branching – Lessons from the MySQL Community on Tuesday, August 28th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   The MySQL Community offers a great example of various forks and branches, with MariaDB being the most well-known fork, […]

Read More

Webinar Thurs 8/23: MySQL vs MongoDB – Choosing the Right Technology for Your Application

 | August 22, 2018 |  Posted In: Events and Announcements, MongoDB, MySQL, MySQL 8.0, Percona Server for MySQL, Technical Webinars

mongodb vs mysql which to choose

Please join Percona’s CEO, Peter Zaitsev as he presents MySQL vs MongoDB – Choosing the Right Technology for Your Application on Thursday, August 23, 2018, at 10:30 AM PDT (UTC-7) / 1:30 PM EDT (UTC-4). Register Now Are you considering to adopt the most popular open source relational database or the most popular open source […]

Read More

How to Change Settings for PMM Deployed via Docker

 | August 9, 2018 |  Posted In: Containers, Docker, MySQL, Percona Monitoring and Management, PMM

change settings for PMM deployed docker

When deployed through Docker Percona Monitoring and Management (PMM) uses environment variables for its configuration For example, if you want to adjust metrics resolution you can pass -e METRICS_RESOLUTION=Ns  as  an option to the docker run  command:

You would think if you want to change the setting for existing installation you can just stop the container with docker stop  and […]

Read More

Resource Usage Improvements in Percona Monitoring and Management 1.13

 | August 7, 2018 |  Posted In: Benchmarks, Insight for DBAs, MongoDB, MySQL, Percona Monitoring and Management, PMM

PMM 1-13 reduction CPU usage by 5x

In Percona Monitoring and Management (PMM) 1.13 we have adopted Prometheus 2, and with this comes a dramatic improvement in resource usage, along with performance improvements! What does it mean for you? This means you can have a significantly larger number of servers and database instances monitored by the same PMM installation. Or you can […]

Read More