1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

what is the difference between MyIsam and InnoDb engine?

Question Posted / sandhirasegaran

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 are the critical issues you have resolved in your company

0 Answers   Wipro,

What is identity in mysql?

0 Answers  

is it possible to assign two primary key in a table

8 Answers   IBM,

How do I install and use mysql?

0 Answers  

How to shutdown mysql server?

0 Answers  




What is a select query?

0 Answers  

How to extract a unit value from a date and time?

0 Answers  

How we can create index in mysql?

0 Answers  

How can increase the performance of MySQL select query?

3 Answers   RV Technologies, Span Systems,

What is MySQL?

0 Answers  

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

0 Answers  

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

0 Answers  

For more MySQL Interview Questions Click Here
Categories