Interested to Buy Any Domain ? << Click Here >> for more details...
what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ?
- 10 Answers
- 44495 Views
- E2 Solutions, Tesco, I also Faced
- E-Mail Answers
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 to load data files into tables with 'mysqlimport'?
How do I start and stop mysql server?
Differentiate CHAR_LENGTH and LENGTH?
How to change the database engine in mysql?
What does do in mysql?
What is processlist in mysql?
How to enter microseconds in sql statements?
What are aggregate functions in mysql?
What is dirty read and phantom read?
What is mysql common?
How can you make a database as your current database?
How to delete a trigger in mysql?
What is pragma autonomous_transaction?
How do I transfer data from one database to another in mysql?
How do you rename a table in mysql?
