what is the difference between MyIsam and InnoDb engine?
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
Can we store images in mysql database?
How do I download mysql?
Explain the difference between primary key and candidate key in mysql?
How to create table with same structure of student table in mysql?
What are the functions of mysql?
How can I compare two mysql databases?
What is the full form of mysql?
How to declare variable in mysql trigger?
Is postgresql better than mysql?
How do I find users in mysql?
What is delimiter $$?
How do I enable mysqli extension?
How do I import database through command line?
How do I declare a variable in mysql?
What is the difference between primary key and candidate key?