What is diff b/w MYISAM and INNODB storage engine. and also
define the benifits and drawbacks of both storage engine
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 |
How can you increase the performance of mysql select query?
What is the query to display top 20 rows?
What are the other commands to know the structure of table using MySQL commands except explain command?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
How do I switch users in mysql?
How can we repair a MySQL table?
How do you rename a table in mysql?
how to find missing numbers between two order numbers; and dates ?
What is ddl, dml, and dcl?
What does "i_am_a_dummy flag" do in mysql?
what do you mean by longblob Data type in MySql?
Which datatype is used for email in mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)