what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage
- 3 Answers
- 8641 Views
- ABC, I also Faced
- E-Mail Answers
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
Is mysql a framework?
Is mysql is a programming language?
Why phpmyadmin is used for mysql?
How do I find mysql version in mysql workbench?
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?
What is a join in mysql?
What is the difference between timestamp and datetime in mysql?
How do I start mysql server?
What is a mysql server?
What is the difference between the LIKE and REGEXP operators?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
How to write optimized query in mysql?
Difference between CHAR and VARCHAR?
What is ISAM?
What is the usage of "i-am-a-dummy" flag in mysql?
