InnoDB or MyIsam?

[Anthony Parsons]

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?

 

[Jake Bunce]

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

Posts by Kier:

http://xenforo.com/community/threads/changing-tables-from-myisam-to-innodb.14476/#post-189581
http://xenforo.com/community/threads/innodb-or-myisam-what-is-better-for-xenforo.13575/#post-178294

Can existing tables be changed to innodb with a live site?

Good question. I'm gonna ask the others to see if there are any special considerations here.

 

[Deebs]

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]

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

 

[CTXMedia]

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

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.

 

[Anthony Parsons]

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.

 

[Jake Bunce]

XF always used InnoDB, even in the 1.0 betas. I went back and checked those older versions.

 

[Anthony Parsons]

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