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
How to use like conditions?
How to display top 10 rows in mysql?
What is mvcc in mysql?
What is max connections in mysql?
What is clob datatype?
How to get a version of mysql?
Can we join 3 tables in mysql?
Is null in mysql?
Why does mysql have so many connections?
What is horizontally scalable?
What is indexing in mysql?
What is difference between function and procedure in mysql?
How can we change the data type of a column of a table?
What is row?
What is deterministic in mysql?