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
How to write optimized query in mysql?
What is the difference between timestamp and datetime in mysql?
What are the security alerts while using mysql?
Which mysql function is used to concatenate string?
How do you rename a table in mysql?
How to find second highest salary from a table?
How to connect html form to mysql database using php?
what is constraints?
what is the difference between between and in operators in mysql?
What is a definer?
When to use order by in delete statement?
How to display top 10 rows in mysql?
What is mysql and how it works?
What are the steps involved in query processing?
What is mysql url?