Causes and Workarounds for Slave Performance Too Slow with Row-Based Events

May 03, 2018 | Insight for DBAs, MySQL

Recently I worked on one customer issue that I would describe as “slave performance too slow”. During a quick analysis, I’ve found that the replication slave SQL thread cannot keep up while processing row-based events from the master’s binary log. For example:

The processlist state for the SQL thread can be one of the following: Reading […]

MySQL 8.0 RESOURCE_GROUP Overview

Jan 25, 2018 | Insight for DBAs, MySQL, Open Source

In this blog post, we’ll provide an overview of the new MySQL 8.0 RESOURCE_GROUP feature. One great new feature introduced in MySQL 8.0 that – from my point of view – requires attention is RESOURCE_GROUP. Short disclaimer: I want to point out that MySQL 8.0 is not GA yet, so it is possible for the MySQL […]

Thread_Statistics and High Memory Usage

Jul 11, 2017 | MySQL, Open Source, Percona Software

In this blog post, we’ll look at how using thread_statistics can cause high memory usage. I was recently working on a high memory usage issue for one of our clients, and made some interesting discoveries: high memory usage with no bounds. It was really tricky to diagnose. Below, I am going to show you how to […]