2019-06-19 12:29 UTC Fun MySQL fact of the day: the buffer pool Since February, we've been intentionally working off a half-formed mental model about InnoDB. In just about all cases, we considered a model wherein InnoDB always reads from and writes to the on-disk index files to serve each query. And while considering a mental model like this can certainly simplify ... read more
2019-05-09 08:00 UTC Fun MySQL fact of the day: multi-range read optimisation So far this week, we've looked at 2 of the 3 Nested-Loop Join algorithms MySQL can use to join tables. Before we look at the third one, we need to take a quick detour. ... read more