KNOWNHOST WIKI

User Tools

Site Tools


resources:check-wordpress-database-tables

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

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 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.

resources/check-wordpress-database-tables.txt · Last modified: 2020/05/28 13:32 by Karson N.