Why Are Reverse Index Scans Slower in InnoDB?
InnoDB's ORDER BY DESC is slower than ASC due to its unidirectional linked list design, making reverse scans O(n) versus forward scans O(1).
Rebooter.S
Read More
6 min
Tag: InnoDB
3 posts
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
Read More
7 min
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
Read More
7 min