MariaDB: Optimizing 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, optimize, export, or import MariaDB data.

👋 Welcome to the Stackhero documentation!

Stackhero offers a ready-to-use MariaDB cloud solution that provides a host of benefits, including:

• Unlimited connections and transfers.
• phpMyAdmin web UI included.
• Effortless updates with just a click.
• Optimal performance and robust security powered by a private and dedicated VM.

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

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

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

If you are unsure which option is best for your setup, it is generally recommended to enable both at first. Then, by monitoring your resource usage and performance, you can decide whether to disable one or both to save memory (RAM).