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

Explain advantages of MyISAM over InnoDB?

Answer Posted / amith

Much more conservative approach to disk space management -
each MyISAM table is stored in a separate file, which could
be compressed then with myisamchk if needed. With InnoDB
the tables are stored in tablespace, and not much further
optimization is possible. All data except for TEXT and BLOB
can occupy 8,000 bytes at most. No full text indexing is
available for InnoDB. TRhe COUNT(*)s execute slower than in
MyISAM due to tablespace complexity.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there a free mysql?

839


What are the security alerts while using mysql?

981


Is mysql free software?

907


Write a query to stop mysql in unix

996


List data types in mysql? Explain

874


How do I install the latest mysql on ubuntu?

923


How do I find my mysql username and password?

920


How to list or view all databases from the mysql server.

876


What is mysql and how it works?

883


How do I download mysql on my laptop?

824


What is the use of concat() in mysql?

934


What are the difference between mongodb and mysql?

1257


How to shutdown mysql server?

1007


How to get a list of columns in an existing table?

834


How to convert character strings to dates?

1030