Tag: MySQL

WordPress

Optimizing Database Configuration After Upgrading WordPress to MySQL 8.0

2026-02-08 Alpha

Linux

Implementing Efficient Search in WordPress with Manticore Search on CentOS

2020-04-08 Ryan

Linux

How to Fix MySQL ERROR 2006 (HY000): MySQL Server Has Gone Away

2018-07-01 Ryan

Linux

Optimized MariaDB/MySQL my.cnf Configuration Guide for 4GB RAM Production Servers

2018-05-15 Ryan

Linux

Production Server Migration & Optimization Notes: LNMP Environment Upgrade

2018-03-20 Ryan

Linux

MariaDB Configuration File Parameter Guide and Example for a 4GB Server

2018-03-20 Ryan

Others

MySQL DMB Monitoring and Backup System: Installation and Configuration Guide

2018-03-18 Ryan

Linux

A Detailed Guide to Using mysqldumpslow for MySQL Slow Query Log Analysis

2018-02-17 Ryan

Linux

MySQL Performance Tuning: Essential my.cnf Parameters and Configuration Guide

2018-02-17 Ryan

Linux

Improve WordPress Search Performance with mysqlcft Chinese Full-Text Index on LNMP

2018-02-14 Ryan

Linux

Fixing MySQL Import Errors in WordPress Database Migration: Version and Character Set Compatibility

2017-07-26 Ryan

Linux

Restoring Baidu RDS MySQL Backup to Local Server Using XtraBackup on CentOS 6.5

2017-07-17 Ryan

Linux

MySQL Service Monitoring and Auto-Restart Script for LNMP Environments

2016-08-13 Ryan

Linux

Fix WordPress "Error Establishing a Database Connection" on LNMP Servers

2015-11-01 Ryan

Others

Install and Configure OpenLiteSpeed with PHP 7 and MySQL 5.6

2015-08-17 Ryan

Linux

How to Fix MySQL Error: Table is Marked as Crashed and Last Repair Failed

2015-08-15 Ryan

Linux

Guide to Configuring a Script for Automatic Backup of MySQL Databases and Website Files to a Remote FTP Server on Linux VPS

2015-08-15 Ryan

Linux

Choosing and Implementing an Automatic MySQL Backup Strategy

2015-08-15 Ryan

Linux

How to Read and Interpret pt-query-digest Slow Query Log Analysis Output

2015-08-14 Ryan

Linux

Analyze and Optimize MySQL Slow Queries with Percona Toolkit

2015-08-14 Ryan