Tag: MySQL Performance

3 posts

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

MySQL LIKE Optimization: 100x Faster Queries!

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.

Rebooter.S

May 14, 2025

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.

Rebooter.S

Apr 29, 2025