What is diff b/w MYISAM and INNODB storage engine. and also
define the benifits and drawbacks of both storage engine
Answer Posted / rajanikanth
1)MYISAM does not support the foreign key constraint and
transaction but InnoDB support it.
2)MYISAM is faster then the InnoDB but in case of perforing
the count operation it takes more time then the InnoDB.
3) MYISAM occupies less memory sapce for tables rather than
InnoDB tables.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why is mysql popular?
Which is better mysql or mssql?
Is there a way to see the files which are stored?
What is a delimiter in mysql?
State the differences between mongodb and mysql.
How do I remove a user from mysql?
How do I transfer data from one database to another in mysql?
What is mysql57?
How do I start mysql manually?
How can I insert images into a Mysql database?
How do I edit a trigger in mysql?
What is truncate in mysql?
What is the difference between truncate and delete?
Which is faster innodb or myisam?
What is the difference between sql and mysql and oracle?