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 is the difference between truncate and delete in mysql?
In the below example, how many String Objects are created? String s1="I am Java Expert"; String s2="I am C Expert"; String s3="I am Java Expert";
Which is better mysql or mssql?
What is key in mysql?
What is ISAM?
How do I create a new database in mysql?
Is mariadb better than mysql?
What are different TEXT data types in MySQL?
How do I change the max connections in mysql?
What is innodb_buffer_pool_size?
Why do we use the mysql database server?
Is mysql better than oracle?
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)