Insight for DBAs

Finding a Regression in MySQL Source Code: A Case Study

finding regression in mysql source

At the Percona engineering team, we often receive requests to analyze changes in MySQL/Percona Server for MySQL behavior from one version to another, either due to regression or a bug fix (when having to point out to a customer that commit X has fixed their issue and upgrading to a version including that fix […]

Read more

Why the Heck Are So Many Databases Being Breached, Leaked, and Hacked?

database security

How many times have we seen this headline lately: “X million records leaked in data breach”? The answer is, too many! 
In fact, because “millions of records” are starting to leak so frequently, larger news outlets are not covering the “smaller” leaks as often as they were a few years ago. These days it’s all […]

Read more

Compiling a Percona Monitoring and Management v2 Client in ARM Architecture

Percona Monitoring and Management ARM

In this blog, we are going to see how to compile a Percona Monitoring and Management 2 (PMM v2) client in ARM. For this, we are going to use an AWS EC2 ARM instance with Amazon Linux 2.
Installing Dependencies
First, let’s get some basic packages out of the way, which probably are installed in your […]

Read more

Using SKIP LOCK For Queue Processing in MySQL

SKIP LOCK in MySQL

A small thing that provides a huge help.
The other day I was writing some code to process a very large amount of items coming from a social media API. My items were ending in a queue in MySQL and then needed to be processed and eventually moved.
The task was not so strange,  but what […]

Read more

Percona Monthly Bug Report: July 2020

Percona Monthly Bug Report

At Percona, we operate on the premise that full-transparency makes a product better. We strive to build not only the best open-source database products but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs […]

Read more