The myisam plugin provides the classic MySQL MyISAM storage engine. Unlike MySQL, however, the InnoDB Storage Engine is the default storage engine in Drizzle.
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.
These command line options configure the plugin when drizzled is started. See Command Line Options for more information about specifying command line options.
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.
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.
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.
MySQL AB
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'