what is the main difference between myisam and innodb
- 2 Answers
- 5530 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
How do I free up space in mysql?
Use mysqldump to create a copy of the database?
Explain the difference between mysql and mysql interfaces in php?
What mysql -u john -p command does?
What is index length in mysql?
How do I exit mysql?
what is the advantage of left outer join?
Explain the different types of constraints?
What are procedures in mysql? Explain
Is mysql relational database?
Explain advantages of MyISAM over InnoDB?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
