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

1 files changed, 0 insertions, 1687 deletions

diff --git a/mysql-test/r/mysqld--help.result b/mysql-test/r/mysqld--help.result
deleted file mode 100644
index ef6a49df08b..00000000000
--- a/mysql-test/r/mysqld--help.result
+++ /dev/null
@@ -1,1687 +0,0 @@
-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'.