v.23.4Experimental Feature

Entries in Query Cache Squashed and Compressed

Entries in the query cache are now squashed to max_block_size and compressed. #45912 (Robert Schulze).
Query cache entries are now consolidated to the max_block_size and compressed to optimize storage and performance.

Why it matters

This feature reduces the memory footprint of cached query results by squashing entries up to the maximum block size and applying compression. It improves cache efficiency, lowers disk usage, and can enhance query performance by serving cached results faster.

How to use it

The query cache automatically squashes and compresses entries according to the max_block_size setting. Users do not need to enable anything explicitly, but can adjust max_block_size in their configuration to control block sizing.