What is a storage engine? What are the differences between innodb and myisam engines?



What is a storage engine? What are the differences between innodb and myisam engines?..

Answer / Kavita Tripathi

A storage engine in MySQL is the method used to store, retrieve, and manage data. InnoDB and MyISAM are two of the most common storage engines. InnoDB supports transactions, foreign keys, row-level locking, and ACID compliance. MyISAM is faster for read-heavy workloads, but does not support transactions or row-level locking.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is memory table?

1 Answers  


Can you save your connection settings to a conf file?

1 Answers  


What are the benefits of mysql?

1 Answers  


How do I connect to a mysql database?

1 Answers  


What are the steps involved in query processing?

1 Answers  


Does adding an index lock a table?

1 Answers  


why not null is not allowed at table level

1 Answers   Cognizant,


Differentiate CHAR_LENGTH and LENGTH?

1 Answers  


What are procedures in mysql? Explain

1 Answers  


What is the purpose of -> in the mysql terminal?

1 Answers  


Why is it called mysql?

1 Answers  


What you can use regular expression for in mysql?

1 Answers  


Categories