v.24.1Improvement

MySQL Interface Enhancements in ClickHouse: Support for Timeout Settings and SQL Select Limit Fix

Official CH changelog text
MySQL interface gained support for net_write_timeout and net_read_timeout settings. net_write_timeout is translated into the native send_timeout ClickHouse setting and, similarly, net_read_timeout into receive_timeout. Fixed an issue where it was possible to set MySQL sql_select_limit setting only if the entire statement was in upper case. #58835 (Serge Klochkov).
The MySQL interface in ClickHouse now supports net_write_timeout and net_read_timeout settings, mapping them to native send_timeout and receive_timeout respectively. Additionally, a bug was fixed to allow setting sql_select_limit regardless of case sensitivity in the query statement.

Why it matters

This feature improves compatibility and usability of the MySQL interface by enabling timeout configurations for network write and read operations. It also resolves a limitation that required sql_select_limit to be set only if the query was fully uppercase, thus making the interface more flexible and user-friendly.

How to use it

Users can now set net_write_timeout and net_read_timeout in MySQL protocol sessions; these will automatically translate to the native ClickHouse send_timeout and receive_timeout settings. The sql_select_limit can be applied without case restrictions on the statement.

Related resources

PreviousNext