v.19.14Improvement

Rewritten Mysql Compatibility Server to Prevent Loading Full Packet Payload in Memory

Official CH changelog text
Rewritten MySQL compatibility server to prevent loading full packet payload in memory. Decreased memory consumption for each connection to approximately 2 * DBMS_DEFAULT_BUFFER_SIZE (read/write buffers). #5811 (Yuriy Baranov)
Rewritten MySQL compatibility server to optimize memory usage by preventing full packet payload loading in memory.

Why it matters

This feature addresses high memory consumption issues by reducing the memory footprint of each connection to about 2 * DBMS_DEFAULT_BUFFER_SIZE, improving resource efficiency and stability for MySQL compatibility server connections.

How to use it

This improvement is applied internally in the MySQL compatibility server. Users benefit automatically from reduced memory consumption when using ClickHouse as a MySQL-compatible server without requiring additional configuration.

Related resources

PreviousNext