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, 2581🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...