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
- 9362 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 the storage engine for mysql?
How do I rename a procedure?
Why do we use pragma autonomous transaction?
How to add a new column to an existing table in mysql?
What is mysqli_free_result?
What is new mysqli?
How do I connect to a mysql database?
what is database white box testing? : Mysql dba
How do I install mysql workbench?
How do I check mysql version?
What are the technical specifications of mysql?
What is mysql database extension?
How do I run mysql on a mac?
How do I clear a mysql database?
What is pragma autonomous_transaction?
