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

What is mysql default port number?

0 Answers  

How do I download mysql on my laptop?

0 Answers  

How do I restore a mysql database dump file in linux?

0 Answers  

How can you change the name of any existing table by using the sql statement?

0 Answers  

How do I change directories in mysql?

0 Answers  

What is mysql ndb?

0 Answers  

Which is faster mongodb or mysql?

0 Answers  

explain GROUPBY & HAVING clause with examples.

0 Answers  

Give the syntax of GRANT commands?

3 Answers  

How many columns can a table have?

0 Answers  

What is blob datatype in mysql?

0 Answers  

Is mysql a relational database?

0 Answers  

For more MySQL Interview Questions Click Here
Categories