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
How many rows we can insert in a mysql table?
What is pdo in php mysql?
How many columns can you create for an index?
what is a cursor? : Mysql dba
Does mysql use sql?
How do I make an action query?
What are the types of index?
What are Heap tables?
How do I import database through command line?
What is longblob in mysql?
explain GROUPBY & HAVING clause with examples.
Where is the mysql config file?
What's the latest version of mysql?
How do I use mysql?
How to update info already in a table and delete a row(s) from a table.