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

Which storage engines support transactions in MySQL?

2 Answers  

How to drop an existing table in mysql?

0 Answers  

Is there a free version of mysql?

0 Answers  

What is prepare statement in mysql?

0 Answers  

How to run a sql statement?

0 Answers  

Is mysql a scripting language?

0 Answers  

Is there a free mysql?

0 Answers  

Explain the architecture models of SQL Server?

0 Answers  

How does mysql store data?

0 Answers  

How to install mysql?

0 Answers  

What is a join? Explain the different types of mysql joins.

1 Answers  

What are the disadvantages of stored procedures?

0 Answers  

For more MySQL Interview Questions Click Here
Categories