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 diff b/w MYISAM and INNODB storage engine. and also
define the benifits and drawbacks of both storage engine

Question Posted / shyamvinay


What is diff b/w MYISAM and INNODB storage engine. and also define the benifits and drawbacks of bo..

Answer / rajanikanth

1)MYISAM does not support the foreign key constraint and
transaction but InnoDB support it.

2)MYISAM is faster then the InnoDB but in case of perforing
the count operation it takes more time then the InnoDB.

3) MYISAM occupies less memory sapce for tables rather than
InnoDB tables.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More MySQL Interview Questions

What are string data types?

0 Answers  

Write a command with which mysql table can be repaired

0 Answers  

What is the limit of mysql database?

0 Answers  

What is unique key in mysql?

0 Answers  

What is data types in mysql?

0 Answers  

What is procedures in mysql?

0 Answers  

How do I flush privileges in mysql?

0 Answers  

What is mysql57?

0 Answers  

What is heap table in mysql?

0 Answers  

What does "i_am_a_dummy flag" do in mysql?

0 Answers  

How to drop an existing view in mysql?

0 Answers  

How can I create table in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories