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

The Benefits of VyOS Enterprise Subscription: Why Businesses Should Go Pro

In today’s rapidly evolving IT landscape, network reliability, security, and scalability are the cornerstones of enterprise success. Open-so...