v.20.4Improvement

Provide max_allowed_packed in MySQL Compatibility Interface for ClickHouse

Provide max_allowed_packed in MySQL compatibility interface that will help some clients to communicate with ClickHouse via MySQL protocol. #10199 (BohuTANG)
Introduces the max_allowed_packed setting in the MySQL compatibility interface to improve client communication with ClickHouse using the MySQL protocol.

Why it matters

This feature addresses compatibility issues experienced by some MySQL clients when connecting to ClickHouse via the MySQL protocol. By providing the max_allowed_packed parameter, it enhances protocol negotiation and ensures smoother client-server interaction.

How to use it

Configure the MySQL compatibility interface in ClickHouse by setting the max_allowed_packed parameter to a suitable value in the server settings. This enables clients requiring this setting to communicate properly over the MySQL protocol.