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
What are the 'mysql' command line options?
What is current version of mysql?
What is max connection in mysql?
What is InnoDB?
How do I start mysql client?
Can we save images in mysql database?
How to declare variable in mysql trigger?
How to load a csv file into a table
What is the difference between having and where clause in mysql? Explain
How do I copy a table in mysql workbench?
How can I change database in mysql?
In which language mysql has been written?
Can python connect to mysql?
How would you enter characters as hex numbers?
How do I set user privileges in mysql?