What is diff b/w MYISAM and INNODB storage engine. and also
define the benifits and drawbacks of both storage engine
- 1 Answers
- 3366 Views
- I also Faced
- E-Mail Answers
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 |
What is sharding in mysql?
Why do we use the mysql database server?
What is database engine in mysql?
What is MySQL?
How do I install mysql on windows 10 64 bit?
Is mysql better than oracle?
Who developed mysql?
How do I insert an image into mysql workbench?
How to insert dynamic values in mysql using php?
Can varchar be primary key?
Write a query to find duplicate rows in table?
How to display top 50 rows?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
