Your website shouldn’t be going too slow. Make sure you’re also performing all of [these](https://wp-power.org/wordpress-performance/ultimate-
You can convert to InnoDB by opening up the Cloudways control panel and going to your website > access details, and then launch the database manager. Under the Engine column, it probably already says that each table is using InnoDB, but if you’re not, click on “SQL command” in the sidebar, and run the command.
SET @DATABASE_NAME = '<YOUR DB NAME HERE>';
SELECT CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements
FROM information_schema.tables AS tb
WHERE table_schema = @DATABASE_NAME
AND `ENGINE` = 'MyISAM'
AND `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;
<YOUR DB NAME HERE> with your DB name.
This won’t do anything yet though. Running this will simply output additional commands that you will need to run. You can run all of these additional commands at the same time.
While your at it, you can also make sure that you are using the same collation everywhere. Below is the command for that. Same thing, replace
<YOUR DB NAME HERE>, and copy and paste the output, and run the output of this query as another command. You can also replace
utf8mb4_unicode_ci with whatever collation you would like to use. I don’t know the benefits of the different collations, but I do know that you should be using the same collation everywhere for faster joins.
SELECT CONCAT("ALTER TABLE ", TABLE_SCHEMA, '.', TABLE_NAME," COLLATE utf8mb4_unicode_ci;") AS ExecuteTheString
WHERE TABLE_SCHEMA="<YOUR DB NAME HERE>"
AND TABLE_TYPE="BASE TABLE";