Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main difference between myisam and innodb
- 2 Answers
- 6719 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 |
Why do we write stored procedures?
What is mysql_connect?
What is int mysql?
What is action query?
What are the other commands to know the structure of table using MySQL commands except explain command?
How to shutdown mysql server?
Is mysql owned by oracle?
Describe mysql transaction properties.
How many primary keys can be there in a table?
How many columns can be used for creating Index?
How can we optimize stored procedure?
How to Change a users password from unix shell.
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
