Planet MariaDB Server

What is a database proxy?

An overview of database proxies, their advantages, and disadvantages.

Programming Brain 2022-11-22

MySQL IOPS for Reads and Surprsies

When you think about IOPS, you probably think about writes because MySQL write I/O has a long tradition of optimization, benchmarking, new algorithms, new storage engines, and so forth. There’s…

Hack MySQL 2022-11-20

Comparing Optimizer Results

A while ago I read a paper about Optimizer Benchmarks: How Good Are Query Optimizers, Really? by Viktor Leis from Fakultät für Informatik of the Technische Universität München. Because we…

FromDual: FromDual all (en) 2022-11-18

Comparing Optimizer Results

A while ago I read a paper about Optimizer Benchmarks: How Good Are Query Optimizers, Really? by Viktor Leis from Fakultät für Informatik of the Technische Universität München. Because we…

FromDual: FromDual all (en) 2022-11-18

Migration of your data from one database to another

Before you consider migrating your data from MySQL to another database you have to know which objects have to be migrated. With this query you will find the objects to…

FromDual: FromDual all (en) 2022-11-17

Migration of your data from one database to another

Before you consider migrating your data from MySQL to another database you have to know which objects have to be migrated. With this query you will find the objects to…

FromDual: FromDual all (en) 2022-11-17

Percona Monitoring and Management 2.32 preview release

Percona Monitoring and Management 2.32 preview release Hello folks! Percona Monitoring and Management (PMM) 2.32 is now available as a preview release. We encourage you to try this PMM preview…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2022-11-04

AWS Summit Mexico City: Back to In-Person Events

In March 2020, I presented my latest talk at an in-person event. This event was organized by a local university, Then when events started to happen online, during the pandemic,…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2022-10-19

MySQL: Tracing a single query with PERFORMANCE_SCHEMA

My task is to collect performance data about a single query, using PERFORMANCE_SCHEMA (P_S for short) in MySQL, to ship it elsewhere for integration with other data. In a grander…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2022-10-18

Is MySQL in the Cloud the End of the DBA?

No, I don’t think so. But it is does change our profession and have important implications for software engineers using (not managing) MySQL.

Hack MySQL 2022-10-15

What is Open Source and why should you care

The term Open Source Software reminds me of Abraham Lincoln’s widely accepted definition of Democracy. Lincoln said, “Democracy is the government of the people, by the people, and for the…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2022-10-14

Linux Container with Incus for focmm unit testing

Currently we are in the testing phase of the next release of our Ops Center (focmm). This testing is quite complex because it includes testing the interaction of various different…

FromDual: FromDual all (en) 2022-10-13

Linux Container with Incus for focmm unit testing

Currently we are in the testing phase of the next release of our Ops Center (focmm). This testing is quite complex because it includes testing the interaction of various different…

FromDual: FromDual all (en) 2022-10-13

Learning Kubernetes Operators with Percona Operator for MongoDB

One of the topics that have resonated a lot for me since the first KubeCon I attended in 2018 is Kubernetes Operators. The concept of Operators was introduced much earlier…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2022-10-13

The mysterious “sk_run_filter”

TL;DR Details: sk_run_filter is part of the Linux secure computing (seccomp), it filters system calls and their parameters seccomp is called for each system call made by all programs inside…

Dmitriy Philimonov MySQL Performance Blog 2022-10-05