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
Is mysql a dbms?
How do I find the database name in mysql?
What is a join in mysql?
Can you tell which of the following where clauses is faster?
How do I stop a mysql command?
How do I flush privileges in mysql?
What is append query?
What is the storage engine for mysql?
Is mysql frontend or backend?
How to use like conditions?
How we can get distinct columns values in mysql?
What are the differences between binary and varbinary?
How many sql ddl commands are supported by 'mysql'?
What is truncate command?
Is mysql a framework?