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

Which statement is used to delete a table in MySQL.

476


How do I download a mysql community server?

442


What is blob datatype in mysql?

478


Can we store pdf files in mysql?

464


What is maximum table size in mysql?

473






What is the difference between primary key and candidate key?

504


In which year mysql created?

525


How we get sum of column.

501


What is clob datatype?

474


What is blob storage?

492


Is mysql a framework?

483


What is prepared statement in mysql?

480


What is a string in mysql?

461


Is mariadb better than mysql?

544


What is mysqlcommand?

473