Tag - insight for DBAs

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

Migrating to PostgreSQL Version 13: Incompatibilities You Should Be Aware Of

Migrating to PostgreSQL Version 13

The PostgreSQL 13 Beta is out in the testing phase with a rich feature set. It is a very good learning effort to participate in the testing of one of the finest databases in the world. It does not matter how much development, coding, and administration experience you have for the testing of the […]

Read more

Evaluating Checkpointing in PostgreSQL

Checkpointing in PostgreSQL

Continuing with the checkpointing topic I started a month ago with my blog post MongoDB Checkpointing Woes, this time I want to review how PostgreSQL performs in this area. After this, I will be taking a look at MySQL and MariaDB. If anything, it will be fair not only to complain about MongoDB but […]

Read more