what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ?
Answer Posted / narendra sharma
MyISAM : it is an engine and faster and occupy the less
space so not good enough for large transaction, also not
support the foreign key concept, it provide the table level
locking mean any change in the will be available as modified
table next time.
innoDB : It is also an engine and slow in comparison the
MyISAM engine, but good enough for large transaction, also
provide the row level locking mean updation is fast. Useful
for BANK SYSTEM.
| Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
How do I run mysql on a mac?
Is blocked because of many connection errors mysql?
How to create a trigger in mysql?
explain GROUPBY & HAVING clause with examples.
What is the current root password of mysql?
What is dump in mysql?
What is schema in mysql?
What is a select query?
Explain timestamp?
What is mysql ndb?
What is the size of mysql database?
Explain % and _ inside like statement?
How can you handle the –secure-file-priv in mysql?
what is the procedure to configure the application of mysql?
What is definer in mysql trigger?