what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage
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 are the method you will follow while sql installing
Which is faster mongodb or mysql?
How can I see all mysql databases?
What are the indexes in mysql?
How do I find mysql version in mysql workbench?
Why do we use views instead of tables?
Can we store videos in mysql database?
What are enums used for in mysql?
What is foreign key in mysql?
What is view? How can you create and drop view in mysql?
How to write date and time literals?
Can you tell the difference between ereg_replace() and eregi_replace()?
How do I start mysql server?
Why to use char instead of varchar in the database?
What is orm in mysql?