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
- 9394 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 database white box testing? : Mysql dba
How do I restore a mysql database dump file in linux?
What's the latest version of mysql?
How does mysql store binary data?
What is the use of mysql_fetch_array () function in php?
How to use mysqldump to create a copy of the database?
What are mysql queries?
Why should I learn mysql?
What is offset limit?
How do I copy an entire mysql database?
Is mariadb better than mysql?
Is mysql a server?
How do you kill a long running query in mysql?
Is mysql a nosql database?
What is the default port for mysql and how it can change?
