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
- 9413 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 can we optimize stored procedure?
What is append query?
Which is faster innodb or myisam?
Where is mysql used?
Is sql and mysql same?
How can you validate emails using a single query?
What is mysqlcommand?
What is “i_am_a_dump” flag in mysql?
What is a tinyint?
1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?
What are the different column comparison operators in mysql?
Why do gaps in sequences occur?
What are mysql data types?
Is mysql easy to learn?
How do I kill a mysql query?
