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 is mysql and how it works?
How do I import database through command line?
Is mysql open source?
What is a deterministic function?
What is full text indexing in mysql?
What is mysql common?
Does mysql scale well?
What are the method you will follow while sql installing
What is mysql sleep process?
What is ibdata1?
what is the default port for mysql server? : Mysql dba
How do you create a primary key?
Is mysql a distributed database?
what are the different tables present in mysql? : Mysql dba
What are the critical issues you have resolved in your company