what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage
- 3 Answers
- 8635 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
Does insert statement lock the table?
How to delete a column and add a new column to database
What are the 5 r's of managing behaviors?
How do I rename a procedure?
How to create table with same structure of student table in mysql?
How can we optimize stored procedure?
What are the security alerts while using mysql?
How to returns the columns and column information pertaining to the designated table.
How to change the database engine in mysql?
How do I use mysql?
What do I do if I forgot my mysql root password?
what is constraints? Also explain the different types of constraints?
What is a left join mysql?
How do you create a schema?
What is 'mysqldump'?
