KNOWNHOST KNOWLEDGE BASE

Hosting Question? Find the Solution - Browse our Guides, Articles, and How-To's

How to Know if Your WordPress Database Tables are MyISAM or InnoDB?

Category: WordPress
Tags: # # # # # #

Option 1:

Login to phpMyAdmin, highlight your database and browse the tables. Check the “Type” column to see what type of tables they are…

Option 2:

Use phpMyAdmin SQL tab and run the query to find the tables that might still be MyISAM:

  SELECT TABLE_NAME, ENGINE
  FROM information_schema.TABLES
  WHERE TABLE_SCHEMA = 'yourdatabasename' and ENGINE = 'MyISAM';

Why Change WordPress Database from MyISAM to InnoDB?

Depending on when you installed WordPress and what’s transpired since then, it could be that some, or all, of your database tables are still MyISAM. While this is perfectly acceptable – many sites have run MyISAM for ages, there are some reasons to consider moving over to InnoDB.

InnoDB is a generational step forward from MyISAM, providing features like transaction handling, foreign key constraints (so that it’s a relational database) and row level locking. Performance benchmarks show InnoDB to be the favorite as well. If you would like to learn more about the differences between MyISAM and InnoDBs WordPress Database read here.

Conclusion

Now that we’ve gone over how to check what database tables WordPress is set to. Use our knowledge base to get other helpful articles, or contact support to get help now.

KnownHost offers 365 days a year, 24 hours a day, all 7 days of the week best in class technical support. A dedicated team is ready to help you should you need our assistance. You’re not using KnownHost for the best web hosting experience? Well, why not? Check with our Sales team to see what can KnownHost do for you in improving your web hosting experience.

Related Articles: