Interested to Buy Any Domain ? << Click Here >> for more details...
what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ?
- 10 Answers
- 44182 Views
- E2 Solutions, Tesco, I also Faced
- E-Mail Answers
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 mysql57?
What are triggers mysql?
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
How large can a mysql database become?
What is unsigned int in mysql?
How to insert html code into mysql database using php?
What is the difference between a database and a table?
Difference between CHAR and VARCHAR?
How can you change the password of a mysql user?
What storage engines are used in MySQL?
What are the technical features of MySQL?
Can you tell what are various ways to create an index?
Explain the difference between procedure and function in mysql?
Is mysql owned by oracle?
What is the return type of mysqli_query?
