Tuesday, 12 December 2017

Amazon Aurora with MySQL compatibility now supports Batched Scans and Hash Join

Amazon Aurora with MySQL compatibility has now added support for Hash Join to accelerate the speed of equijoin queries. Aurora’s cost-based optimizer can now decide when to utilize Hash joins automatically and the user can also force their utilization in a query plan. Hash Joins enhances the latency of queries for internal testing in a decision to support the benchmark when utilizing a cold buffer pool by up to 8.2x on an R3.8x large instance. Batched Scans accelerates speed in-memory queries by a factor up to 1.8x. The features are available in the lab mode on Amazon Aurora MySQL version 1.16.

No comments:

Post a Comment

Now AWS Client VPN available in more AWS Regions

AWS VPN (Virtual Private Network) allows you form a private and secure tunnel from your network or device to the AWS global network. AWS ...