Planet MariaDB Server
Interesting Troubleshooting of a MySQL Crash : filling then freeing the disk
I recently troubleshoot an interesting MySQL crash, and I think it is worth sharing (with the related bugs). MySQL crashed when the disk was full, you can see the free…
Interesting Troubleshooting of a MySQL Crash : filling then freeing the disk
I recently troubleshoot an interesting MySQL crash, and I think it is worth sharing (with the related bugs). MySQL crashed when the disk was full, you can see the free…
What’s new in PMM 3.2.0: Five major improvements you need to know
PMM 3.2.0 brings some long-awaited fixes and new capabilities. You can now install PMM Client on Amazon Linux 2023 with proper RPM packages, get complete MySQL 8.4 replication monitoring, and…
What is a Vector in AI and RAG?
What exactly is a Vector embedding in AI apps and how to use them in RAG architectures?
Interesting Binary Logging Optimization in MariaDB
As I wrote in a LinkedIn post, I am working on a blog post related to binary logging of big transactions. I thought I would split this post in two,…
Interesting Binary Logging Optimization in MariaDB
As I wrote in a LinkedIn post, I am working on a blog post related to binary logging of big transactions. I thought I would split this post in two,…
PostgreSQL 18 – Top Enterprise Features (fast read)
So the Beta1 is available for PostgreSQL 18 and while not all the features have to make it to GA, we can surely hope they do! Taking a close look…
Creating Debian packages from upstream Git
In this post, I demonstrate the optimal workflow for creating new Debian packages in 2025, preserving the upstream Git history. The motivation for this is to lower the barrier for…
long_query_time for Optimal Query Monitoring
Problem In order to facilitate query monitoring in MySQL and MariaDB, you have two options for sourcing the data: performance_schema slow_query_log performance_schema is cheap, but it lacks some of the…
OS Platform End of Life (EOL) Announcement for Ubuntu 20.04 LTS
Ubuntu 20.04 LTS (Focal Fossa) is scheduled to reach its official end of life on May 31, 2025. In alignment with the upstream vendor’s lifecycle, we are also ending platform…
Percona Bug Report: April 2025
At Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any…
Query Response Time
Context This is why you need to learn MySQL query response time: Performance is query response time. This book explores that idea from various angles with a single intent: to…
Indexes and Indexing
Context This is why you need to learn MySQL indexes and indexing: Many factors determine MySQL performance, but indexes are special because performance cannot be achieved without them. You can…
Data and Access Patterns
Context This is why you need to learn about MySQL data storage and access patterns: Even when you master indexes and indexing, you will encounter queries that are simple and…
Sharding
Context This is why you need to learn about sharding MySQL: On a single instance of MySQL, performance depends on queries, data, access patterns, and hardware. When direct and indirect…