Amazon Aurora (MySQL) now supports Asynchronous Key Prefetch feature that speeds up the join queries by more than 10x

Amazon Aurora (MySQL) Speeds the Join Queries by more than an order of magnitude with Asynchronous Key Prefetch. With this release, the feature applies to the queries with the necessity of the Batched Key Access (BKA) join Multi-Range Read (MRR) and Algorithm optimization that enhances the performance when the data set that underlies is not the primary memory buffer pool or query cache. In the Internal testing, the Asynchronous Key Prefetch increases the latency for some queries that meet the criteria above when utilising a cold buffer pool with a factor more than 10x.