what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ?
Answer Posted / prathiba
1.Transactions:MYISAM doesnt support any database
transactions means if the transactions related to large
amount of data transfer it will not provide because memory
is less. But INNODB will provide transactions.
2.Locking:MYISAM provide the table level locking means if
the data in one table has been modified by the other
table ,the entire table will lock for the next process.But
INNODB provide the row level locking only the row of the
table that is being updated is locked.
3.Foreign keys – MYISAM tables do not support foreign keys.
4.Data Types:MYISAM provide a full variety of datatypes,but
INNODB will not.
Is This Answer Correct ? | 62 Yes | 3 No |
Post New Answer View All Answers
How to change the database engine in mysql?
How to Set a root password if there is on root password.
How do I backup mysql database on linux?
What is a storage engine? What are the differences between innodb and myisam engines?
What is difference between schema and table?
How many groups of data types?
Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T
What does do in mysql?
How to delete the repeated records from a table?
How do I connect to a mysql database?
How do I exit mysql?
What is the default port for MySQL Server?
Can mongodb replace mysql?
State the differences between mongodb and mysql.
What is delimiter in mysql stored procedure?