Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between MyIsam and InnoDb engine?
- 2 Answers
- 6467 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is an index? How can an index be declared in mysql?
Is mysql a free database?
How will you export tables as an xml file in mysql?
What is the use of mysql_close()?
What is mysql ndb?
Which datatype is used for email in mysql?
How can I create a database in mysql?
What you can use regular expression for in mysql?
Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
How do I view mysql logs?
What are the disadvantages of mysql?
How many ways we can retrieve the date in result set of mysql using php?
What is difference between mysql and mysql server?
Can you shard mysql?
Is mysql a database?
