what is the main difference between myisam and innodb

Question Posted / dharma teja

2 Answers
5508 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the main difference between myisam and innodb..

both myisam and innodb are storange enginein sql.
innodb support transaction, foreign key while myisam not
support transaction.

Is This Answer Correct ?

7 Yes

0 No

what is the main difference between myisam and innodb..

Answer / ranganath

Other differences are :

1. innodb requires more RAM than mysiam
2. myisam relies on OS for caching while innodb caches with
in the engine itself.

3. Most preffered is innodb because

- Transaction safe
-It has commit, rollback, and crash recovery capabailities
- Innodb is designed for maximum performance when processing
large volumes of data.

Is This Answer Correct ?

4 Yes

0 No

Post New Answer