Planet MariaDB Server
Stop the senseless killing
In over 22 years of working with Linux systems, I have often seen people use excessive force to kill various computer programs, causing unnecessary suffering. A typical example would be:…
How Not to Use MySQL
Chapter 9 of Efficient MySQL Performance changed in development. Originally, it was a chapter titled “Not MySQL”, as in “how not to use MySQL.” But we (O’Reilly and I) pulled…
Creating a Kubernetes cluster on Amazon EKS with eksctl
Amazon Elastic Kubernetes Service (Amazon EKS) is a managed Kubernetes service that makes it easy for you to run Kubernetes on AWS and on-premises. Kubernetes is an open-source system for…
Mining the MySQL Performance Schema for Transactions
The MySQL Performance Schema is a gold mine of valuable data. Among the many nuggets you can extract from it is an historical report of transactions: how long a transaction…
MySQL Transaction Reporting
How to inspect and report MySQL transactions using the Performance Schema
openGauss on ARM
openGauss is an open-source relational database built for internet-scale and optimized for ARM architecture (retaining compatibility with x86). DB kernel is derived from PostgreSQL so PgSQL users will find a…
openGauss on ARM
openGauss is an open-source relational database built for internet-scale and optimized for ARM architecture (retaining compatibility with x86). DB kernel is derived from PostgreSQL so PgSQL users will find a…
Setting up PMM for monitoring MySQL on a local environment
Percona Monitoring and Management (PMM) is an open source database monitoring, observability, and management tool that can be used for monitoring the health of your database infrastructure, exploring new patterns…
Running PMM with Docker on Ubuntu 20.04
I started at Percona a few weeks ago and was looking for a quick way to learn about PMM (Percona Monitoring and Management), which is one of my favorite technologies…
Better Replication Heartbeats
We’ve been measuring MySQL replication lag with heartbeats for more than a decade. It works, but can we do better? Let’s see.
Slides: MariaDB’s Join Optimizer: how it works and current fixes
I’ve spent some time working on the join optimizer recently. Here are the slides covering MySQL/MariaDB join optimizer internals and the improvements that we have made or are making to…
Building a Kubernetes cluster on Raspberry Pi (with automation)
Steps to build a Kubernetes cluster on Raspberry Pi with automation.
MariaDB on openEuler-ARM stack – Multi-NUMA study
MariaDB on the openEuler-ARM stack has shown promising results during the initial evaluation. (If you have missed that blog click here). Taking the assessment further we decided to evaluate the…
MariaDB on openEuler-ARM stack – Multi-NUMA study
MariaDB on the openEuler-ARM stack has shown promising results during the initial evaluation. (If you have missed that blog click here). Taking the assessment further we decided to evaluate the…
Rivers vs Axis
It’s hard to find at least two people who would format the same SQL query in the same way. Everyone has their own style and their own arguments. And everyone…