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

Answer Posted / prathiba



1.Transactions:MYISAM doesnt support any database
transactions means if the transactions related to large
amount of data transfer it will not provide because memory
is less. But INNODB will provide transactions.

2.Locking:MYISAM provide the table level locking means if
the data in one table has been modified by the other
table ,the entire table will lock for the next process.But
INNODB provide the row level locking only the row of the
table that is being updated is locked.

3.Foreign keys – MYISAM tables do not support foreign keys.

4.Data Types:MYISAM provide a full variety of datatypes,but
INNODB will not.

Is This Answer Correct ?    62 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does insert statement lock the table?

724


What does mysql_query return?

747


How do I rename a procedure?

671


write a command to view the content of the table

718


How do I download mysql?

681


What is a crosstab query?

737


Which statement is used in a select query for partial matching?

894


How do you kill a long running query in mysql?

675


How to drop an existing table in mysql?

760


What is a tinyint?

734


Can mysql store files?

719


What are the advantages of myisam over innodb?

771


What are the technical specifications of mysql?

913


How big is a blob mysql?

702


Does mysql use tcp or udp?

722