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 a join in mysql?

861

Differentiate CHAR_LENGTH and LENGTH?

947

What is slow query log in mysql?

1046

all the queries used in sql

2607

How will you export tables as an xml file in mysql?

848

How do I setup mysql?

860

What is the difference between the primary and unique key in mysql?

939

Is mysql a programming language?

845

What is blob datatype in mysql?

907

How to enter microseconds in sql statements?

942

How do I make an action query?

877

Can mysql and mariadb coexist?

1036

How to convert character strings to numeric values?

1071

How do I change global variables in mysql?

866

What is mysql uuid?

890