Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

How do I disable mysql?

0 Answers  

What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?

2 Answers  

What is a join in mysql?

0 Answers  

What is a definer?

0 Answers  

How do I change the max connection in mysql?

0 Answers  

How to convert character strings to numeric values?

0 Answers  

What are the difference between now and current_date in mysql?

1 Answers  

Is mysqli faster than mysql?

0 Answers  

Explain about reporting services of MYSQL?

0 Answers  

How to install mysql?

0 Answers  

what is the advantage of left outer join?

2 Answers  

what is the Dynamic management views? where can you use?

1 Answers   ACC,

For more MySQL Interview Questions Click Here
Categories