The 5th dimension of MongoDB: Adjusting Eviction Threads
In certain situations, MongoDB can’t keep up with the dirty cache flushing. For these cases where the pressure on the cache is high, it might be necessary to adjust the …
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 …
Create a XFS filesystem using LVM
In this blog post, I will demonstrate how to use LVM to create flexible XFS filesystems where it allows us to extend or reduce its size without disrupting services. Instructions …
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 …
Install Valgrind
This post is intended to demonstrate how to install Valgrind in a Centos/Red Hat and Debian/Ubuntu environment. Valgrind is a programming tool for memory debugging, memory leak detection, and profiling. The …
Linux OS error codes
The list below provides the operating system error codes that commonly happens in the MySQL ecosystem. For example: Another alternative is the use of the perror tool to find the error message …
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 …