what is the main difference between myisam and innodb

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mysql used for?

517


How do you select a table?

485


How can you plan the logshipping before processing?

1845


How to make a copy values from one column to another in mysql?

565


What are the two types of queries?

447






Where does mysql store data?

444


What is cursor in mysql?

488


What are mysql functions?

495


What are the method you will follow while sql installing

1872


What are federated tables?

605


If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?

502


What are the 5 r's of managing behaviors?

619


How to declare variable in mysql trigger?

485


What is a crosstab query?

513


How does php communicate with mysql?

478