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 …
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 …
Upgrade MongoDB/PSMDB Standalone 3.4 to 3.6
In this blog post, I will share the necessary steps for a smooth upgrade from MongoDB (or Percona Server MongoDB) standalone version 3.4 to 3.6. I have plans to publish …
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 …