Which storage engines support transactions in MySQL?
- 2 Answers
- 6680 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
Is pdo more secure than mysqli?
What is full form of xampp?
Explain the different types of constraints?
How can I see all mysql databases?
What is the difference between database and table?
How is data stored in mysql?
How can you find out the version of the installed mysql?
How we get sum of column.
what is a cursor? : Mysql dba
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
How to create a new table by selecting rows from another table in mysql?
What is orm in mysql?
What is the difference between the LIKE and REGEXP operators?
What is the difference between BLOB AND TEXT?
What is row level locking in mysql?
