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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use like conditions?

1039


How to display top 10 rows in mysql?

1090


What is mvcc in mysql?

1068


What is max connections in mysql?

994


What is clob datatype?

942


How to get a version of mysql?

1105


Can we join 3 tables in mysql?

1027


Is null in mysql?

913


Why does mysql have so many connections?

944


What is horizontally scalable?

1036


What is indexing in mysql?

1020


What is difference between function and procedure in mysql?

1009


How can we change the data type of a column of a table?

1048


What is row?

1144


What is deterministic in mysql?

1030