MySQL 8.0: Faster batch record retrieval
One of the things we have been working on for MySQL 8, is speeding up scans that read multiple records from a table or an index. Such scans benefit from reading the records in batches, so that they don’t get the overhead of latching data pages and navigating in the B-tree for every single record that is read.…
Source: MySQL 8.0: Faster batch record retrieval
