14.6. The EXAMPLE Storage Engine

MySQL 5.0

14.6. The EXAMPLE Storage Engine

The storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. As such, it is primarily of interest to developers.

The storage engine is included in MySQL-Max binary distributions. To enable this storage engine if you build MySQL from source, invoke configure with the option.

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

When you create an table, the server creates a table format file in the database directory. The file begins with the table name and has an extension. No other files are created. No data can be stored into the table. Retrievals return an empty result.

mysql> 
Query OK, 0 rows affected (0.78 sec)

mysql> 
ERROR 1031 (HY000): Table storage engine for 'test' doesn't have this option

mysql> 
Empty set (0.31 sec)

The storage engine does not support indexing.