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
- 9395 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 an index be declared in mysql?
How do I change directories in mysql?
Why do we use mysql?
Is number a datatype in mysql?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
What port is mysql running on?
How to use count function in mysql?
What happens if null values are involved in expressions?
State the differences between mongodb and mysql.
What is a left join mysql?
Which software is used for mysql?
How do I install the latest mysql on ubuntu?
I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.
How is oracle different from mysql?
What is text in mysql?
