what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage
Answers were Sorted based on User's Feedback
Answer / tushar
MyISAM and InnoDB are storage engines in MySql.
MyISAM does not support transactions while InnoDB support
it.
Is This Answer Correct ? | 27 Yes | 3 No |
Answer / sanjeev chauhan
InnoDB: Row level locking, Transaction support, forgin key
constrant and crash recovery.
MyISAM: Much more conservate approach to disk space
management each MyISAM table store in a separate file. in
MyISAM memory and space usage, full text indexing support,
table based locking, bulk insert capabilities and speed are
plus factor but crushes recovery would be the horror story.
As general approach, if you have a more reads use MyISAM and
if you have a more update use InnoDB.
Is This Answer Correct ? | 17 Yes | 3 No |
Answer / 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 |
What is general log in mysql?
Print 3 highest salary
Why does mysql have so many connections?
Why we use mysql database?
How to see table's field formats or description of table .
What is difference between function and procedure in mysql?
Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr
How to get a list of indexes of an existing table?
How can you get your MySQL root password, if you lost it?
How is oracle different from mysql?
what is the difference between gui testing and database testing? : Mysql dba
How is mysql database stored?