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
Which is better mysql or mssql?
What are Heap tables?
What is heap table in mysql?
What is user in mysql?
Is mysql free software?
What is mysqlcommand?
Where MyISAM table will be stored and also give their formats of storage?
Can I use mariadb instead of mysql?
Describe mysql transaction properties.
how can you test for null values in a database? : Mysql dba
what is a cursor? : Mysql dba
Difference between CHAR and VARCHAR?
What are the 5 r's of managing behaviors?
how to add a new column to an existing table?
How do I find users in mysql?