2012-03-24, 06:00 PM
2012-03-24, 06:14 PM
Each have their own advantages and disadvantages.
Unless you're experiencing table locking issues you don't need InnoDB. InnoDB provides row-level locking which is recommended for tables which see a high number of inserts.
For most forums sticking with MyISAM will suffice.
Unless you're experiencing table locking issues you don't need InnoDB. InnoDB provides row-level locking which is recommended for tables which see a high number of inserts.
For most forums sticking with MyISAM will suffice.
2012-03-24, 06:15 PM
MyISAM is fine.
2012-03-24, 09:12 PM
MyASM gives you full text search (including using AND/OR to refine the search).
InnoDB provides row-level locking and foreign key constraints.
InnoDB provides row-level locking and foreign key constraints.
2012-03-24, 09:48 PM
The biggest thing about InnoDB is the lack of full text indexes, but if you are on a VPS or dedicated box where you would notice benefits from moving to InnoDB, you should be using Sphinx search anyway so no full text in MyBB itself is fine.
2012-06-17, 08:31 AM
I tried to change my database to InnoDB because i had performance issues on my website (mysql overloaded).
But the database operation became too slow, and I had another issue because my host doesn't allow many connection on mysql at the same time...
Finally, I've move my DB to MySQL5.5, keeping MyISAM (except for the session table to MEMORY / HEAP), and everything is now fine
But the database operation became too slow, and I had another issue because my host doesn't allow many connection on mysql at the same time...
Finally, I've move my DB to MySQL5.5, keeping MyISAM (except for the session table to MEMORY / HEAP), and everything is now fine