what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage
Answer Posted / sreedevi yadav
InnoDb table take More Disk space Comparing with MyISAM
InnoDB is Transactions safe means Data Integrity is
maintained Throughout entire qry process.
InnoDB also provides Row-locking as opposed to table
locking while 1 qry is busy with updating or inserting
arow,another qry can update a different row at the same
time.these features increases the multi user concurrency
and Performance
Another greate feature is InnoDB boasts is the ability to
use Foreign key constraints
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What happens if you no create privilege in a database?
Why do we use the mysql database server?
How to returns the columns and column information pertaining to the designated table.
Is mysql same as sql?
How many rows can mysql hold?
Is mysql free for enterprise?
What is mysql vs sql?
Is mysql case-sensitive?
Is oracle better than mysql?
What is the current root password of mysql?
What is max_used_connections in mysql?
Which is faster mongodb or mysql?
How many columns can be used for creating Index?
How do I uninstall mysql connector?
How to convert numeric values to character strings?