what is the main difference between myisam and innodb
- 2 Answers
- 5524 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 |
What are the functions of mysql?
Is pdo faster than mysqli?
How to write date and time literals?
Is mysql a server?
How can we optimize stored procedure?
What is the difference between a heap table and temporary table?
How do you restart mysql?
What is full text indexing in mysql?
Can we create table in stored procedure?
How do I find users in mysql?
Give the syntax of Grant and Revoke commands?
Explain the difference between delete and truncate.
-
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)
