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 …
Blog
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 …
Fixing Perl warning: setlocale: LC_CTYPE: cannot change locale
I use iTerm and SSH to connect to servers for executing various deployment and scripts for my daily basis activities. Basically, I spent 80% of my work hours on this black screen. …
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 …
DBA Talk – What is Isolation Level
This week I came across a topic in a group of DBAs where the following statement was made: Oracle is the only DB where writing does not block reading and …
MongoDB: Execute backup + incremental restore using the oplog
I had a case a few days ago where the secondary node of a replica set went out-of-sync for days and could not recover because the oplog was rotated on …