~drizzle-trunk/drizzle/development

Add Administration Getting Started and Logging. Capitalize SQL clause keywords.

added added

removed removed

Storage Engines

===============

Drizzle's micro-kernel has been designed to allow for data to be stored and

provided for by different "engines". Engines differ in many ways, but the

three primary types are, temporary only, transactional, and non-transaction.

Drizzle runs by default with a transactional engine for both regular and

temporary tables. You can override this behavior by specifying a different

engine when creating a table.

Some engines (for example MyISAM) may only support creating temporary tables.

Drizzle uses the :ref:`innobase_plugin` for all tables. The

:ref:`myisam_plugin` and :ref:`memory_plugin` are only used

for internal or temporary tables.