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

AWS Shield Advanced gets updated for Automatic Application Layer DDoS Mitigation

AWS has rolled out an update for Shield Advanced, managed Distributed Denial of Service (DDoS) protection service -  Automatic Application L...