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...


what is the main difference between myisam and innodb

Answers were Sorted based on User's Feedback



what is the main difference between myisam and innodb..

Answer / manoj

both myisam and innodb are storange enginein sql.
innodb support transaction, foreign key while myisam not
support transaction.

Is This Answer Correct ?    7 Yes 0 No

what is the main difference between myisam and innodb..

Answer / ranganath

Other differences are :

1. innodb requires more RAM than mysiam
2. myisam relies on OS for caching while innodb caches with
in the engine itself.

3. Most preffered is innodb because

- Transaction safe
-It has commit, rollback, and crash recovery capabailities
- Innodb is designed for maximum performance when processing
large volumes of data.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More MySQL Interview Questions

Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

0 Answers  


SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

5 Answers   HCL,


Can you tell few best practices to be followed for optimization in sql?

0 Answers  


What are the mysql database files stored in system ?

0 Answers  


how to repair a table in mysql?

2 Answers  


How do I edit a table in mysql?

0 Answers  


Give the syntax of Grant and Revoke commands?

1 Answers  


How do I change global variables in mysql?

0 Answers  


In mysql, what is the default storage engine?

0 Answers  


How to create a test table in your mysql server?

0 Answers  


how to add a new column to an existing table?

0 Answers   MCN Solutions,


Explain Normalization concept?

2 Answers   Inuva,


Categories