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 the datatype of image in mysql?
How do I update a variable in mysql?
What is the difference between primary key and candidate key?
How to execute mysql query in php?
How do I start mysql?
Explain MySQL locks?
What are mysql data types?
When to use order by in delete statement?
What is the difference between char and varchar data types?
How many rows can a mysql table hold?
What is check constraint?
What language does mysql use?
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)