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

Amazon SNS Offers Assistance For Cost Allocation Tags

Amazon Simple Notification Service (Amazon SNS) is a web service which coordinates and manages the delivery or sending of messages to su...