Compiling MySQL (Desmistifying)
Today we are going to talk about a topic that many people are afraid of. We know that MySQL is open-source, but there are some steps from the code until …
Toss a coin to your DBA: Estimate MySQL Redo Log Size
Having a right REDO log size is fundamental for MySQL to run smoothly without struggling. An undersized REDO can even lead to errors in operations! For example, this week, a …
Monitor MySQL Memory Usage – Part 2 (Valgrind)
So, today, continuing with memory analysis I will present the Valgrind tool. Valgrind programming tool provides information for memory debugging, memory leak detection, and profiling. It is useful for cases …
MySQL built-in function x user-defined function performance
In this article, I’m going to cover the use of built-in functions. The idea is to use the functions that MySQL has available instead of making custom functions (aka user-defined …
Export The Slow_log Table To Slow Query Log File To Apply The Pt-query-digest
Working on customer cases always brings challenges. This week I got one where the customer provided the dump of mysql.slow_log table and it was necessary to analyze it. Unfortunately, pt-query-digest …
Deploying Percona MySQL Server container in one command line
That’s it? Do I have to execute only this line? A: Yes. This article is a silver bullet for those who want to deploy a Percona Server MySQL to quickly …
DBA Talk – What is Isolation Level
This week I came across a topic in a group of DBAs where the following statement was made: Oracle is the only DB where writing does not block reading and …
Webinar: Enhancing MySQL Security
A few days ago, I presented a webinar about security over MySQL. I covered a few topics and discussed the pros and cons of implementing those features. Below is the …
Ressincronizar Slave MySQL sem downtime com Percona Toolkit
Recentemente, trabalhei em um caso extremo em que um slave ficou dessincronizado, mas não pôde ser reconstruído do zero porque o slave estava agindo como um servidor master para uma …
MySQL 8.0.17 Clone Plugin: How to Create a Slave from Scratch
In this post, we will discuss a new feature – the MySQL 8.0.17 clone plugin. Here I will demonstrate how easy it is to use to create the “classic” replication, …