should I convert some Innodb tables back to MyISAM?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Blackhorse
    Senior Member
    • Jul 2018
    • 298
    • 5.3.x

    should I convert some Innodb tables back to MyISAM?

    Hello,

    I have converted all my vbulletin tables to InnoDB

    But I've read now that i should not convert cpsession, session, language, phrase, thread, post, or userfield tables

    Should i restore them back to MyIsam?

    Thanx
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 74123

    #2
    The language, phrase and userfield tables should be MyISAM unless you're using MySQL 5.7 or higher. I don't know how MariaDB supports these tables under InnoDB.

    There is no issue with converting cpsession or session to InnoDB. Changing these two tables to MyISAM will cripple your website.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • Blackhorse
      Senior Member
      • Jul 2018
      • 298
      • 5.3.x

      #3
      Yes I have MySQL 5.7

      So, I keep them all InnoDB if i get it right

      Comment

      Related Topics

      Collapse

      Working...