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

The Road Story of a MyRocks/MariaDB Migration

myrocks migration

This post has been written in collaboration with Nicolas Modalvsky of e-planning. Nicolas and I recently worked together on a tuning engagement involving MyRocks on MariaDB. While it is easy to find online articles and posts about InnoDB performance, finding information about MyRocks tuning is more difficult. Both storage engines are well documented but […]

Read more

Percona Distribution for MySQL, New Features in Percona Kubernetes Operator for Percona XtraDB Cluster: Release Roundup August 3, 2020

Percona Software

It’s release roundup time here at Percona!
Our Release Roundups showcase the latest software updates, tools, and features to help you manage and deploy our software, with highlights and critical information, as well as links to the full release notes and direct links to the software or service itself.
Today’s post includes those releases and updates […]

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

How MySQL 8.0.21 and MariaDB 10.5.4 Perform in IO-Bound Scenarios on SATA SSD and NVMe Storage

MySQL 8.0.21 and MariaDB 10.5.4 Perform in IO-Bound Scenarios

Continuing with the same topic and evaluating new versions of MariaDB and MySQL on Enterprise SSD Storage and How MySQL and MariaDB Perform on NVMe Storage, this time let’s take a look at how MySQL 8.0.21 and MariaDB 10.5.4 perform in IO-bound scenarios on both SATA SSD and NVMe storage.
To emulate the IO-bound scenario, […]

Read more