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 do I start mysql from command line?

0 Answers  

Can we write procedure in mysql?

0 Answers  

What you can use regular expression for in mysql?

0 Answers  

Why do we use preparedstatement?

0 Answers  

Is mysql relational database?

0 Answers  

What is mysql procedure?

0 Answers  

What is 'mysqlimport'?

0 Answers  

Does facebook still use mysql?

0 Answers  

What language is mysql written in?

0 Answers  

How can we convert between Unix & MySQL timestamps?

0 Answers  

What is a scalar function?

0 Answers  

What is dirty read and phantom read?

0 Answers  

For more MySQL Interview Questions Click Here
Categories