Support » Networking WordPress » Can I convert all tables from MyISAM to InnoDB?

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

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Can I convert all tables from MyISAM to InnoDB?’ is closed to new replies.