Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage
- 3 Answers
- 9257 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
How to define numeric 9(3) in db2 table without decimal point??
What is dirty read and phantom read?
How to Set a root password if there is on root password.
What is a blob datatype?
Where does mysql store data?
How to change a password for an existing user via mysqladmin?
Is mysql running ubuntu?
How to delete a trigger in mysql?
How do I restore a mysql database dump file in linux?
How to include comments in sql statements?
How do I create a stored procedure in mysql?
Which is best pdo or mysqli?
What are procedures in mysql?
What is general log in mysql?
What is back end and front end?
