How to deal with a huge Magento 2 database


by Danila Vershinin, April 29, 2020

Cleanup huge Magento 2 database with simple SQL queries and/or do it regularly via cron.

Read More...

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...