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
- 9415 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 does "i_am_a_dummy flag" do in mysql?
What is procedural api?
What do you understand by mysql terminal?
Should I use pdo or mysqli?
Is mysql port 3306 tcp or udp?
When to use order by in delete statement?
How many ways we can retrieve the date in result set of mysql using php?
Do I need python for mysql?
What is orm in mysql?
What is a mysql view?
How does php communicate with mysql?
What is federated tables in mysql?
List some mysql advantages and disadvantages?
How do I rename a table in mysql workbench?
What are the types of queries?
