v.22.1Improvement

Allow Configurable Connection Timeouts for MySQL

Official CH changelog text
Allow to control connection timeouts for MySQL (previously was supported only for dictionary source). Closes #16669. Previously default connect_timeout was rather small, now it is configurable. #32734 (Kseniia Sumarokova).
Introduced configurable connection timeout settings for MySQL tables, extending timeout control previously only available for dictionary sources.

Why it matters

This feature addresses the limitation of a fixed, small connection timeout for MySQL tables in ClickHouse. By allowing users to configure the connection timeout, it improves connectivity robustness and flexibility, helping to optimize performance and prevent premature connection failures.

How to use it

Users can specify the connection timeout by setting the connect_timeout parameter in the MySQL table engine configuration. This allows adjusting the timeout duration according to their environment and needs.

Related resources

PreviousNext