Tag - MySQL

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

Join Us For Percona Tech Days!

In the lead up to Percona Live Online, we are excited to introduce Percona Tech Days!
Percona Tech Days are free, half-day events dedicated to the most popular open source database technologies: MySQL, MongoDB, and PostgreSQL.
Each day, we’ll be focusing on one database technology, with expert presentations and conversations around technical topics, from the latest […]

Read more

How Can ScaleFlux Handle MySQL Workload?

ScaleFlux Handle MySQL

Recently I had the opportunity to test a storage device from ScaleFlux called CSD 2000. In this blog post, I will share the results of using it to run MySQL in comparison with an Intel device that had a similar capacity.
First of all, why do we need another storage device? Why is ScaleFlux any […]

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

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