Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

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?

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

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.

share|improve this answer
    
Shall i keep it that way or change back to MyISAM? –  EApubs Aug 26 '12 at 12:03
    
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 Aug 26 '12 at 12:09
3  
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 Aug 26 '12 at 14:23
add comment

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.

share|improve this answer
    
@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 Jun 13 '13 at 17:48
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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