Interested to Buy Any Domain ? << Click Here >> for more details...
Which storage engines support transactions in MySQL?
- 2 Answers
- 7622 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
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
Why myisam is faster than innodb?
How to find second highest salary from a table?
Where is the mysql database stored?
What is mysql sleep process?
What is the datatype of image?
How do I get a list of table names in mysql?
What is a deterministic function?
Is mysql is a programming language?
What is dirty read and phantom read?
Can we write procedure in mysql?
How to get current MySQL version?
What is dbms in mysql?
How can you add and remove any column of a table?
What is mysql ndb?
