v.22.7Improvement
Add DESCRIBE CACHE and SHOW CACHES Queries for Cache Management
AddDESCRIBE CACHEquery to show cache settings from config. AddSHOW CACHESquery to show available filesystem caches list. #38279 (Kseniia Sumarokova).
Why it matters
These new queries help users easily inspect and understand the current cache configurations and available filesystem caches without needing to directly access configuration files, improving cache management and visibility.How to use it
Use theDESCRIBE CACHE query to view cache-related settings as defined in the config files. Use the SHOW CACHES query to get a list of all available filesystem caches currently configured or detected by ClickHouse.