Different needs require different capabilities, including storage medium (disk, memory), indexing, and concurrency control (locking methods). These different needs can (co)exist within a single application, for instance an e-commerce site that also wants to track page access (logging). As some of features are mutually exclusive, there can be no single storage engine that meets all these needs.
MySQL has a unique architecture with "Storage Engines". A number of storage engines are built in already, but new ones can be added! You can select a storage engine on a per-table basis.
This forum encourages discussion on the use of the currently existing storage engines (InnoDB, MyISAM and MERGE, Cluster, MEMORY), upcoming ones (the Federated storage engine), and new ideas. If you have any questions about this technology, or are thinking about implementing a new storage engine to meet a specific need, this is the place to talk about it!
For background and reference, also see the following MySQL Developer Zone articles:
Edited 2 time(s). Last edit at 04/22/2005 07:35PM by Edwin DeSouza.