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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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, …