6
The :program:`myisam` plugin provides the classic MySQL MyISAM storage engine.
7
Unlike MySQL, however, the :doc:`/plugins/innobase/index` is the
8
default storage engine in Drizzle.
15
This plugin is loaded by default, but it may need to be configured. See
16
the plugin's :ref:`myisam_configuration` and
17
:ref:`myisam_variables`.
19
To stop the plugin from loading by default, start :program:`drizzled`
22
--plugin-remove=myisam
24
.. seealso:: :ref:`drizzled_plugin_options` for more information about adding and removing plugins.
26
.. _myisam_configuration:
31
These command line options configure the plugin when :program:`drizzled`
32
is started. See :ref:`command_line_options` for more information about specifying
37
.. option:: --myisam.max-sort-file-size ARG
40
:Variable: :ref:`myisam_max_sort_file_size <myisam_max_sort_file_size>`
42
Don't use the fast sort index method to created index if the temporary file would get bigger than this.
44
.. option:: --myisam.sort-buffer-size ARG
46
:Default: 8388608 (8M)
47
:Variable: :ref:`myisam_sort_buffer_size <myisam_sort_buffer_size>`
49
The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE.
56
These variables show the running configuration of the plugin.
57
See `variables` for more information about querying and setting variables.
59
.. _myisam_max_sort_file_size:
61
* ``myisam_max_sort_file_size``
65
:Option: :option:`--myisam.max-sort-file-size`
67
Don't use the fast sort index method to created index if the temporary file would get bigger than this.
69
.. _myisam_sort_buffer_size:
71
* ``myisam_sort_buffer_size``
75
:Option: :option:`--myisam.sort-buffer-size`
77
The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE.
93
This documentation applies to **myisam 2.0**.
95
To see which version of the plugin a Drizzle server is running, execute:
99
SELECT MODULE_VERSION FROM DATA_DICTIONARY.MODULES WHERE MODULE_NAME='myisam'
106
* First Drizzle version.