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

Networking & Connectivity in Hybrid Cloud: Connecting On-Premises with AWS

Hybrid cloud adoption is on the rise as organizations aim to balance on-premises control with the scalability of public clouds like AWS. A c...