Amazon Aurora (MySQL) Speeds Join Queries by More than 10x with Asynchronous Key Prefetch October 27, 2017 By admin Amazon Aurora (MySQL) now supports the asynchronous key prefetch (AKP) feature which can speed up join queries by more than an order of magnitude.