Collections:
Show Storage Engines Supported in MySQL in MySQL
How To See Which Storage Engines Are Supported in Your MySQL Server in MySQL?
✍: FYIcenter.com
If you want to know exactly which storage engines are supported in your MySQL server, you can run the "SHOW ENGINES" command as shown in the tutorial example below:
mysql> SHOW ENGINES;
+------------+---------+-----------------------------------
| Engine | Support | Comment
+------------+---------+-----------------------------------
| MyISAM | DEFAULT | Default engine as of MySQL 3.23
with great performance
| MEMORY | YES | Hash based, stored in memory,
useful for temporary tables
| InnoDB | YES | Supports transactions, row-level
locking, and foreign keys
| BerkeleyDB | YES | Supports transactions and page-
level locking
| BLACKHOLE | YES | /dev/null storage engine (anything
you write to it disappears)
| EXAMPLE | YES | Example storage engine
| ARCHIVE | YES | Archive storage engine
| CSV | NO | CSV storage engine
| ndbcluster | NO | Clustered, fault-tolerant, memory-
based tables
| FEDERATED | YES | Federated MySQL storage engine
| MRG_MYISAM | YES | Collection of identical MyISAM
tables
| ISAM | NO | Obsolete storage engine
+------------+---------+-----------------------------------
12 rows in set (0.00 sec)
⇒ Transaction Management: Commit or Rollback in MySQL
⇐ Data Removed in MEMORY Tables in MySQL
2017-08-08, 4313🔥, 0💬
Popular Posts:
How To Concatenate Two Binary Strings Together in SQL Server Transact-SQL? SQL Server 2005 allows to...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How to print value on console in SQL Server Transact-SQL? How to use the PRINT statements? In Transa...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...