Melhorando a performance da replicação do MySQL
Este post é o meu primeiro após o blog ter um novo design! Yayyy! Espero que vocês gostem e lembre-se: o feedback é sempre bem-vindo! Uma das perguntas mais comuns …
Boosting MySQL Replication
This post is my first one after the blog got a new design! Yayyy! I hope you guys enjoy it and remember: feedback is always welcome! One of the most …
Stop Fake News! The most common fake news about MySQL (contains bad language)
Since I have been working with MySQL, I saw a lot of comments about the MySQL ecosystem, which, if they are not made in a bad intention to sell commercial …
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 …
Top 7 Linux Optimizations For MySQL
That’s all. Like a cake recipe. The DBA and sysadmin dream. You don’t think, you can just apply. Here are the 7 crushing tips for basic OS tunning: Swappiness The …
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 …
Monitor MySQL memory usage – Part 1 (Performance Schema)
On my day-to-day activities, one of the most classic cases that I get is: I think that my database has a memory leak. Where MySQL is spending so much memory? …
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 …