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
- 9527 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 the difference between is null & is not null?
How many types of indexes are there in mysql?
What is the function of myisamchk?
How many tables we can create in mysql database?
How to write after insert event update trigger on the same table in mysql?
How can you move the master database
How do I clear the command in mysql?
What are the disadvantages of mysql?
Does mysql support nosql?
What is the usage of ENUMs in MySQL?
How many sql ddl commands are supported by 'mysql'?
What are the different types of triggers in mysql?
What is flush privileges in mysql?
Is there a free version of mysql?
What is dirty read and phantom read?
