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

InnoDB or MyIsam?

Discussion in 'Installation, Upgrade, and Import Support' started by Anthony Parsons, Jun 28, 2012.

  1. Anthony Parsons

    Anthony Parsons Well-Known Member

    When I changed over the XF, it was right from beta... importing from VB. The majority of tables when created where myisam, where now when XF is fresh installed, they're innodb.

    I am wondering how much difference there is, because it seems my host is telling me that my database is often getting stuck on an insert or read, which is creating a lot of my load issues.

    Is it this older DB structure that could be the issue? Can existing tables be changed to innodb with a live site?
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    InnoDB is more scalable. MyISAM can become increasingly slow on large forums (~1 million posts).

    Posts by Kier:


    Good question. I'm gonna ask the others to see if there are any special considerations here.
    Anthony Parsons likes this.
  3. Deebs

    Deebs Well-Known Member

    Yes, you can convert a live site to innodb, depending upon the table size it can block so it would be best to shut the site and do the conversion.
    Anthony Parsons and CyclingTribe like this.
  4. Anthony Parsons

    Anthony Parsons Well-Known Member

    Thank you both... I will look at Kiers instructions and make some changes.
  5. CyclingTribe

    CyclingTribe Well-Known Member

    You might want to check your my.cnf file first to ensure InnoDB isn't skipped (and if it is, get it enable and setup) and also to double-check your InnoDB settings. (y)
    Anthony Parsons likes this.
  6. Anthony Parsons

    Anthony Parsons Well-Known Member

    Innodb is enabled on my server and it is functional, though being one who converted right from beta, I have a funny feeling XF changed to innodb along the way, after I had imported vb4.x into xf beta, hence a majority of my tables are myisam... though newer tables that xf have added during releases, some are InnoDB, at a rough guess being the point XF changed to that structure the majority of tables.
  7. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    XF always used InnoDB, even in the 1.0 betas. I went back and checked those older versions.
    Anthony Parsons and TheVisitors like this.
  8. Anthony Parsons

    Anthony Parsons Well-Known Member

    Interesting... will do some changes and see what happens.

Share This Page