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 view in mysql?

0 Answers  

What is mysql common?

0 Answers  

How do I use mysql?

0 Answers  

How do I select a database in mysql?

0 Answers  

Can mysql handle billions of records?

0 Answers  

How to include comments in sql statements?

0 Answers  

What is A BI Ap;plication?

1 Answers   HCL,

maximum size of a database in mysql?

2 Answers  

List some mysql advantages and disadvantages?

0 Answers  

What do we use to remove duplicate records while fetching a data in mysql ?

0 Answers  

What is the difference between timestamp and datetime in mysql?

0 Answers  

How many columns can be used for creating Index?

0 Answers  

For more MySQL Interview Questions Click Here
Categories