v.21.9Improvement

Expose RocksDB Statistics via system.rocksdb Table in ClickHouse

Official CH changelog text
Expose RocksDB statistics via system.rocksdb table. Read rocksdb options from ClickHouse config (rocksdb... keys). NOTE: ClickHouse does not rely on RocksDB, it is just one of the additional integration storage engines. #26821 (Azat Khuzhin).
Expose RocksDB statistics through the new system.rocksdb table and enable configuration of RocksDB options from ClickHouse settings using rocksdb... keys.

Why it matters

This feature provides visibility into RocksDB engine internals by exposing its metrics and statistics within ClickHouse. It allows users to monitor and tune RocksDB settings directly from the ClickHouse configuration, improving manageability and observability for setups using the RocksDB integration storage engine, which is optional and additional to ClickHouse's core engines.

How to use it

Users can query the system.rocksdb table to access RocksDB statistics. Configuration options for RocksDB are now read from the ClickHouse configuration files under keys prefixed with rocksdb, enabling users to customize RocksDB behavior within ClickHouse by adjusting these settings accordingly.

Related resources

PreviousNext