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

How can you increase the performance of mysql select query?

0 Answers  

What is the query to display top 20 rows?

0 Answers  

What are the other commands to know the structure of table using MySQL commands except explain command?

2 Answers   SigmaTree,

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

0 Answers  

How do I switch users in mysql?

0 Answers  

How can we repair a MySQL table?

2 Answers   Infosys,

How do you rename a table in mysql?

0 Answers  

how to find missing numbers between two order numbers; and dates ?

1 Answers  

What is ddl, dml, and dcl?

0 Answers  

What does "i_am_a_dummy flag" do in mysql?

0 Answers  

what do you mean by longblob Data type in MySql?

3 Answers  

Which datatype is used for email in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories