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

Explain advantages of MyISAM over InnoDB?

Question Posted / amith


Explain advantages of MyISAM over InnoDB?..

Answer / 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

More MySQL Interview Questions

What is schema in mysql?

0 Answers  

Is mysql a framework?

0 Answers  

What is cast in mysql?

0 Answers  

What are Heap tables?

1 Answers  

How can you handle the –secure-file-priv in mysql?

0 Answers  

How can you do the fine tunning?

3 Answers   ACC,

What is 'mysqldump'?

0 Answers  

How do I edit a database in mysql workbench?

0 Answers  

Is mysql free for commercial use?

0 Answers  

What is the difference between myisam dynamic and myisam static in mysql?

0 Answers  

what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?

10 Answers   E2 Solutions, Tesco,

How does mysql clustering work?

0 Answers  

For more MySQL Interview Questions Click Here
Categories