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

How many mysql connections can handle?

668


How to write after insert event update trigger on the same table in mysql?

731


What is mysql protocol?

675


What is the current root password of mysql?

671


What is back end and front end?

684


What is a blob datatype?

648


Does mysql need a server?

687


How can you make a database as your current database?

699


How to get a list of columns in an existing table?

676


State the differences between mongodb and mysql.

795


How do I clear the command in mysql?

703


What is current version of mysql?

694


How do I install mysql on windows 10 64 bit?

657


What is difference between mysql_connect and mysql_pconnect?

749


In mysql, what is joins? Explain

749