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

Claude Enterprise: Understand which Claude plan is best for you and why

  Before deciding how to buy Claude, it helps to see the whole menu. Anthropic sells Claude in two fundamentally different shapes, and most ...