Author: mcbrown
Date: 2006-08-23 20:00:19 +0200 (Wed, 23 Aug 2006)
New Revision: 3090
Log:
Checking ing first version of the new options/variables XML for building DBA and other tables so that I can being it under version control.
At the moment this doesn't validate against the corresponding DTD, but will when I finish putting the options together.
Added:
trunk/mysqld-optvars/options.dtd
trunk/mysqld-optvars/options.xml
Added: trunk/mysqld-optvars/options.dtd
===================================================================
--- trunk/mysqld-optvars/options.dtd (rev 0)
+++ trunk/mysqld-optvars/options.dtd 2006-08-23 18:00:19 UTC (rev 3090)
Changed blocks: 1, Lines Added: 52, Lines Deleted: 0; 2382 bytes
@@ -0,0 +1,52 @@
+<!ELEMENT introduced (#PCDATA)>
+<!ELEMENT types (optype|vartype)+>
+<!ELEMENT manual EMPTY>
+<!ATTLIST manual version (4.0 | 4.1 | 5.0 | 5.1) #REQUIRED >
+<!ELEMENT optype EMPTY>
+<!ELEMENT vartype EMPTY>
+<!ATTLIST optype class (serveropt | mycnf | cmdline) #REQUIRED>
+<!ATTLIST optype inversion CDATA #IMPLIED>
+<!ATTLIST optype outversion CDATA #IMPLIED>
+<!ATTLIST optype format CDATA #IMPLIED>
+<!ATTLIST optype setvar CDATA #IMPLIED>
+<!ATTLIST optype default CDATA #IMPLIED >
+<!ATTLIST vartype inversion CDATA #IMPLIED>
+<!ATTLIST vartype outversion CDATA #IMPLIED>
+<!ATTLIST vartype format CDATA #IMPLIED>
+<!ATTLIST vartype type (global|session|both) #IMPLIED>
+<!ATTLIST vartype class (status | server|both) #REQUIRED>
+<!ATTLIST vartype default CDATA #IMPLIED>
+<!ATTLIST vartype isdynamic (yes | no) #REQUIRED >
+<!ELEMENT seealso EMPTY>
+<!ATTLIST seealso xref IDREF #REQUIRED>
+<!ELEMENT opclass EMPTY>
+<!ATTLIST opclass class (security | ssl | binlog | replication | server | myisam
+| innodb | cluster | ndb | bdb) #REQUIRED >
+<!ELEMENT disabledby EMPTY>
+<!ATTLIST disabledby xref IDREF #REQUIRED>
+<!ELEMENT deprecated EMPTY>
+<!ATTLIST deprecated xref IDREF #IMPLIED>
+<!ATTLIST deprecated version CDATA #REQUIRED >
+<!ELEMENT cmdline (#PCDATA | format)*>
+<!ELEMENT mysqloptions (#PCDATA | mysqloption)*>
+<!ELEMENT shortdescription (#PCDATA)>
+<!ELEMENT engines (engine)*>
+<!ATTLIST engines includes CDATA "all">
+<!ELEMENT engine EMPTY>
+<!ATTLIST engine engine (myisam | memory | innodb | bdb | blackhole | example
+|archive | csv | ndb | federated | merge | isam | falcon | maria) #REQUIRED >
+<!ELEMENT version (#PCDATA)>
+<!ELEMENT platforms (#PCDATA)>
+<!ELEMENT incompatible (#PCDATA)>
+<!ELEMENT section EMPTY>
+<!ATTLIST section id (mysqld | replication | cluster) #REQUIRED>
+<!ELEMENT mysqloption
+( name+ , shortdescription+, section*, opclass+, engines*,
+platforms*,seealso*,incompatible*,disabledby*,deprecated?,types+,versions? )>
+<!ATTLIST mysqloption id ID #REQUIRED>
+<!ELEMENT versions (#PCDATA | introduced | manual)*>
+<!ELEMENT name (#PCDATA)>
+<!ELEMENT format (#PCDATA)>
+<!ATTLIST format version CDATA #IMPLIED>
+
+
Added: trunk/mysqld-optvars/options.xml
===================================================================
--- trunk/mysqld-optvars/options.xml (rev 0)
+++ trunk/mysqld-optvars/options.xml 2006-08-23 18:00:19 UTC (rev 3090)
Changed blocks: 1, Lines Added: 5999, Lines Deleted: 0; 206264 bytes
@@ -0,0 +1,5999 @@
+<!DOCTYPE mysqloptions SYSTEM "file:/MySQLData/Docs/mysqldoc.dbatable/trunk/refman-options/options.dtd">
+<mysqloptions>
+ <mysqloption id="binlog_format">
+ <name>Binlog format</name>
+ <shortdescription>Specifies the format of the binary log</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="binlog"/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <seealso xref="log-bin-trust-function-creators"/>
+ <seealso xref="innodb_locks_unsafe_for_binlog"/>
+ <types>
+ <optype class="serveropt" inversion="5.1.5" format="binlog-format"
+ setvar="binlog_format"/>
+ <vartype class="server" inversion="5.1.8" isdynamic="yes"/>
+ <optype class="cmdline" inversion="5.1.5" format="--binlog-format"
+ setvar="binlog_format"/>
+ </types>
+ <versions>
+ <introduced>5.1.5</introduced>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+
+ <mysqloption id="help">
+ <name>Help</name>
+ <shortdescription>Display help</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="server"/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+
+ <types>
+ <optype class="cmdline" format="-?"/>
+ <optype class="cmdline" format="-help"/>
+ </types>
+ <versions>
+ <introduced>4.0.24</introduced>
+ <introduced>4.1.10a</introduced>
+ <manual version="4.0"/>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+
+ <mysqloption id="abort-slave-event-count">
+ <name>abort-slave-event-count</name>
+ <shortdescription>Option used by mysql-test for debugging and testing of
+ replication.</shortdescription>
+ <section id="replication"/>
+ <opclass class="replication"/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--abort-slave-event-count=#"
+ setvar="abort-slave-event-count"/>
+ <vartype class="server" isdynamic="no" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+
+ <mysqloption id="allow-suspicious-udfs">
+ <name>allow-suspicious-udfs</name>
+ <shortdescription>Allows use of UDFs consisting of only one symbol xxx()
+ without corresponding xxx_init() or xxx_deinit().</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="server"/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--allow-suspicious-udfs"
+ setvar="allow-suspicious-udfs"/>
+ <vartype class="server" isdynamic="no" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+
+ <mysqloption id="ansi">
+ <name>ansi</name>
+ <shortdescription>Use ANSI SQL syntax instead of MySQL syntax. </shortdescription>
+ <section id="mysqld"/>
+ <opclass class="server"/>
+ <engines includes="all"/>
+
+ <platforms>All</platforms>
+ <seealso xref="sql-mode"/>
+ <types>
+ <optype class="cmdline" format="--ansi"/>
+ <optype class="cmdline" format="-a"/>
+ <optype class="serveropt" format="ansi"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+
+ <mysqloption id="auto-increment-increment">
+ <name>auto-increment-increment</name>
+ <shortdescription>Auto-increment columns are incremented by this value.</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="server"/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <seealso xref="auto-increment-offset"/>
+ <types>
+ <optype class="cmdline" format="--auto-increment-increment[=#]"
+ setvar="auto-increment-increment"/>
+ <vartype class="server" isdynamic="yes" default="1"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="auto-increment-offset">
+ <name>auto-increment-offset</name>
+ <shortdescription>Offset added to Auto-increment columns. </shortdescription>
+ <section id="mysqld"/>
+ <opclass class="server"/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <seealso xref="auto-increment-increment"/>
+ <types>
+ <optype class="cmdline" format="--auto-increment-offset[=#]"
+ setvar="auto-increment-offset"/>
+ <vartype class="server" isdynamic="yes" default="1"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="automatic-sp-privileges">
+ <name>automatic-sp-privileges</name>
+ <shortdescription>Creating and dropping stored procedures alters ACLs.</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="security"/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <disabledby xref="skip-automatic-sp-privileges"/>
+ <types>
+ <optype class="cmdline" format="--automatic-sp-privileges"
+ setvar="automatic-sp-privileges"/>
+ <vartype class="server" isdynamic="yes" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="back_log">
+ <name>back_log</name>
+ <shortdescription>The number of outstanding connection requests MySQL can
+ have. </shortdescription>
+ <section id="mysqld"/>
+ <opclass class="server"/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--back_log=#" setvar="back_log"/>
+ <vartype class="server" isdynamic="yes" default="50"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="basedir">
+ <name>basedir</name>
+ <shortdescription>Path to installation directory. All paths are usually
+ resolved relative to this.</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="server"/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--basedir=name" setvar="basedir"/>
+ <optype class="cmdline" format="-b" setvar="basedir"/>
+ <optype class="serveropt" format="basedir" setvar="basedir"/>
+ <vartype class="server" isdynamic="no"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+
+ <mysqloption id="bdb">
+ <name>bdb</name>
+ <shortdescription>Enable Berkeley DB (if this version of MySQL supports it).
+ Disable with --skip-bdb (will save memory).</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="bdb"/>
+ <engines>
+ <engine engine="bdb"/>
+ </engines>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--bdb" outversion="5.1.12"
+ setvar="have_bdb"/>
+ <vartype class="server" format="have_bdb" outversion="5.1.12"
+ isdynamic="no" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="bdb-home">
+ <name>bdb-home</name>
+ <shortdescription>Berkeley home directory.</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="bdb"/>
+ <engines>
+ <engine engine="bdb"/>
+ </engines>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--bdb-home=name" outversion="5.1.12"
+ setvar="bdb_home"/>
+ <vartype class="server" format="bdb_home" outversion="5.1.12"
+ isdynamic="no"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="bdb-lock-detect">
+ <name>bdb-lock-detect</name>
+ <shortdescription>Berkeley lock detect.</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="bdb"/>
+ <engines>
+ <engine engine="bdb"/>
+ </engines>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--bdb-lock-detect=name"
+ outversion="5.1.12"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="bdb-logdir">
+ <name>bdb-logdir</name>
+ <shortdescription>Berkeley DB log file directory.</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="bdb"/>
+ <engines>
+ <engine engine="bdb"/>
+ </engines>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--bdb-logdir=name" outversion="5.1.12"
+ setvar="bdb_logdir"/>
+ <vartype class="server" isdynamic="no" format="bdb_logdir"
+ outversion="5.1.12"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="bdb-no-recover">
+ <name>bdb-no-recover</name>
+ <shortdescription>Don't try to recover Berkeley DB tables on start.</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="bdb"/>
+ <engines>
+ <engine engine="bdb"/>
+ </engines>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--bdb-no-recover" outversion="5.1.12"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="bdb-no-sync">
+ <name>bdb-no-sync</name>
+ <shortdescription>Disables synchronous BDB log flushes</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="bdb"/>
+ <engines>
+ <engine engine="bdb"/>
+ </engines>
+ <platforms>All</platforms>
+ <deprecated version="5.0.24" xref="skip-sync-bdb-logs"/>
+ <types>
+ <optype class="cmdline" format="--bdb-no-sync" outversion="5.1.12"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="bdb-shared-data">
+ <name>bdb-shared-data</name>
+ <shortdescription>Start Berkeley DB in multi-process mode.</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="bdb"/>
+ <engines>
+ <engine engine="bdb"/>
+ </engines>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--bdb-shared-data" outversion="5.1.12"
+ setvar="bdb_shared_data"/>
+ <vartype class="server" format="bdb_shared_data" outversion="5.1.12"
+ isdynamic="no"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="bdb-tmpdir">
+ <name>bdb-tmpdir</name>
+ <shortdescription>Berkeley DB tempfile name.</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="server"/>
+ <engines>
+ <engine engine="bdb"/>
+ </engines>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--bdb-tmpdir=name" outversion="5.1.12"
+ setvar="bdb_tmpdir"/>
+ <vartype class="server" format="bdb_tmpdir" outversion="5.1.12"
+ isdynamic="no"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="bdb_cache_size">
+ <name>bdb_cache_size</name>
+ <shortdescription>The buffer that is allocated to cache index and rows for
+ BDB tables.</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="bdb"/>
+ <engines>
+ <engine engine="bdb"/>
+ </engines>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--bdb_cache_size=#" outversion="5.1.12"
+ setvar="bdb_cache_size"/>
+ <vartype class="server" isdynamic="no" format="bdb_cache_size"
+ outversion="5.1.12" default="8388600"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="bdb_lock_max">
+ <name>bdb_lock_max</name>
+ <shortdescription>Synonym for bdb_max_lock.</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="bdb"/>
+ <engines>
+ <engine engine="bdb"/>
+ </engines>
+
+ <platforms>All</platforms>
+ <seealso xref="bdb_max_lock"/>
+ <types>
+ <optype class="cmdline" format="--bdb_lock_max=#" outversion="5.1.12"
+ setvar="bdb_lock_max"/>
+ <vartype class="server" isdynamic="no" outversion="5.1.12" default="10000"
+ />
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="bdb_log_buffer_size">
+ <name>bdb_log_buffer_size</name>
+ <shortdescription>The buffer that is allocated to cache index and rows for
+ BDB tables.</shortdescription>
+ <section id="mysqld"/>
+ <opclass class="bdb"/>
+ <engines><engine engine="bdb"/></engines>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--bdb_log_buffer_size=#"
+ setvar="bdb_log_buffer_size"/>
+ <vartype class="server" format="bdb_log_buffer_size" isdynamic="no"
+ outversion="5.1.12" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="bdb_max_lock">
+ <name>bdb_max_lock</name>
+ <shortdescription>The maximum number of locks you can have active on a BDB
+ table.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--bdb_max_lock=#" setvar="bdb_max_lock"/>
+ <vartype class="server" default="10000"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="big-tables">
+ <name>big-tables</name>
+ <shortdescription>Allow big result sets by saving all temporary sets on file
+ (Solves most 'table full' errors).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--big-tables"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="bind-address">
+ <name>bind-address</name>
+ <shortdescription>IP address to bind to. --binlog_format=name Tell the
+ master the form of binary logging to use: either 'row' for row-based
+ binary logging, or 'statement' for statement-based binary logging, or
+ 'mixed'. 'mixed' is statement-based binary logging except for those
+ statements where only row-based is correct: those which involve
+ user-defined functions (i.e. UDFs) or the UUID() function; for those,
+ row-based binary logging is automatically used. If ndbcluster is enabled,
+ the default is 'row'.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--bind-address=name" setvar="bind-address"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="binlog-do-db">
+ <name>binlog-do-db</name>
+ <shortdescription>Tells the master it should log updates for the specified
+ database, and exclude all others not explicitly mentioned.
+ --binlog-ignore-db=name Tells the master that updates to the given
+ database should not be logged tothe binary log.
+ --binlog-row-event-max-size=# The maximum size of a row-based binary log
+ event in bytes. Rows will be grouped into events smaller than this size if
+ possible. The value has to be a multiple of 256.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--binlog-do-db=name"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="binlog-ignore-db">
+ <name>binlog-ignore-db</name>
+ <shortdescription>Tells the master that updates to the given database should
+ not be logged tothe binary log.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--binlog-ignore-db=name"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="binlog-row-event-max-size">
+ <name>binlog-row-event-max-size</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="binlog_cache_size">
+ <name>binlog_cache_size</name>
+ <shortdescription>The size of the cache to hold the SQL statements for the
+ binary log during a transaction. If you often use big, multi-statement
+ transactions you can increase this to get more performance.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--binlog_cache_size=#"
+ setvar="binlog_cache_size"/>
+ <vartype class="server" default="32768"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="bootstrap">
+ <name>bootstrap</name>
+ <shortdescription>Used by mysql installation scripts.
+ --character-set-client-handshake Don't ignore client side character set
+ value sent during handshake. --character-set-filesystem=name Set the
+ filesystem character set.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--bootstrap"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="bulk_insert_buffer_size">
+ <name>bulk_insert_buffer_size</name>
+ <shortdescription>Size of tree cache used in bulk insert optimisation. Note
+ that this is a limit per thread!</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--bulk_insert_buffer_size=#"
+ setvar="bulk_insert_buffer_size"/>
+ <vartype class="server" default="8388608"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="character-set-client-handshake">
+ <name>character-set-client-handshake</name>
+ <shortdescription>Don't ignore client side character set value sent during
+ handshake.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--character-set-client-handshake"
+ setvar="character-set-client-handshake"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="character-set-filesystem">
+ <name>character-set-filesystem</name>
+ <shortdescription>Set the filesystem character set.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--character-set-filesystem=name"
+ setvar="character-set-filesystem"/>
+ <vartype class="server" default="binary"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="character-set-server">
+ <name>character-set-server</name>
+ <shortdescription>instead). --default-collation=name Set the default
+ collation (deprecated option, use</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--character-set-server"
+ setvar="character-set-server"/>
+ <vartype class="server" default="latin1"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="character-sets-dir">
+ <name>character-sets-dir</name>
+ <shortdescription>Directory where character sets are.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--character-sets-dir=name"
+ setvar="character-sets-dir"/>
+ <vartype class="server" default="/usr/local/mysql/share/mysql/charsets/"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="chroot">
+ <name>chroot</name>
+ <shortdescription>Chroot mysqld daemon during startup.
+ --collation-server=name Set the default collation.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--chroot=name" setvar="chroot"/>
+ <optype class="cmdline" format="-r" setvar="chroot"/>
+ <optype class="serveropt" format="chroot" setvar="chroot"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="collation-server">
+ <name>collation-server</name>
+ <shortdescription>instead). --default-storage-engine=name Set the default
+ storage engine (table type) for tables. --default-table-type=name
+ (deprecated) Use --default-storage-engine. --default-time-zone=name Set
+ the default time zone. --delay-key-write[=name] Type of DELAY_KEY_WRITE.
+ --delay-key-write-for-all-tables Don't flush key buffers between writes
+ for any MyISAM table (Deprecated option, use --delay-key-write=all
+ instead). --disconnect-slave-event-count=# Option used by mysql-test for
+ debugging and testing of replication.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--collation-server"
+ setvar="collation-server"/>
+ <vartype class="server" default="latin1_swedish_ci"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="completion-type">
+ <name>completion-type</name>
+ <shortdescription>Default completion type. --concurrent-insert[=#] Use
+ concurrent insert with MyISAM. Disable with --concurrent-insert=0</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--completion-type=#"
+ setvar="completion-type"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="concurrent-insert">
+ <name>concurrent-insert</name>
+ <shortdescription>Use concurrent insert with MyISAM. Disable with
+ --concurrent-insert=0</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--concurrent-insert[=#]"
+ setvar="concurrent-insert"/>
+ <vartype class="server" default="1"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="connect_timeout">
+ <name>connect_timeout</name>
+ <shortdescription>The number of seconds the mysqld server is waiting for a
+ connect packet before responding with 'Bad handshake'.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--connect_timeout=#"
+ setvar="connect_timeout"/>
+ <vartype class="server" default="5"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="console">
+ <name>console</name>
+ <shortdescription>Write error output on screen; Don't remove the console
+ window on windows.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--console" setvar="console"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="core-file">
+ <name>core-file</name>
+ <shortdescription>Write core on errors.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--core-file"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="crash_binlog_innodb">
+ <name>crash_binlog_innodb</name>
+ <shortdescription>Used only for testing, to crash when writing Nth event to
+ binlog.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--crash_binlog_innodb=#"
+ setvar="crash_binlog_innodb"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="datadir">
+ <name>datadir</name>
+ <shortdescription>Path to the database root.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--datadir=name" setvar="datadir"/>
+ <optype class="cmdline" format="-h" setvar="datadir"/>
+ <optype class="serveropt" format="datadir" setvar="datadir"/>
+ <vartype class="server" default="/usr/local/mysql/var/"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="date_format">
+ <name>date_format</name>
+ <shortdescription>The DATE format (For future). --datetime_format=name The
+ DATETIME/TIMESTAMP format (for future). --default_week_format=# The
+ default week format used by WEEK() functions. --delayed_insert_limit=#
+ After inserting delayed_insert_limit rows, the INSERT DELAYED handler will
+ check if there are any SELECT statements pending. If so, it allows these
+ to execute before continuing. --delayed_insert_timeout=# How long a INSERT
+ DELAYED thread should wait for INSERT statements before terminating.
+ --delayed_queue_size=# What size queue (in rows) should be allocated for
+ handling INSERT DELAYED. If the queue becomes full, any client that does
+ INSERT DELAYED will wait until there is room in the queue again.
+ --div_precision_increment=# Precision of the result of '/' operator will
+ be increased on that value. --expire_logs_days=# If non-zero, binary logs
+ will be purged after expire_logs_days days; possible purges happen at
+ startup and at binary log rotation.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--date_format=name" setvar="date_format"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="datetime_format">
+ <name>datetime_format</name>
+ <shortdescription>The DATETIME/TIMESTAMP format (for future).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--datetime_format=name"
+ setvar="datetime_format"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="default-character-set">
+ <name>default-character-set</name>
+ <shortdescription>Set the default character set (deprecated option, use</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--default-character-set=name"
+ setvar="default-character-set"/>
+ <optype class="cmdline" format="-C" setvar="default-character-set"/>
+ <optype class="serveropt" format="default-character-set"
+ setvar="default-character-set"/>
+ <vartype class="server" default="latin1"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="default-collation">
+ <name>default-collation</name>
+ <shortdescription>Set the default collation (deprecated option, use</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--default-collation=name"
+ setvar="default-collation"/>
+ <vartype class="server" default="latin1_swedish_ci"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="default-storage-engine">
+ <name>default-storage-engine</name>
+ <shortdescription>Set the default storage engine (table type) for tables.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--default-storage-engine=name"
+ setvar="default-storage-engine"/>
+ <vartype class="server" default="MyISAM"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="default-table-type">
+ <name>default-table-type</name>
+ <shortdescription>(deprecated) Use --default-storage-engine.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--default-table-type=name"
+ setvar="default-table-type"/>
+ <vartype class="server" default="MyISAM"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="default-time-zone">
+ <name>default-time-zone</name>
+ <shortdescription>Set the default time zone.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--default-time-zone=name"
+ setvar="default-time-zone"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="default_week_format">
+ <name>default_week_format</name>
+ <shortdescription>The default week format used by WEEK() functions.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--default_week_format=#"
+ setvar="default_week_format"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="delay-key-write">
+ <name>delay-key-write</name>
+ <shortdescription>Type of DELAY_KEY_WRITE.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--delay-key-write[=name]"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="delay-key-write-for-all-tables">
+ <name>delay-key-write-for-all-tables</name>
+ <shortdescription>Don't flush key buffers between writes for any MyISAM
+ table (Deprecated option, use --delay-key-write=all instead).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--delay-key-write-for-all-tables"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="delayed_insert_limit">
+ <name>delayed_insert_limit</name>
+ <shortdescription>After inserting delayed_insert_limit rows, the INSERT
+ DELAYED handler will check if there are any SELECT statements pending. If
+ so, it allows these to execute before continuing.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--delayed_insert_limit=#"
+ setvar="delayed_insert_limit"/>
+ <vartype class="server" default="100"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="delayed_insert_timeout">
+ <name>delayed_insert_timeout</name>
+ <shortdescription>How long a INSERT DELAYED thread should wait for INSERT
+ statements before terminating.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--delayed_insert_timeout=#"
+ setvar="delayed_insert_timeout"/>
+ <vartype class="server" default="300"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="delayed_queue_size">
+ <name>delayed_queue_size</name>
+ <shortdescription>What size queue (in rows) should be allocated for handling
+ INSERT DELAYED. If the queue becomes full, any client that does INSERT
+ DELAYED will wait until there is room in the queue again.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--delayed_queue_size=#"
+ setvar="delayed_queue_size"/>
+ <vartype class="server" default="1000"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="des-key-file">
+ <name>des-key-file</name>
+ <shortdescription>Load keys for des_encrypt() and des_encrypt from given
+ file.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--des-key-file=name" setvar="des-key-file"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="disconnect-slave-event-count">
+ <name>disconnect-slave-event-count</name>
+ <shortdescription>Option used by mysql-test for debugging and testing of
+ replication.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--disconnect-slave-event-count=#"
+ setvar="disconnect-slave-event-count"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="div_precision_increment">
+ <name>div_precision_increment</name>
+ <shortdescription>Precision of the result of '/' operator will be increased
+ on that value.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--div_precision_increment=#"
+ setvar="div_precision_increment"/>
+ <vartype class="server" default="4"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="enable-locking">
+ <name>enable-locking</name>
+ <shortdescription>Deprecated option, use --external-locking instead.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--enable-locking" setvar="enable-locking"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="enable-pstack">
+ <name>enable-pstack</name>
+ <shortdescription>Print a symbolic stack trace on failure.
+ --engine-condition-pushdown Push supported query conditions to the storage
+ engine.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--enable-pstack" setvar="enable-pstack"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="engine-condition-pushdown">
+ <name>engine-condition-pushdown</name>
+ <shortdescription>Push supported query conditions to the storage engine.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--engine-condition-pushdown"
+ setvar="engine-condition-pushdown"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="event-scheduler">
+ <name>event-scheduler</name>
+ <shortdescription>Enable/disable the event scheduler.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--event-scheduler=#"
+ setvar="event-scheduler"/>
+ <vartype class="server" default="2"/>
+ </types>
+ <versions>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="exit-info">
+ <name>exit-info</name>
+ <shortdescription>Used for debugging; Use at your own risk!</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--exit-info[=#]"/>
+ <optype class="cmdline" format="-T"/>
+ <optype class="serveropt" format="exit-info"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="expire_logs_days">
+ <name>expire_logs_days</name>
+ <shortdescription>If non-zero, binary logs will be purged after
+ expire_logs_days days; possible purges happen at startup and at binary log
+ rotation.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--expire_logs_days=#"
+ setvar="expire_logs_days"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="external-locking">
+ <name>external-locking</name>
+ <shortdescription>Use system (external) locking (disabled by default). With
+ this option enabled you can run myisamchk to test (not repair) tables
+ while the MySQL server is running. Disable with --skip-external-locking.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--external-locking"
+ setvar="external-locking"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="flush">
+ <name>flush</name>
+ <shortdescription>Flush tables to disk between SQL commands.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--flush"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="flush_time">
+ <name>flush_time</name>
+ <shortdescription>A dedicated thread is created to flush all tables at the
+ given interval. --ft_boolean_syntax=name List of operators for MATCH ...
+ AGAINST ( ... IN BOOLEAN MODE)</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--flush_time=#" setvar="flush_time"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ft_boolean_syntax">
+ <name>ft_boolean_syntax</name>
+ <shortdescription>List of operators for MATCH ... AGAINST ( ... IN BOOLEAN
+ MODE)</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ft_boolean_syntax=name"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ft_max_word_len">
+ <name>ft_max_word_len</name>
+ <shortdescription>The maximum length of the word to be included in a
+ FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this
+ variable.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ft_max_word_len=#"
+ setvar="ft_max_word_len"/>
+ <vartype class="server" default="84"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ft_min_word_len">
+ <name>ft_min_word_len</name>
+ <shortdescription>The minimum length of the word to be included in a
+ FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this
+ variable. --ft_query_expansion_limit=# Number of best matches to use for
+ query expansion --ft_stopword_file=name Use stopwords from this file
+ instead of built-in list. --group_concat_max_len=# The maximum length of
+ the result of function group_concat. --innodb_additional_mem_pool_size=#
+ Size of a memory pool InnoDB uses to store data dictionary information and
+ other internal data structures. --innodb_autoextend_increment=# Data file
+ autoextend increment in megabytes --innodb_buffer_pool_awe_mem_mb=# If
+ Windows AWE is used, the size of InnoDB buffer pool allocated from the AWE
+ memory. --innodb_buffer_pool_size=# The size of the memory buffer InnoDB
+ uses to cache data and indexes of its tables.
+ --innodb_commit_concurrency=# Helps in performance tuning in heavily
+ concurrent environments. --innodb_concurrency_tickets=# Number of times a
+ thread is allowed to enter InnoDB within the same SQL query after it has
+ once got the ticket --innodb_file_io_threads=# Number of file I/O threads
+ in InnoDB. --innodb_force_recovery=# Helps to save your data in case the
+ disk image of the database becomes corrupt. --innodb_lock_wait_timeout=#
+ Timeout in seconds an InnoDB transaction may wait for a lock before being
+ rolled back. --innodb_log_buffer_size=# The size of the buffer which
+ InnoDB uses to write log to the log files on disk.
+ --innodb_log_file_size=# Size of each log file in a log group.
+ --innodb_log_files_in_group=# Number of log files in the log group. InnoDB
+ writes to the files in a circular fashion. Value 3 is recommended here.
+ --innodb_mirrored_log_groups=# Number of identical copies of log groups we
+ keep for the database. Currently this should be set to 1.
+ --innodb_open_files=# How many files at the maximum InnoDB keeps open at
+ the same time. --innodb_sync_spin_loops=# Count of spin-loop rounds in
+ InnoDB mutexes --innodb_thread_concurrency=# Helps in performance tuning
+ in heavily concurrent environments. Sets the maximum number of threads
+ allowed inside InnoDB. Value 0 will disable the thread throttling.
+ --innodb_thread_sleep_delay=# Time of innodb thread sleeping before
+ joining InnoDB queue (usec). Value 0 disable a sleep
+ --interactive_timeout=# The number of seconds the server waits for
+ activity on an interactive connection before closing it.
+ --join_buffer_size=# The size of the buffer that is used for full joins.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ft_min_word_len=#"
+ setvar="ft_min_word_len"/>
+ <vartype class="server" default="4"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ft_query_expansion_limit">
+ <name>ft_query_expansion_limit</name>
+ <shortdescription>Number of best matches to use for query expansion</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ft_query_expansion_limit=#"
+ setvar="ft_query_expansion_limit"/>
+ <vartype class="server" default="20"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ft_stopword_file">
+ <name>ft_stopword_file</name>
+ <shortdescription>Use stopwords from this file instead of built-in list.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ft_stopword_file=name"
+ setvar="ft_stopword_file"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="gdb">
+ <name>gdb</name>
+ <shortdescription>Set up signals usable for debugging</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--gdb" setvar="gdb"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="general-log">
+ <name>general-log</name>
+ <shortdescription>Enable|disable general log</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--general-log" setvar="general-log"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="group_concat_max_len">
+ <name>group_concat_max_len</name>
+ <shortdescription>The maximum length of the result of function group_concat.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--group_concat_max_len=#"
+ setvar="group_concat_max_len"/>
+ <vartype class="server" default="1024"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="help">
+ <name>help</name>
+ <shortdescription>Display this help and exit. --abort-slave-event-count=#
+ Option used by mysql-test for debugging and testing of replication.
+ --allow-suspicious-udfs Allows use of UDFs consisting of only one symbol
+ xxx() without corresponding xxx_init() or xxx_deinit(). That also means
+ that one can load any function from any library, for example exit() from
+ libc.so</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--help" setvar="help"/>
+ <optype class="cmdline" format="-?" setvar="help"/>
+ <optype class="serveropt" format="help" setvar="help"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="init-connect">
+ <name>init-connect</name>
+ <shortdescription>Command(s) that are executed for each new connection</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--init-connect=name" setvar="init-connect"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="init-file">
+ <name>init-file</name>
+ <shortdescription>Read SQL commands from this file at startup.
+ --init-rpl-role=name Set the replication role.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--init-file=name" setvar="init-file"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="init-rpl-role">
+ <name>init-rpl-role</name>
+ <shortdescription>Set the replication role.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--init-rpl-role=name"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="init-slave">
+ <name>init-slave</name>
+ <shortdescription>Command(s) that are executed when a slave connects to this
+ master</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--init-slave=name" setvar="init-slave"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb">
+ <name>innodb</name>
+ <shortdescription>Enable InnoDB (if this version of MySQL supports it).
+ Disable with --skip-innodb (will save memory).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb" setvar="innodb"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_additional_mem_pool_size">
+ <name>innodb_additional_mem_pool_size</name>
+ <shortdescription>Size of a memory pool InnoDB uses to store data dictionary
+ information and other internal data structures.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_additional_mem_pool_size=#"
+ setvar="innodb_additional_mem_pool_size"/>
+ <vartype class="server" default="1048576"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_autoextend_increment">
+ <name>innodb_autoextend_increment</name>
+ <shortdescription>Data file autoextend increment in megabytes</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_autoextend_increment=#"
+ setvar="innodb_autoextend_increment"/>
+ <vartype class="server" default="8"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_buffer_pool_awe_mem_mb">
+ <name>innodb_buffer_pool_awe_mem_mb</name>
+ <shortdescription>If Windows AWE is used, the size of InnoDB buffer pool
+ allocated from the AWE memory.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_buffer_pool_awe_mem_mb=#"
+ setvar="innodb_buffer_pool_awe_mem_mb"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_buffer_pool_size">
+ <name>innodb_buffer_pool_size</name>
+ <shortdescription>The size of the memory buffer InnoDB uses to cache data
+ and indexes of its tables.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_buffer_pool_size=#"
+ setvar="innodb_buffer_pool_size"/>
+ <vartype class="server" default="8388608"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_checksums">
+ <name>innodb_checksums</name>
+ <shortdescription>Enable InnoDB checksums validation (enabled by default).
+ Disable with --skip-innodb-checksums. --innodb_data_file_path=name Path to
+ individual files and their sizes. --innodb_data_home_dir=name The common
+ part for InnoDB table spaces. --innodb_doublewrite Enable InnoDB
+ doublewrite buffer (enabled by default). Disable with
+ --skip-innodb-doublewrite. --innodb_fast_shutdown[=#] Speeds up the
+ shutdown process of the InnoDB storage engine. Possible values are 0, 1
+ (faster) or 2 (fastest - crash-like). --innodb_file_per_table Stores each
+ InnoDB table to an .ibd file in the database dir.
+ --innodb_flush_log_at_trx_commit[=#] Set to 0 (write and flush once per
+ second), 1 (write and flush at each commit) or 2 (write at commit, flush
+ once per second). --innodb_flush_method=name With which method to flush
+ data. --innodb_locks_unsafe_for_binlog Force InnoDB to not use next-key
+ locking, to use only row-level locking. --innodb_log_arch_dir=name Where
+ full logs should be archived. --innodb_log_archive[=#] Set to 1 if you
+ want to have logs archived. --innodb_log_group_home_dir=name Path to
+ InnoDB log files. --innodb_max_dirty_pages_pct=# Percentage of dirty pages
+ allowed in bufferpool. --innodb_max_purge_lag=# Desired maximum length of
+ the purge queue (0 = no limit) --innodb_status_file Enable SHOW INNODB
+ STATUS output in the innodb_status.[pid] file</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_checksums"
+ setvar="innodb_checksums"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_commit_concurrency">
+ <name>innodb_commit_concurrency</name>
+ <shortdescription>Helps in performance tuning in heavily concurrent
+ environments.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_commit_concurrency=#"
+ setvar="innodb_commit_concurrency"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_concurrency_tickets">
+ <name>innodb_concurrency_tickets</name>
+ <shortdescription>Number of times a thread is allowed to enter InnoDB within
+ the same SQL query after it has once got the ticket</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_concurrency_tickets=#"
+ setvar="innodb_concurrency_tickets"/>
+ <vartype class="server" default="500"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_data_file_path">
+ <name>innodb_data_file_path</name>
+ <shortdescription>Path to individual files and their sizes.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_data_file_path=name"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_data_home_dir">
+ <name>innodb_data_home_dir</name>
+ <shortdescription>The common part for InnoDB table spaces.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_data_home_dir=name"
+ setvar="innodb_data_home_dir"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_doublewrite">
+ <name>innodb_doublewrite</name>
+ <shortdescription>Enable InnoDB doublewrite buffer (enabled by default).
+ Disable with --skip-innodb-doublewrite.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_doublewrite"
+ setvar="innodb_doublewrite"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_fast_shutdown">
+ <name>innodb_fast_shutdown</name>
+ <shortdescription>Speeds up the shutdown process of the InnoDB storage
+ engine. Possible values are 0, 1 (faster) or 2 (fastest - crash-like).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_fast_shutdown[=#]"
+ setvar="innodb_fast_shutdown"/>
+ <vartype class="server" default="1"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_file_io_threads">
+ <name>innodb_file_io_threads</name>
+ <shortdescription>Number of file I/O threads in InnoDB.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_file_io_threads=#"
+ setvar="innodb_file_io_threads"/>
+ <vartype class="server" default="4"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_file_per_table">
+ <name>innodb_file_per_table</name>
+ <shortdescription>Stores each InnoDB table to an .ibd file in the database
+ dir.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_file_per_table"
+ setvar="innodb_file_per_table"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_flush_log_at_trx_commit">
+ <name>innodb_flush_log_at_trx_commit</name>
+ <shortdescription>Set to 0 (write and flush once per second), 1 (write and
+ flush at each commit) or 2 (write at commit, flush once per second).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_flush_log_at_trx_commit[=#]"
+ setvar="innodb_flush_log_at_trx_commit"/>
+ <vartype class="server" default="1"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_flush_method">
+ <name>innodb_flush_method</name>
+ <shortdescription>With which method to flush data.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_flush_method=name"
+ setvar="innodb_flush_method"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_force_recovery">
+ <name>innodb_force_recovery</name>
+ <shortdescription>Helps to save your data in case the disk image of the
+ database becomes corrupt.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_force_recovery=#"
+ setvar="innodb_force_recovery"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_lock_wait_timeout">
+ <name>innodb_lock_wait_timeout</name>
+ <shortdescription>Timeout in seconds an InnoDB transaction may wait for a
+ lock before being rolled back.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_lock_wait_timeout=#"
+ setvar="innodb_lock_wait_timeout"/>
+ <vartype class="server" default="50"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_locks_unsafe_for_binlog">
+ <name>innodb_locks_unsafe_for_binlog</name>
+ <shortdescription>Force InnoDB not to use next-key locking. Instead use only
+ row-level locking</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_locks_unsafe_for_binlog"
+ setvar="innodb_locks_unsafe_for_binlog"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_log_arch_dir">
+ <name>innodb_log_arch_dir</name>
+ <shortdescription>Where full logs should be archived.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_log_arch_dir=name"
+ setvar="innodb_log_arch_dir"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_log_archive">
+ <name>innodb_log_archive</name>
+ <shortdescription>Set to 1 if you want to have logs archived.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_log_archive[=#]"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_log_buffer_size">
+ <name>innodb_log_buffer_size</name>
+ <shortdescription>The size of the buffer which InnoDB uses to write log to
+ the log files on disk.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_log_buffer_size=#"
+ setvar="innodb_log_buffer_size"/>
+ <vartype class="server" default="1048576"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_log_file_size">
+ <name>innodb_log_file_size</name>
+ <shortdescription>Size of each log file in a log group.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_log_file_size=#"
+ setvar="innodb_log_file_size"/>
+ <vartype class="server" default="5242880"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_log_files_in_group">
+ <name>innodb_log_files_in_group</name>
+ <shortdescription>Number of log files in the log group. InnoDB writes to the
+ files in a circular fashion. Value 3 is recommended here.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_log_files_in_group=#"
+ setvar="innodb_log_files_in_group"/>
+ <vartype class="server" default="2"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_log_group_home_dir">
+ <name>innodb_log_group_home_dir</name>
+ <shortdescription>Path to InnoDB log files.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_log_group_home_dir=name"
+ setvar="innodb_log_group_home_dir"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_max_dirty_pages_pct">
+ <name>innodb_max_dirty_pages_pct</name>
+ <shortdescription>Percentage of dirty pages allowed in bufferpool.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_max_dirty_pages_pct=#"
+ setvar="innodb_max_dirty_pages_pct"/>
+ <vartype class="server" default="90"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_max_purge_lag">
+ <name>innodb_max_purge_lag</name>
+ <shortdescription>Desired maximum length of the purge queue (0 = no limit)</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_max_purge_lag=#"
+ setvar="innodb_max_purge_lag"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_mirrored_log_groups">
+ <name>innodb_mirrored_log_groups</name>
+ <shortdescription>Number of identical copies of log groups we keep for the
+ database. Currently this should be set to 1.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_mirrored_log_groups=#"
+ setvar="innodb_mirrored_log_groups"/>
+ <vartype class="server" default="1"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_open_files">
+ <name>innodb_open_files</name>
+ <shortdescription>How many files at the maximum InnoDB keeps open at the
+ same time.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_open_files=#"
+ setvar="innodb_open_files"/>
+ <vartype class="server" default="300"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_safe_binlog">
+ <name>innodb_safe_binlog</name>
+ <shortdescription>After a crash recovery by InnoDB, truncate the binary log
+ after the last not-rolled-back statement/transaction.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_safe_binlog"
+ setvar="innodb_safe_binlog"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_status_file">
+ <name>innodb_status_file</name>
+ <shortdescription>Enable SHOW INNODB STATUS output in the
+ innodb_status.[pid] file</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_status_file"
+ setvar="innodb_status_file"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_support_xa">
+ <name>innodb_support_xa</name>
+ <shortdescription>Enable InnoDB support for the XA two-phase commit
+ --innodb_table_locks Enable InnoDB locking in LOCK TABLES</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_support_xa"
+ setvar="innodb_support_xa"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_sync_spin_loops">
+ <name>innodb_sync_spin_loops</name>
+ <shortdescription>Count of spin-loop rounds in InnoDB mutexes</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_sync_spin_loops=#"
+ setvar="innodb_sync_spin_loops"/>
+ <vartype class="server" default="20"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_table_locks">
+ <name>innodb_table_locks</name>
+ <shortdescription>Enable InnoDB locking in LOCK TABLES</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_table_locks"
+ setvar="innodb_table_locks"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_thread_concurrency">
+ <name>innodb_thread_concurrency</name>
+ <shortdescription>Helps in performance tuning in heavily concurrent
+ environments. Sets the maximum number of threads allowed inside InnoDB.
+ Value 0 will disable the thread throttling.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_thread_concurrency=#"
+ setvar="innodb_thread_concurrency"/>
+ <vartype class="server" default="8"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="innodb_thread_sleep_delay">
+ <name>innodb_thread_sleep_delay</name>
+ <shortdescription>Time of innodb thread sleeping before joining InnoDB queue
+ (usec). Value 0 disable a sleep</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--innodb_thread_sleep_delay=#"
+ setvar="innodb_thread_sleep_delay"/>
+ <vartype class="server" default="10000"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="interactive_timeout">
+ <name>interactive_timeout</name>
+ <shortdescription>The number of seconds the server waits for activity on an
+ interactive connection before closing it.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--interactive_timeout=#"
+ setvar="interactive_timeout"/>
+ <vartype class="server" default="28800"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="isam">
+ <name>isam</name>
+ <shortdescription>Obsolete. ISAM storage engine is no longer supported.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--isam" setvar="isam"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="join_buffer_size">
+ <name>join_buffer_size</name>
+ <shortdescription>The size of the buffer that is used for full joins.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--join_buffer_size=#"
+ setvar="join_buffer_size"/>
+ <vartype class="server" default="131072"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="key_buffer_size">
+ <name>key_buffer_size</name>
+ <shortdescription>The size of the buffer used for index blocks for MyISAM
+ tables. Increase this to get better index handling (for all reads and
+ multiple writes) to as much as you can afford; 64M on a 256M machine that
+ mainly runs MySQL is quite common. --key_cache_age_threshold=# This
+ characterizes the number of hits a hot block has to be untouched until it
+ is considered aged enough to be downgraded to a warm block. This specifies
+ the percentage ratio of that number of hits to the total number of blocks
+ in key cache --key_cache_block_size=# The default size of key cache blocks
+ --key_cache_division_limit=# The minimum percentage of warm blocks in key
+ cache</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--key_buffer_size=#"
+ setvar="key_buffer_size"/>
+ <vartype class="server" default="8388600"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="key_cache_age_threshold">
+ <name>key_cache_age_threshold</name>
+ <shortdescription>This characterizes the number of hits a hot block has to
+ be untouched until it is considered aged enough to be downgraded to a warm
+ block. This specifies the percentage ratio of that number of hits to the
+ total number of blocks in key cache</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--key_cache_age_threshold=#"
+ setvar="key_cache_age_threshold"/>
+ <vartype class="server" default="300"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="key_cache_block_size">
+ <name>key_cache_block_size</name>
+ <shortdescription>The default size of key cache blocks</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--key_cache_block_size=#"
+ setvar="key_cache_block_size"/>
+ <vartype class="server" default="1024"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="key_cache_division_limit">
+ <name>key_cache_division_limit</name>
+ <shortdescription>The minimum percentage of warm blocks in key cache</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--key_cache_division_limit=#"
+ setvar="key_cache_division_limit"/>
+ <vartype class="server" default="100"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="language">
+ <name>language</name>
+ <shortdescription>Client error messages in given language. May be given as a
+ full path.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--language=name" setvar="language"/>
+ <optype class="cmdline" format="-L" setvar="language"/>
+ <optype class="serveropt" format="language" setvar="language"/>
+ <vartype class="server" default="/usr/local/mysql/share/mysql/english/"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="large-pages">
+ <name>large-pages</name>
+ <shortdescription>Enable support for large pages. Disable with
+ --skip-large-pages.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--large-pages" setvar="large-pages"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="local-infile">
+ <name>local-infile</name>
+ <shortdescription>Enable/disable LOAD DATA LOCAL INFILE (takes values 1|0).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--local-infile" setvar="local-infile"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log">
+ <name>log</name>
+ <shortdescription>Log connections and queries to file.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log[=name]" setvar="log"/>
+ <optype class="cmdline" format="-l" setvar="log"/>
+ <optype class="serveropt" format="log" setvar="log"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-bin">
+ <name>log-bin</name>
+ <shortdescription>instead.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-bin" setvar="log-bin"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-bin-index">
+ <name>log-bin-index</name>
+ <shortdescription>File that holds the names for last binary log files.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-bin-index=name"
+ setvar="log-bin-index"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-bin-trust-function-creators">
+ <name>log-bin-trust-function-creators</name>
+ <shortdescription>If equal to 0 (the default), then when --log-bin is used,
+ creation of a stored function is allowed only to users having the SUPER
+ privilege and only if this function may not break binary logging.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-bin-trust-function-creators"
+ setvar="log-bin-trust-function-creators"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-bin-trust-routine-creators">
+ <name>log-bin-trust-routine-creators</name>
+ <shortdescription>(deprecated) Use log-bin-trust-function-creators.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-bin-trust-routine-creators"
+ setvar="log-bin-trust-routine-creators"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-error">
+ <name>log-error</name>
+ <shortdescription>Error log file.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-error[=name]" setvar="log-error"/>
+ <vartype class="server" default=""/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-isam">
+ <name>log-isam</name>
+ <shortdescription>Log all MyISAM changes to file.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-isam[=name]" setvar="log-isam"/>
+ <vartype class="server" default="myisam.log"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-long-format">
+ <name>log-long-format</name>
+ <shortdescription>Log some extra information to update log. Please note that
+ this option is deprecated; see --log-short-format option.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-long-format"/>
+ <optype class="cmdline" format="-0"/>
+ <optype class="serveropt" format="log-long-format"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-output">
+ <name>log-output</name>
+ <shortdescription>Syntax: log-output[=value[,value...]], where "value" could
+ be TABLE, FILE or NONE. --log-queries-not-using-indexes Log queries that
+ are executed without benefit of any index to the slow log if it is open.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-output[=name]" setvar="log-output"/>
+ <vartype class="server" default="TABLE"/>
+ </types>
+ <versions>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-queries-not-using-indexes">
+ <name>log-queries-not-using-indexes</name>
+ <shortdescription>Log queries that are executed without benefit of any index
+ to the slow log if it is open.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-queries-not-using-indexes"
+ setvar="log-queries-not-using-indexes"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-short-format">
+ <name>log-short-format</name>
+ <shortdescription>Don't log extra information to update and slow-query logs.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-short-format"
+ setvar="log-short-format"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-slave-updates">
+ <name>log-slave-updates</name>
+ <shortdescription>is used. --replicate-wild-do-table=name Tells the slave
+ thread to restrict replication to the tables that match the specified
+ wildcard pattern. To specify more than one table, use the directive
+ multiple times, once for each table. This will work for cross-database
+ updates. Example: replicate-wild-do-table=foo%.bar% will replicate only
+ updates to tables in all databases that start with foo and whose table
+ names start with bar. --replicate-wild-ignore-table=name Tells the slave
+ thread to not replicate to the tables that match the given wildcard
+ pattern. To specify more than one table to ignore, use the directive
+ multiple times, once for each table. This will work for cross-database
+ updates. Example: replicate-wild-ignore-table=foo%.bar% will not do
+ updates to tables in databases that start with foo and whose table names
+ start with bar.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-slave-updates"
+ setvar="log-slave-updates"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-slow-admin-statements">
+ <name>log-slow-admin-statements</name>
+ <shortdescription>Log slow OPTIMIZE, ANALYZE, ALTER and other administrative
+ statements to the slow log if it is open.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-slow-admin-statements"
+ setvar="log-slow-admin-statements"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-slow-queries">
+ <name>log-slow-queries</name>
+ <shortdescription>Log slow queries to this log file. Defaults logging to
+ hostname-slow.log file. Must be enabled to activate other slow log
+ options.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-slow-queries[=name]"
+ setvar="log-slow-queries"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-tc">
+ <name>log-tc</name>
+ <shortdescription>Path to transaction coordinator log (used for transactions
+ that affect more than one storage engine, when binary log is disabled)</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-tc=name" setvar="log-tc"/>
+ <vartype class="server" default="tc.log"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-tc-size">
+ <name>log-tc-size</name>
+ <shortdescription>Size of transaction coordinator log.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-tc-size=#" setvar="log-tc-size"/>
+ <vartype class="server" default="24576"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-update">
+ <name>log-update</name>
+ <shortdescription>The update log is deprecated since version 5.0, is
+ replaced by the binary log and this option justs turns on</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-update[=name]" setvar="log-update"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="log-warnings">
+ <name>log-warnings</name>
+ <shortdescription>Log some not critical warnings to the log file.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--log-warnings[=#]" setvar="log-warnings"/>
+ <optype class="cmdline" format="-W" setvar="log-warnings"/>
+ <optype class="serveropt" format="log-warnings" setvar="log-warnings"/>
+ <vartype class="server" default="1"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="long_query_time">
+ <name>long_query_time</name>
+ <shortdescription>Log all queries that have taken more than long_query_time
+ seconds to execute to file. --lower_case_table_names[=#] If set to 1 table
+ names are stored in lowercase on disk and table names will be
+ case-insensitive. Should be set to 2 if you are using a case insensitive
+ file system --max_allowed_packet=# Max packetlength to send/receive from
+ to server. --max_binlog_cache_size=# Can be used to restrict the total
+ size used to cache a multi-transaction query.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--long_query_time=#"
+ setvar="long_query_time"/>
+ <vartype class="server" default="10"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="low-priority-updates">
+ <name>low-priority-updates</name>
+ <shortdescription>INSERT/DELETE/UPDATE has lower priority than selects.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--low-priority-updates"
+ setvar="low-priority-updates"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="lower_case_table_names">
+ <name>lower_case_table_names</name>
+ <shortdescription>If set to 1 table names are stored in lowercase on disk
+ and table names will be case-insensitive. Should be set to 2 if you are
+ using a case insensitive file system</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--lower_case_table_names[=#]"
+ setvar="lower_case_table_names"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="master-connect-retry">
+ <name>master-connect-retry</name>
+ <shortdescription>The number of seconds the slave thread will sleep before
+ retrying to connect to the master in case the master goes down or the
+ connection is lost.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--master-connect-retry=#"
+ setvar="master-connect-retry"/>
+ <vartype class="server" default="60"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="master-host">
+ <name>master-host</name>
+ <shortdescription>Master hostname or IP address for replication. If not set,
+ the slave thread will not be started. Note that the setting of master-host
+ will be ignored if there exists a valid master.info file.
+ --master-info-file=name The location and name of the file that remembers
+ the master and where the I/O replication thread is in the master's
+ binlogs. --master-password=name The password the slave thread will
+ authenticate with when connecting to the master. If not set, an empty
+ password is assumed.The value in master.info will take precedence if it
+ can be read.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--master-host=name" setvar="master-host"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="master-info-file">
+ <name>master-info-file</name>
+ <shortdescription>The location and name of the file that remembers the
+ master and where the I/O replication thread is in the master's binlogs.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--master-info-file=name"
+ setvar="master-info-file"/>
+ <vartype class="server" default="master.info"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="master-password">
+ <name>master-password</name>
+ <shortdescription>The password the slave thread will authenticate with when
+ connecting to the master. If not set, an empty password is assumed.The
+ value in master.info will take precedence if it can be read.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--master-password=name"
+ setvar="master-password"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="master-port">
+ <name>master-port</name>
+ <shortdescription>The port the master is listening on. If not set, the
+ compiled setting of MYSQL_PORT is assumed. If you have not tinkered with
+ configure options, this should be 3306. The value in master.info will take
+ precedence if it can be read. --master-retry-count=# The number of tries
+ the slave will make to connect to the master before giving up.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--master-port=#" setvar="master-port"/>
+ <vartype class="server" default="3306"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="master-retry-count">
+ <name>master-retry-count</name>
+ <shortdescription>The number of tries the slave will make to connect to the
+ master before giving up.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--master-retry-count=#"
+ setvar="master-retry-count"/>
+ <vartype class="server" default="86400"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="master-ssl">
+ <name>master-ssl</name>
+ <shortdescription>Enable the slave to connect to the master using SSL.
+ --master-ssl-ca[=name] Master SSL CA file. Only applies if you have
+ enabled master-ssl. --master-ssl-capath[=name] Master SSL CA path. Only
+ applies if you have enabled master-ssl. --master-ssl-cert[=name] Master
+ SSL certificate file name. Only applies if you have enabled master-ssl
+ --master-ssl-cipher[=name] Master SSL cipher. Only applies if you have
+ enabled master-ssl. --master-ssl-key[=name] Master SSL keyfile name. Only
+ applies if you have enabled master-ssl.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--master-ssl" setvar="master-ssl"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="master-ssl-ca">
+ <name>master-ssl-ca</name>
+ <shortdescription>Master SSL CA file. Only applies if you have enabled
+ master-ssl.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--master-ssl-ca[=name]"
+ setvar="master-ssl-ca"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="master-ssl-capath">
+ <name>master-ssl-capath</name>
+ <shortdescription>Master SSL CA path. Only applies if you have enabled
+ master-ssl.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--master-ssl-capath[=name]"
+ setvar="master-ssl-capath"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="master-ssl-cert">
+ <name>master-ssl-cert</name>
+ <shortdescription>Master SSL certificate file name. Only applies if you have
+ enabled master-ssl</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--master-ssl-cert[=name]"
+ setvar="master-ssl-cert"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="master-ssl-cipher">
+ <name>master-ssl-cipher</name>
+ <shortdescription>Master SSL cipher. Only applies if you have enabled
+ master-ssl.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--master-ssl-cipher[=name]"
+ setvar="master-ssl-cipher"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="master-ssl-key">
+ <name>master-ssl-key</name>
+ <shortdescription>Master SSL keyfile name. Only applies if you have enabled
+ master-ssl.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--master-ssl-key[=name]"
+ setvar="master-ssl-key"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="master-user">
+ <name>master-user</name>
+ <shortdescription>The username the slave thread will use for authentication
+ when connecting to the master. The user must have FILE privilege. If the
+ master user is not set, user test is assumed. The value in master.info
+ will take precedence if it can be read. --max-binlog-dump-events=# Option
+ used by mysql-test for debugging and testing of replication.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--master-user=name" setvar="master-user"/>
+ <vartype class="server" default="test"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max-binlog-dump-events">
+ <name>max-binlog-dump-events</name>
+ <shortdescription>Option used by mysql-test for debugging and testing of
+ replication.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max-binlog-dump-events=#"
+ setvar="max-binlog-dump-events"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_allowed_packet">
+ <name>max_allowed_packet</name>
+ <shortdescription>Max packetlength to send/receive from to server.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_allowed_packet=#"
+ setvar="max_allowed_packet"/>
+ <vartype class="server" default="1048576"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_binlog_cache_size">
+ <name>max_binlog_cache_size</name>
+ <shortdescription>Can be used to restrict the total size used to cache a
+ multi-transaction query.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_binlog_cache_size=#"
+ setvar="max_binlog_cache_size"/>
+ <vartype class="server" default="4294967295"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_binlog_size">
+ <name>max_binlog_size</name>
+ <shortdescription>Binary log will be rotated automatically when the size
+ exceeds this value. Will also apply to relay logs if max_relay_log_size is
+ 0. The minimum value for this variable is 4096. --max_connect_errors=# If
+ there is more than this number of interrupted connections from a host this
+ host will be blocked from further connections.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_binlog_size=#"
+ setvar="max_binlog_size"/>
+ <vartype class="server" default="1073741824"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_connect_errors">
+ <name>max_connect_errors</name>
+ <shortdescription>If there is more than this number of interrupted
+ connections from a host this host will be blocked from further
+ connections.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_connect_errors=#"
+ setvar="max_connect_errors"/>
+ <vartype class="server" default="10"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_connections">
+ <name>max_connections</name>
+ <shortdescription>The number of simultaneous clients allowed.
+ --max_delayed_threads=# Don't start more than this number of threads to
+ handle INSERT DELAYED statements. If set to zero, which means INSERT
+ DELAYED is not used.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_connections=#"
+ setvar="max_connections"/>
+ <vartype class="server" default="100"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_delayed_threads">
+ <name>max_delayed_threads</name>
+ <shortdescription>Don't start more than this number of threads to handle
+ INSERT DELAYED statements. If set to zero, which means INSERT DELAYED is
+ not used.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_delayed_threads=#"
+ setvar="max_delayed_threads"/>
+ <vartype class="server" default="20"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_error_count">
+ <name>max_error_count</name>
+ <shortdescription>Max number of errors/warnings to store for a statement.
+ --max_heap_table_size=# Don't allow creation of heap tables bigger than
+ this.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_error_count=#"
+ setvar="max_error_count"/>
+ <vartype class="server" default="64"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_heap_table_size">
+ <name>max_heap_table_size</name>
+ <shortdescription>Don't allow creation of heap tables bigger than this.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_heap_table_size=#"
+ setvar="max_heap_table_size"/>
+ <vartype class="server" default="16777216"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_join_size">
+ <name>max_join_size</name>
+ <shortdescription>Joins that are probably going to read more than
+ max_join_size records return an error. --max_length_for_sort_data=# Max
+ number of bytes in sorted records. --max_prepared_stmt_count=# Maximum
+ number of prepared statements in the server. --max_relay_log_size=# If
+ non-zero: relay log will be rotated automatically when the size exceeds
+ this value; if zero (the default): when the size exceeds max_binlog_size.
+ 0 excepted, the minimum value for this variable is 4096.
+ --max_seeks_for_key=# Limit assumed max number of seeks when looking up
+ rows based on a key</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_join_size=#" setvar="max_join_size"/>
+ <vartype class="server" default="4294967295"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_length_for_sort_data">
+ <name>max_length_for_sort_data</name>
+ <shortdescription>Max number of bytes in sorted records.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_length_for_sort_data=#"
+ setvar="max_length_for_sort_data"/>
+ <vartype class="server" default="1024"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_prepared_stmt_count">
+ <name>max_prepared_stmt_count</name>
+ <shortdescription>Maximum number of prepared statements in the server.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_prepared_stmt_count=#"
+ setvar="max_prepared_stmt_count"/>
+ <vartype class="server" default="16382"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_relay_log_size">
+ <name>max_relay_log_size</name>
+ <shortdescription>If non-zero: relay log will be rotated automatically when
+ the size exceeds this value; if zero (the default): when the size exceeds
+ max_binlog_size. 0 excepted, the minimum value for this variable is 4096.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_relay_log_size=#"
+ setvar="max_relay_log_size"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_seeks_for_key">
+ <name>max_seeks_for_key</name>
+ <shortdescription>Limit assumed max number of seeks when looking up rows
+ based on a key</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_seeks_for_key=#"
+ setvar="max_seeks_for_key"/>
+ <vartype class="server" default="4294967295"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_sort_length">
+ <name>max_sort_length</name>
+ <shortdescription>The number of bytes to use when sorting BLOB or TEXT
+ values (only the first max_sort_length bytes of each value are used; the
+ rest are ignored). --max_sp_recursion_depth[=#] Maximum stored procedure
+ recursion depth. (discussed with docs).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_sort_length=#"
+ setvar="max_sort_length"/>
+ <vartype class="server" default="1024"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_sp_recursion_depth">
+ <name>max_sp_recursion_depth</name>
+ <shortdescription>Maximum stored procedure recursion depth. (discussed with
+ docs).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_sp_recursion_depth[=#]"
+ setvar="max_sp_recursion_depth"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_tmp_tables">
+ <name>max_tmp_tables</name>
+ <shortdescription>Maximum number of temporary tables a client can keep open
+ at a time. --max_user_connections=# The maximum number of active
+ connections for a single user (0 = no limit). --max_write_lock_count=#
+ After this many write locks, allow some read locks to run in between.
+ --multi_range_count=# Number of key ranges to request at once.
+ --myisam_block_size=# Block size to be used for MyISAM index pages.
+ --myisam_data_pointer_size=# Default pointer size to be used for MyISAM
+ tables. --myisam_max_extra_sort_file_size=# Deprecated 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_repair_threads=# Number of threads to use when repairing MyISAM
+ tables. The value of 1 disables parallel repair.
+ --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.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_tmp_tables=#"
+ setvar="max_tmp_tables"/>
+ <vartype class="server" default="32"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_user_connections">
+ <name>max_user_connections</name>
+ <shortdescription>The maximum number of active connections for a single user
+ (0 = no limit).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_user_connections=#"
+ setvar="max_user_connections"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="max_write_lock_count">
+ <name>max_write_lock_count</name>
+ <shortdescription>After this many write locks, allow some read locks to run
+ in between.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--max_write_lock_count=#"
+ setvar="max_write_lock_count"/>
+ <vartype class="server" default="4294967295"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="memlock">
+ <name>memlock</name>
+ <shortdescription>Lock mysqld in memory.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--memlock" setvar="memlock"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="merge">
+ <name>merge</name>
+ <shortdescription>Enable Merge storage engine. Disable with --skip-merge.
+ --myisam-recover[=name] Syntax: myisam-recover[=option[,option...]], where
+ option can be DEFAULT, BACKUP, FORCE or QUICK.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--merge" setvar="merge"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="multi_range_count">
+ <name>multi_range_count</name>
+ <shortdescription>Number of key ranges to request at once.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--multi_range_count=#"
+ setvar="multi_range_count"/>
+ <vartype class="server" default="256"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="myisam-recover">
+ <name>myisam-recover</name>
+ <shortdescription>Syntax: myisam-recover[=option[,option...]], where option
+ can be DEFAULT, BACKUP, FORCE or QUICK.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--myisam-recover[=name]"
+ setvar="myisam-recover"/>
+ <vartype class="server" default="OFF"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="myisam_block_size">
+ <name>myisam_block_size</name>
+ <shortdescription>Block size to be used for MyISAM index pages.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--myisam_block_size=#"
+ setvar="myisam_block_size"/>
+ <vartype class="server" default="1024"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="myisam_data_pointer_size">
+ <name>myisam_data_pointer_size</name>
+ <shortdescription>Default pointer size to be used for MyISAM tables.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--myisam_data_pointer_size=#"
+ setvar="myisam_data_pointer_size"/>
+ <vartype class="server" default="6"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="myisam_max_extra_sort_file_size">
+ <name>myisam_max_extra_sort_file_size</name>
+ <shortdescription>Deprecated option</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--myisam_max_extra_sort_file_size=#"
+ setvar="myisam_max_extra_sort_file_size"/>
+ <vartype class="server" default="2147483648"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="myisam_max_sort_file_size">
+ <name>myisam_max_sort_file_size</name>
+ <shortdescription>Don't use the fast sort index method to created index if
+ the temporary file would get bigger than this.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--myisam_max_sort_file_size=#"
+ setvar="myisam_max_sort_file_size"/>
+ <vartype class="server" default="2147483647"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="myisam_repair_threads">
+ <name>myisam_repair_threads</name>
+ <shortdescription>Number of threads to use when repairing MyISAM tables. The
+ value of 1 disables parallel repair.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--myisam_repair_threads=#"
+ setvar="myisam_repair_threads"/>
+ <vartype class="server" default="1"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="myisam_sort_buffer_size">
+ <name>myisam_sort_buffer_size</name>
+ <shortdescription>The buffer that is allocated when sorting the index when
+ doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--myisam_sort_buffer_size=#"
+ setvar="myisam_sort_buffer_size"/>
+ <vartype class="server" default="8388608"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="myisam_stats_method">
+ <name>myisam_stats_method</name>
+ <shortdescription>Specifies how MyISAM index statistics collection code
+ should threat NULLs. Possible values of name are "nulls_unequal" (default
+ behavior for 4.1/5.0), "nulls_equal" (emulate 4.0 behavior), and
+ "nulls_ignored".</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--myisam_stats_method=name"
+ setvar="myisam_stats_method"/>
+ <vartype class="server" default="nulls_unequal"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="myisam_use_mmap">
+ <name>myisam_use_mmap</name>
+ <shortdescription>Use memory mapping for reading and writing MyISAM tables
+ --myisam_stats_method=name Specifies how MyISAM index statistics
+ collection code should threat NULLs. Possible values of name are
+ "nulls_unequal" (default behavior for 4.1/5.0), "nulls_equal" (emulate 4.0
+ behavior), and "nulls_ignored". --net_buffer_length=# Buffer length for
+ TCP/IP and socket communication. --net_read_timeout=# Number of seconds to
+ wait for more data from a connection before aborting the read.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--myisam_use_mmap"
+ setvar="myisam_use_mmap"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ndb-autoincrement-prefetch-sz">
+ <name>ndb-autoincrement-prefetch-sz</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndb-cache-check-time">
+ <name>ndb-cache-check-time</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndb-connectstring">
+ <name>ndb-connectstring</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndb-distribution">
+ <name>ndb-distribution</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndb-extra-logging">
+ <name>ndb-extra-logging</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndb-force-send">
+ <name>ndb-force-send</name>
+ <shortdescription>Force send of buffers to ndb immediately without waiting
+ for other threads.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ndb-force-send"/>
+ </types>
+ <versions>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ndb-index-stat-cache-entries">
+ <name>ndb-index-stat-cache-entries</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndb-index-stat-enable">
+ <name>ndb-index-stat-enable</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndb-index-stat-update-freq">
+ <name>ndb-index-stat-update-freq</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndb-mgmd-host">
+ <name>ndb-mgmd-host</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndb-nodeid">
+ <name>ndb-nodeid</name>
+ <shortdescription>Nodeid for this mysqlserver in the cluster.
+ --ndb-autoincrement-prefetch-sz=# Specify number of autoincrement values
+ that are prefetched. --ndb-distribution=name Default distribution for new
+ tables in ndb</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ndb-nodeid=#" setvar="ndb-nodeid"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ndb-optimized-node-selection">
+ <name>ndb-optimized-node-selection</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndb-report-thresh-binlog-epoch-slip3">
+ <name>ndb-report-thresh-binlog-epoch-slip3</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndb-report-thresh-binlog-mem-usage10">
+ <name>ndb-report-thresh-binlog-mem-usage10</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndb-shm">
+ <name>ndb-shm</name>
+ <shortdescription>Use shared memory connections when available.
+ --ndb-optimized-node-selection Select nodes for transactions in a more
+ optimal way. --ndb-cache-check-time=# A dedicated thread is created to, at
+ the given millisecons interval, invalidate the query cache if another
+ MySQL server in the cluster has changed the data in the database.
+ --ndb-index-stat-enable Use ndb index statistics in query optimization.
+ --ndb-index-stat-cache-entries[=#] Number of start/end keys to store in
+ statistics memory cache. Zero means no cache and forces query of db nodes
+ always. --ndb-index-stat-update-freq[=#] How often, in the long run, to
+ query db nodes instead of statistics cache. For example 20 means every
+ 20th time. --ndb-use-copying-alter-table Force ndbcluster to always copy
+ tables at alter table (should only be used if on-line alter table fails).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ndb-shm" setvar="ndb-shm"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ndb-use-copying-alter-table">
+ <name>ndb-use-copying-alter-table</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndb-use-exact-count">
+ <name>ndb-use-exact-count</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndb_force_send">
+ <name>ndb_force_send</name>
+ <shortdescription>same as --ndb-force-send. --ndb-extra-logging[=#] Turn on
+ more logging in the error log. --ndb-report-thresh-binlog-epoch-slip=#
+ Threshold on number of epochs to be behind before reporting binlog status.
+ E.g. 3 means that if the difference between what epoch has been received
+ from the storage nodes and what has been applied to the binlog is 3 or
+ more, a status message will be sent to the cluster log.
+ --ndb-report-thresh-binlog-mem-usage=# Threshold on percentage of free
+ memory before reporting binlog status. E.g. 10 means that if amount of
+ available memory for receiving binlog data from the storage nodes goes
+ below 10%, a status message will be sent to the cluster log.
+ --ndb-use-exact-count Use exact records count during query planning and
+ for fast select count(*), disable for faster queries.
+ --ndb_use_exact_count same as --ndb-use-exact-count.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ndb_force_send" setvar="ndb_force_send"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ndb_use_exact_count">
+ <name>ndb_use_exact_count</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="ndbcluster">
+ <name>ndbcluster</name>
+ <shortdescription>Enable NDB Cluster (if this version of MySQL supports it).
+ Disable with --skip-ndbcluster (will save memory).
+ --ndb-connectstring=name Connect string for ndbcluster.
+ --ndb-mgmd-host=name Set host and port for ndb_mgmd. Syntax:
+ hostname[:port]</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ndbcluster" setvar="ndbcluster"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="net_buffer_length">
+ <name>net_buffer_length</name>
+ <shortdescription>Buffer length for TCP/IP and socket communication.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--net_buffer_length=#"
+ setvar="net_buffer_length"/>
+ <vartype class="server" default="16384"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="net_read_timeout">
+ <name>net_read_timeout</name>
+ <shortdescription>Number of seconds to wait for more data from a connection
+ before aborting the read.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--net_read_timeout=#"
+ setvar="net_read_timeout"/>
+ <vartype class="server" default="30"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="net_retry_count">
+ <name>net_retry_count</name>
+ <shortdescription>If a read on a communication port is interrupted, retry
+ this many times before giving up. --net_write_timeout=# Number of seconds
+ to wait for a block to be written to a connection before aborting the
+ write. --open_files_limit=# If this is not 0, then mysqld will use this
+ value to reserve file descriptors to use with setrlimit(). If this value
+ is 0 then mysqld will reserve max_connections*5 or max_connections +
+ table_cache*2 (whichever is larger) number of files.
+ --optimizer_prune_level[=#] Controls the heuristic(s) applied during query
+ optimization to prune less-promising partial plans from the optimizer
+ search space. Meaning: 0 - do not apply any heuristic, thus perform
+ exhaustive search; 1 - prune plans based on number of retrieved rows.
+ --optimizer_search_depth[=#] Maximum depth of search performed by the
+ query optimizer. Values larger than the number of relations in a query
+ result in better query plans, but take longer to compile a query. Smaller
+ values than the number of tables in a relation result in faster
+ optimization, but may produce very bad query plans. If set to 0, the
+ system will automatically pick a reasonable value; if set to MAX_TABLES+2,
+ the optimizer will switch to the original find_best (used for
+ testing/comparison).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--net_retry_count=#"
+ setvar="net_retry_count"/>
+ <vartype class="server" default="10"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="net_write_timeout">
+ <name>net_write_timeout</name>
+ <shortdescription>Number of seconds to wait for a block to be written to a
+ connection before aborting the write.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--net_write_timeout=#"
+ setvar="net_write_timeout"/>
+ <vartype class="server" default="60"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="new">
+ <name>new</name>
+ <shortdescription>Use very new possible 'unsafe' functions.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--new" setvar="new"/>
+ <optype class="cmdline" format="-n" setvar="new"/>
+ <optype class="serveropt" format="new" setvar="new"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="old-alter-table">
+ <name>old-alter-table</name>
+ <shortdescription>Use old, non-optimized alter table.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--old-alter-table"
+ setvar="old-alter-table"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="old-passwords">
+ <name>old-passwords</name>
+ <shortdescription>Use old password encryption method (needed for 4.0 and
+ older clients). --old-style-user-limits Enable old-style user limits
+ (before 5.0.3 user resources were counted per each user+host vs. per
+ account)</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--old-passwords" setvar="old-passwords"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="old-style-user-limits">
+ <name>old-style-user-limits</name>
+ <shortdescription>Enable old-style user limits (before 5.0.3 user resources
+ were counted per each user+host vs. per account)</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--old-style-user-limits"
+ setvar="old-style-user-limits"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="open_files_limit">
+ <name>open_files_limit</name>
+ <shortdescription>If this is not 0, then mysqld will use this value to
+ reserve file descriptors to use with setrlimit(). If this value is 0 then
+ mysqld will reserve max_connections*5 or max_connections + table_cache*2
+ (whichever is larger) number of files.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--open_files_limit=#"
+ setvar="open_files_limit"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="optimizer_prune_level">
+ <name>optimizer_prune_level</name>
+ <shortdescription>Controls the heuristic(s) applied during query
+ optimization to prune less-promising partial plans from the optimizer
+ search space. Meaning: 0 - do not apply any heuristic, thus perform
+ exhaustive search; 1 - prune plans based on number of retrieved rows.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--optimizer_prune_level[=#]"
+ setvar="optimizer_prune_level"/>
+ <vartype class="server" default="1"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="optimizer_search_depth">
+ <name>optimizer_search_depth</name>
+ <shortdescription>Maximum depth of search performed by the query optimizer.
+ Values larger than the number of relations in a query result in better
+ query plans, but take longer to compile a query. Smaller values than the
+ number of tables in a relation result in faster optimization, but may
+ produce very bad query plans. If set to 0, the system will automatically
+ pick a reasonable value; if set to MAX_TABLES+2, the optimizer will switch
+ to the original find_best (used for testing/comparison).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--optimizer_search_depth[=#]"
+ setvar="optimizer_search_depth"/>
+ <vartype class="server" default="62"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="pid-file">
+ <name>pid-file</name>
+ <shortdescription>Pid file used by safe_mysqld.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--pid-file=name" setvar="pid-file"/>
+ <vartype class="server" default="/usr/local/mysql/var/mothra.pid"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="plugin_dir">
+ <name>plugin_dir</name>
+ <shortdescription>Directory for plugins. --preload_buffer_size=# The size of
+ the buffer that is allocated when preloading indexes
+ --query_alloc_block_size=# Allocation block size for query parsing and
+ execution --query_cache_limit=# Don't cache results that are bigger than
+ this. --query_cache_min_res_unit=# minimal size of unit in wich space for
+ results is allocated (last unit will be trimed after writing all result
+ data. --query_cache_size=# The memory allocated to store results from old
+ queries. --query_cache_type=# 0 = OFF = Don't cache or retrieve results. 1
+ = ON = Cache all results except SELECT SQL_NO_CACHE ... queries. 2 =
+ DEMAND = Cache only SELECT SQL_CACHE ... queries.
+ --query_cache_wlock_invalidate Invalidate queries in query cache on LOCK
+ for write --query_prealloc_size=# Persistent buffer for query parsing and
+ execution --range_alloc_block_size=# Allocation block size for storing
+ ranges during optimization --read_buffer_size=# Each thread that does a
+ sequential scan allocates a buffer of this size for each table it scans.
+ If you do many sequential scans, you may want to increase this value.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--plugin_dir=name" setvar="plugin_dir"/>
+ <vartype class="server" default="/usr/local/mysql/lib/mysql"/>
+ </types>
+ <versions>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="port">
+ <name>port</name>
+ <shortdescription>Port number to use for connection. --port-open-timeout=#
+ Maximum time in seconds to wait for the port to become free. (Default: no
+ wait)</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--port=#" setvar="port"/>
+ <optype class="cmdline" format="-P" setvar="port"/>
+ <optype class="serveropt" format="port" setvar="port"/>
+ <vartype class="server" default="3306"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="port-open-timeout">
+ <name>port-open-timeout</name>
+ <shortdescription>Maximum time in seconds to wait for the port to become
+ free. (Default: no wait)</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--port-open-timeout=#"
+ setvar="port-open-timeout"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="preload_buffer_size">
+ <name>preload_buffer_size</name>
+ <shortdescription>The size of the buffer that is allocated when preloading
+ indexes</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--preload_buffer_size=#"
+ setvar="preload_buffer_size"/>
+ <vartype class="server" default="32768"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="query_alloc_block_size">
+ <name>query_alloc_block_size</name>
+ <shortdescription>Allocation block size for query parsing and execution</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--query_alloc_block_size=#"
+ setvar="query_alloc_block_size"/>
+ <vartype class="server" default="8192"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="query_cache_limit">
+ <name>query_cache_limit</name>
+ <shortdescription>Don't cache results that are bigger than this.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--query_cache_limit=#"
+ setvar="query_cache_limit"/>
+ <vartype class="server" default="1048576"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="query_cache_min_res_unit">
+ <name>query_cache_min_res_unit</name>
+ <shortdescription>minimal size of unit in wich space for results is
+ allocated (last unit will be trimed after writing all result data.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--query_cache_min_res_unit=#"
+ setvar="query_cache_min_res_unit"/>
+ <vartype class="server" default="4096"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="query_cache_size">
+ <name>query_cache_size</name>
+ <shortdescription>The memory allocated to store results from old queries.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--query_cache_size=#"
+ setvar="query_cache_size"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="query_cache_type">
+ <name>query_cache_type</name>
+ <shortdescription>0 = OFF = Don't cache or retrieve results. 1 = ON = Cache
+ all results except SELECT SQL_NO_CACHE ... queries. 2 = DEMAND = Cache
+ only SELECT SQL_CACHE ... queries.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--query_cache_type=#"
+ setvar="query_cache_type"/>
+ <vartype class="server" default="1"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="query_cache_wlock_invalidate">
+ <name>query_cache_wlock_invalidate</name>
+ <shortdescription>Invalidate queries in query cache on LOCK for write</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--query_cache_wlock_invalidate"
+ setvar="query_cache_wlock_invalidate"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="query_prealloc_size">
+ <name>query_prealloc_size</name>
+ <shortdescription>Persistent buffer for query parsing and execution</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--query_prealloc_size=#"
+ setvar="query_prealloc_size"/>
+ <vartype class="server" default="8192"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="range_alloc_block_size">
+ <name>range_alloc_block_size</name>
+ <shortdescription>Allocation block size for storing ranges during
+ optimization</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--range_alloc_block_size=#"
+ setvar="range_alloc_block_size"/>
+ <vartype class="server" default="2048"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="read_buffer_size">
+ <name>read_buffer_size</name>
+ <shortdescription>Each thread that does a sequential scan allocates a buffer
+ of this size for each table it scans. If you do many sequential scans, you
+ may want to increase this value.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--read_buffer_size=#"
+ setvar="read_buffer_size"/>
+ <vartype class="server" default="131072"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="read_only">
+ <name>read_only</name>
+ <shortdescription>Make all non-temporary tables read-only, with the
+ exception for replication (slave) threads and users with the SUPER
+ privilege --read_rnd_buffer_size=# When reading rows in sorted order after
+ a sort, the rows are read through this buffer to avoid a disk seeks. If
+ not set, then it's set to the value of record_buffer.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--read_only" setvar="read_only"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="read_rnd_buffer_size">
+ <name>read_rnd_buffer_size</name>
+ <shortdescription>When reading rows in sorted order after a sort, the rows
+ are read through this buffer to avoid a disk seeks. If not set, then it's
+ set to the value of record_buffer.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--read_rnd_buffer_size=#"
+ setvar="read_rnd_buffer_size"/>
+ <vartype class="server" default="262144"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="record_buffer">
+ <name>record_buffer</name>
+ <shortdescription>Alias for read_buffer_size</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--record_buffer=#" setvar="record_buffer"/>
+ <vartype class="server" default="131072"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="relay-log">
+ <name>relay-log</name>
+ <shortdescription>The location and name to use for relay logs.
+ --relay-log-index=name The location and name to use for the file that
+ keeps a list of the last relay logs. --relay-log-info-file=name The
+ location and name of the file that remembers where the SQL replication
+ thread is in the relay logs. --replicate-do-db=name Tells the slave thread
+ to restrict replication to the specified database. To specify more than
+ one database, use the directive multiple times, once for each database.
+ Note that this will only work if you do not use cross-database queries
+ such as UPDATE some_db.some_table SET foo='bar' while having selected a
+ different or no database. If you need cross database updates to work, make
+ sure you have 3.23.28 or later, and use replicate-wild-do-table=db_name.%.
+ --replicate-do-table=name Tells the slave thread to restrict replication
+ to the specified table. To specify more than one table, use the directive
+ multiple times, once for each table. This will work for cross-database
+ updates, in contrast to replicate-do-db. --replicate-ignore-db=name Tells
+ the slave thread to not replicate to the specified database. To specify
+ more than one database to ignore, use the directive multiple times, once
+ for each database. This option will not work if you use cross database
+ updates. If you need cross database updates to work, make sure you have
+ 3.23.28 or later, and use replicate-wild-ignore-table=db_name.%.
+ --replicate-ignore-table=name Tells the slave thread to not replicate to
+ the specified table. To specify more than one table to ignore, use the
+ directive multiple times, once for each table. This will work for
+ cross-datbase updates, in contrast to replicate-ignore-db.
+ --replicate-rewrite-db=name Updates to a database with a different name
+ than the original. Example:
+ replicate-rewrite-db=master_db_name->slave_db_name.
+ --replicate-same-server-id In replication, if set to 1, do not skip events
+ having our server id. Default value is 0 (to break infinite loops in
+ circular replication). Can't be set to 1 if</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--relay-log=name" setvar="relay-log"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="relay-log-index">
+ <name>relay-log-index</name>
+ <shortdescription>The location and name to use for the file that keeps a
+ list of the last relay logs.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--relay-log-index=name"
+ setvar="relay-log-index"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="relay-log-info-file">
+ <name>relay-log-info-file</name>
+ <shortdescription>The location and name of the file that remembers where the
+ SQL replication thread is in the relay logs.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--relay-log-info-file=name"
+ setvar="relay-log-info-file"/>
+ <vartype class="server" default="relay-log.info"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="relay_log_purge">
+ <name>relay_log_purge</name>
+ <shortdescription>0 = do not purge relay logs. 1 = purge them as soon as
+ they are no more needed. --relay_log_space_limit=# Maximum space to use
+ for all relay logs. --slave_compressed_protocol Use compression on
+ master/slave protocol. --slave_net_timeout=# Number of seconds to wait for
+ more data from a master/slave connection before aborting the read.
+ --slave_transaction_retries=# Number of times the slave SQL thread will
+ retry a transaction in case it failed with a deadlock or elapsed lock wait
+ timeout, before giving up and stopping. --slow_launch_time=# If creating
+ the thread takes longer than this value (in seconds), the
+ Slow_launch_threads counter will be incremented. --sort_buffer_size=# Each
+ thread that needs to do a sort allocates a buffer of this size.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--relay_log_purge"
+ setvar="relay_log_purge"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="relay_log_space_limit">
+ <name>relay_log_space_limit</name>
+ <shortdescription>Maximum space to use for all relay logs.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--relay_log_space_limit=#"
+ setvar="relay_log_space_limit"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="replicate-do-db">
+ <name>replicate-do-db</name>
+ <shortdescription>Tells the slave thread to restrict replication to the
+ specified database. To specify more than one database, use the directive
+ multiple times, once for each database. Note that this will only work if
+ you do not use cross-database queries such as UPDATE some_db.some_table
+ SET foo='bar' while having selected a different or no database. If you
+ need cross database updates to work, make sure you have 3.23.28 or later,
+ and use replicate-wild-do-table=db_name.%.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--replicate-do-db=name"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="replicate-do-table">
+ <name>replicate-do-table</name>
+ <shortdescription>Tells the slave thread to restrict replication to the
+ specified table. To specify more than one table, use the directive
+ multiple times, once for each table. This will work for cross-database
+ updates, in contrast to replicate-do-db.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--replicate-do-table=name"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="replicate-ignore-db">
+ <name>replicate-ignore-db</name>
+ <shortdescription>Tells the slave thread to not replicate to the specified
+ database. To specify more than one database to ignore, use the directive
+ multiple times, once for each database. This option will not work if you
+ use cross database updates. If you need cross database updates to work,
+ make sure you have 3.23.28 or later, and use
+ replicate-wild-ignore-table=db_name.%. </shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--replicate-ignore-db=name"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="replicate-ignore-table">
+ <name>replicate-ignore-table</name>
+ <shortdescription>Tells the slave thread to not replicate to the specified
+ table. To specify more than one table to ignore, use the directive
+ multiple times, once for each table. This will work for cross-datbase
+ updates, in contrast to replicate-ignore-db.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--replicate-ignore-table=name"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="replicate-rewrite-db">
+ <name>replicate-rewrite-db</name>
+ <shortdescription>Updates to a database with a different name than the
+ original. Example: replicate-rewrite-db=master_db_name->slave_db_name.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--replicate-rewrite-db=name"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="replicate-same-server-id">
+ <name>replicate-same-server-id</name>
+ <shortdescription>In replication, if set to 1, do not skip events having our
+ server id. Default value is 0 (to break infinite loops in circular
+ replication). Can't be set to 1 if</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--replicate-same-server-id"
+ setvar="replicate-same-server-id"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="replicate-wild-do-table">
+ <name>replicate-wild-do-table</name>
+ <shortdescription>Tells the slave thread to restrict replication to the
+ tables that match the specified wildcard pattern. To specify more than one
+ table, use the directive multiple times, once for each table. This will
+ work for cross-database updates. Example:
+ replicate-wild-do-table=foo%.bar% will replicate only updates to tables in
+ all databases that start with foo and whose table names start with bar.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--replicate-wild-do-table=name"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="replicate-wild-ignore-table">
+ <name>replicate-wild-ignore-table</name>
+ <shortdescription>Tells the slave thread to not replicate to the tables that
+ match the given wildcard pattern. To specify more than one table to
+ ignore, use the directive multiple times, once for each table. This will
+ work for cross-database updates. Example:
+ replicate-wild-ignore-table=foo%.bar% will not do updates to tables in
+ databases that start with foo and whose table names start with bar.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--replicate-wild-ignore-table=name"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="report-host">
+ <name>report-host</name>
+ <shortdescription>Hostname or IP of the slave to be reported to to the
+ master during slave registration. Will appear in the output of SHOW SLAVE
+ HOSTS. Leave unset if you do not want the slave to register itself with
+ the master. Note that it is not sufficient for the master to simply read
+ the IP of the slave off the socket once the slave connects. Due to NAT and
+ other routing issues, that IP may not be valid for connecting to the slave
+ from the master or other hosts. --report-password=name Undocumented.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--report-host=name" setvar="report-host"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="report-password">
+ <name>report-password</name>
+ <shortdescription>Undocumented.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--report-password=name"
+ setvar="report-password"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="report-port">
+ <name>report-port</name>
+ <shortdescription>Port for connecting to slave reported to the master during
+ slave registration. Set it only if the slave is listening on a non-default
+ port or if you have a special tunnel from the master or other clients to
+ the slave. If not sure, leave this option unset.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--report-port=#" setvar="report-port"/>
+ <vartype class="server" default="3306"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="report-user">
+ <name>report-user</name>
+ <shortdescription>Undocumented. --rpl-recovery-rank=# Undocumented.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--report-user=name" setvar="report-user"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="rpl-recovery-rank">
+ <name>rpl-recovery-rank</name>
+ <shortdescription>Undocumented.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--rpl-recovery-rank=#"
+ setvar="rpl-recovery-rank"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="s">
+ <name>s</name>
+ <shortdescription>--use-symbolic-links Enable symbolic link support.
+ Deprecated option; use</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="-s,"/>
+ </types>
+ <versions>
+ <manual version="5.1"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="safe-mode">
+ <name>safe-mode</name>
+ <shortdescription>Skip some optimize stages (for testing).
+ --safe-show-database Deprecated option; use GRANT SHOW DATABASES
+ instead...</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--safe-mode"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="safe-show-database">
+ <name>safe-show-database</name>
+ <shortdescription>Deprecated option; use GRANT SHOW DATABASES instead...</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--safe-show-database"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="safe-user-create">
+ <name>safe-user-create</name>
+ <shortdescription>Don't allow new user creation by the user who has no write
+ privileges to the mysql.user table. --safemalloc-mem-limit=# Simulate
+ memory shortage when compiled with the</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--safe-user-create"
+ setvar="safe-user-create"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="safemalloc-mem-limit">
+ <name>safemalloc-mem-limit</name>
+ <shortdescription>Simulate memory shortage when compiled with the</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--safemalloc-mem-limit=#"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="secure-auth">
+ <name>secure-auth</name>
+ <shortdescription>Disallow authentication for accounts that have old
+ (pre-4.1) passwords.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--secure-auth" setvar="secure-auth"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="server-id">
+ <name>server-id</name>
+ <shortdescription>Uniquely identifies the server instance in the community
+ of replication partners.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--server-id=#" setvar="server-id"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="set-variable">
+ <name>set-variable</name>
+ <shortdescription>Change the value of a variable. Please note that this
+ option is deprecated;you can set variables directly with
+ --variable-name=value.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--set-variable=name"/>
+ <optype class="cmdline" format="-O"/>
+ <optype class="serveropt" format="set-variable"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="show-slave-auth-info">
+ <name>show-slave-auth-info</name>
+ <shortdescription>Show user and password in SHOW SLAVE HOSTS on this master</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--show-slave-auth-info"
+ setvar="show-slave-auth-info"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="skip-grant-tables">
+ <name>skip-grant-tables</name>
+ <shortdescription>Start without grant tables. This gives all users FULL
+ ACCESS to all tables!</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--skip-grant-tables"
+ setvar="skip-grant-tables"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="skip-host-cache">
+ <name>skip-host-cache</name>
+ <shortdescription>Don't cache host names.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--skip-host-cache"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="skip-locking">
+ <name>skip-locking</name>
+ <shortdescription>Deprecated option, use --skip-external-locking instead.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--skip-locking"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="skip-name-resolve">
+ <name>skip-name-resolve</name>
+ <shortdescription>Don't resolve hostnames. All hostnames are IP's or
+ 'localhost'.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--skip-name-resolve"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="skip-networking">
+ <name>skip-networking</name>
+ <shortdescription>Don't allow connection with TCP/IP.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--skip-networking"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="skip-new">
+ <name>skip-new</name>
+ <shortdescription>Don't use new, possible wrong routines.
+ --skip-show-database Don't allow 'SHOW DATABASE' commands.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--skip-new"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="skip-show-database">
+ <name>skip-show-database</name>
+ <shortdescription>Don't allow 'SHOW DATABASE' commands.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--skip-show-database"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="skip-slave-start">
+ <name>skip-slave-start</name>
+ <shortdescription>If set, slave is not autostarted.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--skip-slave-start"
+ setvar="skip-slave-start"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="skip-stack-trace">
+ <name>skip-stack-trace</name>
+ <shortdescription>Don't print a stack trace on failure.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--skip-stack-trace"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="skip-symbolic-links">
+ <name>skip-symbolic-links</name>
+ <shortdescription>instead. --skip-thread-priority Don't give threads
+ different priorities. --slave-load-tmpdir=name The location where the
+ slave should put its temporary files when replicating a LOAD DATA INFILE
+ command. --slave-skip-errors=name Tells the slave thread to continue
+ replication when a query returns an error from the provided list.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--skip-symbolic-links"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="skip-symlink">
+ <name>skip-symlink</name>
+ <shortdescription>Don't allow symlinking of tables. Deprecated option. Use</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--skip-symlink"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="skip-thread-priority">
+ <name>skip-thread-priority</name>
+ <shortdescription>Don't give threads different priorities.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--skip-thread-priority"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="slave-load-tmpdir">
+ <name>slave-load-tmpdir</name>
+ <shortdescription>The location where the slave should put its temporary
+ files when replicating a LOAD DATA INFILE command.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--slave-load-tmpdir=name"
+ setvar="slave-load-tmpdir"/>
+ <vartype class="server" default="/tmp"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="slave-skip-errors">
+ <name>slave-skip-errors</name>
+ <shortdescription>Tells the slave thread to continue replication when a
+ query returns an error from the provided list.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--slave-skip-errors=name"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="slave_compressed_protocol">
+ <name>slave_compressed_protocol</name>
+ <shortdescription>Use compression on master/slave protocol.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--slave_compressed_protocol"
+ setvar="slave_compressed_protocol"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="slave_net_timeout">
+ <name>slave_net_timeout</name>
+ <shortdescription>Number of seconds to wait for more data from a
+ master/slave connection before aborting the read.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--slave_net_timeout=#"
+ setvar="slave_net_timeout"/>
+ <vartype class="server" default="3600"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="slave_transaction_retries">
+ <name>slave_transaction_retries</name>
+ <shortdescription>Number of times the slave SQL thread will retry a
+ transaction in case it failed with a deadlock or elapsed lock wait
+ timeout, before giving up and stopping.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--slave_transaction_retries=#"
+ setvar="slave_transaction_retries"/>
+ <vartype class="server" default="10"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="slow-query-log">
+ <name>slow-query-log</name>
+ <shortdescription>Enable|disable slow query log</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--slow-query-log" setvar="slow-query-log"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="slow_launch_time">
+ <name>slow_launch_time</name>
+ <shortdescription>If creating the thread takes longer than this value (in
+ seconds), the Slow_launch_threads counter will be incremented.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--slow_launch_time=#"
+ setvar="slow_launch_time"/>
+ <vartype class="server" default="2"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="socket">
+ <name>socket</name>
+ <shortdescription>Socket file to use for connection.
+ --sporadic-binlog-dump-fail Option used by mysql-test for debugging and
+ testing of replication. --sql-bin-update-same=# The update log is
+ deprecated since version 5.0, is replaced by the binary log and this
+ option does nothing anymore.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--socket=name" setvar="socket"/>
+ <vartype class="server" default="/tmp/mysql.sock"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="sort_buffer_size">
+ <name>sort_buffer_size</name>
+ <shortdescription>Each thread that needs to do a sort allocates a buffer of
+ this size.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--sort_buffer_size=#"
+ setvar="sort_buffer_size"/>
+ <vartype class="server" default="2097144"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="sporadic-binlog-dump-fail">
+ <name>sporadic-binlog-dump-fail</name>
+ <shortdescription>Option used by mysql-test for debugging and testing of
+ replication.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--sporadic-binlog-dump-fail"
+ setvar="sporadic-binlog-dump-fail"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="sql-bin-update-same">
+ <name>sql-bin-update-same</name>
+ <shortdescription>The update log is deprecated since version 5.0, is
+ replaced by the binary log and this option does nothing anymore.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--sql-bin-update-same=#"
+ setvar="sql-bin-update-same"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="sql-mode">
+ <name>sql-mode</name>
+ <shortdescription>Syntax: sql-mode=option[,option[,option...]] where option
+ can be one of: REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE,
+ ONLY_FULL_GROUP_BY, NO_UNSIGNED_SUBTRACTION.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--sql-mode=name" setvar="sql-mode"/>
+ <vartype class="server" default="OFF"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ssl">
+ <name>ssl</name>
+ <shortdescription>Enable SSL for connection (automatically enabled with
+ other flags). Disable with --skip-ssl.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ssl" setvar="ssl"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ssl-ca">
+ <name>ssl-ca</name>
+ <shortdescription>CA file in PEM format (check OpenSSL docs, implies --ssl).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ssl-ca=name" setvar="ssl-ca"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ssl-capath">
+ <name>ssl-capath</name>
+ <shortdescription>CA directory (check OpenSSL docs, implies --ssl).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ssl-capath=name" setvar="ssl-capath"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ssl-cert">
+ <name>ssl-cert</name>
+ <shortdescription>X509 cert in PEM format (implies --ssl).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ssl-cert=name" setvar="ssl-cert"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ssl-cipher">
+ <name>ssl-cipher</name>
+ <shortdescription>SSL cipher to use (implies --ssl).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ssl-cipher=name" setvar="ssl-cipher"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="ssl-key">
+ <name>ssl-key</name>
+ <shortdescription>X509 key in PEM format (implies --ssl).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--ssl-key=name" setvar="ssl-key"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="symbolic-links">
+ <name>symbolic-links</name>
+ <shortdescription>instead.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--symbolic-links" setvar="symbolic-links"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="sync-bdb-logs">
+ <name>sync-bdb-logs</name>
+ <shortdescription>Synchronously flush Berkeley DB logs. Enabled by default</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--sync-bdb-logs" setvar="sync-bdb-logs"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="sync-binlog">
+ <name>sync-binlog</name>
+ <shortdescription>Synchronously flush binary log to disk after every #th
+ event. Use 0 (default) to disable synchronous flushing.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--sync-binlog=#" setvar="sync-binlog"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="sync-frm">
+ <name>sync-frm</name>
+ <shortdescription>Sync .frm to disk on create. Enabled by default.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--sync-frm" setvar="sync-frm"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="sysdate-is-now">
+ <name>sysdate-is-now</name>
+ <shortdescription>Non-default option to alias SYSDATE() to NOW() to make it
+ safe-replicable. Since 5.0, SYSDATE() returns a `dynamic' value different
+ for different invocations, even within the same statement.
+ --tc-heuristic-recover=name Decision to use in heuristic recover process.
+ Possible values are COMMIT or ROLLBACK.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--sysdate-is-now" setvar="sysdate-is-now"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="table_cache">
+ <name>table_cache</name>
+ <shortdescription>Deprecated; use --table_open_cache instead.
+ --table_definition_cache=# The number of cached table definitions.
+ --table_open_cache=# The number of cached open tables.
+ --table_lock_wait_timeout=# Timeout in seconds to wait for a table level
+ lock before returning an error. Used only if the connection has active
+ cursors. --thread_cache_size=# How many threads we should keep in a cache
+ for reuse. --thread_concurrency=# Permits the application to give the
+ threads system a hint for the desired number of threads that should be run
+ at the same time.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--table_cache=#" setvar="table_cache"/>
+ <vartype class="server" default="64"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="table_definition_cache">
+ <name>table_definition_cache</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="table_lock_wait_timeout">
+ <name>table_lock_wait_timeout</name>
+ <shortdescription>Timeout in seconds to wait for a table level lock before
+ returning an error. Used only if the connection has active cursors.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--table_lock_wait_timeout=#"
+ setvar="table_lock_wait_timeout"/>
+ <vartype class="server" default="50"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="table_open_cache">
+ <name>table_open_cache</name>
+ <shortdescription/>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <vartype class="server"/>
+ </types>
+ <versions/>
+ </mysqloption>
+ <mysqloption id="tc-heuristic-recover">
+ <name>tc-heuristic-recover</name>
+ <shortdescription>Decision to use in heuristic recover process. Possible
+ values are COMMIT or ROLLBACK.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--tc-heuristic-recover=name"
+ setvar="tc-heuristic-recover"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="temp-pool">
+ <name>temp-pool</name>
+ <shortdescription>Using this option will cause most temporary files created
+ to use a small set of names, rather than a unique name for each new file.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--temp-pool" setvar="temp-pool"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="thread_cache_size">
+ <name>thread_cache_size</name>
+ <shortdescription>How many threads we should keep in a cache for reuse.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--thread_cache_size=#"
+ setvar="thread_cache_size"/>
+ <vartype class="server" default="0"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="thread_concurrency">
+ <name>thread_concurrency</name>
+ <shortdescription>Permits the application to give the threads system a hint
+ for the desired number of threads that should be run at the same time.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--thread_concurrency=#"
+ setvar="thread_concurrency"/>
+ <vartype class="server" default="10"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="thread_stack">
+ <name>thread_stack</name>
+ <shortdescription>The stack size for each thread.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--thread_stack=#" setvar="thread_stack"/>
+ <vartype class="server" default="196608"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="time_format">
+ <name>time_format</name>
+ <shortdescription>The TIME format (for future).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--time_format=name" setvar="time_format"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="timed_mutexes">
+ <name>timed_mutexes</name>
+ <shortdescription>Specify whether to time mutexes (only InnoDB mutexes are
+ currently supported)</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--timed_mutexes" setvar="timed_mutexes"/>
+ <vartype class="server" default="FALSE"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="tmp_table_size">
+ <name>tmp_table_size</name>
+ <shortdescription>If an in-memory temporary table exceeds this size, MySQL
+ will automatically convert it to an on-disk MyISAM table.
+ --transaction_alloc_block_size=# Allocation block size for transactions to
+ be stored in binary log --transaction_prealloc_size=# Persistent buffer
+ for transactions to be stored in binary log --updatable_views_with_limit=#
+ 1 = YES = Don't issue an error message (warning only) if a VIEW without
+ presence of a key of the underlying table is used in queries with a LIMIT
+ clause for updating. 0 = NO = Prohibit update of a VIEW, which does not
+ contain a key of the underlying table and the query uses a LIMIT clause
+ (usually get from GUI tools).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--tmp_table_size=#"
+ setvar="tmp_table_size"/>
+ <vartype class="server" default="33554432"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="tmpdir">
+ <name>tmpdir</name>
+ <shortdescription>Path for temporary files. Several paths may be specified,
+ separated by a colon (:), in this case they are used in a round-robin
+ fashion. --transaction-isolation=name Default transaction isolation level.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--tmpdir=name" setvar="tmpdir"/>
+ <optype class="cmdline" format="-t" setvar="tmpdir"/>
+ <optype class="serveropt" format="tmpdir" setvar="tmpdir"/>
+ <vartype class="server"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="transaction-isolation">
+ <name>transaction-isolation</name>
+ <shortdescription>Default transaction isolation level.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--transaction-isolation=name"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="transaction_alloc_block_size">
+ <name>transaction_alloc_block_size</name>
+ <shortdescription>Allocation block size for transactions to be stored in
+ binary log</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--transaction_alloc_block_size=#"
+ setvar="transaction_alloc_block_size"/>
+ <vartype class="server" default="8192"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="transaction_prealloc_size">
+ <name>transaction_prealloc_size</name>
+ <shortdescription>Persistent buffer for transactions to be stored in binary
+ log</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--transaction_prealloc_size=#"
+ setvar="transaction_prealloc_size"/>
+ <vartype class="server" default="4096"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="updatable_views_with_limit">
+ <name>updatable_views_with_limit</name>
+ <shortdescription>1 = YES = Don't issue an error message (warning only) if a
+ VIEW without presence of a key of the underlying table is used in queries
+ with a LIMIT clause for updating. 0 = NO = Prohibit update of a VIEW,
+ which does not contain a key of the underlying table and the query uses a
+ LIMIT clause (usually get from GUI tools).</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--updatable_views_with_limit=#"
+ setvar="updatable_views_with_limit"/>
+ <vartype class="server" default="1"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="use-symbolic-links">
+ <name>use-symbolic-links</name>
+ <shortdescription>Enable symbolic link support. Deprecated option; use</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--use-symbolic-links"
+ setvar="use-symbolic-links"/>
+ <optype class="cmdline" format="-s" setvar="use-symbolic-links"/>
+ <optype class="serveropt" format="use-symbolic-links"
+ setvar="use-symbolic-links"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="user">
+ <name>user</name>
+ <shortdescription>Run mysqld daemon as user.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--user=name"/>
+ <optype class="cmdline" format="-u"/>
+ <optype class="serveropt" format="user"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="verbose">
+ <name>verbose</name>
+ <shortdescription>Used with --help option for detailed help</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--verbose" setvar="verbose"/>
+ <optype class="cmdline" format="-v" setvar="verbose"/>
+ <optype class="serveropt" format="verbose" setvar="verbose"/>
+ <vartype class="server" default="TRUE"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="version">
+ <name>version</name>
+ <shortdescription>Output version information and exit.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--version"/>
+ <optype class="cmdline" format="-V"/>
+ <optype class="serveropt" format="version"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="wait_timeout">
+ <name>wait_timeout</name>
+ <shortdescription>The number of seconds the server waits for activity on a
+ connection before closing it.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--wait_timeout=#" setvar="wait_timeout"/>
+ <vartype class="server" default="28800"/>
+ </types>
+ <versions>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="warnings">
+ <name>warnings</name>
+ <shortdescription>Deprecated; use --log-warnings instead.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--warnings[=#]" setvar="warnings"/>
+ <optype class="cmdline" format="-W" setvar="warnings"/>
+ <optype class="serveropt" format="warnings" setvar="warnings"/>
+ <vartype class="server" default="1"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+ <mysqloption id="with-debug">
+ <name>with-debug</name>
+ <shortdescription>option.</shortdescription>
+ <section/>
+ <opclass/>
+ <engines includes="all"/>
+ <platforms>All</platforms>
+ <types>
+ <optype class="cmdline" format="--with-debug=full"/>
+ </types>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </mysqloption>
+</mysqloptions>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r3090 - in trunk: . mysqld-optvars | mcbrown | 23 Aug |
