adspace


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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the current mysql version?

1105


What is current version of mysql?

1084


How to Change a users password from unix shell.

1223


Which statement is used in a select query for partial matching?

1247