Beyond Linear Read-Ahead: Logical Prefetching Using Indexes in InnoDB

Author: MySQL - Bewertung: 0x - Views:0

Supercharge MySQL InnoDB query speed with advanced logical prefetching. Learn proven strategies for boosting performance and efficiency in modern databases.



This technical session from the 2026 MySQL Belgium Days event offers an in-depth exploration of logical prefetching in InnoDB, focusing on the use of both primary and secondary indexes to enhance database performance. The presentation breaks down the intricacies of read-ahead optimization, contrasting traditional linear read-ahead with cutting-edge logical approaches. Through data-driven demonstrations, viewers will discover how the buffer pool, thread behavior, and page replacement policies impact query latency and throughput in enterprise environments. Learn why asynchronous and synchronous reads behave differently and how fragmented databases can create hidden performance bottlenecks. Attendees also receive practical guidance for configuring InnoDB settings, understanding buffer pool mechanics, and maximizing resource utilization. This video is ideal for DBAs, system architects, and developers seeking to achieve higher engagement through improved MySQL performance and reliability.