what is the main difference between myisam and innodb
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 Heap tables?
Does mysql support nosql?
What is maximum size of a database in MySQL?
13 Answers Bastioncoup, CIS, NM, V2 Solutions, Wipro,
How do I grant privileges to a user in mysql phpmyadmin?
What are different TEXT data types in MySQL?
What is A BI Ap;plication?
What are the objects can be created using CREATE statement?
What is difference between group by and order by clause?
Is postgresql better than mysql?
How will you export tables as an xml file in mysql?
Is mysql and sql are same?
Why should I learn mysql?
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)