v.19.3Improvements
Add One Required Argument to SET Index (max Stored Rows Number)
Add one required argument to SET index (max stored rows number). #4386 (Nikita Vasilev)Why it matters
This feature allows users to explicitly limit the number of rows stored in aSET index, improving control over memory usage and performance when using this index type.How to use it
When creating aSET index, specify the maximum number of stored rows as a required argument, for example:ALTER TABLE table_name ADD INDEX index_name SET(column_name, max_rows_number) TYPE set();