Tuesday, 31 October 2017

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. 

No comments:

Post a Comment

Give Your Healthcare Team the Tech They Deserve With AWS, the Breath of Fresh Digital Air

Imagine a nurse juggling a dozen tasks: checking on patients, updating charts, hunting down lab results, and trying to remember her login pa...