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
- 9371 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 are the disadvantages of mysql?
How do you rename a procedure in mysql?
What is meant by decimal (5,2)?
How do you create a table in mysql workbench?
What are the functions of mysql?
How to determine the location of the data directory?
How many sql ddl commands are supported by 'mysql'?
How do I kill a mysql connection?
What is horizontally scalable?
How do I rename a procedure?
What are all the Common SQL Function?
What is the difference between b-tree and hash indexes?
Why do we use group by and order by function in mysql?
How To see all the tables from a database of mysql server.
Is mysql still popular?
