MariaDB: Optimising MariaDB for InnoDB or MyISAM engines

This documentation is part of the Advanced usage guide. You can view the complete guide here: How to configure, optimise, export, or import MariaDB data.

👋 Welcome to Stackhero documentation

Stackhero offers a ready-to-use MariaDB cloud solution with a range of benefits, including:

• Unlimited connections and data transfers.
• Built-in phpMyAdmin web interface.
• One-click updates for simplified maintenance.
• Optimal performance and enhanced security thanks to private, dedicated infrastructure.

Save time and make your life easier: it takes just 5 minutes to try Stackhero's MariaDB cloud hosting solution!

If your database uses the InnoDB storage engine, you can enable the "InnoDB Optimisations" option in your dashboard. This helps improve performance for InnoDB-based workloads.

For databases using the MyISAM storage engine, enabling the "MyISAM Optimisations" option can also provide benefits.

If you are unsure which option is best for your setup, it is generally safe to enable both initially. As you monitor your resource usage and performance, you can then decide whether to disable one or both to save memory (RAM).