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, 2899🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...