what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage
- 3 Answers
- 8130 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 the nvl function, ifnull function, and the isnull function? : Mysql dba
How do I rename a mysql database?
Is foreign key indexed mysql?
What is the command line end user interface - mysql?
How many rows can mysql hold?
Why mysql is used with php?
How is mysql database stored?
How to increment dates by 1 in mysql?
Why use mysql procedures?
How do I change mysql password?
Is mysql and sql are same?
What is dblink?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
What is deterministic in mysql?
What are the functions used to encrypt and decrypt the data present in mysql?
