1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.5 Converting all tables to MyISAM Engine

Discussion in 'XenForo Questions and Support' started by Babak Ajideh, Oct 23, 2015.

  1. Babak Ajideh

    Babak Ajideh Member

    Hello Everyone,

    Does converting all tables to MyISAM have any negative impact on xenforo functionality?

    I know that the InnoDB has some performance advantages over MyISAM, but i need to know regardless of the performance and speed, is there any major problem to use MyISAM for all tables or not?

    Babak
     
  2. Mike

    Mike XenForo Developer Staff Member

    Major problems? No.

    But I would strongly dissuade you from making a change like this. Aside from the fact that MyISAM is just not a great storage engine, XF is developed using InnoDB so that's what's expected.
     
    Babak Ajideh and Chris D like this.
  3. Babak Ajideh

    Babak Ajideh Member

    Thank you so much

    Does the database use foreign keys to update and delete entries such as threads, posts, and etc?
     
  4. Mike

    Mike XenForo Developer Staff Member

    No, but we use transactions.
     
    Babak Ajideh likes this.
  5. Babak Ajideh

    Babak Ajideh Member

    So it has to be InnoDB.

    Appreciate it.
     

Share This Page