Converting MySQL Storage Engine from MyISAM to InnoDB (via phpMyAdmin)
Reference Link: https://kinsta.com/knowledgebase/convert-myisam-to-innodb/. Using phpMyAdmin https://my.wpengine.com/installs/websitename/phpmyadmin you can count and grab a list of tables needing conversion from WP Engine’s production database using the following.
SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA,'.', TABLE_NAME, ' ENGINE=InnoDB;') FROM information_schema.TABLES WHERE ENGINE = 'MyISAM'
Select “show all” and then under Options select “Full texts” as shown.
Copy and run the outputted SQL on the production database.
Converting MySQL Storage Engine from MyISAM to InnoDB (via SSH & WP-CLI)
wp db query "SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA,'.', TABLE_NAME, ' ENGINE=InnoDB;') FROM information_schema.TABLES WHERE ENGINE = 'MyISAM'" --skip-column-names > db_optimize.sql
wp db query < db_optimize.sql
rm db_optimize.sql