Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between MyIsam and InnoDb engine?
- 2 Answers
- 6739 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / satya
MyIsam is my default storage engine , where as InnoDB is
faster storage Engine and offers row level locking ,
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / madhuri
1) MYISAM is faster then the InnoDB but in case of perforing
the count operation it takes more time then the InnoDB.
2)MYISAM does not support the foreign key constraint and
transaction but InnoDB support it.
3)Upto Mysql 5.0 MyIsam is the default engine and from
Mysql 5.1 Innodb is the default engine.
4)MyIsam supports table level lock and where as Innodb
supports row level locking.
Thanks.,
Madhuri.
| Is This Answer Correct ? | 3 Yes | 0 No |
Why should I use mysql?
Where is the mysql database stored?
How many sql dml commands are supported by 'mysql'?
What is mysql installer?
What is data in mysql?
What is the difference between mysql and oracle?
what is constraints? Also explain the different types of constraints?
Is mysql relational database?
What is a tinyint?
What is MySQL?
How do I connect to a mysql database?
What is mvcc in mysql?
-
Oracle (3253) - 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)
