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

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


Please Help Members By Posting Answers For Below Questions

Why is mysql used?

506


What is cursor in mysql?

465


Can mysql store files?

476


What is the difference between timestamp and datetime in mysql?

528


What is csv?

497






What is the purpose of using a heap table?

512


what is the difference between gui testing and database testing? : Mysql dba

506


Is mysql free software?

477


What is mysqli_select_db?

497


Is mariadb better than mysql?

527


How to add a new column to an existing table in mysql?

507


What is orm in mysql?

449


What is memory table in mysql?

477


How show all tables in mysql query?

460


What are views in mysql?

498