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

File Gateway Gives Assistance To Amazon S3 Object Lock

AWS Storage Gateway offers assistance for Amazon S3 Object Lock to File Gateway, allowing write-once-read-many (WORM) file-based syst...