1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

What is diff b/w MYISAM and INNODB storage engine. and also
define the benifits and drawbacks of both storage engine

Question Posted / shyamvinay


What is diff b/w MYISAM and INNODB storage engine. and also define the benifits and drawbacks of bo..

Answer / rajanikanth

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 ?    2 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is slow query log in mysql?

0 Answers  

What is a session in mysql?

0 Answers  

What is the difference between MyISAM Static and MyISAM Dynamic?

0 Answers  

What is the use of i-am-a-dummy flag in mysql?

0 Answers  

i made a table in sql server 2000 and in a column i want to add image path of a picture present in my hardisk... so using insert statement how will i insert the path of the image in the table??

1 Answers   WebTech,




Will mysql remain free?

0 Answers  

How to Change a users password from unix shell.

0 Answers  

I want to find out all databases starting with ‘test’, I have access to?

0 Answers  

How many entries can mysql handle?

0 Answers  

Is mysql a scripting language?

0 Answers  

what do you mean by longblob Data type in MySql?

3 Answers  

What is a transaction? Describe mysql transaction properties.

0 Answers  

For more MySQL Interview Questions Click Here
Categories