Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage
- 3 Answers
- 9522 Views
- ABC, I also Faced
- E-Mail Answers
Answer Posted / sanjeev chauhan
InnoDB: Row level locking, Transaction support, forgin key
constrant and crash recovery.
MyISAM: Much more conservate approach to disk space
management each MyISAM table store in a separate file. in
MyISAM memory and space usage, full text indexing support,
table based locking, bulk insert capabilities and speed are
plus factor but crushes recovery would be the horror story.
As general approach, if you have a more reads use MyISAM and
if you have a more update use InnoDB.
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
Is mysql a server or database?
How do I view mysql logs?
What is a result set object?
How to display odd rows in student table in mysql?
How do I insert multiple rows in a table?
How to change a password for an existing user via mysqladmin?
What are the two types of queries?
In which format data is stored in mysql database?
What is a tinyint in mysql?
Differentiate CHAR_LENGTH and LENGTH?
What is maximum table size in mysql?
What is mysql root?
What is striped backup
How do I edit a table in mysql?
what is cte? : Mysql dba
