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 |
What is memory table?
Can you save your connection settings to a conf file?
What are the benefits of mysql?
How do I connect to a mysql database?
What are the steps involved in query processing?
Does adding an index lock a table?
why not null is not allowed at table level
Differentiate CHAR_LENGTH and LENGTH?
What are procedures in mysql? Explain
What is the purpose of -> in the mysql terminal?
Why is it called mysql?
What you can use regular expression for in mysql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)