7

I just created a new WordPress site in my server. Normally, WordPress uses MyISAM as the database type. But this time, it created all InnoDB tables! Is this normal? Has WordPress switched to InnoDB in the latest versions?

2 Answers 2

9

WordPress actually specifies no table type in the create statements, so it uses MySQL's default table engine which is InnoDB from version 5.5 onwards.

4
  • Shall i keep it that way or change back to MyISAM?
    – THpubs
    Commented Aug 26, 2012 at 12:03
  • 1
    That's up to you and depends on your use case - there's a lot of discussion that you can find via Google, but in most cases InnoDB simply is faster.
    – kaiser
    Commented Aug 26, 2012 at 12:09
  • 5
    InnoDB is fine, for most cases. Some search plugins will try to add FULLTEXT indexes, and you may need to convert some tables to MyISAM to be able to add those indexes, but if you don't need FULLTEXT then it generally doesn't matter much.
    – Otto
    Commented Aug 26, 2012 at 14:23
  • 2
    @Otto: Beating the dead horse: Using since Mysql 5.6 there is FULLTEXT support in InnoDB. (ref: percona.com/blog/2013/02/26/…). Just adding up.
    – hakre
    Commented Feb 13, 2017 at 23:25
1

It matters when it comes to backing up your Wordpress site. I learned this the hard way. If the DB is innodb then R1 cloud restore type backups won't save all the data because it has to be shut down first in order to back it up. Whereas MYISAM can be backed up no problem.

3
  • @s_ha_dum Never mind, it's useful and should stay here. Only problem: Is there a source or was that learned the hard way? If there's a source, would you mind linking to it?
    – kaiser
    Commented Jun 13, 2013 at 17:48
  • This is true for raw backups, but normaly you don't do raw backups of a MySQL database but create a dump instead.
    – Bachsau
    Commented Dec 16, 2018 at 7:37
  • Mariabackup can make "hot online" backups of InnoDB in MariaDB.
    – Paul
    Commented May 22, 2022 at 18:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.