As of MySQL 8.0.28-u3, 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 your data.
While data compression results in smaller HeatWave Clusters, 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, you can disable data
compression by setting the
OFF before loading data:
SET SESSION rapid_compression=OFF;