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 does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
What is a storage engine? What are the differences between innodb and myisam engines?
How can an index be declared in mysql?
How to shutdown mysql server?
How do I start mysql in linux?
Is mysql a dbms?
Can python connect to mysql?
How will show all records containing the name "sonia" and the phone number '9876543210'
What is the difference between float and double?
How to create trigger in mysql phpmyadmin?
What are the advantages of mysql in comparison to oracle?
How do I rename a mysql database?
What is mysqli_free_result?
What is the function of myisamchk?
write a query to mysql in safe mode and to change the root password