Planet MariaDB Server

Checking User Threads and Temporary Tables With gdb in MariaDB 10.4+, Step By Step

There were no posts about gdb tricks for a long time in this blog. This is surely unusual, but I had not done anything fancy with gdb for more than…

Blog of (former?) MySQL Entomologist 2021-01-25

Checking User Threads and Temporary Tables With gdb in MariaDB 10.4+, Step By Step

There were no posts about gdb tricks for a long time in this blog. This is surely unusual, but I had not done anything fancy with gdb for more than…

Blog of (former?) MySQL Entomologist 2021-01-25

Playing with recent bpftrace and MariaDB 10.5 on Fedora – Part II, Using the Existing Tools

In the previous post in this series I’ve presented a couple of my quick and dirty attempts to use bpftrace add uprobes to MariaDB server and dynamic libraries it uses,…

Blog of (former?) MySQL Entomologist 2021-01-24

Playing with recent bpftrace and MariaDB 10.5 on Fedora – Part II, Using the Existing Tools

In the previous post in this series I’ve presented a couple of my quick and dirty attempts to use bpftrace add uprobes to MariaDB server and dynamic libraries it uses,…

Blog of (former?) MySQL Entomologist 2021-01-24

Playing with recent bpftrace and MariaDB 10.5 on Fedora – Part I, Basic uprobes

There is still some non-zero probability that my talk called “Monitoring MariaDB Server with bpftrace on Linux” is accepted for the FOSDEM 2021 Monitoring and Observability devroom, so it’s time…

Blog of (former?) MySQL Entomologist 2021-01-23

Playing with recent bpftrace and MariaDB 10.5 on Fedora – Part I, Basic uprobes

There is still some non-zero probability that my talk called “Monitoring MariaDB Server with bpftrace on Linux” is accepted for the FOSDEM 2021 Monitoring and Observability devroom, so it’s time…

Blog of (former?) MySQL Entomologist 2021-01-23

Life with Rona 2.0 – Days 1 & 2

Today is the first day that in the state of Pahang, we have to encounter what many Malaysians are referring to as the Movement Control Order 2.0 (MCO 2.0). I…

Colin Charles Colin Charles Agenda 2021-01-23

fork, exec, wait and exit

This is the english version of a 2007 article. In de.comp.os.unix.linux.misc somebody asked: Are commands in a script executed strictly sequentially, that is, will the next command only be executed…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2021-01-04

MySQL Password Rotation with AWS Secrets Manager and Lambda

How to set up MySQL password rotation with AWS Secrets Manager, AWS Lambda, and Terraform

Hack MySQL 2020-12-28

Embracing the Stream

So this happened: CentOS Project shifts focus to CentOS Stream The future of the CentOS Project is CentOS Stream, and over the next year we’ll be shifting focus from CentOS…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2020-12-10

Fixing Common PostgreSQL Performance Bottlenecks

Overview In this article, I look at how poorly designed sharding systems and replication systems in PostgreSQL affect query performance in high volume situations, and how to ensure data consistency…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2020-12-04

Not JOINing on PERFORMANCE_SCHEMA

The tables in PERFORMANCE_SCHEMA (P_S) are not actually tables. You should not think of them as tables, even if your SQL works on them. You should not JOIN them, and…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2020-12-01

Installing the Latest MariaDB from the Repository on Debian 10 and Downgrading to Older Minor Version

 I had not written any new blog posts here since this one for quite a some time, for two reasons. First of all, I have another project to spend time…

Blog of (former?) MySQL Entomologist 2020-11-29

Installing the Latest MariaDB from the Repository on Debian 10 and Downgrading to Older Minor Version

 I had not written any new blog posts here since this one for quite a some time, for two reasons. First of all, I have another project to spend time…

Blog of (former?) MySQL Entomologist 2020-11-29

On the Observability of Outliers

At work, I am in an ongoing discussion with a number of people on the Observability of Outliers. It started with the age-old question “How do I find slow queries…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2020-11-23