What is diff b/w MYISAM and INNODB storage engine. and also
define the benifits and drawbacks of both storage engine
- 1 Answers
- 3376 Views
- I also Faced
- E-Mail Answers
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 mysql is open source?
How do you rename a procedure in mysql?
How do I automate a backup in mysql?
What is difference mysql and mysqli?
What is the difference between mysql and sql?
In which year mysql created?
Can we write procedure in mysql?
How can you retrieve a particular number of records from a table?
What are the steps involved in query processing?
How to insert dynamic values in mysql using php?
What are the disadvantages of mysql?
What is ddl, dml, and dcl?
Is mysql a backend?
What is schema in mysql?
How to use triggers to track changes in mysql?
