My ISAM or InnoDB

  • Resolved davi8r

    (@davi8r)


    3 years, 10 months ago

    While doing some database maintenance I noticed that wpForo has 8 tables that are MyISAM. All other tables in my site’s database are InnoDB.

    I can convert these tables to InnoDB but, before doing so, I wanted to ask if there’s a reason why 8 wpForo tables would be MyISAM, and possibly should be left as such?

    Thank you,
    — Dave

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author gVectors Team

    (@gvectors-team)

    Hi @davi8r,
    It depends on your MySQL version. If you use 5.6 and higher, all tables should be InnoDB except these tables:

    • wp_wpforo_accesses
    • wp_wpforo_languages
    • wp_wpforo_likes
    • wp_wpforo_phrases
    • wp_wpforo_usergroups
    • wp_wpforo_visits
    • This reply was modified 3 years, 10 months ago by gVectors Team.
    Thread Starter davi8r

    (@davi8r)

    Hi,

    Thank you for the list of MyISAM tables. Comparing my configuration, there are 3 MyISAM tables to convert to InnoDB. They are:

    mg2wpforo
    wpforo_tags
    wpforo_votes

    MySQL Version 5.7.34

    I’ll backup the database and convert these 3 tables to InnoDB in a few days, and let you know how it goes.

    Thanks again. I appreciate your responsiveness!

    — Dave

    Plugin Author gVectors Team

    (@gvectors-team)

    Ok, sorry for the delayed reply. BTW, for faster support, please use wpForo Support forum: https://wpforo.com/community/

    The mg2wpforo can be removed, it was used for forum migration process.

    Thread Starter davi8r

    (@davi8r)

    Hello gVectors,

    I wanted to let you know that I converted wpforo_tags and wpforo_votes to InnoDB; and dropped the mg2wpforo table from my database. After several days of testing, everything is working fine with no errors.

    Thank you for your responsiveness including clear & accurate instructions of steps I can (and have) taken to get the best performance out of your amazing plugin!

    My question has been resolved so this thread can be closed.

    Best regards,
    — Dave
    https://www.legal.com/community

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘My ISAM or InnoDB’ is closed to new replies.