Which storage engines support transactions in MySQL?
- 2 Answers
- 7099 Views
- I also Faced
- E-Mail Answers
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 auto increment in mysql?
How can we run batch mode in mysql?
What is mysql uuid?
How we get sum of column.
How large can a mysql table be?
Does mysql support nosql?
What is bigint in mysql?
What is difference between mongodb and mysql?
How to get a list of all tables in a database?
Can you tell how to find the number of rows in a resultset using php?
Write a command with which mysql table can be repaired
What is save point in mysql?
How does mysql store binary data?
What is an index? How can an index be declared in mysql?
How to check if value already exists in mysql database in php?
