MariaDB 12.0.2 Optimization and Feedback Plugin Disable Recommendations

[nima1024m]

After reviewing the transition from MariaDB 11.8.3 to 12.0.2 for Releem's hosting environments, I’ve identified several new configuration parameters and optimizations to ensure maximum performance for multi-tenant MariaDB hosting (especially for PrestaShop). Additionally, I suggest disabling the new “feedback” plugin, which can cause unnecessary overhead.

---

Key Recommendations:

1. New MariaDB 12.0 Parameters to Address

• max_open_cursors: Per-session cursor limit for stored routines.
  Action: Ensure that Releem can monitor and warn about cursor leaks.

• create_tmp_table_binlog_formats: Controls logging for CREATE TEMPORARY TABLE.
  Action: Expose this in the config and document any changes to replication behavior.

• ssl_passphrase: Tied to TDE encryption key.
  Action: Detect TDE setups and ensure they’re handled properly within Releem.

• show_slave_auth_info & replicate_same_server_id: Security and replication hygiene updates.
  Action: Make sure to expose these for monitoring and validation in shared environments.

---

2. Temporary Space Optimizations (Pre-12, but crucial in 12.x)

• max_tmp_session_space_usage & max_tmp_total_space_usage: Cap the usage of temporary tables.
  Action: Expose these settings for shared environments and allow custom configurations based on usage patterns. Trigger alerts if usage approaches caps.

• tmp_space_used / max_tmp_space_used: Monitor temporary space usage.
  Action: Add these variables to the health-checks, alerting when the limits are approached.

---

3. Optimizer Hints for Query-Level Recommendations

• Optimizer hints like NO_RANGE_OPTIMIZATION, NO_ICP, MRR/NO_MRR, BKA/NO_BKA, BNL/NO_BNL, and join hints (JOIN_PREFIX, JOIN_ORDER, etc.) have been added to 12.0.
  Action: Integrate an advisory mechanism in Releem's query analytics to suggest these hints for queries exhibiting performance issues.

---

4. Dropped Variables in 12.0

• big_tables, large_page_size, storage_engine have been removed in MariaDB 12.0.
  Action: Ensure Releem-generated my.cnf no longer includes these variables and prevent issues in case of legacy setup transitions.

---

5. Disable the "feedback" Plugin in Production

• The "feedback" plugin can send data every minute and weekly after startup, which introduces small performance overhead.
  Action: Ensure the feedback plugin is disabled on production servers by adding feedback=OFF under [mysqld] or removing the plugin using UNINSTALL PLUGIN feedback;.

---

Request for Configuration Input:

To help fine-tune the MariaDB 12.0 settings for specific Releem setups, please share a sample Releem-generated my.cnf configuration file (along with current Releem recommendations for multi-tenant hosting) to make sure the suggested parameters are properly aligned with your fleet.

---

Impact:

By addressing the above points, Releem will be well-optimized for MariaDB 12.0, ensuring smooth performance in multi-tenant environments. Disabling the "feedback" plugin will also reduce unnecessary overhead in shared hosting setups.

[kochetovd]

Thank you for your suggestions. We will review them and implement them in Releem.