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

How do you know the version of your mysql server?

0 Answers  

How do I create a mysql database?

0 Answers  

how many table created when we create a table in mysql?

3 Answers  

What is the difference between mysql and pdo?

0 Answers  

In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

0 Answers  

What is unsigned in mysql?

0 Answers  

Is mysql a server or database?

0 Answers  

How much does mysql cost?

0 Answers  

What is the use of mysqli_fetch_assoc?

0 Answers  

if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?

2 Answers  

How internally data stores in MyISAM and INNODB table types?

0 Answers   Zensar,

What is the password of mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories