Jump to the post that solved this thread.
Solved: 1 Year, 2 Weeks ago MyISAM or InnoDB for MyBB?
#7
Solved: 1 Year, 2 Weeks ago
Thank you for the pointers @Dragonexpert.

We switched it to InnoDB last night. My board is fairly small (about 5-6 members and about ~50 guests online during peak hours). We did not have many concurrency issues with the size of the board, but we had random problems with pages sometimes freezing during busier hours.

InnoDB seems to be doing well. I was very surprised to find that after we increased the buffer pool size, the performance was actually better than MyISAM. I've always heard the opposite, but we saw about a 5% reduction in page generation times and about ~20% increase in general query performance.

If anyone is looking at this thread to get an idea, we found that it worked very poorly unless we increased the buffer pool size. If you have adequate RAM designated towards the database, it outperformed MyISAM for us.

Thanks for the advice everyone!
Reply
Jump to the post that solved this thread.


Messages In This Thread
MyISAM or InnoDB for MyBB? - by Darth Apple - 2020-04-22, 12:24 PM
RE: MyISAM or InnoDB for MyBB? - by kawaii - 2020-04-22, 12:59 PM
RE: MyISAM or InnoDB for MyBB? - by NoRules - 2020-04-22, 01:27 PM
RE: MyISAM or InnoDB for MyBB? - by WallBB - 2020-04-22, 01:36 PM
RE: MyISAM or InnoDB for MyBB? - by Darth Apple - 2020-04-22, 09:46 PM
RE: MyISAM or InnoDB for MyBB? - by dragonexpert - 2020-04-23, 05:46 PM
RE: MyISAM or InnoDB for MyBB? - by Darth Apple - 2020-04-23, 09:52 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)