Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main difference between myisam and innodb
- 2 Answers
- 6859 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 |
Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
How do I quit mysql?
Consider you have the following three tables which have to be linked together.
using primary can we relate two table, with out foreign key?
Is mysql good for big data?
Is mysql is a programming language?
How do you determine the location of mysql data directory?
Which command is used to view the content of the table in mysql?
What is row level locking?
What is database clustering in mysql?
How to create a new table by selecting rows from another table in mysql?
What is the use of mysqli_fetch_array?
-
Oracle (3253) - 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)
