WordPress.org

Forums

Can I convert all tables from MyISAM to InnoDB? (2 posts)

  1. leitmedium
    Member
    Posted 11 months ago #

    Hey,

    I have a multisite running with several and wondered why it uses MyISAM and InnoDB at the same time:

    mysql> select TABLE_NAME, ENGINE from information_schema.TABLES WHERE TABLE_SCHEMA='wordpress';
    +--------------------------+--------+
    | TABLE_NAME               | ENGINE |
    +--------------------------+--------+
    | wp_2_commentmeta         | MyISAM |
    | wp_2_comments            | MyISAM |
    | wp_2_links               | MyISAM |
    | wp_2_options             | MyISAM |
    | wp_2_postmeta            | MyISAM |
    | wp_2_posts               | MyISAM |
    | wp_2_term_relationships  | MyISAM |
    | wp_2_term_taxonomy       | MyISAM |
    | wp_2_terms               | MyISAM |
    | wp_3_commentmeta         | MyISAM |
    | wp_3_comments            | MyISAM |
    | wp_3_links               | MyISAM |
    | wp_3_options             | MyISAM |
    | wp_3_postmeta            | MyISAM |
    | wp_3_posts               | MyISAM |
    | wp_3_term_relationships  | MyISAM |
    | wp_3_term_taxonomy       | MyISAM |
    | wp_3_terms               | MyISAM |
    | wp_4_commentmeta         | MyISAM |
    | wp_4_comments            | MyISAM |
    | wp_4_links               | MyISAM |
    | wp_4_options             | MyISAM |
    | wp_4_postmeta            | MyISAM |
    | wp_4_posts               | MyISAM |
    | wp_4_term_relationships  | MyISAM |
    | wp_4_term_taxonomy       | MyISAM |
    | wp_4_terms               | MyISAM |
    | wp_5_commentmeta         | MyISAM |
    | wp_5_comments            | MyISAM |
    | wp_5_links               | MyISAM |
    | wp_5_options             | MyISAM |
    | wp_5_postmeta            | MyISAM |
    | wp_5_posts               | MyISAM |
    | wp_5_term_relationships  | MyISAM |
    | wp_5_term_taxonomy       | MyISAM |
    | wp_5_terms               | MyISAM |
    | wp_6_commentmeta         | InnoDB |
    | wp_6_comments            | InnoDB |
    | wp_6_links               | InnoDB |
    | wp_6_options             | InnoDB |
    | wp_6_postmeta            | InnoDB |
    | wp_6_posts               | InnoDB |
    | wp_6_term_relationships  | InnoDB |
    | wp_6_term_taxonomy       | InnoDB |
    | wp_6_terms               | InnoDB |
    | wp_7_commentmeta         | InnoDB |
    | wp_7_comments            | InnoDB |
    | wp_7_links               | InnoDB |
    | wp_7_options             | InnoDB |
    | wp_7_postmeta            | InnoDB |
    | wp_7_posts               | InnoDB |
    | wp_7_term_relationships  | InnoDB |
    | wp_7_term_taxonomy       | InnoDB |
    | wp_7_terms               | InnoDB |
    | wp_8_commentmeta         | InnoDB |
    | wp_8_comments            | InnoDB |
    | wp_8_links               | InnoDB |
    | wp_8_options             | InnoDB |
    | wp_8_postmeta            | InnoDB |
    | wp_8_posts               | InnoDB |
    | wp_8_term_relationships  | InnoDB |
    | wp_8_term_taxonomy       | InnoDB |
    | wp_8_terms               | InnoDB |
    | wp_blog_versions         | MyISAM |
    | wp_blogs                 | MyISAM |
    | wp_commentmeta           | MyISAM |
    | wp_comments              | MyISAM |
    | wp_domain_mapping        | MyISAM |
    | wp_domain_mapping_logins | MyISAM |
    | wp_links                 | MyISAM |
    | wp_options               | MyISAM |
    | wp_postmeta              | MyISAM |
    | wp_posts                 | MyISAM |
    | wp_registration_log      | MyISAM |
    | wp_signups               | MyISAM |
    | wp_site                  | MyISAM |
    | wp_sitemeta              | MyISAM |
    | wp_term_relationships    | MyISAM |
    | wp_term_taxonomy         | MyISAM |
    | wp_terms                 | MyISAM |
    | wp_usermeta              | MyISAM |
    | wp_users                 | MyISAM |
    +--------------------------+--------+
    82 rows in set (0.01 sec)

    As I prefer InnoDB over MyISAM and moreover prefer to tune a MySQL for one engine only, I'd like to convert all tables to InnoDB by a simple ALTERNATE TABLE. Is there any reason against doing this?

    Best.

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

    Which is to say if you changed your DB on the server, it would do this.

    https://dba.stackexchange.com/questions/58998/myisam-with-innodb-in-the-same-wordpress-database-reduce-performace

Reply

You must log in to post.

About this Topic