Sed? Long live “replace”!


by Danila Vershinin, May 22, 2019

Use replace2 to quickly replace strings in text files. Sed alternative for strings replacement

Read More...

Install MySQLTuner in CentOS/RHEL


by Danila Vershinin, March 20, 2019

How to install MySQLTuner in CentOS/RHEL 7 to help with tuning MySQL server instances

Read More...

NGINX Amplify – MySQL Monitoring in CentOS 6


by Danila Vershinin, August 4, 2018

MySQL monitoring in CentOS 6 using NGINX Amplify agent

Read More...

In-Place Upgrading: Percona MySQL 5.6 to 5.7 (RedHat/CentOS 7)


by Danila Vershinin, June 17, 2018

A simple script for updating your Percona MySQL Server 5.6 to version 5.7, in CentOS/RHEL systems.

Read More...

Safe MySQL configuration reload? Easy


by Danila Vershinin, June 14, 2018

An easy way into implementing `systemctl reload mysqld`.

Read More...

The evil increment_id? Or why MySQL is not using an index


by Danila Vershinin, February 17, 2018

Debugging guide to help you with your MySQL index optimization in Magento 1.x

Read More...

MySQLTuner fix for “Reduce or eliminate unclosed connections and network issues”


by Danila Vershinin, October 21, 2017

Find out how to eliminate unclosed MySQL connections

Read More...

MariaDB: replicate single database. Tutorial and gotchas


by Danila Vershinin, July 16, 2017

Setup MySQL slave replication with few easy steps. Some gotchas on MySQL replication lag and how to fix it.

Read More...

Optimize slow MySQL queries


by Danila Vershinin, March 15, 2017

Let’s optimise slow MySQL queries on Citrus (or other Percona MySQL) powered servers.

Read More...

Mysqldump hangs website? [Solved]


by Danila Vershinin, September 22, 2016

Here is how to run mysqldump properly, without affecting the live website and no slowdown during your database backup

Read More...