Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between MyIsam and InnoDb engine?
- 2 Answers
- 6488 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 |
What is the purpose of -> in the mysql terminal?
date funciton
what are the different tables present in mysql? : Mysql dba
How we can copy one table data into another table whose name same as table but in differ database
What are mysql queries?
What data type is money?
How to convert character strings to numeric values?
What is the difference between mysql and pdo?
How to get a list of all tables in a database?
What are the applications required to support mysql?
Why is the basic difference between left join, right join and inner join?
How to update info already in a table and delete a row(s) from a table.
-
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)
