what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage
- 3 Answers
- 8084 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
What is acid in mysql?
What is the limitation of mysql?
what is database black box testing? : Mysql dba
How do I get a list of table names in mysql?
What is information_schema in mysql?
How can we get total number of records by query in mysql?
How to get current MySQL version?
What data type is money?
How do you select a table?
What is mysqli procedural?
What are the functions used to encrypt and decrypt the data present in mysql?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
Is mysql a free database?
What is inner join in mysql?
How do I copy an entire mysql database?
