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 |
Does mysql automatically index foreign keys?
how we can find nth max salary from an employe table by using my sql?
How do I get a list of table names in mysql?
How to convert dates to character strings?
How do I transfer data from one database to another in mysql?
What is mysql optimization?
How many TRIGGERS are allowed in MySql table?
What is mysql gpl?
What is mysql procedure?
Can you rename a database in mysql?
Explain advantages of MyISAM over InnoDB?
What is full text indexing in mysql?