Planet MariaDB Server

Metadata Locks Instrumentation in MariaDB 10.5

There are different ways to study metadata locks in MySQL and MariaDB, as I once described in details. Until recently MariaDB had not provided the performance_schema.metadata_locks table, but it was…

Blog of (former?) MySQL Entomologist 2020-09-27

MySQL + Dynimize: 3.6 Million Queries per Second on a Single VM

In this post I describe the various steps that allowed me to reach 3.6 million queries per second on a single VM instance using MySQL 8.0 with the help of…

David Yeager Dynimize Tutorials and Discussions 2020-09-22

MySQL mysql_config_editor & expect

This is just a note to help out anyone that might want to use the mysql_config_editor command in their automation tools. the mysql_config_editor does not take a password argument so automation tools that…

Keith Larson ( anothermysqldba ) Another MySQL DBA 2020-09-21

Dynamic Tracing of pthread_mutex_lock in MariaDB – First Steps

 I’ve got several comments and questions during my session on dynamic tracing at MariaDB Server Fest 2020. One of them was from a MariaDB developer at Slack and sounded as…

Blog of (former?) MySQL Entomologist 2020-09-20

Dynamic Tracing of pthread_mutex_lock in MariaDB – First Steps

 I’ve got several comments and questions during my session on dynamic tracing at MariaDB Server Fest 2020. One of them was from a MariaDB developer at Slack and sounded as…

Blog of (former?) MySQL Entomologist 2020-09-20

BCC Tools for disk I/O Analysis and More

A lot of time passed since I had written about bcc tools in my dynamic tracing series. That post was mostly about building bcc tools from GitHub source on Ubuntu…

Blog of (former?) MySQL Entomologist 2020-09-13

BCC Tools for disk I/O Analysis and More

A lot of time passed since I had written about bcc tools in my dynamic tracing series. That post was mostly about building bcc tools from GitHub source on Ubuntu…

Blog of (former?) MySQL Entomologist 2020-09-13

Scaling up or scaling down Azure Database for MySQL for cost optimization

In the previous test we looked at what happened when we scaleup an Azure Database for MySQL server to sustain an heavy workload. We saw that the service interruption was…

administrateur Serge Frezefond ‘s blog 2020-09-08

Scaling up or scaling down Azure Database for MySQL for cost optimization

In the previous test we looked at what happened when we scaleup an Azure Database for MySQL server to sustain an heavy workload. We saw that the service interruption was…

administrateur Serge Frezefond ‘s blog 2020-09-08

Azure Database for MySQL failover impact on availability

In that test I would like to measure the impact of a failover of an Azure Database for MySQL. Unfortunately there is no mechanism to force the crash of the…

administrateur Serge Frezefond ‘s blog 2020-09-07

Azure Database for MySQL failover impact on availability

In that test I would like to measure the impact of a failover of an Azure Database for MySQL. Unfortunately there is no mechanism to force the crash of the…

administrateur Serge Frezefond ‘s blog 2020-09-07

Google Summer of Code Refactor PMM Framework Project with Percona

I am Meet Patel, 2nd year undergraduate at DAIICT, Gandhinagar, India; pursuing a bachelor’s degree in Information and Communication Technology with a minor in Computational Science. I am proud to…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2020-09-07

Two weeks to MariaDB Server Fest

There is still time to register for the MariaDB Server Fest 2020! MariaDB Fest 2020[/caption] Our Fest is the opportunity to have live interactions with the key players on MariaDB…

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

IoT Performance Bottlenecks & Open Source Databases

The Internet of Things (IoT), in essence, is all about everyday devices that are readable, recognizable, trackable, and/or controllable via the Internet, regardless of the communication means — RFID, wireless…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2020-09-03

MariaDB 10.5 and Memory Instrumentation in Performance Schema – Basic Checks

My MariaDB 10.5-related talk at upcoming MariaDB Server Fest is already announced, so I have no other option but to continue writing blog posts while preparing for it. In the previous…

Blog of (former?) MySQL Entomologist 2020-08-24