XF 1.5 Converting all tables to MyISAM Engine

[Babak Ajideh]

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

 

[Mike]

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]

Thank you so much

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

 

[Mike]

No, but we use transactions.

 

[Babak Ajideh]

So it has to be InnoDB.

Appreciate it.