Tag: InnoDB

3 posts

Lesson 15 of the SQL Optimization Course: Index Design (MySQL Index Structures)

Explore the index structures of MySQL's MyISAM and InnoDB engines, their advantages, disadvantages, and optimization strategies for database performance.

ytt

Apr 17, 2025

Lesson 13 of the SQL Optimization Course: Data Page Merging

Adjusting MERGE_THRESHOLD optimizes data page merging and splitting in MySQL InnoDB, enhancing performance.

ytt

Apr 11, 2025

Lesson 11 of the SQL Optimization Course: How to test the performance of compressed tables?

This article discusses monitoring compressed tables in MySQL, highlighting their suitability for read-intensive workloads and providing practical examples of performance impacts.

ytt

Apr 7, 2025