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