ALLInterview.com :: Home Page KalAajKal.com
 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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  MySQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
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 ?    4 Yes 2 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 ?    5 Yes 2 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 ?    11 Yes 0 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 ?    0 Yes 2 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 ?    3 Yes 1 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 ?    0 Yes 3 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 ?    5 Yes 1 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 ?    8 Yes 1 No
Dharma Teja
 

 
 
 
Other MySQL Interview Questions
 
  Question Asked @ Answers
 
For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.  1
how many ways we can get the current date in mysql?  1
How many services is running in sql server? ACC3
Explain Normalization concept? Inuva1
how to find missing numbers between two order numbers; and dates ?  1
how to repair a table in mysql?  1
What are some good ideas regarding user security in MySQL?  2
how do i list constraints in my database by using sql server2000?  1
How to find out the second largest element from mysql table  11
Give the syntax of GRANT commands?  1
What are HEAP tables in MySQL?  1
How can we change the name of a column of a table?  4
Explain the difference between MyISAM Static and MyISAM Dynamic?  1
If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?  1
How many tables will create when we create table, what are they?  2
The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated? Afixi3
How would you backup and restore a big MySQL database? What are the advantages of the approach which you have taken over the others?  2
How many ways we can we find the current date using MySQL?  4
What are the other commands to know the structure of table using MySQL commands except explain command? SigmaTree2
What is maximum size of a database in MySQL? V2-Solutions9
 
For more MySQL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com