Current time: 04-24-2014, 01:17 AM Hello There, Guest! (LoginRegister)


Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[General] MYSAM or InnoDB?
03-24-2012, 06:00 PM
Post: #1
Not Solved Toungue MYSAM or InnoDB?
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?
Find all posts by this user
Quote this message in a reply
03-24-2012, 06:14 PM
Post: #2
Not Solved RE: MYSAM or InnoDB?
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.
Visit this user's website Find all posts by this user
Quote this message in a reply
03-24-2012, 06:15 PM
Post: #3
Not Solved RE: MYSAM or InnoDB?
MyISAM is fine.

Please rep me if I helped you Smile
Find all posts by this user
Quote this message in a reply
03-24-2012, 09:12 PM
Post: #4
Not Solved RE: MYSAM or InnoDB?
MyASM gives you full text search (including using AND/OR to refine the search).
InnoDB provides row-level locking and foreign key constraints.
Find all posts by this user
Quote this message in a reply
03-24-2012, 09:48 PM
Post: #5
Not Solved RE: MYSAM or InnoDB?
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.
Visit this user's website Find all posts by this user
Quote this message in a reply
06-17-2012, 08:31 AM (This post was last modified: 07-08-2012 08:24 AM by Goose.)
Post: #6
Not Solved RE: MYSAM or InnoDB?
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
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication