ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Databases >> MySQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions (2035)
 SQL Server interview questions  SQL Server Interview Questions (1075)
 MS Access interview questions  MS Access Interview Questions (24)
 MySQL interview questions  MySQL Interview Questions (194)
 Postgre interview questions  Postgre Interview Questions (6)
 Sybase interview questions  Sybase Interview Questions (22)
 DB Architecture interview questions  DB Architecture Interview Questions (5)
 DB Administration interview questions  DB Administration Interview Questions (213)
 DB Development interview questions  DB Development Interview Questions (53)
 SQL PLSQL interview questions  SQL PLSQL Interview Questions (768)
 Databases AllOther interview questions  Databases AllOther Interview Questions (106)
Question
what are the main differences between MyISAM and InnoDB
table storage structures ? 
what are the advantages and disadvantages in usage of these ?
 Question Submitted By :: Pk
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
Answer
# 1
this is pretty straightforward, not too technical though:

http://forums.devarticles.com/general-sql-development-47/difference-between-myisam-and-non-myisam-tables-1745.html

FTA:
"MyISAM is of course the default table type i'm MySQL. It's
an improvement over the now-deprecated ISAM table type. It
provides a simple tree structure for quick indexing on small
tables, typicall fewer than 10,000 rows of data.

There are some other types of tables supported in MySQL,
most of which won't provide any noticable differences.

A MERGE table is a table that only exists in memory, and
will not be saved if MySQL crashes or has to be restarted.
It is, as the name suggests, a merge of two (or more)
tables. If you drop a MERGE table, it only drops the
reference to the merge, not to the tables that are combined
in it. It's not good for much!

Another table, the one which is best for huge tables, is
InnoDB. It's probably the best RDBMS out there; it's
actually a whole set of drivers on it's own, and when you
use it, MySQL is really just a wrapper around the InnoDB
table. Slashdot and other megamammoth sites out there use
it, it's fast and effecient, but the trees are pretty large,
so it's not good for smaller tables.

There are a few others.. like BerkeleyDB, which isn't
anything special and doesn't provide any major performance
increase.

The major difference between the various table types are the
data tree structures and how they're handled within the RDBMS.

In the end, you'll probably find yourself sticking to MyISAM
unless you're on a very large-scale project, in which cas
eyou probably woudln't use MySQL anyway =D"
 
Is This Answer Correct ?    29 Yes 12 No
Mark
 
  Re: what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
Answer
# 2
There is foolowing Differences between MYISAM and InnoDB
ENGINE:-

1)MYISAM does not support the foreign key constraint and
transaction but InnoDB support it.

2)MYISAM is faster then the InnoDB but in case of perforing
the count operation it takes more time then the InnoDB.

3) MYISAM occupies less memory sapce for tables rather than
InnoDB tables.
 
Is This Answer Correct ?    75 Yes 5 No
Lekhraj Deshmukh
 
 
 
  Re: what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
Answer
# 3


1.Transactions:MYISAM doesnt support any database
transactions means if the transactions related to large
amount of data transfer it will not provide because memory
is less. But INNODB will provide transactions.

2.Locking:MYISAM provide the table level locking means if
the data in one table has been modified by the other
table ,the entire table will lock for the next process.But
INNODB provide the row level locking only the row of the
table that is being updated is locked.

3.Foreign keys MYISAM tables do not support foreign keys.

4.Data Types:MYISAM provide a full variety of datatypes,but
INNODB will not.
 
Is This Answer Correct ?    59 Yes 3 No
Prathiba
 
  Re: what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
Answer
# 4
MyIsam provide full text search which is not supported by
Innodb
 
Is This Answer Correct ?    20 Yes 8 No
Chalbal Jha
 
  Re: what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
Answer
# 5
innodb is acid engine 
Is This Answer Correct ?    14 Yes 3 No
Dharma Teja
 
  Re: what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
Answer
# 6
it supports online backups 
Is This Answer Correct ?    7 Yes 15 No
Sharath Bit
 
  Re: what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
Answer
# 7
innoodb has maximum performance for large databases 
Is This Answer Correct ?    24 Yes 2 No
Zubair Bit
 
  Re: what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
Answer
# 8
myisam supports table level locking where as innoodb
supports only row level locking when updated
 
Is This Answer Correct ?    31 Yes 9 No
Dharma Teja
 
  Re: what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
Answer
# 9
MyISAM : it is an engine and faster and occupy the less
space so not good enough for large transaction, also not
support the foreign key concept, it provide the table level
locking mean any change in the will be available as modified
table next time.

innoDB : It is also an engine and slow in comparison the
MyISAM engine, but good enough for large transaction, also
provide the row level locking mean updation is fast. Useful
for BANK SYSTEM.
 
Is This Answer Correct ?    16 Yes 1 No
Narendra Sharma
 
  Re: what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
Answer
# 10
MyISAM don't take more space comparision to the INNODB in mysql 
Is This Answer Correct ?    4 Yes 1 No
Vikas
 

 
 
 
Other MySQL Interview Questions
 
  Question Asked @ Answers
 
Give the syntax of Grant and Revoke commands?   1
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...   1
What is the difference between primary and unique key CSC 5
What are the different table present in MYsql?   3
How can we store binary data in mysql? HP 2
mazimum size of a database in mysql? when we create a table then how many tables actually created? write there name?   1
what is the advantage of stored procedures, triggers and indexing in mysql   1
Print 3 highest salary   9
How do you index just the first four bytes of the column?   2
how to find missing numbers between two order numbers; and dates ?   1
if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?   2
How can we repair a MySQL table? Infosys 2
 
For more MySQL Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com