Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved [General] MYSAM or InnoDB?
#1
Not Solved Toungue 
This user has been denied support. This user has been denied support.
Which one of the two do you think are better?

I just switched to InnoDB, just to see the ins and outs. What are your opinions?
Reply
#2
Not Solved
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.
Reply
#3
Not Solved
MyISAM is fine.
Please rep me if I helped you Smile
Reply
#4
Not Solved
MyASM gives you full text search (including using AND/OR to refine the search).
InnoDB provides row-level locking and foreign key constraints.
Reply
#5
Not Solved
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.
Personal site: CommunityPlugins.com

Please do not PM me for MyBB support here. Use the forums, they are here for a reason. Thanks.
Reply
#6
Not Solved
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 Smile
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)