New advanced configuration parameters for Aiven for MySQL®

Aiven for MySQL® now supports 16 new advanced configuration parameters. Users can configure persistent, service-wide global defaults for query behavior, InnoDB full-text search, and query optimizer settings.

The new parameters are available through the Aiven Console, CLI, API, and Terraform, and span four categories:

• Toggles: automatic_sp_privileges, innodb_optimize_fulltext_only, windowing_use_high_precision, end_markers_in_json
• Bounded integers: max_execution_time, div_precision_increment, eq_range_index_dive_limit
• InnoDB full-text search: innodb_ft_max_token_size, innodb_ft_enable_stopword, innodb_ft_user_stopword_table, innodb_ft_result_cache_limit, innodb_ft_num_word_optimize
• Query optimizer: optimizer_switch, optimizer_prune_level, optimizer_search_depth, max_seeks_for_key

For more information, see Advanced parameters for Aiven for MySQL®.