myisam supports table level locking where as innoodb supports only row lev

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

Question Posted / dharma teja

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

Please Help Members By Posting Answers For Below Questions

What is mysqli procedural?

1004

How can you move the master database

2095

What is unsigned in mysql?

987

Where is mysql used?

1033

What is required to create mysql database?

1032

What are the functions of commit and rollback statements?

1103

How can you find out the version of the installed mysql?

1372

What is the use of count function in mysql?

1073

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

993

What is delimiter $$?

1020

How can we optimize stored procedure?

1012

What is a storage engine?

1015

How do I run mysql from command line?

1104

What are the differences between binary and varbinary?

1125

What are triggers mysql?

947