89546

The example Storage Engine

The example storage engine is a stub engine that does nothing. Its purpose is to serve as an example

in the MySQL source codę that illustrates how to begin writing new storage engines. As such, it is primarily of interest to developers.

To enable the example storage engine if you build MySQL from source, invoke CMake with the -

DWITH_EXAMPLE_STORAGE_ENGINE option.

To examine the source for the example engine, look in the storage/example directory of a MySQL source distribution.

When you create an EXAMPLE table, the server creates a table format file in the database directory.

The file begins with the table name and has an . f rm extension. No

otherfiles are created. No data can

be stored into the table. Retrievals return an empty result.

mysq1 -CREATE TABLE test (i INT) ENGINE = EXAMPLE;