How to Convert Database Tables Storage Engine from MyISAM to InnoDB

In this post, I will show you how to easily convert your WordPress database tables from the MyISAM engine to the InnoDB engine.

One of the biggest reasons that WordPress sites slow down because their database hasn’t been optimized. A lot number of older sites are still using the MyISAM storage engine in their database. A big reason to use InnoDB over MyISAM is the lack of full table-level locking. This allows your queries to process faster.

Are You Using MyISAM or InnoDB?

Check if any of your tables are using MyISAM instead of InnoDB

For WP-CLI

wp db query "SHOW TABLE STATUS WHERE Engine = 'MyISAM'" --allow-root

For MYSQL-CLI

In case if your host doesn’t support WP-CLI then you can use MySQL-CLI.

use $database; SHOW TABLE STATUS WHERE Engine = 'MyISAM';

Remember to change $database with your own database name

If the output is empty then there are no MyISAM tables, if you do get some results it will look like this: