what is the difference between MyIsam and InnoDb engine?

Question Posted / sandhirasegaran

2 Answers
6482 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difference between MyIsam and InnoDb engine?..

Answer / satya

MyIsam is my default storage engine , where as InnoDB is
faster storage Engine and offers row level locking ,

Is This Answer Correct ?

8 Yes

3 No

what is the difference between MyIsam and InnoDb engine?..

Answer / madhuri

1) MYISAM is faster then the InnoDB but in case of perforing
the count operation it takes more time then the InnoDB.
2)MYISAM does not support the foreign key constraint and
transaction but InnoDB support it.
3)Upto Mysql 5.0 MyIsam is the default engine and from
Mysql 5.1 Innodb is the default engine.
4)MyIsam supports table level lock and where as Innodb
supports row level locking.

Thanks.,
Madhuri.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer

More MySQL Interview Questions

What is the default port for mysql and how it can change?

0 Answers

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

0 Answers

How to insert dynamic values in mysql using php?

0 Answers

Does uninstalling mysql delete database?

0 Answers

Can you tell few best practices to be followed for optimization in sql?

0 Answers

Write command to import an mysql file?

0 Answers

How does limit work in mysql?

0 Answers

What is DDL in MySQL?