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.
Rebooter.S
Read More
6 min
Tag: MySQL Optimization
10 posts
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.
Rebooter.S
Read More
5 min
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.
Rebooter.S
Read More
18 min
MySQL 8.0 EOL Countdown: Secure Your Database Future Now!
As MySQL 8.0 approaches its End-of-Life in April 2026, this comprehensive guide explores critical upgrade, migration, and extended support strategies for database administrators. Discover actionable insights on mitigating security vulnerabilities, maintaining compliance, and minimizing downtime through LTS upgrades, third-party vendor solutions, or full database migrations to modern systems like PostgreSQL. Learn key considerations for application compatibility, performance impact analysis, and resource planning to ensure seamless transitions.
SQLFlash
Read More
7 min
Lesson 26 of the SQL Optimization Course: Mastering MySQL Full-Text Indexing
This tutorial comprehensively covers three advanced full-text indexing modes in MySQL (Natural Language, Boolean, Query Expansion). It provides practical SQL syntax guidance, performance optimization techniques, and real-world examples to help developers implement precise text search solutions.
ytt
Read More
4 min
Lesson 24 of the SQL Optimization Course: Index Condition Pushdown
Learn how MySQL index cardinality impacts query performance, including factors affecting accuracy, practical optimization techniques, and real-world case studies demonstrating the balance between read/write efficiency.
ytt
Read More
3 min
Lesson 23 of the SQL Optimization Course: Index Cardinality and Selectivity
Learn how MySQL index cardinality impacts query performance, including factors affecting accuracy, practical optimization techniques, and real-world case studies demonstrating the balance between read/write efficiency.
ytt
Read More
3 min
Window Function Performance Comparison and Optimization Strategies
This report compares MySQL TopN query optimizations using window functions, showcasing a two-order performance boost via CTE and LIMIT strategies with SQLFlash. Original 8-second queries optimized to 10ms through execution plan analysis and indexing strategies.
Rebooter.S
Read More
5 min
Lesson 12 of the SQL Optimization Course: How MySQL Calculates Table Statistics?
Explore MySQL's table statistics calculation, including persistent vs non-persistent options and optimization strategies.
ytt
Read More
4 min
Lesson 9 of the SQL Optimization Course: How to Choose the Right MySQL Tablespace
Explore MySQL's tablespace types with pros and cons. This guide helps you pick the best one to boost performance and ease management.
ytt
Read More
3 min