Amazon Aurora (MySQL) now supports the asynchronous key prefetch (AKP) feature which can speed up join queries by more than an order of magnitude.

Google+