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, 2559🔥, 0💬
Popular Posts:
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...