Improving WordPress database performance with cleanup and maintenance
by Danila Vershinin, September 4, 2022
Improve MySQL database performance for WordPress by adding high-performance keys and other maintenance tasks.
Read More...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...
