Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage
- 3 Answers
- 9261 Views
- ABC, I also Faced
- E-Mail Answers
Answer Posted / sanjeev chauhan
InnoDB: Row level locking, Transaction support, forgin key
constrant and crash recovery.
MyISAM: Much more conservate approach to disk space
management each MyISAM table store in a separate file. in
MyISAM memory and space usage, full text indexing support,
table based locking, bulk insert capabilities and speed are
plus factor but crushes recovery would be the horror story.
As general approach, if you have a more reads use MyISAM and
if you have a more update use InnoDB.
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
What is schema in mysql?
How do I export mysql query results to excel?
How to write date and time literals?
How to start mysql server?
Is mysql and sql are same?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
How do I show all mysql databases?
How to include comments in sql statements?
can you tell the order of sql select statement? : Mysql dba
Does mysql use t sql?
What is trigger in mysql?
What is the use of innodb in mysql?
What is the use of count function in mysql?
What is the data source name for mysql?
How to get current MySQL version?
