When is it appropriate to use InnoDB table types? What about for a forum such as this one with huge post and thread and memberlist tables? I was reading on dev.mysql.com that it is more efficient than MyISAM for large table types? Is this always the case? Would it make sense to mix and match MyISAM and InnoDB table types in my database based on the number of rows in the table?
Dani
4,074
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Recommended Answers
Jump to PostThe way we typically back up MySQL at work is to run MySQL with replication between two systems, and once a day we bring down the mysql instance on the passive box and perform a file-level backup.
It gets really touchy if the two somehow get out of sync …
Jump to Postthis thread was very helpful thanks a lot dani
Jump to PostHere is some information about this: http://dev.mysql.com/doc/refman/5.0/en/table-locking.html
There is another very good reason to use INNODB: concurrency. If you are going o have multiple users updating (different rows of) the same table concurrently, …
Jump to PostHere is some information about this: http://dev.mysql.com/doc/refman/5.0/en/table-locking.html
I had really only ever seen the MyISAM engine in use but when I installed MySQL Workbench it defaults to the innodb engine and that led …
Jump to PostYep, the conclusion is:
if your table is mainly Read: MyISAM better because faster
if your table is mainly Write: InnoDB better because faster, especially for concurrency:
MyISAM or InnoDB?
All 30 Replies
Troy
35
Posting Whiz
Dani
4,074
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Troy
35
Posting Whiz
Dani
4,074
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Dani
4,074
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Troy
35
Posting Whiz
Dani
4,074
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Dani
4,074
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Crirus
0
Newbie Poster
Stylish
1
Junior Poster
Dani
4,074
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
purefusion
0
Newbie Poster
anjama
0
Newbie Poster
Stylish
1
Junior Poster
anjama
0
Newbie Poster
Dani
4,074
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
jbcrawford
0
Newbie Poster
spirilis
0
Newbie Poster
cfry
0
Light Poster
chandranshu
0
Newbie Poster
mwasif
10
Posting Whiz
lizzeelike
0
Newbie Poster
salami1_1
0
Newbie Poster
Sword
0
Newbie Poster
markainsworth
0
Newbie Poster
ppetree
2
Junior Poster
bottomless
0
Newbie Poster
cardi777
0
Newbie Poster
Indurajput
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.