Introducing new MySQL HeatWave features for lower cost and better performance

 

Customers with various sizes of workloads want to use MySQL HeatWave for query acceleration. MySQL HeatWave is addressing the wide spectrum of MySQL workloads with the following new features:

  1. For MySQL HeatWave on OCI, which is optimized for the AMD EPYC™ platform:
    1. A new HeatWave shape with 32GB of memory that can process up to 50GB of data is available: 1/16th of the currently offered HeatWave shape with 512GB of memory.
    2. Increased amount of data processed per 512GB memory HeatWave node, from 800GB to 1TB, extending the maximum supported data size from 50TB to 64TB.
  1. MySQL Autopilot – Auto Unload advisor which helps customers to actively look for lower memory consumption by unloading unused tables in HeatWave

HeatWave can now address workloads from less than 50GB to 64TB with the best price performance.

 

Improved price performance with HeatWave processing more data per node

1TB data per HeatWave node

MySQL HeatWave team strives for best price performance with continuous innovations. Since the service GA, the amount of data that can be processed per HeatWave node has improved from 400GB to 800GB (2 times improvement). Now, the amount of data a HeatWave node can process is increased up to 1TB (the amount of data a HeatWave node can processed varies based on the characteristics of the data and workloads).  This reduces the number of HeatWave nodes needed for a given workload, hence further brings down the cost. For example, you can now run 4TB TPCH workload with 4 HeatWave nodes down from 5 HeatWave nodes which reduces the cost by 20% and improves price performance by 15%.

With this increased processing capacity, HeatWave can now support workload with up to 64TB of data (up from 50TB).

 

Lower cost shape for processing small workload

Small HeatWave shape

A new HeatWave shape with 32GB of memory is now available. This new HeatWave shape costs only $16 per month, is perfect for customers with small workload to take advantage of the query acceleration from HeatWave while keeping the cost low.

Together with the existing HeatWave shape with 512GB of memory, customers now have more options to choose from based on their workload needs.

 

Unload unused tables in HeatWave to lower cost

MySQL Autopilot is introducing two new features:

  1. Auto unload utility – Unloading tables from HeatWave can be a tedious task depends on the number of schemas and tables. Auto unload improves usability by automating these manual steps to ease.

Auto Unload

  1. Auto unload advisor – Auto unload advisor determines unused or rarely used tables in HeatWave, and predicts the memory saved from unloading the tables.

Auto Unload Advisor

Users can save cost by unloading tables that are never or rarely queried in HeatWave to lower the total memory required and decrease the HeatWave cluster size. However, this requires understanding all queries and access patterns of the tables. Auto unload automates and tracks table usage and provides recommendations along with an explanation to support them.

 

Addition Resources