v.23.8Improvement

Added system table flushing on unexpected shutdown

Added possibility to flush system tables on unexpected shutdown. #52174 (Alexey Gerasimchuck).
Added the capability to flush system tables automatically on unexpected shutdowns.

Why it matters

This feature addresses the problem of potential data loss or inconsistency in system tables when ClickHouse shuts down unexpectedly. By flushing system tables during such shutdowns, it ensures that system metadata and related information are reliably saved, enhancing stability and recoverability.

How to use it

The flushing of system tables on unexpected shutdowns is enabled automatically with this update, requiring no additional configuration from the user.