Which storage engines support transactions in MySQL?
Answers were Sorted based on User's Feedback
Answer / muthuk
Storage Engine - Description
MyISAM Default engine as of MySQL 3.23 with great
performance
MEMORY Hash based, stored in memory, useful for
temporary tables
InnoDB Supports transactions, row-level locking,
and foreign keys
BerkeleyDB Supports transactions and page-level locking
BLACKHOLE /dev/null storage engine (anything you write to
it disappears)
EXAMPLE Example storage engine
ARCHIVE Archive storage engine
CSV CSV storage engine
ndbcluster Clustered, fault-tolerant, memory-based tables
FEDERATED Federated MySQL storage engine
MRG_MYISAM Collection of identical MyISAM tables
ISAM Obsolete storage engine
| Is This Answer Correct ? | 1 Yes | 1 No |
What is mysql aggregate functions? Explain
Why phpmyadmin is used for mysql?
What are the non-standard sql commands supported by 'mysql'?
How do I copy a table in mysql workbench?
What is the difference between a heap table and temporary table?
What is mysqli procedural?
Which is better sqlite or mysql?
How to rename an existing column in a table?
Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .
How can an index be declared in mysql?
How to show table names with 'mysqlshow'?
What is mysql protocol?
Oracle (3259)
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)