Learning MySQL – What you will find when you read it
Recently, I and my colleague Sergey Kuzmichev published a book about Learning MySQL. So, what people will find in case they are considering using the book? The book has 16 …
Percona MongoDB incremental backup and PITR feature
Percona released Percona Backup MongoDB version 1.3.1 and it brings a feature that was hugely expected by the community. It’s the ability to perform consistent incremental backups. This allows us …
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 …