|
|
| Applications |
| Mailing Lists |
| Miscellaneous |
| Operating Systems |
| Programming |
Table of Contents [+/-]
- 13.1. Overview of MySQL Storage Engine Architecture [+/-]
- 13.2. Supported Storage Engines [+/-]
- 13.3. Setting the Storage Engine
- 13.4. The
MyISAMStorage Engine [+/-] - 13.4. The
- 13.5. The
InnoDBStorage Engine [+/-] - 13.6. The
FalconStorage Engine [+/-] - 13.7. The
MERGEStorage Engine [+/-] - 13.8. The
MEMORY(HEAP) Storage Engine- 13.9. The
EXAMPLEStorage Engine- 13.10. The
FEDERATEDStorage Engine [+/-] - 13.9. The
- 13.11. The
ARCHIVEStorage Engine- 13.12. The
CSVStorage Engine [+/-] - 13.12. The
- 13.13. The
BLACKHOLEStorage Engine
MySQL supports several storage engines that act as handlers for different table types. MySQL storage engines include both those that handle transaction-safe tables and those that handle non-transaction-safe tables.
With MySQL 5.1, MySQL AB has introduced a new pluggable storage engine architecture that allows storage engines to be loaded into and unloaded from a running MySQL server.
This chapter describes each of the MySQL storage engines except for
NDBCLUSTER, which is covered in
MySQL Cluster. It also contains a description of
the pluggable storage engine architecture (see
Section 13.1, “Overview of MySQL Storage Engine Architectureâ€).
For answers to some commonly asked questions about MySQL storage engines, see Section A.2, “MySQL 6.0 FAQ — Storage Enginesâ€.
|
Contact Us Legal Notices Order Services Online Pantek Home Privacy Policy IT news Site Map Pantek Library |
User Comments
I have tried setting the storage engine or table type in my.cnf as well as in the command line. These appear to be unknown variables in 4.1.7. This is on a Mac OS X 10.3.5 machine.
To set the default engine use this in the my.cnf file: default-table-type=NDBCLUSTER
From the command line use: --default-table-type=NDBCLUSTER
I've tried setting up the default storage engine in the configuration, and if I use:
table_type = innodb
or
storage_engine = innodb
mysqld would fail to restart. I've now used:
default-storage_engine = innodb
And it works. See also http://bugs.mysql.com/bug.php?id=19061
More information about how to pick the best MySQL Storage engine for your real life scenario:
http://www.softwareprojects.com/resources/programming/t-mysql-storage-engines-1470.html
Add your own comment.