Tag: MySQL Performance

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 …

Lesson 34 of the SQL Optimization Course: Partition Pruning Techniques for Time-Based Tables

Master advanced MySQL partition pruning techniques to optimize query performance for time-based tables. Learn practical strategies to reduce scan times and enhance data retrieval efficiency.

Lesson 27 of the SQL Optimization Course: Monitoring MySQL Full-Text Indexes

Learn advanced techniques for monitoring MySQL full-text indexes, including parameter configuration, metadata table analysis, and practical monitoring workflows. Gain insights into cache management, deletion tracking, and performance optimization using real-world examples.

Predicate Pushdown Performance Optimization Scheme

Unlock 100x faster MySQL queries by mastering LIKE optimization through range scans and index-aware SQL rewriting. Discover how SQLFlash leverages B+ tree principles to eliminate full-table scans and boost database performance.

Leetcode Hardest SQL 185: Is the Best Solution Still Slow?

Explore LeetCode's No.185 SQL solutions, comparing subquery and window function performance with SQLFLASH optimization insights.