MySQL: Optimising MySQL 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 MySQL data.

👋 Welcome to the Stackhero documentation!

Stackhero offers a ready-to-use MySQL 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 MySQL cloud hosting solution!

If your database uses the InnoDB storage engine, you can enable the "InnoDB Optimisations" option in the Stackhero dashboard to improve performance.

Similarly, if your database runs on the MyISAM engine, enabling the "MyISAM Optimisations" option can also enhance performance.

If you are unsure which storage engine your database uses or which optimisation to choose, it is generally recommended to enable these options by default. You can always adjust them later based on your workload or resource usage.