Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To See Which Storage Engines Are Supported in Your MySQL Server
How To See Which Storage Engines Are Supported in Your MySQL Server? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB
✍: 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)
2007-05-10, 4510👍, 0💬
Popular Posts:
How can you enable automatic paging in DataGrid ? Following are the points to be done in order to en...
What Is a LABEL Tag/Element? - XHTML 1.0 Tutorials - Understanding Forms and Input Fields A "label" ...
How To Process Query Result in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL You can run queries...
How To Wirte a Simple JUnit Test Class? This is a common test in a job interview. You should be able...
Can we have shared events ? Yes, you can have shared event’s note only shared methods can raise shar...