Insight for DBAs

binlog2sql: Binlog to Raw SQL Conversion and Point In Time Recovery

binlog2sql

In this blog, I will look at the tool binlog2sql, designed by Cao Danfeng. The tool will help to decode the MySQL binary logs and extract the raw SQL, which also helps to generate the ROLLBACK statements for point in time recovery (PITR) using the “flashback” feature. This feature is also implemented in MariaDB’s […]

Read more

MySQL Deadlocks Are Our Friends

MySQL Deadlocks

Why another article on this, Marco?
MySQL deadlocks is a topic covered many times, including here at Percona. I suggest you review the reference section at the end of this post for articles on how to identify deadlocks and from where they are generated.
So why another article?
The answer is that messages we receive like the […]

Read more

Enable Email Sending in Percona Monitoring and Management 2

email sending percona monitoring and management

Many years ago I was banned from touching anything of critical importance as far as production infrastructure goes…something about “the leadership curse”, so the multiple layers of monitoring and notifications I once wrestled with were now overkill for my needs. What that means is that even though Percona Monitoring and Management (PMM) now integrates […]

Read more

MySQL 101: Linux Tuning for MySQL

Linux Tuning for MySQL

When trying to do some Linux tuning for MySQL, there are a few options that will greatly influence the speed of MySQL.  Below are some of the most important of these settings to help you get started.
Swappiness
The first thing to look at is what swappiness is set to.  This will determine the tendency of […]

Read more

Adding eBPF-Based Metrics to Percona Monitoring and Management

ebpf percona monitoring and management

I wanted to start this post with the words “eBPF is the hot new thing”, but I think it’s already too late to write that. Running eBPF programs in production is becoming less of a peculiarity and more of a normal way to operate. Famously, Facebook runs about 40 BPF programs on each server. […]

Read more