what is the main difference between myisam and innodb
Answer Posted / 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 |
Post New Answer View All Answers
How do I rename a table in mysql?
Can we write pl sql mysql?
What is sharding in mysql?
What is append query?
Does mysql use t sql?
Which command is used to view the content of the table in mysql?
Is mysql a free database?
What is a trigger? How you can create a trigger in mysql?
Can you tell what are various ways to create an index?
How to get a list of all tables in a database?
What is current version of mysql?
What is max connection in mysql?
What is int unsigned?
Is pdo faster than mysqli?
How to delete a column and add a new column to database