Create 'main' test directory and move 't' and 'r' there

1 files changed, 1687 insertions, 0 deletions

diff --git a/mysql-test/main/mysqld--help.result b/mysql-test/main/mysqld--help.result
new file mode 100644
index 00000000000..ef6a49df08b
--- /dev/null
+++ b/mysql-test/main/mysqld--help.result
@@ -0,0 +1,1687 @@
+Windows bug: happens when a new line is exactly at the right offset.
+The following options may be given as the first argument:
+--print-defaults Print the program argument list and exit.
+--no-defaults Don't read default options from any option file.
+--defaults-file=# Only read default options from the given file #.
+--defaults-extra-file=# Read this file after the global files are read.
+
+ --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
+ -a, --ansi          Use ANSI SQL syntax instead of MySQL syntax. This mode
+ will also set transaction isolation level 'serializable'.
+ --auto-increment-increment[=#] 
+ Auto-increment columns are incremented by this
+ --auto-increment-offset[=#] 
+ Offset added to Auto-increment columns. Used when
+ auto-increment-increment != 1
+ --autocommit        Set default value for autocommit (0 or 1)
+ (Defaults to on; use --skip-autocommit to disable.)
+ --automatic-sp-privileges 
+ Creating and dropping stored procedures alters ACLs
+ (Defaults to on; use --skip-automatic-sp-privileges to disable.)
+ --back-log=#        The number of outstanding connection requests MariaDB can
+ have. This comes into play when the main MariaDB thread
+ gets very many connection requests in a very short time
+ (Automatically configured unless set explicitly)
+ -b, --basedir=name  Path to installation directory. All paths are usually
+ resolved relative to this
+ --big-tables        Old variable, which if set to 1, allows large result sets
+ by saving all temporary sets to disk, avoiding 'table
+ full' errors. No longer needed, as the server now handles
+ this automatically. sql_big_tables is a synonym.
+ --bind-address=name IP address to bind to.
+ --binlog-annotate-row-events 
+ Tells the master to annotate RBR events with the
+ statement that caused these events
+ (Defaults to on; use --skip-binlog-annotate-row-events to disable.)
+ --binlog-cache-size=# 
+ The size of the transactional cache for updates to
+ transactional engines for the binary log. If you often
+ use transactions containing many statements, you can
+ increase this to get more performance
+ --binlog-checksum=name 
+ Type of BINLOG_CHECKSUM_ALG. Include checksum for log
+ events in the binary log. One of: NONE, CRC32
+ --binlog-commit-wait-count=# 
+ If non-zero, binlog write will wait at most
+ binlog_commit_wait_usec microseconds for at least this
+ many commits to queue up for group commit to the binlog.
+ This can reduce I/O on the binlog and provide increased
+ opportunity for parallel apply on the slave, but too high
+ a value will decrease commit throughput.
+ --binlog-commit-wait-usec=# 
+ Maximum time, in microseconds, to wait for more commits
+ to queue up for binlog group commit. Only takes effect if
+ the value of binlog_commit_wait_count is non-zero.
+ --binlog-direct-non-transactional-updates 
+ Causes updates to non-transactional engines using
+ statement format to be written directly to binary log.
+ Before using this option make sure that there are no
+ dependencies between transactional and non-transactional
+ tables such as in the statement INSERT INTO t_myisam
+ SELECT * FROM t_innodb; otherwise, slaves may diverge
+ from the master.
+ --binlog-do-db=name Tells the master it should log updates for the specified
+ database, and exclude all others not explicitly
+ mentioned.
+ --binlog-file-cache-size=# 
+ The size of file cache for the binary log
+ --binlog-format=name 
+ What form of binary logging the master will use: either
+ ROW for row-based binary logging, 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.
+ --binlog-ignore-db=name 
+ Tells the master that updates to the given database
+ should not be logged to the binary log.
+ --binlog-optimize-thread-scheduling 
+ Run fast part of group commit in a single thread, to
+ optimize kernel thread scheduling. On by default. Disable
+ to run each transaction in group commit in its own
+ thread, which can be slower at very high concurrency.
+ This option is mostly for testing one algorithm versus
+ the other, and it should not normally be necessary to
+ change it.
+ (Defaults to on; use --skip-binlog-optimize-thread-scheduling to disable.)
+ --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.
+ --binlog-row-image=name 
+ Controls whether rows should be logged in 'FULL',
+ 'NOBLOB' or 'MINIMAL' formats. 'FULL', means that all
+ columns in the before and after image are logged.
+ 'NOBLOB', means that mysqld avoids logging blob columns
+ whenever possible (eg, blob column was not changed or is
+ not part of primary key). 'MINIMAL', means that a PK
+ equivalent (PK columns or full row if there is no PK in
+ the table) is logged in the before image, and only
+ changed columns are logged in the after image. (Default:
+ FULL).
+ --binlog-stmt-cache-size=# 
+ The size of the statement cache for updates to
+ non-transactional engines for the binary log. If you
+ often use statements updating a great number of rows, you
+ can increase this to get more performance.
+ --bootstrap         Used by mysql installation scripts.
+ --bulk-insert-buffer-size=# 
+ Size of tree cache used in bulk insert optimisation. Note
+ that this is a limit per thread!
+ --character-set-client-handshake 
+ Don't ignore client side character set value sent during
+ handshake.
+ (Defaults to on; use --skip-character-set-client-handshake to disable.)
+ --character-set-filesystem=name 
+ Set the filesystem character set.
+ -C, --character-set-server=name 
+ Set the default character set.
+ --character-sets-dir=name 
+ Directory where character sets are
+ -r, --chroot=name   Chroot mysqld daemon during startup.
+ --collation-server=name 
+ Set the default collation.
+ --column-compression-threshold=# 
+ Minimum column data length eligible for compression
+ --column-compression-zlib-level=# 
+ zlib compression level (1 gives best speed, 9 gives best
+ compression)
+ --column-compression-zlib-strategy=name 
+ The strategy parameter is used to tune the compression
+ algorithm. Use the value DEFAULT_STRATEGY for normal
+ data, FILTERED for data produced by a filter (or
+ predictor), HUFFMAN_ONLY to force Huffman encoding only
+ (no string match), or RLE to limit match distances to one
+ (run-length encoding). Filtered data consists mostly of
+ small values with a somewhat random distribution. In this
+ case, the compression algorithm is tuned to compress them
+ better. The effect of FILTERED is to force more Huffman
+ coding and less string matching; it is somewhat
+ intermediate between DEFAULT_STRATEGY and HUFFMAN_ONLY.
+ RLE is designed to be almost as fast as HUFFMAN_ONLY, but
+ give better compression for PNG image data. The strategy
+ parameter only affects the compression ratio but not the
+ correctness of the compressed output even if it is not
+ set appropriately. FIXED prevents the use of dynamic
+ Huffman codes, allowing for a simpler decoder for special
+ applications.
+ --column-compression-zlib-wrap 
+ Generate zlib header and trailer and compute adler32
+ check value. It can be used with storage engines that
+ don't provide data integrity verification to detect data
+ corruption.
+ --completion-type=name 
+ The transaction completion type. One of: NO_CHAIN, CHAIN,
+ RELEASE
+ --concurrent-insert[=name] 
+ Use concurrent insert with MyISAM. One of: NEVER, AUTO, 
+ ALWAYS
+ --console           Write error output on screen; don't remove the console
+ window on windows.
+ --core-file         Write core on errors.
+ -h, --datadir=name  Path to the database root directory
+ --date-format=name  The DATE format (ignored)
+ --datetime-format=name 
+ The DATETIME format (ignored)
+ --deadlock-search-depth-long=# 
+ Long search depth for the two-step deadlock detection
+ --deadlock-search-depth-short=# 
+ Short search depth for the two-step deadlock detection
+ --deadlock-timeout-long=# 
+ Long timeout for the two-step deadlock detection (in
+ microseconds)
+ --deadlock-timeout-short=# 
+ Short timeout for the two-step deadlock detection (in
+ microseconds)
+ --default-regex-flags=name 
+ Default flags for the regex library. Any combination of: 
+ DOTALL, DUPNAMES, EXTENDED, EXTRA, MULTILINE, UNGREEDY
+ --default-storage-engine=name 
+ The default storage engine for new tables
+ --default-time-zone=name 
+ Set the default time zone.
+ --default-tmp-storage-engine=name 
+ The default storage engine for user-created temporary
+ tables
+ --default-week-format=# 
+ The default week format used by WEEK() functions
+ --delay-key-write[=name] 
+ Specifies how MyISAM tables handles CREATE TABLE
+ DELAY_KEY_WRITE. If set to ON, the default, any DELAY KEY
+ WRITEs are honored. The key buffer is then flushed only
+ when the table closes, speeding up writes. MyISAM tables
+ should be automatically checked upon startup in this
+ case, and --external locking should not be used, as it
+ can lead to index corruption. If set to OFF, DELAY KEY
+ WRITEs are ignored, while if set to ALL, all new opened
+ tables are treated as if created with DELAY KEY WRITEs
+ enabled.
+ --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
+ --encrypt-binlog    Encrypt binary logs (including relay logs)
+ --encrypt-tmp-disk-tables 
+ Encrypt temporary on-disk tables (created as part of
+ query execution)
+ --encrypt-tmp-files Encrypt temporary files (created for filesort, binary log
+ cache, etc)
+ --enforce-storage-engine=name 
+ Force the use of a storage engine for new tables
+ --event-scheduler[=name] 
+ Enable the event scheduler. Possible values are ON, OFF,
+ and DISABLED (keep the event scheduler completely
+ deactivated, it cannot be activated run-time)
+ --expensive-subquery-limit=# 
+ The maximum number of rows a subquery may examine in
+ order to be executed during optimization and used for
+ constant optimization
+ --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
+ --explicit-defaults-for-timestamp 
+ This option causes CREATE TABLE to create all TIMESTAMP
+ columns as NULL with DEFAULT NULL attribute, Without this
+ option, TIMESTAMP columns are NOT NULL and have implicit
+ DEFAULT clauses.
+ --external-locking  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.
+ --extra-max-connections=# 
+ The number of connections on extra-port
+ --extra-port=#      Extra port number to use for tcp connections in a
+ one-thread-per-connection manner. 0 means don't use
+ another port
+ --flashback         Setup the server to use flashback. This enables binary
+ log in row mode and will enable extra logging for DDL's
+ needed by flashback feature
+ --flush             Flush MyISAM tables to disk between SQL commands
+ --flush-time=#      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)
+ --ft-max-word-len=# The maximum length of the word to be included in a
+ FULLTEXT index. Note: FULLTEXT indexes must be rebuilt
+ after changing this variable
+ --ft-min-word-len=# 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
+ --gdb               Set up signals usable for debugging. Deprecated, use
+ --general-log       Log connections and queries to a table or log file.
+ Defaults logging to a file 'hostname'.log or a table
+ mysql.general_logif --log-output=TABLE is used.
+ --general-log-file=name 
+ Log connections and queries to given file
+ --getopt-prefix-matching 
+ Recognize command-line options by their unambiguos
+ prefixes.
+ (Defaults to on; use --skip-getopt-prefix-matching to disable.)
+ --group-concat-max-len=# 
+ The maximum length of the result of function
+ GROUP_CONCAT()
+ --gtid-domain-id=#  Used with global transaction ID to identify logically
+ independent replication streams. When events can
+ propagate through multiple parallel paths (for example
+ multiple masters), each independent source server must
+ use a distinct domain_id. For simple tree-shaped
+ replication topologies, it can be left at its default, 0.
+ --gtid-ignore-duplicates 
+ When set, different master connections in multi-source
+ replication are allowed to receive and process event
+ groups with the same GTID (when using GTID mode). Only
+ one will be applied, any others will be ignored. Within a
+ given replication domain, just the sequence number will
+ be used to decide whether a given GTID has been already
+ applied; this means it is the responsibility of the user
+ to ensure that GTID sequence numbers are strictly
+ increasing.
+ --gtid-pos-auto-engines=name 
+ List of engines for which to automatically create a
+ mysql.gtid_slave_pos_ENGINE table, if a transaction using
+ that engine is replicated. This can be used to avoid
+ introducing cross-engine transactions, if engines are
+ used different from that used by table
+ mysql.gtid_slave_pos
+ --gtid-strict-mode  Enforce strict seq_no ordering of events in the binary
+ log. Slave stops with an error if it encounters an event
+ that would cause it to generate an out-of-order binlog if
+ executed.
+ -?, --help          Display this help and exit.
+ --histogram-size=#  Number of bytes used for a histogram. If set to 0, no
+ histograms are created by ANALYZE.
+ --histogram-type=name 
+ Specifies type of the histograms created by ANALYZE.
+ Possible values are: SINGLE_PREC_HB - single precision
+ height-balanced, DOUBLE_PREC_HB - double precision
+ height-balanced.
+ --host-cache-size=# How many host names should be cached to avoid resolving.
+ (Automatically configured unless set explicitly)
+ --idle-readonly-transaction-timeout=# 
+ The number of seconds the server waits for read-only idle
+ transaction
+ --idle-transaction-timeout=# 
+ The number of seconds the server waits for idle
+ transaction
+ --idle-write-transaction-timeout=# 
+ The number of seconds the server waits for write idle
+ transaction
+ --ignore-builtin-innodb 
+ Disable initialization of builtin InnoDB plugin
+ --ignore-db-dirs=name 
+ Specifies a directory to add to the ignore list when
+ collecting database names from the datadir. Put a blank
+ argument to reset the list accumulated so far.
+ --init-connect=name Command(s) that are executed for each new connection
+ (unless the user has SUPER privilege)
+ --init-file=name    Read SQL commands from this file at startup
+ --init-rpl-role=name 
+ Set the replication role. One of: MASTER, SLAVE
+ --init-slave=name   Command(s) that are executed by a slave server each time
+ the SQL thread starts
+ --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 joins
+ --join-buffer-space-limit=# 
+ The limit of the space for all join buffers used by a
+ query
+ --join-cache-level=# 
+ Controls what join operations can be executed with join
+ buffers. Odd numbers are used for plain join buffers
+ while even numbers are used for linked buffers
+ --keep-files-on-create 
+ Don't overwrite stale .MYD and .MYI even if no directory
+ is specified
+ --key-buffer-size=# 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
+ --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
+ --key-cache-file-hash-size=# 
+ Number of hash buckets for open and changed files.  If
+ you have a lot of MyISAM files open you should increase
+ this for faster flush of changes. A good value is
+ probably 1/10 of number of possible open MyISAM files.
+ --key-cache-segments=# 
+ The number of segments in a key cache
+ -L, --language=name Client error messages in given language. May be given as
+ a full path. Deprecated. Use --lc-messages-dir instead.
+ --large-pages       Enable support for large pages
+ --lc-messages=name  Set the language used for the error messages.
+ -L, --lc-messages-dir=name 
+ Directory where error messages are
+ --lc-time-names=name 
+ Set the language used for the month names and the days of
+ the week.
+ --local-infile      Enable LOAD DATA LOCAL INFILE
+ (Defaults to on; use --skip-local-infile to disable.)
+ --lock-wait-timeout=# 
+ Timeout in seconds to wait for a lock before returning an
+ error.
+ --log-basename=name Basename for all log files and the .pid file. This sets
+ all log file names at once (in 'datadir') and is normally
+ the only option you need for specifying log files. Sets
+ names for --log-bin, --log-bin-index, --relay-log,
+ --relay-log-index, --general-log-file,
+ --log-slow-query-log-file, --log-error-file, and
+ --pid-file
+ --log-bin[=name]    Log update queries in binary format. Optional argument
+ should be name for binary log. If not given
+ 'datadir'/'log-basename'-bin or 'datadir'/mysql-bin will
+ be used (the later if --log-basename is not specified).
+ We strongly recommend to use either --log-basename or
+ specify a filename to ensure that replication doesn't
+ stop if the real hostname of the computer changes.
+ --log-bin-compress  Whether the binary log can be compressed
+ --log-bin-compress-min-len[=#] 
+ Minimum length of sql statement(in statement mode) or
+ record(in row mode)that can be compressed.
+ --log-bin-index=name 
+ File that holds the names for last binary log files.
+ --log-bin-trust-function-creators 
+ If set to FALSE (the default), then when --log-bin is
+ used, creation of a stored function (or trigger) is
+ allowed only to users having the SUPER privilege and only
+ if this stored function (trigger) may not break binary
+ logging. Note that if ALL connections to this server
+ ALWAYS use row-based binary logging, the security issues
+ do not exist and the binary logging cannot break, so you
+ can safely set this to TRUE
+ --log-disabled-statements=name 
+ Don't log certain types of statements to general log. Any
+ combination of: slave, sp
+ --log-error[=name]  Log errors to file (instead of stdout).  If file name is
+ not specified then 'datadir'/'log-basename'.err or the
+ 'pid-file' path with extension .err is used
+ --log-isam[=name]   Log all MyISAM changes to file.
+ --log-output=name   How logs should be written. Any combination of: NONE, 
+ FILE, TABLE
+ --log-queries-not-using-indexes 
+ Log queries that are executed without benefit of any
+ index to the slow log if it is open. Same as
+ log_slow_filter='not_using_index'
+ --log-short-format  Don't log extra information to update and slow-query
+ logs.
+ --log-slave-updates Tells the slave to log the updates from the slave thread
+ to the binary log. You will need to turn it on if you
+ plan to daisy-chain the slaves.
+ --log-slow-admin-statements 
+ Log slow OPTIMIZE, ANALYZE, ALTER and other
+ administrative statements to the slow log if it is open. 
+ Resets or sets the option 'admin' in
+ log_slow_disabled_statements
+ --log-slow-disabled-statements=name 
+ Don't log certain types of statements to slow log. Any
+ combination of: admin, call, slave, sp
+ --log-slow-filter=name 
+ Log only certain types of queries to the slow log. If
+ variable empty alll kind of queries are logged.  All
+ types are bound by slow_query_time, except
+ 'not_using_index' which is always logged if enabled. Any
+ combination of: admin, filesort, filesort_on_disk, 
+ filesort_priority_queue, full_join, full_scan, 
+ not_using_index, query_cache, query_cache_miss, tmp_table,
+ tmp_table_on_disk
+ --log-slow-rate-limit=# 
+ Write to slow log every #th slow query. Set to 1 to log
+ everything. Increase it to reduce the size of the slow or
+ the performance impact of slow logging
+ --log-slow-slave-statements 
+ Log slow statements executed by slave thread to the slow
+ log if it is open. Resets or sets the option 'slave' in
+ log_slow_disabled_statements
+ --log-slow-verbosity=name 
+ Verbosity level for the slow log. Any combination of: 
+ innodb, query_plan, explain
+ --log-tc=name       Path to transaction coordinator log (used for
+ transactions that affect more than one storage engine,
+ when binary log is disabled).
+ --log-tc-size=#     Size of transaction coordinator log.
+ -W, --log-warnings[=#] 
+ Log some not critical warnings to the general log
+ file.Value can be between 0 and 11. Higher values mean
+ more verbosity
+ --long-query-time=# Log all queries that have taken more than long_query_time
+ seconds to execute to the slow query log file. The
+ argument will be treated as a decimal value with
+ microsecond precision
+ --low-priority-updates 
+ INSERT/DELETE/UPDATE has lower priority than selects
+ --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
+ --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. Defaults to master.info
+ --master-retry-count=# 
+ The number of tries the slave will make to connect to the
+ master before giving up.
+ --master-verify-checksum 
+ Force checksum verification of logged events in the
+ binary log before sending them to slaves or printing them
+ in the output of SHOW BINLOG EVENTS
+ --max-allowed-packet=# 
+ Max packet length to send to or receive from the server
+ --max-binlog-cache-size=# 
+ Sets the total size of the transactional cache
+ --max-binlog-size=# Binary log will be rotated automatically when the size
+ exceeds this value.
+ --max-binlog-stmt-cache-size=# 
+ Sets the total size of the statement cache
+ --max-connect-errors=# 
+ If there is more than this number of interrupted
+ connections from a host this host will be blocked from
+ further connections
+ --max-connections=# 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 INSERT DELAYED
+ will be not used
+ --max-digest-length=# 
+ Maximum length considered for digest text.
+ --max-error-count=# Max number of errors/warnings to store for a statement
+ --max-heap-table-size=# 
+ Don't allow creation of heap tables bigger than this
+ --max-join-size=#   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-long-data-size=# 
+ The maximum BLOB length to send to server from
+ mysql_send_long_data API. Deprecated option; use
+ max_allowed_packet instead.
+ --max-prepared-stmt-count=# 
+ Maximum number of prepared statements in the server
+ --max-recursive-iterations[=#] 
+ Maximum number of iterations when executing recursive
+ queries
+ --max-relay-log-size=# 
+ relay log will be rotated automatically when the size
+ exceeds this value.  If 0 at startup, it's set to
+ max_binlog_size
+ --max-seeks-for-key=# 
+ Limit assumed max number of seeks when looking up rows
+ based on a key
+ --max-session-mem-used=# 
+ Amount of memory a single user session is allowed to
+ allocate. This limits the value of the session variable
+ MEM_USED
+ --max-sort-length=# 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
+ --max-statement-time=# 
+ A query that has taken more than max_statement_time
+ seconds will be aborted. The argument will be treated as
+ a decimal value with microsecond precision. A value of 0
+ (default) means no timeout
+ --max-tmp-tables=#  Unused, will be removed.
+ --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
+ --memlock           Lock mysqld in memory.
+ --metadata-locks-cache-size=# 
+ Unused
+ --metadata-locks-hash-instances=# 
+ Unused
+ --min-examined-row-limit=# 
+ Don't write queries to slow log that examine fewer rows
+ than that
+ --mrr-buffer-size=# Size of buffer to use when using MRR with range access
+ --multi-range-count=# 
+ Ignored. Use mrr_buffer_size instead
+ --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-sort-file-size=# 
+ Don't use the fast sort index method to created index if
+ the temporary file would get bigger than this
+ --myisam-mmap-size=# 
+ Restricts the total memory used for memory mapping of
+ MySQL tables
+ --myisam-recover-options[=name] 
+ Specifies how corrupted tables should be automatically
+ repaired. Any combination of: DEFAULT, BACKUP, FORCE, 
+ QUICK, BACKUP_ALL, OFF
+ --myisam-repair-threads=# 
+ If larger than 1, when repairing a MyISAM table all
+ indexes will be created in parallel, with one thread per
+ index. 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
+ --myisam-stats-method=name 
+ Specifies how MyISAM index statistics collection code
+ should treat NULLs. Possible values of name are
+ NULLS_UNEQUAL (default behavior for 4.1 and later),
+ NULLS_EQUAL (emulate 4.0 behavior), and NULLS_IGNORED
+ --myisam-use-mmap   Use memory mapping for reading and writing MyISAM tables
+ --mysql56-temporal-format 
+ Use MySQL-5.6 (instead of MariaDB-5.3) format for TIME,
+ DATETIME, TIMESTAMP columns.
+ (Defaults to on; use --skip-mysql56-temporal-format to disable.)
+ --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
+ --net-retry-count=# 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
+ --old               Use compatible behavior from previous MariaDB version.
+ See also --old-mode
+ --old-alter-table   Use old, non-optimized alter table
+ --old-mode=name     Used to emulate old behavior from earlier MariaDB or
+ MySQL versions. Any combination of: 
+ NO_DUP_KEY_WARNINGS_WITH_IGNORE, NO_PROGRESS_INFO, 
+ ZERO_DATE_TIME_CAST
+ --old-passwords     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).
+ --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 or autoset then mysqld will reserve
+ max_connections*5 or max_connections + table_cache*2
+ (whichever is larger) number of file descriptors
+ (Automatically configured unless set explicitly)
+ --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. Values smaller 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.
+ --optimizer-selectivity-sampling-limit=# 
+ Controls number of record samples to check condition
+ selectivity
+ --optimizer-switch=name 
+ Fine-tune the optimizer behavior. Takes a comma-separated
+ list of option=value pairs, where value is on, off, or
+ default, and options are: index_merge, index_merge_union,
+ index_merge_sort_union, index_merge_intersection, 
+ index_merge_sort_intersection, engine_condition_pushdown,
+ index_condition_pushdown, derived_merge, 
+ derived_with_keys, firstmatch, loosescan, materialization,
+ in_to_exists, semijoin, partial_match_rowid_merge, 
+ partial_match_table_scan, subquery_cache, mrr, 
+ mrr_cost_based, mrr_sort_keys, outer_join_with_cache, 
+ semijoin_with_cache, join_cache_incremental, 
+ join_cache_hashed, join_cache_bka, 
+ optimize_join_buffer_size, table_elimination, 
+ extended_keys, exists_to_in, orderby_uses_equalities, 
+ condition_pushdown_for_derived, split_materialized
+ --optimizer-use-condition-selectivity=# 
+ Controls selectivity of which conditions the optimizer
+ takes into account to calculate cardinality of a partial
+ join when it searches for the best execution plan
+ Meaning: 1 - use selectivity of index backed range
+ conditions to calculate the cardinality of a partial join
+ if the last joined table is accessed by full table scan
+ or an index scan, 2 - use selectivity of index backed
+ range conditions to calculate the cardinality of a
+ partial join in any case, 3 - additionally always use
+ selectivity of range conditions that are not backed by
+ any index to calculate the cardinality of a partial join,
+ 4 - use histograms to calculate selectivity of range
+ conditions that are not backed by any index to calculate
+ the cardinality of a partial join.5 - additionally use
+ selectivity of certain non-range predicates calculated on
+ record samples
+ --performance-schema 
+ Enable the performance schema.
+ --performance-schema-accounts-size=# 
+ Maximum number of instrumented user@host accounts. Use 0
+ to disable, -1 for automated sizing.
+ --performance-schema-consumer-events-stages-current 
+ Default startup value for the events_stages_current
+ consumer.
+ --performance-schema-consumer-events-stages-history 
+ Default startup value for the events_stages_history
+ consumer.
+ --performance-schema-consumer-events-stages-history-long 
+ Default startup value for the events_stages_history_long
+ consumer.
+ --performance-schema-consumer-events-statements-current 
+ Default startup value for the events_statements_current
+ consumer.
+ (Defaults to on; use --skip-performance-schema-consumer-events-statements-current to disable.)
+ --performance-schema-consumer-events-statements-history 
+ Default startup value for the events_statements_history
+ consumer.
+ --performance-schema-consumer-events-statements-history-long 
+ Default startup value for the
+ events_statements_history_long consumer.
+ --performance-schema-consumer-events-waits-current 
+ Default startup value for the events_waits_current
+ consumer.
+ --performance-schema-consumer-events-waits-history 
+ Default startup value for the events_waits_history
+ consumer.
+ --performance-schema-consumer-events-waits-history-long 
+ Default startup value for the events_waits_history_long
+ consumer.
+ --performance-schema-consumer-global-instrumentation 
+ Default startup value for the global_instrumentation
+ consumer.
+ (Defaults to on; use --skip-performance-schema-consumer-global-instrumentation to disable.)
+ --performance-schema-consumer-statements-digest 
+ Default startup value for the statements_digest consumer.
+ (Defaults to on; use --skip-performance-schema-consumer-statements-digest to disable.)
+ --performance-schema-consumer-thread-instrumentation 
+ Default startup value for the thread_instrumentation
+ consumer.
+ (Defaults to on; use --skip-performance-schema-consumer-thread-instrumentation to disable.)
+ --performance-schema-digests-size=# 
+ Size of the statement digest. Use 0 to disable, -1 for
+ automated sizing.
+ --performance-schema-events-stages-history-long-size=# 
+ Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to
+ disable, -1 for automated sizing.
+ --performance-schema-events-stages-history-size=# 
+ Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0
+ to disable, -1 for automated sizing.
+ --performance-schema-events-statements-history-long-size=# 
+ Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. Use 0
+ to disable, -1 for automated sizing.
+ --performance-schema-events-statements-history-size=# 
+ Number of rows per thread in EVENTS_STATEMENTS_HISTORY.
+ Use 0 to disable, -1 for automated sizing.
+ --performance-schema-events-waits-history-long-size=# 
+ Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to
+ disable, -1 for automated sizing.
+ --performance-schema-events-waits-history-size=# 
+ Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0
+ to disable, -1 for automated sizing.
+ --performance-schema-hosts-size=# 
+ Maximum number of instrumented hosts. Use 0 to disable,
+ -1 for automated sizing.
+ --performance-schema-instrument[=name] 
+ Default startup value for a performance schema
+ instrument.
+ --performance-schema-max-cond-classes=# 
+ Maximum number of condition instruments.
+ --performance-schema-max-cond-instances=# 
+ Maximum number of instrumented condition objects. Use 0
+ to disable, -1 for automated sizing.
+ --performance-schema-max-digest-length=# 
+ Maximum length considered for digest text, when stored in
+ performance_schema tables.
+ --performance-schema-max-file-classes=# 
+ Maximum number of file instruments.
+ --performance-schema-max-file-handles=# 
+ Maximum number of opened instrumented files.
+ --performance-schema-max-file-instances=# 
+ Maximum number of instrumented files. Use 0 to disable,
+ -1 for automated sizing.
+ --performance-schema-max-mutex-classes=# 
+ Maximum number of mutex instruments.
+ --performance-schema-max-mutex-instances=# 
+ Maximum number of instrumented MUTEX objects. Use 0 to
+ disable, -1 for automated sizing.
+ --performance-schema-max-rwlock-classes=# 
+ Maximum number of rwlock instruments.
+ --performance-schema-max-rwlock-instances=# 
+ Maximum number of instrumented RWLOCK objects. Use 0 to
+ disable, -1 for automated sizing.
+ --performance-schema-max-socket-classes=# 
+ Maximum number of socket instruments.
+ --performance-schema-max-socket-instances=# 
+ Maximum number of opened instrumented sockets. Use 0 to
+ disable, -1 for automated sizing.
+ --performance-schema-max-stage-classes=# 
+ Maximum number of stage instruments.
+ --performance-schema-max-statement-classes=# 
+ Maximum number of statement instruments.
+ --performance-schema-max-table-handles=# 
+ Maximum number of opened instrumented tables. Use 0 to
+ disable, -1 for automated sizing.
+ --performance-schema-max-table-instances=# 
+ Maximum number of instrumented tables. Use 0 to disable,
+ -1 for automated sizing.
+ --performance-schema-max-thread-classes=# 
+ Maximum number of thread instruments.
+ --performance-schema-max-thread-instances=# 
+ Maximum number of instrumented threads. Use 0 to disable,
+ -1 for automated sizing.
+ --performance-schema-session-connect-attrs-size=# 
+ Size of session attribute string buffer per thread. Use 0
+ to disable, -1 for automated sizing.
+ --performance-schema-setup-actors-size=# 
+ Maximum number of rows in SETUP_ACTORS.
+ --performance-schema-setup-objects-size=# 
+ Maximum number of rows in SETUP_OBJECTS.
+ --performance-schema-users-size=# 
+ Maximum number of instrumented users. Use 0 to disable,
+ -1 for automated sizing.
+ --pid-file=name     Pid file used by safe_mysqld
+ --plugin-dir=name   Directory for plugins
+ --plugin-load=name  Semicolon-separated list of plugins to load, where each
+ plugin is specified as ether a plugin_name=library_file
+ pair or only a library_file. If the latter case, all
+ plugins from a given library_file will be loaded.
+ --plugin-load-add=name 
+ Optional semicolon-separated list of plugins to load.
+ This option adds to the list specified by --plugin-load
+ in an incremental way. It can be specified many times,
+ adding more plugins every time.
+ --plugin-maturity=name 
+ The lowest desirable plugin maturity. Plugins less mature
+ than that will not be installed or loaded. One of: 
+ unknown, experimental, alpha, beta, gamma, stable
+ -P, --port=#        Port number to use for connection or 0 to default to,
+ my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default
+ (3306), whatever comes first
+ --port-open-timeout=# 
+ Maximum time in seconds to wait for the port to become
+ free. (Default: No wait).
+ --preload-buffer-size=# 
+ The size of the buffer that is allocated when preloading
+ indexes
+ --profiling-history-size=# 
+ Number of statements about which profiling information is
+ maintained. If set to 0, no profiles are stored. See SHOW
+ PROFILES.
+ --progress-report-time=# 
+ Seconds between sending progress reports to the client
+ for time-consuming statements. Set to 0 to disable
+ progress reporting.
+ --proxy-protocol-networks=name 
+ Enable proxy protocol for these source networks. The
+ syntax is a comma separated list of IPv4 and IPv6
+ networks. If the network doesn't contain mask, it is
+ considered to be a single host. "*" represents all
+ networks and must the only directive on the line. String
+ "localhost" represents non-TCP local connections (Unix
+ domain socket, Windows named pipe or shared memory).
+ --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=# 
+ The minimum size for blocks allocated by the query cache
+ --query-cache-size=# 
+ The memory allocated to store results from old queries
+ --query-cache-strip-comments 
+ Strip all comments from a query before storing it in the
+ query cache
+ --query-cache-type=name 
+ OFF = Don't cache or retrieve results. ON = Cache all
+ results except SELECT SQL_NO_CACHE ... queries. 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-binlog-speed-limit=# 
+ Maximum speed(KB/s) to read binlog from master (0 = no
+ limit)
+ --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
+ --read-only         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
+ --relay-log=name    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.
+ --relay-log-purge   if disabled - do not purge relay logs. if enabled - purge
+ them as soon as they are no more needed.
+ (Defaults to on; use --skip-relay-log-purge to disable.)
+ --relay-log-recovery 
+ Enables automatic relay log recovery right after the
+ database startup, which means that the IO Thread starts
+ re-fetching from the master right after the last
+ transaction processed.
+ --relay-log-space-limit=# 
+ Maximum space to use for all relay logs
+ --replicate-annotate-row-events 
+ Tells the slave to write annotate rows events received
+ from the master to its own binary log. Ignored if
+ log_slave_updates is not set
+ (Defaults to on; use --skip-replicate-annotate-row-events to disable.)
+ --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-events-marked-for-skip=name 
+ Whether the slave should replicate events that were
+ created with @@skip_replication=1 on the master. Default
+ REPLICATE (no events are skipped). Other values are
+ FILTER_ON_SLAVE (events will be sent by the master but
+ ignored by the slave) and FILTER_ON_MASTER (events marked
+ with @@skip_replication=1 will be filtered on the master
+ and never be sent to the slave).
+ --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-database 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
+ --log-slave-updates 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.
+ --report-host=name  Hostname or IP of the slave to be reported 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 
+ The account password of the slave to be reported to the
+ master during slave registration
+ --report-port=#     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
+ --report-user=name  The account user name of the slave to be reported to the
+ master during slave registration
+ --rowid-merge-buff-size=# 
+ The size of the buffers used [NOT] IN evaluation via
+ partial matching
+ --rpl-semi-sync-master-enabled 
+ Enable semi-synchronous replication master (disabled by
+ default).
+ --rpl-semi-sync-master-timeout=# 
+ The timeout value (in ms) for semi-synchronous
+ replication in the master
+ --rpl-semi-sync-master-trace-level=# 
+ The tracing level for semi-sync replication.
+ --rpl-semi-sync-master-wait-no-slave 
+ Wait until timeout when no semi-synchronous replication
+ slave available (enabled by default).
+ (Defaults to on; use --skip-rpl-semi-sync-master-wait-no-slave to disable.)
+ --rpl-semi-sync-master-wait-point=name 
+ Should transaction wait for semi-sync ack after having
+ synced binlog, or after having committed in storage
+ engine.. One of: AFTER_SYNC, AFTER_COMMIT
+ --rpl-semi-sync-slave-delay-master 
+ Only write master info file when ack is needed.
+ --rpl-semi-sync-slave-enabled 
+ Enable semi-synchronous replication slave (disabled by
+ default).
+ --rpl-semi-sync-slave-kill-conn-timeout[=#] 
+ Timeout for the mysql connection used to kill the slave
+ io_thread's connection on master. This timeout comes into
+ play when stop slave is executed.
+ --rpl-semi-sync-slave-trace-level=# 
+ The tracing level for semi-sync replication.
+ --safe-mode         Skip some optimize stages (for testing). Deprecated.
+ --safe-user-create  Don't allow new user creation by the user who has no
+ write privileges to the mysql.user table.
+ --secure-auth       Disallow authentication for accounts that have old
+ (pre-4.1) passwords
+ (Defaults to on; use --skip-secure-auth to disable.)
+ --secure-file-priv=name 
+ Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to
+ files within specified directory
+ --server-id=#       Uniquely identifies the server instance in the community
+ of replication partners
+ --session-track-schema 
+ Track changes to the default schema.
+ (Defaults to on; use --skip-session-track-schema to disable.)
+ --session-track-state-change 
+ Track changes to the session state.
+ --session-track-system-variables=name 
+ Track changes in registered system variables. 
+ --session-track-transaction-info=name 
+ Track changes to the transaction attributes. OFF to
+ disable; STATE to track just transaction state (Is there
+ an active transaction? Does it have any data? etc.);
+ CHARACTERISTICS to track transaction state and report all
+ statements needed to start a transaction withthe same
+ characteristics (isolation level, read only/read
+ write,snapshot - but not any work done / data modified
+ within the transaction).
+ --show-slave-auth-info 
+ Show user and password in SHOW SLAVE HOSTS on this
+ master.
+ --silent-startup    Don't print [Note] to the error log during startup.
+ --skip-bdb          Deprecated option; Exist only for compatibility with old
+ my.cnf files
+ --skip-grant-tables Start without grant tables. This gives all users FULL
+ ACCESS to all tables.
+ --skip-host-cache   Don't cache host names.
+ --skip-name-resolve Don't resolve hostnames. All hostnames are IP's or
+ 'localhost'.
+ --skip-networking   Don't allow connection with TCP/IP
+ --skip-show-database 
+ Don't allow 'SHOW DATABASE' commands
+ --skip-slave-start  If set, slave is not autostarted.
+ --slave-compressed-protocol 
+ Use compression on master/slave protocol
+ --slave-ddl-exec-mode=name 
+ How replication events should be executed. Legal values
+ are STRICT and IDEMPOTENT (default). In IDEMPOTENT mode,
+ replication will not stop for DDL operations that are
+ idempotent. This means that CREATE TABLE is treated as
+ CREATE TABLE OR REPLACE and DROP TABLE is treated as DROP
+ TABLE IF EXISTS.
+ --slave-domain-parallel-threads=# 
+ Maximum number of parallel threads to use on slave for
+ events in a single replication domain. When using
+ multiple domains, this can be used to limit a single
+ domain from grabbing all threads and thus stalling other
+ domains. The default of 0 means to allow a domain to grab
+ as many threads as it wants, up to the value of
+ slave_parallel_threads.
+ --slave-exec-mode=name 
+ How replication events should be executed. Legal values
+ are STRICT (default) and IDEMPOTENT. In IDEMPOTENT mode,
+ replication will not stop for operations that are
+ idempotent. For example, in row based replication
+ attempts to delete rows that doesn't exist will be
+ ignored. In STRICT mode, replication will stop on any
+ unexpected difference between the master and the slave.
+ --slave-load-tmpdir=name 
+ The location where the slave should put its temporary
+ files when replicating a LOAD DATA INFILE command
+ --slave-max-allowed-packet=# 
+ The maximum packet length to sent successfully from the
+ master to slave.
+ --slave-net-timeout=# 
+ Number of seconds to wait for more data from any
+ master/slave connection before aborting the read
+ --slave-parallel-max-queued=# 
+ Limit on how much memory SQL threads should use per
+ parallel replication thread when reading ahead in the
+ relay log looking for opportunities for parallel
+ replication. Only used when --slave-parallel-threads > 0.
+ --slave-parallel-mode=name 
+ Controls what transactions are applied in parallel when
+ using --slave-parallel-threads. Possible values:
+ "optimistic" tries to apply most transactional DML in
+ parallel, and handles any conflicts with rollback and
+ retry. "conservative" limits parallelism in an effort to
+ avoid any conflicts. "aggressive" tries to maximise the
+ parallelism, possibly at the cost of increased conflict
+ rate. "minimal" only parallelizes the commit steps of
+ transactions. "none" disables parallel apply completely.
+ --slave-parallel-threads=# 
+ If non-zero, number of threads to spawn to apply in
+ parallel events on the slave that were group-committed on
+ the master or were logged with GTID in different
+ replication domains. Note that these threads are in
+ addition to the IO and SQL threads, which are always
+ created by a replication slave
+ --slave-parallel-workers=# 
+ Alias for slave_parallel_threads
+ --slave-run-triggers-for-rbr=name 
+ Modes for how triggers in row-base replication on slave
+ side will be executed. Legal values are NO (default), YES
+ and LOGGING. NO means that trigger for RBR will not be
+ running on slave. YES and LOGGING means that triggers
+ will be running on slave, if there was not triggers
+ running on the master for the statement. LOGGING also
+ means results of that the executed triggers work will be
+ written to the binlog.
+ --slave-skip-errors=name 
+ Tells the slave thread to continue replication when a
+ query event returns an error from the provided list
+ --slave-sql-verify-checksum 
+ Force checksum verification of replication events after
+ reading them from relay log. Note: Events are always
+ checksum-verified by slave on receiving them from the
+ network before writing them to the relay log
+ (Defaults to on; use --skip-slave-sql-verify-checksum to disable.)
+ --slave-transaction-retries=# 
+ Number of times the slave SQL thread will retry a
+ transaction in case it failed with a deadlock, elapsed
+ lock wait timeout or listed in
+ slave_transaction_retry_errors, before giving up and
+ stopping
+ --slave-transaction-retry-errors=name 
+ Tells the slave thread to retry transaction for
+ replication when a query event returns an error from the
+ provided list. Deadlock and elapsed lock wait timeout
+ errors are automatically added to this list
+ --slave-transaction-retry-interval=# 
+ Interval of the slave SQL thread will retry a transaction
+ in case it failed with a deadlock or elapsed lock wait
+ timeout or listed in slave_transaction_retry_errors
+ --slave-type-conversions=name 
+ Set of slave type conversions that are enabled. If the
+ variable is empty, no conversions are allowed and it is
+ expected that the types match exactly. Any combination
+ of: ALL_LOSSY, ALL_NON_LOSSY
+ --slow-launch-time=# 
+ If creating the thread takes longer than this value (in
+ seconds), the Slow_launch_threads counter will be
+ incremented
+ --slow-query-log    Log slow queries to a table or log file. Defaults logging
+ to a file 'hostname'-slow.log or a table mysql.slow_log
+ if --log-output=TABLE is used. Must be enabled to
+ activate other slow log options.
+ --slow-query-log-file=name 
+ Log slow queries to given log file. Defaults logging to
+ 'hostname'-slow.log. Must be enabled to activate other
+ slow log options
+ --socket=name       Socket file to use for connection
+ --sort-buffer-size=# 
+ Each thread that needs to do a sort allocates a buffer of
+ this size
+ --sql-mode=name     Sets the sql mode. Any combination of: REAL_AS_FLOAT, 
+ PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, 
+ IGNORE_BAD_TABLE_OPTIONS, ONLY_FULL_GROUP_BY, 
+ NO_UNSIGNED_SUBTRACTION, NO_DIR_IN_CREATE, POSTGRESQL, 
+ ORACLE, MSSQL, DB2, MAXDB, NO_KEY_OPTIONS, 
+ NO_TABLE_OPTIONS, NO_FIELD_OPTIONS, MYSQL323, MYSQL40, 
+ ANSI, NO_AUTO_VALUE_ON_ZERO, NO_BACKSLASH_ESCAPES, 
+ STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, 
+ NO_ZERO_DATE, ALLOW_INVALID_DATES, 
+ ERROR_FOR_DIVISION_BY_ZERO, TRADITIONAL, 
+ NO_AUTO_CREATE_USER, HIGH_NOT_PRECEDENCE, 
+ NO_ENGINE_SUBSTITUTION, PAD_CHAR_TO_FULL_LENGTH, 
+ EMPTY_STRING_IS_NULL, SIMULTANEOUS_ASSIGNMENT
+ --stack-trace       Print a symbolic stack trace on failure
+ (Defaults to on; use --skip-stack-trace to disable.)
+ --standard-compliant-cte 
+ Allow only CTEs compliant to SQL standard
+ (Defaults to on; use --skip-standard-compliant-cte to disable.)
+ --stored-program-cache=# 
+ The soft upper limit for number of cached stored routines
+ for one connection.
+ --strict-password-validation 
+ When password validation plugins are enabled, reject
+ passwords that cannot be validated (passwords specified
+ as a hash)
+ (Defaults to on; use --skip-strict-password-validation to disable.)
+ -s, --symbolic-links 
+ Enable symbolic link support.
+ --sync-binlog=#     Synchronously flush binary log to disk after every #th
+ event. Use 0 (default) to disable synchronous flushing
+ --sync-frm          Sync .frm files to disk on creation
+ (Defaults to on; use --skip-sync-frm to disable.)
+ --sync-master-info=# 
+ Synchronously flush master info to disk after every #th
+ event. Use 0 to disable synchronous flushing
+ --sync-relay-log=#  Synchronously flush relay log to disk after every #th
+ event. Use 0 to disable synchronous flushing
+ --sync-relay-log-info=# 
+ Synchronously flush relay log info to disk after every
+ #th transaction. Use 0 to disable synchronous flushing
+ --sysdate-is-now    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.
+ --system-versioning-alter-history=name 
+ Versioning ALTER TABLE mode. ERROR: Fail ALTER with
+ error; KEEP: Keep historical system rows and subject them
+ to ALTER; 
+ --table-cache=#     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-open-cache-instances=# 
+ Maximum number of table cache instances
+ --tc-heuristic-recover=name 
+ Decision to use in heuristic recover process. One of: OFF,
+ COMMIT, ROLLBACK
+ --tcp-keepalive-interval=# 
+ The interval, in seconds, between when successive
+ keep-alive packets are sent if no acknowledgement is
+ received.If set to 0, system dependent default is used.
+ (Automatically configured unless set explicitly)
+ --tcp-keepalive-probes=# 
+ The number of unacknowledged probes to send before
+ considering the connection dead and notifying the
+ application layer.If set to 0, system dependent default
+ is used. (Automatically configured unless set explicitly)
+ --tcp-keepalive-time=# 
+ Timeout, in milliseconds, with no activity until the
+ first TCP keep-alive packet is sent.If set to 0, system
+ dependent default is used. (Automatically configured
+ unless set explicitly)
+ --thread-cache-size=# 
+ How many threads we should keep in a cache for reuse.
+ These are freed after 5 minutes of idle time
+ --thread-pool-idle-timeout=# 
+ Timeout in seconds for an idle thread in the thread
+ pool.Worker thread will be shut down after timeout
+ --thread-pool-max-threads=# 
+ Maximum allowed number of worker threads in the thread
+ pool
+ --thread-pool-oversubscribe=# 
+ How many additional active worker threads in a group are
+ allowed.
+ --thread-pool-prio-kickup-timer=# 
+ The number of milliseconds before a dequeued low-priority
+ statement is moved to the high-priority queue
+ --thread-pool-priority=name 
+ Threadpool priority. High priority connections usually
+ start executing earlier than low priority.If priority set
+ to 'auto', the the actual priority(low or high) is
+ determined based on whether or not connection is inside
+ transaction.
+ --thread-pool-size=# 
+ Number of thread groups in the pool. This parameter is
+ roughly equivalent to maximum number of concurrently
+ executing threads (threads in a waiting state do not
+ count as executing).
+ --thread-pool-stall-limit=# 
+ Maximum query execution time in milliseconds,before an
+ executing non-yielding thread is considered stalled.If a
+ worker thread is stalled, additional worker thread may be
+ created to handle remaining clients.
+ --thread-stack=#    The stack size for each thread
+ --time-format=name  The TIME format (ignored)
+ --timed-mutexes     Specify whether to time mutexes. Deprecated, has no
+ effect.
+ --tmp-disk-table-size=# 
+ Max size for data for an internal temporary on-disk
+ MyISAM or Aria table.
+ --tmp-memory-table-size=# 
+ If an internal in-memory temporary table exceeds this
+ size, MariaDB will automatically convert it to an on-disk
+ MyISAM or Aria table. Same as tmp_table_size.
+ --tmp-table-size=#  Alias for tmp_memory_table_size. If an internal in-memory
+ temporary table exceeds this size, MariaDB will
+ automatically convert it to an on-disk MyISAM or Aria
+ table.
+ -t, --tmpdir=name   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-alloc-block-size=# 
+ Allocation block size for transactions to be stored in
+ binary log
+ --transaction-isolation=name 
+ Default transaction isolation level. One of: 
+ READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, 
+ SERIALIZABLE
+ --transaction-prealloc-size=# 
+ Persistent buffer for transactions to be stored in binary
+ log
+ --transaction-read-only 
+ Default transaction access mode. True if transactions are
+ read-only.
+ --updatable-views-with-limit=name 
+ 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. 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)
+ --use-stat-tables=name 
+ Specifies how to use system statistics tables. One of: 
+ NEVER, COMPLEMENTARY, PREFERABLY
+ -u, --user=name     Run mysqld daemon as user.
+ --userstat          Enables statistics gathering for USER_STATISTICS,
+ CLIENT_STATISTICS, INDEX_STATISTICS and TABLE_STATISTICS
+ tables in the INFORMATION_SCHEMA
+ -v, --verbose       Used with --help option for detailed help.
+ -V, --version[=name] 
+ Output version information and exit.
+ --wait-timeout=#    The number of seconds the server waits for activity on a
+ connection before closing it
+
+Variables (--variable-name=value)
+allow-suspicious-udfs FALSE
+auto-increment-increment 1
+auto-increment-offset 1
+autocommit TRUE
+automatic-sp-privileges TRUE
+back-log 80
+big-tables FALSE
+bind-address (No default value)
+binlog-annotate-row-events TRUE
+binlog-cache-size 32768
+binlog-checksum CRC32
+binlog-commit-wait-count 0
+binlog-commit-wait-usec 100000
+binlog-direct-non-transactional-updates FALSE
+binlog-file-cache-size 16384
+binlog-format MIXED
+binlog-optimize-thread-scheduling TRUE
+binlog-row-event-max-size 8192
+binlog-row-image FULL
+binlog-stmt-cache-size 32768
+bulk-insert-buffer-size 8388608
+character-set-client-handshake TRUE
+character-set-filesystem binary
+character-sets-dir MYSQL_CHARSETSDIR/
+chroot (No default value)
+column-compression-threshold 100
+column-compression-zlib-level 6
+column-compression-zlib-strategy DEFAULT_STRATEGY
+column-compression-zlib-wrap FALSE
+completion-type NO_CHAIN
+concurrent-insert AUTO
+console TRUE
+date-format %Y-%m-%d
+datetime-format %Y-%m-%d %H:%i:%s
+deadlock-search-depth-long 15
+deadlock-search-depth-short 4
+deadlock-timeout-long 50000000
+deadlock-timeout-short 10000
+default-regex-flags 
+default-storage-engine myisam
+default-time-zone (No default value)
+default-tmp-storage-engine (No default value)
+default-week-format 0
+delay-key-write ON
+delayed-insert-limit 100
+delayed-insert-timeout 300
+delayed-queue-size 1000
+div-precision-increment 4
+encrypt-binlog FALSE
+encrypt-tmp-disk-tables FALSE
+encrypt-tmp-files FALSE
+enforce-storage-engine (No default value)
+event-scheduler OFF
+expensive-subquery-limit 100
+expire-logs-days 0
+explicit-defaults-for-timestamp FALSE
+external-locking FALSE
+extra-max-connections 1
+extra-port 0
+flashback FALSE
+flush FALSE
+flush-time 0
+ft-boolean-syntax + -><()~*:""&|
+ft-max-word-len 84
+ft-min-word-len 4
+ft-query-expansion-limit 20
+ft-stopword-file (No default value)
+gdb FALSE
+general-log FALSE
+getopt-prefix-matching FALSE
+group-concat-max-len 1048576
+gtid-domain-id 0
+gtid-ignore-duplicates FALSE
+gtid-pos-auto-engines 
+gtid-strict-mode FALSE
+help TRUE
+histogram-size 0
+histogram-type SINGLE_PREC_HB
+host-cache-size 279
+idle-readonly-transaction-timeout 0
+idle-transaction-timeout 0
+idle-write-transaction-timeout 0
+ignore-builtin-innodb FALSE
+ignore-db-dirs 
+init-connect 
+init-file (No default value)
+init-rpl-role MASTER
+init-slave 
+interactive-timeout 28800
+join-buffer-size 262144
+join-buffer-space-limit 2097152
+join-cache-level 2
+keep-files-on-create FALSE
+key-buffer-size 134217728
+key-cache-age-threshold 300
+key-cache-block-size 1024
+key-cache-division-limit 100
+key-cache-file-hash-size 512
+key-cache-segments 0
+large-pages FALSE
+lc-messages en_US
+lc-messages-dir MYSQL_SHAREDIR/
+lc-time-names en_US
+local-infile TRUE
+lock-wait-timeout 86400
+log-bin (No default value)
+log-bin-compress FALSE
+log-bin-compress-min-len 256
+log-bin-index (No default value)
+log-bin-trust-function-creators FALSE
+log-disabled-statements sp
+log-error 
+log-isam myisam.log
+log-output FILE
+log-queries-not-using-indexes FALSE
+log-short-format FALSE
+log-slave-updates FALSE
+log-slow-admin-statements TRUE
+log-slow-disabled-statements sp
+log-slow-filter admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
+log-slow-rate-limit 1
+log-slow-slave-statements TRUE
+log-slow-verbosity 
+log-tc tc.log
+log-warnings 2
+long-query-time 10
+low-priority-updates FALSE
+lower-case-table-names 1
+master-info-file master.info
+master-retry-count 86400
+master-verify-checksum FALSE
+max-allowed-packet 16777216
+max-binlog-cache-size 18446744073709547520
+max-binlog-size 1073741824
+max-binlog-stmt-cache-size 18446744073709547520
+max-connect-errors 100
+max-connections 151
+max-delayed-threads 20
+max-digest-length 1024
+max-error-count 64
+max-heap-table-size 16777216
+max-join-size 18446744073709551615
+max-length-for-sort-data 1024
+max-long-data-size 16777216
+max-prepared-stmt-count 16382
+max-recursive-iterations 18446744073709551615
+max-relay-log-size 1073741824
+max-seeks-for-key 18446744073709551615
+max-session-mem-used 9223372036854775807
+max-sort-length 1024
+max-sp-recursion-depth 0
+max-statement-time 0
+max-tmp-tables 32
+max-user-connections 0
+max-write-lock-count 18446744073709551615
+memlock FALSE
+metadata-locks-cache-size 1024
+metadata-locks-hash-instances 8
+min-examined-row-limit 0
+mrr-buffer-size 262144
+multi-range-count 256
+myisam-block-size 1024
+myisam-data-pointer-size 6
+myisam-max-sort-file-size 9223372036853727232
+myisam-mmap-size 18446744073709551615
+myisam-recover-options BACKUP,QUICK
+myisam-repair-threads 1
+myisam-sort-buffer-size 134216704
+myisam-stats-method NULLS_UNEQUAL
+myisam-use-mmap FALSE
+mysql56-temporal-format TRUE
+net-buffer-length 16384
+net-read-timeout 30
+net-retry-count 10
+net-write-timeout 60
+old FALSE
+old-alter-table FALSE
+old-mode 
+old-passwords FALSE
+old-style-user-limits FALSE
+optimizer-prune-level 1
+optimizer-search-depth 62
+optimizer-selectivity-sampling-limit 100
+optimizer-switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on
+optimizer-use-condition-selectivity 1
+performance-schema FALSE
+performance-schema-accounts-size -1
+performance-schema-consumer-events-stages-current FALSE
+performance-schema-consumer-events-stages-history FALSE
+performance-schema-consumer-events-stages-history-long FALSE
+performance-schema-consumer-events-statements-current TRUE
+performance-schema-consumer-events-statements-history FALSE
+performance-schema-consumer-events-statements-history-long FALSE
+performance-schema-consumer-events-waits-current FALSE
+performance-schema-consumer-events-waits-history FALSE
+performance-schema-consumer-events-waits-history-long FALSE
+performance-schema-consumer-global-instrumentation TRUE
+performance-schema-consumer-statements-digest TRUE
+performance-schema-consumer-thread-instrumentation TRUE
+performance-schema-digests-size -1
+performance-schema-events-stages-history-long-size -1
+performance-schema-events-stages-history-size -1
+performance-schema-events-statements-history-long-size -1
+performance-schema-events-statements-history-size -1
+performance-schema-events-waits-history-long-size -1
+performance-schema-events-waits-history-size -1
+performance-schema-hosts-size -1
+performance-schema-instrument 
+performance-schema-max-cond-classes 80
+performance-schema-max-cond-instances -1
+performance-schema-max-digest-length 1024
+performance-schema-max-file-classes 50
+performance-schema-max-file-handles 32768
+performance-schema-max-file-instances -1
+performance-schema-max-mutex-classes 200
+performance-schema-max-mutex-instances -1
+performance-schema-max-rwlock-classes 40
+performance-schema-max-rwlock-instances -1
+performance-schema-max-socket-classes 10
+performance-schema-max-socket-instances -1
+performance-schema-max-stage-classes 160
+performance-schema-max-statement-classes 200
+performance-schema-max-table-handles -1
+performance-schema-max-table-instances -1
+performance-schema-max-thread-classes 50
+performance-schema-max-thread-instances -1
+performance-schema-session-connect-attrs-size -1
+performance-schema-setup-actors-size 100
+performance-schema-setup-objects-size 100
+performance-schema-users-size -1
+port 3306
+port-open-timeout 0
+preload-buffer-size 32768
+profiling-history-size 15
+progress-report-time 5
+protocol-version 10
+proxy-protocol-networks 
+query-alloc-block-size 16384
+query-cache-limit 1048576
+query-cache-min-res-unit 4096
+query-cache-size 1048576
+query-cache-strip-comments FALSE
+query-cache-type OFF
+query-cache-wlock-invalidate FALSE
+query-prealloc-size 24576
+range-alloc-block-size 4096
+read-binlog-speed-limit 0
+read-buffer-size 131072
+read-only FALSE
+read-rnd-buffer-size 262144
+relay-log (No default value)
+relay-log-index (No default value)
+relay-log-info-file relay-log.info
+relay-log-purge TRUE
+relay-log-recovery FALSE
+relay-log-space-limit 0
+replicate-annotate-row-events TRUE
+replicate-events-marked-for-skip REPLICATE
+replicate-same-server-id FALSE
+report-host (No default value)
+report-password (No default value)
+report-port 0
+report-user (No default value)
+rowid-merge-buff-size 8388608
+rpl-semi-sync-master-enabled FALSE
+rpl-semi-sync-master-timeout 10000
+rpl-semi-sync-master-trace-level 32
+rpl-semi-sync-master-wait-no-slave TRUE
+rpl-semi-sync-master-wait-point AFTER_COMMIT
+rpl-semi-sync-slave-delay-master FALSE
+rpl-semi-sync-slave-enabled FALSE
+rpl-semi-sync-slave-kill-conn-timeout 5
+rpl-semi-sync-slave-trace-level 32
+safe-user-create FALSE
+secure-auth TRUE
+secure-file-priv (No default value)
+server-id 1
+session-track-schema TRUE
+session-track-state-change FALSE
+session-track-system-variables autocommit,character_set_client,character_set_connection,character_set_results,time_zone
+session-track-transaction-info OFF
+show-slave-auth-info FALSE
+silent-startup FALSE
+skip-grant-tables TRUE
+skip-name-resolve FALSE
+skip-networking FALSE
+skip-show-database FALSE
+skip-slave-start FALSE
+slave-compressed-protocol FALSE
+slave-ddl-exec-mode IDEMPOTENT
+slave-domain-parallel-threads 0
+slave-exec-mode STRICT
+slave-max-allowed-packet 1073741824
+slave-net-timeout 60
+slave-parallel-max-queued 131072
+slave-parallel-mode conservative
+slave-parallel-threads 0
+slave-parallel-workers 0
+slave-run-triggers-for-rbr NO
+slave-skip-errors OFF
+slave-sql-verify-checksum TRUE
+slave-transaction-retries 10
+slave-transaction-retry-errors 1213,1205
+slave-transaction-retry-interval 0
+slave-type-conversions 
+slow-launch-time 2
+slow-query-log FALSE
+sort-buffer-size 2097152
+sql-mode STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
+stack-trace TRUE
+standard-compliant-cte TRUE
+stored-program-cache 256
+strict-password-validation TRUE
+symbolic-links FALSE
+sync-binlog 0
+sync-frm FALSE
+sync-master-info 10000
+sync-relay-log 10000
+sync-relay-log-info 10000
+sysdate-is-now FALSE
+system-versioning-alter-history ERROR
+table-cache 431
+table-definition-cache 400
+table-open-cache 431
+table-open-cache-instances 8
+tc-heuristic-recover OFF
+tcp-keepalive-interval 0
+tcp-keepalive-probes 0
+tcp-keepalive-time 0
+thread-cache-size 151
+thread-pool-idle-timeout 60
+thread-pool-max-threads 65536
+thread-pool-oversubscribe 3
+thread-pool-prio-kickup-timer 1000
+thread-pool-priority auto
+thread-pool-stall-limit 500
+thread-stack 299008
+time-format %H:%i:%s
+timed-mutexes FALSE
+tmp-disk-table-size 18446744073709551615
+tmp-memory-table-size 16777216
+tmp-table-size 16777216
+transaction-alloc-block-size 8192
+transaction-isolation REPEATABLE-READ
+transaction-prealloc-size 4096
+transaction-read-only FALSE
+updatable-views-with-limit YES
+use-stat-tables NEVER
+userstat FALSE
+verbose TRUE
+wait-timeout 28800
+
+To see what values a running MySQL server is using, type
+'mysqladmin variables' instead of 'mysqld --verbose --help'.