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
- 44505 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 the insert?
How do you name a table?
What does mysql flush privileges do?
What is the maximum connection pool size?
Which is faster mongodb or mysql?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
What are the benefits of mysql?
How to start mysql server?
What is database engine in mysql?
What is 'mysqldump'?
SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?
What is mysql root?
What is key in mysql?
How to get the number of rows selected or affected by a sql statement?
How do I install and use mysql?
