WordPress.org

Forums

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

  1. leitmedium
    Member
    Posted 1 year 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

Topic Closed

This topic has been closed to new replies.

About this Topic