MySQL: Optimizing MySQL 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 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 relies on the InnoDB storage engine, you can enable the "InnoDB Optimizations" option within the Stackhero dashboard to help boost performance.

Similarly, if your database uses the MyISAM storage engine, activating the "MyISAM Optimizations" option can provide performance improvements.

If you are unsure which storage engine your database uses or which optimization option to select, it is generally safe to enable these options by default. You can always fine-tune them later based on your workload or resource usage.