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

Why do we use mysql?

0 Answers  

Is sqlite faster than mysql?

0 Answers  

What is sql vs mysql?

0 Answers  

How many groups of data types?

0 Answers  

Is mysqli deprecated?

0 Answers  




How to rename an existing table in mysql?

0 Answers  

What is sql in mysql?

0 Answers  

How to represent ENUMs and SETs internally?

0 Answers  

How does triggers work in mysql?

0 Answers  

What is the purpose of using timestamp data type?

0 Answers  

how you will Create a database on the mysql server with unix shell.

0 Answers  

What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

0 Answers  

For more MySQL Interview Questions Click Here
Categories