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

Maximizing Cloud Sales: How to Pitch Customers and Drive Business Growth

In the fast-paced world of cloud services, the ability to pitch effectively can make or break your business. Whether you’re an AWS partner, ...