MyISAM Storage Engine

The myisam plugin provides the classic MySQL MyISAM storage engine. Unlike MySQL, however, the InnoDB Storage Engine is the default storage engine in Drizzle.

Loading

This plugin is loaded by default, but it may need to be configured. See the plugin’s Configuration and Variables.

To stop the plugin from loading by default, start drizzled with:

--plugin-remove=myisam

See also

Plugin Options for more information about adding and removing plugins.

Configuration

These command line options configure the plugin when drizzled is started. See Command Line Options for more information about specifying command line options.

--myisam.max-sort-file-size ARG
Default:INT32_MAX
Variable:myisam_max_sort_file_size

Don’t use the fast sort index method to created index if the temporary file would get bigger than this.

--myisam.sort-buffer-size ARG
Default:8388608 (8M)
Variable:myisam_sort_buffer_size

The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE.

Variables

These variables show the running configuration of the plugin. See variables for more information about querying and setting variables.

  • myisam_max_sort_file_size

    Scope:Global
    Dynamic:No
    Option:--myisam.max-sort-file-size

    Don’t use the fast sort index method to created index if the temporary file would get bigger than this.

  • myisam_sort_buffer_size

    Scope:Global
    Dynamic:No
    Option:--myisam.sort-buffer-size

    The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE.

Authors

MySQL AB

Version

This documentation applies to myisam 2.0.

To see which version of the plugin a Drizzle server is running, execute:

SELECT MODULE_VERSION FROM DATA_DICTIONARY.MODULES WHERE MODULE_NAME='myisam'

Changelog

v2.0

  • First Drizzle version.

Table Of Contents

Previous topic

Multi-Thread Scheduler

Next topic

MySQL Protocol

This Page