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 architecture?
What does blob mean in mysql?
How do I save in mysql?
What is A BI Ap;plication?
What is the use of procedure in mysql?
How to delete an existing column in a table?
Give the syntax of GRANT commands?
How do I import database through command line?
What are the advantages of stored procedures, triggers, indexes?
How do I clear the screen in mysql?
How to use rank function in mysql?
Can we save images in mysql database?
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)