Tag: SQL Tuning

2 posts

Lesson 35 of the SQL Optimization Course: Optimizing MySQL Partitioned Tables for Time Series Queries

Learn advanced techniques to enhance query performance on MySQL time-based partitioned tables. Master partition pruning, SQL rewriting, and partition hints for large-scale data optimization.

ytt

Aug 15, 2025

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.

ytt

May 25, 2025