EmergencyEMERGENCY? Get 24/7 Help Now!

Troubleshooting Percona Monitoring and Management (PMM) Metrics

 | January 17, 2018 |  Posted In: Database Monitoring, Insight for DBAs, Percona Monitoring and Management

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

Read More

Webinar Wednesday, January 10, 2018: Why We’re Excited About MySQL 8.0

and  | January 9, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, MySQL 8.0, Technical Webinars

MySQL 8.0 RESOURCE_GROUP

Join Percona’s, CEO and Co-Founder, Peter Zaitsev as he presents Why We’re Excited About MySQL 8.0 on Wednesday, January 10, 2018, at 11:00 am PST / 2:00 pm EST (UTC-8). Experience: Basic Tags: Developer, DBAs, Operations, Executive, MySQL There are many great new features in MySQL 8.0, but how exactly can they help your applications? […]

Read More

Webinar Wednesday, December 20, 2017: InnoDB Performance Optimization

and  | December 18, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, Technical Webinars

InnoDB Performance Optimization

Join Percona’s, CEO and Co-Founder, Peter Zaitsev as he presents InnoDB Performance Optimization on Wednesday, December 20, 2017, at 11:00 am PST / 2:00 pm EST (UTC-8). InnoDB is one of the most commonly used storage engines for MySQL and Percona Server for MySQL. It balances high reliability with high performance and is the focus of the majority […]

Read More

Webinars on Wednesday November 15, 2017: Proxy Wars and Percona Software Update for Q4

, and  | November 14, 2017 |  Posted In: Events and Announcements, Insight for Developers, MariaDB, MongoDB, MySQL, Percona Monitoring and Management, ProxySQL, Technical Webinars

Webinars double bill

Do you need to get to grips with MySQL proxies? Or maybe you could do with discovering the latest developments and plans for Percona’s software? Well, wait no more because … on Wednesday November 15, 2017, we bring you a webinar double bill. Join Percona’s Chief Evangelist, Colin Charles as he presents “The Proxy Wars […]

Read More

MySQL and Linux Context Switches

 | November 9, 2017 |  Posted In: MySQL

Context Switches

In this blog post, I’ll look at MySQL and Linux context switches and what is the normal number per second for a database environment. You might have heard many times about the importance of looking at the number of context switches to indicate if MySQL is suffering from the internal contention issues. I often get […]

Read More

MySQL Dashboard Improvements in Percona Monitoring and Management 1.4.0

 | October 31, 2017 |  Posted In: Database Monitoring, InnoDB, MySQL, Percona Monitoring and Management

In this blog post, I’ll walk through some of the improvements to the Percona Monitoring and Management (PMM) MySQL dashboard in release 1.4.0. As the part of Percona Monitoring and Management development, we’re constantly looking for better ways to visualize information and help you to spot and resolve problems faster. We’ve made some updates to the […]

Read More

How to Choose the MySQL innodb_log_file_size

 | October 18, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL

innodb_log_file_size

In this blog post, I’ll provide some guidance on how to choose the MySQL innodb_log_file_size. Like many database management systems, MySQL uses logs to achieve data durability (when using the default InnoDB storage engine). This ensures that when a transaction is committed, data is not lost in the event of crash or power loss. MySQL’s […]

Read More

sysbench Histograms: A Helpful Feature Often Overlooked

 | September 20, 2017 |  Posted In: Database Monitoring, Insight for DBAs, MySQL

Sysbench Histograms

In this blog post, I will demonstrate how to run and use sysbench histograms. One of the features of sysbench that I often I see overlooked (and rarely used) is its ability to produce detailed query response time histograms in addition to computing percentile numbers. Looking at histograms together with throughput or latency over time […]

Read More