what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ?

Answer Posted / dharma teja

myisam supports table level locking where as innoodb
supports only row level locking when updated

Is This Answer Correct ?    32 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a data directory?

515


How many TRIGGERS are allowed in MySql table?

587


Does mysql case matter?

497


What does mysql_fetch_assoc do?

520


How can you export the table as an xml file in mysql?

504






Is mariadb faster than mysql?

469


table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

794


What are the critical issues you have resolved in your company

1762


Do you need a license for mysql?

516


How many rows we can insert in a mysql table?

490


Can we write pl sql mysql?

506


How many columns can be used for creating Index?

578


How do I view data in mysql workbench?

513


Is postgresql better than mysql?

518


How to get last inserted id after insert data from a table in mysql?

549