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
What is mysql used for?
How do you select a table?
How can you plan the logshipping before processing?
How to make a copy values from one column to another in mysql?
What are the two types of queries?
Where does mysql store data?
What is cursor in mysql?
What are mysql functions?
What are the method you will follow while sql installing
What are federated tables?
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
What are the 5 r's of managing behaviors?
How to declare variable in mysql trigger?
What is a crosstab query?
How does php communicate with mysql?