Tag: Database Tuning

MySQL 8.0/8.4 Performance Tuning Practice Guide

Executive Summary: The Three Pillars of MySQL Performance

Effective MySQL performance tuning for the 8.0 and 8.4 Long-Term Support (LTS) series is a systematic …

MySQL OR Condition to UNION ALL

This article demonstrates how optimizing MySQL OR conditions with UNION ALL significantly improves query performance, based on experimental results and execution plan analysis.

5 Steps to Optimize MySQL Deep Pagination

This article explores MySQL deep pagination optimization using Deferred Join technique, demonstrating 80.3% faster query performance with 99.99% fewer back-to-table operations through comprehensive testing.

Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Explore MySQL 8.0's optimizer enhancements including GROUP BY sorting changes, derived condition pushdown, and subquery-to-derived table conversion. Learn how these improvements reduce filesort operations and enhance query execution efficiency through practical benchmarking.