Which storage engines support transactions in MySQL?
- 2 Answers
- 6700 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 the command used to create a database using php and mysql?
what is the default port for mysql server? : Mysql dba
What is the use of mysql workbench?
How to check if a record exists in a mysql database php?
What are the similarities between a function and a procedure?
Is mysql query case sensitive?
What is a user defined variable?
what is constraints?
Is mysql a dbms?
What language is mysql written in?
How many types of indexes are there in mysql?
What are mysql functions?
How to filter data from a mysql database table with php?
How can I see mysql database?
Is mysql from oracle?
