MariaDB: Optimizing MariaDB for InnoDB or MyISAM engines

This documentation is part of the Advanced usage guide. View the full 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 may want to enable the "InnoDB Optimizations" option in your dashboard. This can help improve performance for InnoDB-based workloads.

For databases built on the MyISAM storage engine, turning on the "MyISAM Optimizations" option can also provide benefits.

If you are not sure which option is best for your setup, it is usually safe to enable both at first. Later, as you monitor your resource usage and performance, you can decide whether to disable one or both to conserve memory (RAM).