Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff b/w MYISAM and INNODB storage engine. and also
define the benifits and drawbacks of both storage engine
- 1 Answers
- 3730 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
Is mysql still popular?
What is database migration in mysql?
How do I check mysql version?
How do I run mysql without installing?
How do I setup mysql?
What are the different mysql database engines?
What are the types of queries?
How to shut down the server with 'mysqladmin'?
How to create table show example
What is the date format in mysql?
What is the latest version of php and mysql?
Can you tell how to find the number of rows in a resultset using php?
What are the differences between char and varchar data types?
How can you handle the –secure-file-priv in mysql?
Does mysql support nosql?
