what is the difference between MyIsam and InnoDb engine?
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 |
How does triggers work in mysql?
How do I restore a database in mysql workbench?
What is the difference between sql and mysql and oracle?
How we can get distinct columns values in mysql?
Should I use pdo or mysqli?
What is orm in mysql?
What are the advantages and disadvantages of MySQL?
How many values can the SET function of MySQL take?
2 Answers Creative Informatics,
What is maximum size of a database in MySQL?
13 Answers Bastioncoup, CIS, NM, V2 Solutions, Wipro,
Write a query to stop mysql in unix
How to create a new view in mysql?
What is action query?