Database Monitoring

Percona Consulting can help you determine the right database monitoring solution for your system and help with its deployment, while ensuring optimal performance. Percona Support includes monitoring and management tools which put Percona’s deep operational expertise in your hands to provide visibility into problems before they happen. And if you lack the resources to manage your deployment, Managed Services team can take over the full operation, administration, and monitoring of your database.

Verifying Query Performance Using ProxySQL

Query Performance Using ProxySQL

In this blog post, we’ll look at how you can verify query performance using ProxySQL.
In the previous blog post, I showed you how many information can you get from the “stats.stats_mysql_query_digest” table in ProxySQL. I also mentioned you could even collect and graph these metrics. I will show you this is not just theory, it […]

Read more

Adding Custom Graphs and Dashboards to Percona Monitoring and Management

PMM custom graphs

In this blog post, we’ll look at how to create PMM custom graphs and dashboards to track what you need to see in your database.
Percona Monitoring and Management (PMM)‘s default set of graphs is pretty complete: it covers most of the stuff a DBA requires to fully visualize database servers. However, sometimes custom information […]

Read more

Webinar Thursday, March 15, 2018: Basic External MySQL Troubleshooting Tools

Troubleshooting Tools

Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Basic External MySQL Troubleshooting Tools on March 15, 2018 at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4).
In my troubleshooting webinar series, I normally like to discuss built-in instruments available via the SQL interface. While they are effective and help to understand […]

Read more

This Week in Data with Colin Charles 31: Meltdown/Spectre Performance Regressions and Percona Live 2018

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Have you been following the Meltdown/Spectre performance regressions? Some of the best blog posts have been coming from Brendan Gregg, who’s keynoting at Percona Live this year. We’ve also got Scott Simpson from Upwork giving a keynote […]

Read more

Binlog Encryption with Percona Server for MySQL

binlog encryption

In this blog post, we’ll look at how to turn on binlog encryption in Percona Server for MySQL.
Why do I need this?
As you probably know, Percona Server for MySQL’s binlog contains sensitive information. Replication uses the binlog to copy events between servers. They contain all the information from one server so that it can be […]

Read more

Webinar Thursday March 8, 2018: How Percona Maintains Optimal Customer Health

Percona Maintains Optimal Customer Health

Please join Percona Technical Account Manager Tim Sharp, as he presents How Percona Maintains Optimal Customer Health on Thursday, March 8, 2018 at 11:00 am PST (UTC -8) / 2:00 pm EST (UTC -5).
Register Now
How do you guarantee optimal database performance for your critical applications and services? Proactive monitoring and intervention is one way.
Percona […]

Read more

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

Percona Monitoring and Management for MongoDB

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

Read more

Visualize This! MySQL Tools That Explain Queries

MySQL Tools

In this blog post, I want to go over some of the day-to-day MySQL tools and methods DBAs use to analyze queries and visualize “what is going on?” I won’t be going into the nitty-gritty details of each of these tools, I just want to introduce you to them and show you what they […]

Read more

Great Metrics Graphs: Percona Monitoring and Management vs. gnuplot

Percona Monitoring and Management vs. gnuplot

In this blog post, we’ll checkout Percona Monitoring and Management vs. gnuplot when it comes to creating great metrics graphs. gnuplot is great, but PMM might provide graphs that are easier to read.
Percona Monitoring and Management (PMM) is our free and open-source platform for managing and monitoring MySQL®, MariaDB® and MongoDB® performance, and is […]

Read more