Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted July 21, 20159 yr Hi,I am currently upgrading my forum to 4.0.10 from 3.4.x. I performed this upgrade in my local machine once to simulate the upgrade.However, I was wondering if the forum could be moved from innodb to MyISAM. My forum's DB is almost 4GB and even I've read and I've been told that working with InnoDB could be a nightmare if my dedicated server is not powerful enough. Mine, indeed, is not that powerful and my sysadmin told me that could be tough to manage.Currently my forum sometimes was having DB issues and had to execute mysqlcheck and that kind of jobs almost daily. InnoDB is supposed to be quite tough when table corruptions are occurred.I was wondering if it was possible to migrate innodb to myisam and how is performance with IPB4.0 and this config. Is it possible to do this quickly? Or is it a long job?Regards,Ibai
July 21, 20159 yr You have read wrong. Innodb is better in almost every aspect, including in low resource server. You just need to tune your mysql for innodb.
July 23, 20159 yr From what I've seen InnoDB is faster, though it does like a rather large amount of RAM for caches to run optimally!
Archived
This topic is now archived and is closed to further replies.