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
What is bigint in mysql?
Explain % and _ inside like statement?
What is the role of a limit in a mysql query?
How do I switch users in mysql?
What are the differences between char and varchar?
How to use like conditions?
What is mysql community server?
How to upload a large file through phpmyadmin in mysql?
How to declare variable in mysql trigger?
How is mysql database stored?
Write a query to retrieve a hundred books starting from 20th.
What is mysql57?
Where the database is stored in mysql?
Why does mysql have so many connections?
What is difference between mysql and mysqli?