InnoDB (5 posts)

  1. yz
    Posted 5 years ago #

    Hi, can WordPress use InnoDB? If so, how do I tell WordPress to use InnoDB? If I have an existing database, how do I migrate it to InnoDB? (I tried simply dumping and loading back the tables but with ENGINE=innodb instead of myisam, but that doesn't work.)

  2. yz
    Posted 5 years ago #

    Just to add some more info on the specific error I got, it was that FULLTEXT indexes are not supported by innodb.

  3. lury
    Posted 5 years ago #

    yes, you cannot use fulltext indexes with innodb so you better switch to some search engine or use google search on your site.

    read this first: http://www.619cloud.com/blog/5-essential-steps-for-hosting-wordpress/

    you have script to generate sql to convert engine for each table

  4. yz
    Posted 5 years ago #

    Turns out that WP *is* compatible with InnoDB - it was just a plugin I was using (YARP) that relied on fulltext indexes.

  5. davidmstokes
    Posted 4 years ago #

    InnoDB supports full-text searches starting with 5.6,

    And you can use the MySQL statement 'ALTER TABLE wp_posts ENGINE=Innodb' to convert the tables.

Topic Closed

This topic has been closed to new replies.

About this Topic