Which storage engines support transactions in MySQL?
Answer Posted / 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 |
Post New Answer View All Answers
What is the command used to create a database using php and mysql?
How do I insert an image into mysql workbench?
How is data stored in mysql?
How do I restore a mysql database dump file in linux?
Is mysql deprecated?
Do while loop in mysql procedure?
What does mysql_fetch_assoc do?
What is mysqli_num?
How to change the database engine in mysql?
What is difference between mysql_connect and mysql_pconnect?
What mysql means?
Why do we use views instead of tables?
What is 'mysqlcheck'?
How to determine the location of the data directory?
Can we store pdf files in mysql?