Answer / lekhraj deshmukh

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.

Answer / prathiba

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.

Answer / zubair bit

innoodb has maximum performance for large databases

Answer / dharma teja

myisam supports table level locking where as innoodb
supports only row level locking when updated

Answer / mark

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"

Answer / narendra sharma

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.

Answer / chalbal jha

MyIsam provide full text search which is not supported by
Innodb

Answer / dharma teja

innodb is acid engine

Answer / vikas

MyISAM don't take more space comparision to the INNODB in mysql

Answer / sharath bit

it supports online backups

Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 Answers  

How do I clear the command in mysql?

0 Answers  

What is mysqlcheck do?

0 Answers  

How do I edit a database in mysql workbench?

0 Answers  

What are the functions of commit and rollback statements?

0 Answers  

what is the difference between gui testing and database testing? : Mysql dba

0 Answers  

What is database migration in mysql?

0 Answers  

How do I create a mysql username and password?

0 Answers  

How can we store binary data in mysql?

2 Answers   HP,

i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?

0 Answers  

In the below example, how many String Objects are created? String s1="I am Java Expert"; String s2="I am C Expert"; String s3="I am Java Expert";

1 Answers  

Where is the mysql data directory?

0 Answers