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
Why is mysql used?
What is cursor in mysql?
Can mysql store files?
What is the difference between timestamp and datetime in mysql?
What is csv?
What is the purpose of using a heap table?
what is the difference between gui testing and database testing? : Mysql dba
Is mysql free software?
What is mysqli_select_db?
Is mariadb better than mysql?
How to add a new column to an existing table in mysql?
What is orm in mysql?
What is memory table in mysql?
How show all tables in mysql query?
What are views in mysql?