v.22.1Improvement
Support for SETTINGS clause in MySQL table engine with key-value or config options
If table engine supports SETTINGS clause, allow to pass the settings as key-value or via config. Add this support for MySQL. #33231 (Kseniia Sumarokova).Why it matters
This feature enables users to configure MySQL table engine settings directly at table creation, enhancing flexibility and control over table behavior without manual configuration changes.How to use it
When creating a table using the MySQL engine, specify the desired engine settings using theSETTINGS clause either inline as key-value pairs or through configuration files. For example:CREATE TABLE mysql_table ENGINE = MySQL(...) SETTINGS setting_name = 'value';