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, 2572🔥, 0💬
Popular Posts:
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...