HeatWave compresses data as it is loaded, which permits HeatWave nodes to store more data. More data per node reduces costs by minimizing the size of the HeatWave Cluster required to store the data.
While data compression results in a smaller HeatWave Cluster, decompression operations that occur as data is accessed affect performance to a small degree. Specifically, decompression operations have a minor effect on query runtimes, on the rate at which queries are offloaded to HeatWave during change propagation, and on recovery time from Object Storage.
If data storage size is not a concern, disable data
compression by setting the
rapid_compression
session
variable to OFF
before loading data:
mysql> SET SESSION rapid_compression=OFF;
The default option is AUTO
which
automatically chooses the best compression algorithm for each
column.