v.1.1.54289New Feature

SYSTEM Queries for Server Administration

Official CH changelog text
SYSTEM queries for server administration: SYSTEM RELOAD DICTIONARY, SYSTEM RELOAD DICTIONARIES, SYSTEM DROP DNS CACHE, SYSTEM SHUTDOWN, SYSTEM KILL.
Adds new SYSTEM queries for server administration, including commands to reload dictionaries, clear DNS cache, shutdown the server, and kill queries.

Why it matters

This feature provides database administrators with enhanced control over server operations and maintenance tasks. It addresses the need to dynamically reload dictionaries without restarting the server, clear DNS cache to resolve network issues, and manage server processes by shutting down or killing queries, thus improving operational flexibility and reducing downtime.

How to use it

Use the SYSTEM RELOAD DICTIONARY or SYSTEM RELOAD DICTIONARIES commands to reload one or all dictionaries respectively. Use SYSTEM DROP DNS CACHE to clear the DNS cache. To shut down the server gracefully, use SYSTEM SHUTDOWN. To terminate running queries, use SYSTEM KILL with appropriate parameters.
PreviousNext