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 to drop an existing table in mysql?
How do you use auto increment?
What is blob and text in mysql?
How to include numeric values in sql statements?
Is mysql server free?
How can you retrieve a portion of any column value by using a select query?
What is mysql in dbms?
Is mysql case-sensitive?
How to change a password for an existing user via mysqladmin?
How do I save in mysql?
how to display nth highest salary from a table in a mysql query? : Mysql dba
How to get current MySQL version?
What is a simple query?
What is mysql server?
How to include character strings in sql statements?