Author - Alex Poritskiy

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

Slave Performance Too Slow

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:

Slave thread example
MySQL

mysql> SHOW SLAVE STATUSG
*************************** 1. row ***************************
[…]

Read more

MySQL 8.0 RESOURCE_GROUP Overview

MySQL 8.0 innodb_dedicated_server

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

Read more

Thread_Statistics and High Memory Usage

thread_statistics

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

Read more