what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage




Answers were Sorted based on User's Feedback



what is the difference between MyISAM and INNO DB in MySQL with the Advantage and disadvantage..

Answer / tushar

MyISAM and InnoDB are storage engines in MySql.
MyISAM does not support transactions while InnoDB support
it.

Is This Answer Correct ?    27 Yes 3 No

what is the difference between MyISAM and INNO DB in MySQL with the Advantage and disadvantage..

Answer / 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

what is the difference between MyISAM and INNO DB in MySQL with the Advantage and disadvantage..

Answer / sreedevi yadav

InnoDb table take More Disk space Comparing with MyISAM
InnoDB is Transactions safe means Data Integrity is
maintained Throughout entire qry process.
InnoDB also provides Row-locking as opposed to table
locking while 1 qry is busy with updating or inserting
arow,another qry can update a different row at the same
time.these features increases the multi user concurrency
and Performance
Another greate feature is InnoDB boasts is the ability to
use Foreign key constraints

Is This Answer Correct ?    8 Yes 2 No



Post New Answer



More MySQL Interview Questions

How to store binary data in mysql?

0 Answers  


How many rows can mysql hold?

0 Answers  


Where is the mysql data directory?

0 Answers  


What is the use of mysql workbench?

0 Answers  


How to make a copy values from one column to another in mysql?

0 Answers  






How can we repair a MySQL table?

2 Answers   Infosys,


How to rename an existing table in mysql?

0 Answers  


How to concatenate two character strings?

0 Answers  


How do I show all mysql databases?

0 Answers  


maximum size of a database in mysql?

2 Answers  


How do I grant privileges to a user in mysql phpmyadmin?

0 Answers  


How does mysql encrypt passwords?

0 Answers  






Categories