mysqld --help --verbose

From wikieduonline
Jump to navigation Jump to search

/usr/sbin/mysqld --help --verbose
/usr/sbin/mysqld  Ver 10.5.15-MariaDB-0ubuntu0.21.10.1 for debian-linux-gnu on aarch64 (Ubuntu 21.10)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Starts the MariaDB database server.

Usage: /usr/sbin/mysqld [OPTIONS]

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
The following groups are read: mysqld server mysqld-10.5 mariadb mariadb-10.5 mariadbd mariadbd-10.5 client-server galera
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.
The following specify which files/extra groups are read (specified before remaining options):
--defaults-file=#         Only read default options from the given file #.
--defaults-extra-file=#   Read this file after the global files are read.
--defaults-group-suffix=# Additionally read default groups with # appended as a suffix.

  --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
  --alter-algorithm[=name]
                      Specify the alter table algorithm. One of: DEFAULT, COPY,
                      INPLACE, NOCOPY, INSTANT
  --analyze-sample-percentage=#
                      Percentage of rows from the table ANALYZE TABLE will
                      sample to collect table statistics. Set to 0 to let
                      MariaDB decide what percentage of rows to sample.
  -a, --ansi          Use ANSI SQL syntax instead of MySQL syntax. This mode
                      will also set transaction isolation level 'serializable'.
  --aria-block-size=# Block size to be used for Aria index pages.
  --aria-checkpoint-interval=#
                      Interval between tries to do an automatic checkpoints. In
                      seconds; 0 means 'no automatic checkpoints' which makes
                      sense only for testing.
  --aria-checkpoint-log-activity=#
                      Number of bytes that the transaction log has to grow
                      between checkpoints before a new checkpoint is written to
                      the log.
  --aria-encrypt-tables
                      Encrypt tables (only for tables with ROW_FORMAT=PAGE
                      (default) and not FIXED/DYNAMIC)
  --aria-force-start-after-recovery-failures=#
                      Number of consecutive log recovery failures after which
                      logs will be automatically deleted to cure the problem; 0
                      (the default) disables the feature.
  --aria-group-commit=name
                      Specifies Aria group commit mode. Possible values are
                      "none" (no group commit), "hard" (with waiting to actual
                      commit), "soft" (no wait for commit (DANGEROUS!!!))
  --aria-group-commit-interval=#
                      Interval between commits in microseconds (1/1000000 sec).
                      0 stands for no waiting for other threads to come and do
                      a commit in "hard" mode and no sync()/commit at all in
                      "soft" mode.  Option has only an effect if
                      aria_group_commit is used
  --aria-log-dir-path=name
                      Path to the directory where to store transactional log
  --aria-log-file-size=#
                      Limit for transaction log size
  --aria-log-purge-type=name
                      Specifies how Aria transactional log will be purged. One
                      of: immediate, external, at_flush
  --aria-max-sort-file-size=#
                      Don't use the fast sort index method to created index if
                      the temporary file would get bigger than this.
  --aria-page-checksum
                      Maintain page checksums (can be overridden per table with
                      PAGE_CHECKSUM clause in CREATE TABLE)
                      (Defaults to on; use --skip-aria-page-checksum to disable.)
  --aria-pagecache-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 the page cache.
  --aria-pagecache-buffer-size=#
                      The size of the buffer used for index blocks for Aria
                      tables. Increase this to get better index handling (for
                      all reads and multiple writes) to as much as you can
                      afford.
  --aria-pagecache-division-limit=#
                      The minimum percentage of warm blocks in key cache
  --aria-pagecache-file-hash-size=#
                      Number of hash buckets for open and changed files.  If
                      you have a lot of Aria files open you should increase
                      this for faster flush of changes. A good value is
                      probably 1/10 of number of possible open Aria files.
  --aria-recover-options[=name]
                      Specifies how corrupted tables should be automatically
                      repaired. Any combination of: NORMAL, BACKUP, FORCE,
                      QUICK, OFF
  --aria-repair-threads=#
                      Number of threads to use when repairing Aria tables. The
                      value of 1 disables parallel repair.
  --aria-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.
  --aria-stats-method=name
                      Specifies how Aria index statistics collection code
                      should treat NULLs. One of: nulls_unequal, nulls_equal,
                      nulls_ignored
  --aria-sync-log-dir=name
                      Controls syncing directory after log file growth and new
                      file creation. One of: NEVER, NEWFILE, ALWAYS
  --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.
  --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-row-metadata=name
                      Controls whether metadata is logged using FULL , MINIMAL
                      format and NO_LOG.FULL causes all metadata to be logged;
                      MINIMAL means that only metadata actually required by
                      slave is logged; NO_LOG NO metadata will be
                      logged.Default: NO_LOG.
  --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
  --connect-timeout=# The number of seconds the mysqld server is waiting for a
                      connect packet before responding with 'Bad handshake'
  --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)
  -#, --debug[=name]  Built in DBUG debugger. Disabled in this build.
  --debug-abort-slave-event-count=#
                      Option used by mysql-test for debugging and testing of
                      replication.
  --debug-disconnect-slave-event-count=#
                      Option used by mysql-test for debugging and testing of
                      replication.
  -T, --debug-exit-info[=#]
                      Used for debugging. Use at your own risk.
  --debug-gdb         Set up signals usable for debugging.
  --debug-max-binlog-dump-events=#
                      Option used by mysql-test for debugging and testing of
                      replication.
  --debug-no-sync     Disables system sync calls. Only for running tests or
                      debugging!
  --debug-no-thread-alarm
                      Disable system thread alarm calls. Disabling it may be
                      useful in debugging or testing, never do it in production
  --debug-sporadic-binlog-dump-fail
                      Option used by mysql-test for debugging and testing of
                      replication.
  --default-password-lifetime=#
                      This defines the global password expiration policy. 0
                      means automatic password expiration is disabled. If the
                      value is a positive integer N, the passwords must be
                      changed every N days. This behavior can be overridden
                      using the password expiration options in ALTER USER.
  --default-regex-flags=name
                      Default flags for the regex library. Any combination of:
                      DOTALL, DUPNAMES, EXTENDED, EXTENDED_MORE, 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
  --des-key-file=name Load keys for des_encrypt() and des_encrypt from given
                      file.
  --disconnect-on-expired-password
                      This variable controls how the server handles clients
                      that are not aware of the sandbox mode. If enabled, the
                      server disconnects the client, otherwise the server puts
                      the client in a sandbox mode.
  --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
  --eq-range-index-dive-limit=#
                      The optimizer will use existing index statistics instead
                      of doing index dives for equality ranges if the number of
                      equality ranges for the index is larger than or equal to
                      this number. If set to 0, index dives are always used.
  --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
  --feedback[=name]   Enable or disable FEEDBACK plugin. One of: ON, OFF, FORCE
                      (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --feedback-http-proxy=name
                      Proxy server host:port.
  --feedback-send-retry-wait=#
                      Wait this many seconds before retrying a failed send.
  --feedback-send-timeout=#
                      Timeout (in seconds) for the sending the report.
  --feedback-url=name Space separated URLs to send the feedback report to.
  --feedback-user-info=name
                      User specified string that will be included in the
                      feedback report.
  --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
                      --debug-gdb instead.
  --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-cleanup-batch-size=#
                      Normally does not need tuning. How many old rows must
                      accumulate in the mysql.gtid_slave_pos table before a
                      background job will be run to delete them. Can be
                      increased to reduce number of commits if using many
                      different engines with --gtid_pos_auto_engines, or to
                      reduce CPU overhead if using a huge number of different
                      gtid_domain_ids. Can be decreased to reduce number of old
                      rows in the table.
  --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.
  --in-predicate-conversion-threshold=#
                      The minimum number of scalar elements in the value list
                      of IN predicate that triggers its conversion to IN
                      subquery. Set to 0 to disable the conversion.
  --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
  --innodb[=name]     Enable or disable InnoDB plugin. One of: ON, OFF, FORCE
                      (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-adaptive-flushing
                      Attempt flushing dirty pages to avoid IO bursts at
                      checkpoints.
                      (Defaults to on; use --skip-innodb-adaptive-flushing to disable.)
  --innodb-adaptive-flushing-lwm=#
                      Percentage of log capacity below which no adaptive
                      flushing happens.
  --innodb-adaptive-hash-index
                      Enable InnoDB adaptive hash index (disabled by default).
  --innodb-adaptive-hash-index-parts[=#]
                      Number of InnoDB Adaptive Hash Index Partitions (default
                      8)
  --innodb-adaptive-max-sleep-delay=#
                      Deprecated parameter with no effect.
  --innodb-autoextend-increment=#
                      Data file autoextend increment in megabytes
  --innodb-autoinc-lock-mode=#
                      The AUTOINC lock modes supported by InnoDB: 0 => Old
                      style AUTOINC locking (for backward compatibility); 1 =>
                      New style AUTOINC locking; 2 => No AUTOINC locking
                      (unsafe for SBR)
  --innodb-background-scrub-data-check-interval=#
                      Deprecated parameter with no effect.
  --innodb-background-scrub-data-compressed
                      Deprecated parameter with no effect.
  --innodb-background-scrub-data-interval=#
                      Deprecated parameter with no effect.
  --innodb-background-scrub-data-uncompressed
                      Deprecated parameter with no effect.
  --innodb-buf-dump-status-frequency=#
                      A number between [0, 100] that tells how oftern buffer
                      pool dump status in percentages should be printed. E.g.
                      10 means that buffer pool dump status is printed when
                      every 10% of number of buffer pool pages are dumped.
                      Default is 0 (only start and end status is printed).
  --innodb-buffer-page[=name]
                      Enable or disable INNODB_BUFFER_PAGE plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-buffer-page-lru[=name]
                      Enable or disable INNODB_BUFFER_PAGE_LRU plugin. One of:
                      ON, OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-buffer-pool-chunk-size=#
                      Size of a single memory chunk for resizing buffer pool.
                      Online buffer pool resizing happens at this granularity.
                      0 means disable resizing buffer pool.
  --innodb-buffer-pool-dump-at-shutdown
                      Dump the buffer pool into a file named
                      @@innodb_buffer_pool_filename
                      (Defaults to on; use --skip-innodb-buffer-pool-dump-at-shutdown to disable.)
  --innodb-buffer-pool-dump-now
                      Trigger an immediate dump of the buffer pool into a file
                      named @@innodb_buffer_pool_filename
  --innodb-buffer-pool-dump-pct=#
                      Dump only the hottest N% of each buffer pool, defaults to
                      25
  --innodb-buffer-pool-filename=name
                      Filename to/from which to dump/load the InnoDB buffer
                      pool
  --innodb-buffer-pool-instances=#
                      Deprecated parameter with no effect.
  --innodb-buffer-pool-load-abort
                      Abort a currently running load of the buffer pool
  --innodb-buffer-pool-load-at-startup
                      Load the buffer pool from a file named
                      @@innodb_buffer_pool_filename
                      (Defaults to on; use --skip-innodb-buffer-pool-load-at-startup to disable.)
  --innodb-buffer-pool-load-now
                      Trigger an immediate load of the buffer pool from a file
                      named @@innodb_buffer_pool_filename
  --innodb-buffer-pool-size=#
                      The size of the memory buffer InnoDB uses to cache data
                      and indexes of its tables.
  --innodb-buffer-pool-stats[=name]
                      Enable or disable INNODB_BUFFER_POOL_STATS plugin. One
                      of: ON, OFF, FORCE (don't start if the plugin fails to
                      load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin
                      can not be uninstalled).
  --innodb-change-buffer-max-size=#
                      Maximum on-disk size of change buffer in terms of
                      percentage of the buffer pool.
  --innodb-change-buffering=name
                      Buffer changes to secondary indexes.. One of: none,
                      inserts, deletes, changes, purges, all
  --innodb-checksum-algorithm=name
                      The algorithm InnoDB uses for page checksumming. Possible
                      values are FULL_CRC32 for new files, always use CRC-32C;
                      for old, see CRC32 below; STRICT_FULL_CRC32 for new
                      files, always use CRC-32C; for old, see STRICT_CRC32
                      below; CRC32 write crc32, allow any of the other
                      checksums to match when reading; STRICT_CRC32 write
                      crc32, do not allow other algorithms to match when
                      reading; INNODB write a software calculated checksum,
                      allow any other checksums to match when reading;
                      STRICT_INNODB write a software calculated checksum, do
                      not allow other algorithms to match when reading; NONE
                      write a constant magic number, do not do any checksum
                      verification when reading (same as innodb_checksums=OFF);
                      STRICT_NONE write a constant magic number, do not allow
                      values other than that magic number when reading; Files
                      updated when this option is set to crc32 or strict_crc32
                      will not be readable by MariaDB versions older than
                      10.0.4; new files created with full_crc32 are readable by
                      MariaDB 10.4.3+
  --innodb-cmp[=name] Enable or disable INNODB_CMP plugin. One of: ON, OFF,
                      FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-cmp-per-index[=name]
                      Enable or disable INNODB_CMP_PER_INDEX plugin. One of:
                      ON, OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-cmp-per-index-enabled
                      Enable INFORMATION_SCHEMA.innodb_cmp_per_index, may have
                      negative impact on performance (off by default)
  --innodb-cmp-per-index-reset[=name]
                      Enable or disable INNODB_CMP_PER_INDEX_RESET plugin. One
                      of: ON, OFF, FORCE (don't start if the plugin fails to
                      load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin
                      can not be uninstalled).
  --innodb-cmp-reset[=name]
                      Enable or disable INNODB_CMP_RESET plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-cmpmem[=name]
                      Enable or disable INNODB_CMPMEM plugin. One of: ON, OFF,
                      FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-cmpmem-reset[=name]
                      Enable or disable INNODB_CMPMEM_RESET plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-commit-concurrency=#
                      Deprecated parameter with no effect.
  --innodb-compression-algorithm[=name]
                      Compression algorithm used on page compression. One of:
                      none, zlib, lz4, lzo, lzma, bzip2, or snappy
  --innodb-compression-default
                      Is compression the default for new tables
  --innodb-compression-failure-threshold-pct[=#]
                      If the compression failure rate of a table is greater
                      than this number more padding is added to the pages to
                      reduce the failures. A value of zero implies no padding
  --innodb-compression-level=#
                      Compression level used for zlib compression.  0 is no
                      compression, 1 is fastest, 9 is best compression and
                      default is 6.
  --innodb-compression-pad-pct-max[=#]
                      Percentage of empty space on a data page that can be
                      reserved to make the page compressible.
  --innodb-concurrency-tickets=#
                      Deprecated parameter with no effect.
  --innodb-data-file-path=name
                      Path to individual files and their sizes.
  --innodb-data-home-dir=name
                      The common part for InnoDB table spaces.
  --innodb-deadlock-detect
                      Enable/disable InnoDB deadlock detector (default ON). if
                      set to OFF, deadlock detection is skipped, and we rely on
                      innodb_lock_wait_timeout in case of deadlock.
                      (Defaults to on; use --skip-innodb-deadlock-detect to disable.)
  --innodb-default-encryption-key-id=#
                      Default encryption key id used for table encryption.
  --innodb-default-row-format=name
                      The default ROW FORMAT for all innodb tables created
                      without explicit ROW_FORMAT. Possible values are
                      REDUNDANT, COMPACT, and DYNAMIC. The ROW_FORMAT value
                      COMPRESSED is not allowed. One of: redundant, compact,
                      dynamic
  --innodb-defragment Enable/disable InnoDB defragmentation (default FALSE).
                      When set to FALSE, all existing defragmentation will be
                      paused. And new defragmentation command will fail.Paused
                      defragmentation commands will resume when this variable
                      is set to true again.
  --innodb-defragment-fill-factor=#
                      A number between [0.7, 1] that tells defragmentation how
                      full it should fill a page. Default is 0.9. Number below
                      0.7 won't make much sense.This variable, together with
                      innodb_defragment_fill_factor_n_recs, is introduced so
                      defragmentation won't pack the page too full and cause
                      page split on the next insert on every page. The variable
                      indicating more defragmentation gain is the one
                      effective.
  --innodb-defragment-fill-factor-n-recs=#
                      How many records of space defragmentation should leave on
                      the page. This variable, together with
                      innodb_defragment_fill_factor, is introduced so
                      defragmentation won't pack the page too full and cause
                      page split on the next insert on every page. The variable
                      indicating more defragmentation gain is the one
                      effective.
  --innodb-defragment-frequency=#
                      Do not defragment a single index more than this number of
                      time per second.This controls the number of time
                      defragmentation thread can request X_LOCK on an index.
                      Defragmentation thread will check whether
                      1/defragment_frequency (s) has passed since it worked on
                      this index last time, and put the index back to the queue
                      if not enough time has passed. The actual frequency can
                      only be lower than this given number.
  --innodb-defragment-n-pages=#
                      Number of pages considered at once when merging multiple
                      pages to defragment
  --innodb-defragment-stats-accuracy=#
                      How many defragment stats changes there are before the
                      stats are written to persistent storage. Set to 0 meaning
                      disable defragment stats tracking.
  --innodb-disable-sort-file-cache
                      Whether to disable OS system file cache for sort I/O
  --innodb-doublewrite
                      Enable InnoDB doublewrite buffer (enabled by default).
                      Disable with --skip-innodb-doublewrite.
                      (Defaults to on; use --skip-innodb-doublewrite to disable.)
  --innodb-encrypt-log
                      Enable redo log encryption
  --innodb-encrypt-tables[=name]
                      Enable encryption for tables. Don't forget to enable
                      --innodb-encrypt-log too. One of: OFF, ON, FORCE
  --innodb-encrypt-temporary-tables
                      Enrypt the temporary table data.
  --innodb-encryption-rotate-key-age=#
                      Key rotation - re-encrypt in background all pages that
                      were encrypted with a key that many (or more) versions
                      behind. Value 0 indicates that key rotation is disabled.
  --innodb-encryption-rotation-iops=#
                      Use this many iops for background key rotation
  --innodb-encryption-threads=#
                      Number of threads performing background key rotation
  --innodb-fast-shutdown[=#]
                      Speeds up the shutdown process of the InnoDB storage
                      engine. Possible values are 0, 1 (faster), 2
                      (crash-like), 3 (fastest clean).
  --innodb-fatal-semaphore-wait-threshold=#
                      Maximum number of seconds that semaphore times out in
                      InnoDB.
  --innodb-file-format=name
                      Deprecated parameter with no effect.
  --innodb-file-per-table
                      Stores each InnoDB table to an .ibd file in the database
                      dir.
                      (Defaults to on; use --skip-innodb-file-per-table to disable.)
  --innodb-fill-factor=#
                      Percentage of B-tree page filled during bulk insert
  --innodb-flush-log-at-timeout[=#]
                      Write and flush logs every (n) second.
  --innodb-flush-log-at-trx-commit[=#]
                      Controls the durability/speed trade-off for commits. Set
                      to 0 (write and flush redo log to disk only once per
                      second), 1 (flush to disk at each commit), 2 (write to
                      log at commit but flush to disk only once per second) or
                      3 (flush to disk at prepare and at commit, slower and
                      usually redundant). 1 and 3 guarantees that after a
                      crash, committed transactions will not be lost and will
                      be consistent with the binlog and other transactional
                      engines. 2 can get inconsistent and lose transactions if
                      there is a power failure or kernel crash but not if
                      mysqld crashes. 0 has no guarantees in case of crash. 0
                      and 2 can be faster than 1 or 3.
  --innodb-flush-method=name
                      With which method to flush data.. One of: fsync, O_DSYNC,
                      littlesync, nosync, O_DIRECT, O_DIRECT_NO_FSYNC
  --innodb-flush-neighbors[=#]
                      Set to 0 (don't flush neighbors from buffer pool), 1
                      (flush contiguous neighbors from buffer pool) or 2 (flush
                      neighbors from buffer pool), when flushing a block
  --innodb-flush-sync Allow IO bursts at the checkpoints ignoring io_capacity
                      setting.
                      (Defaults to on; use --skip-innodb-flush-sync to disable.)
  --innodb-flushing-avg-loops=#
                      Number of iterations over which the background flushing
                      is averaged.
  --innodb-force-load-corrupted
                      Force InnoDB to load metadata of corrupted table.
  --innodb-force-primary-key
                      Do not allow creating a table without primary key (off by
                      default)
  --innodb-force-recovery=#
                      Helps to save your data in case the disk image of the
                      database becomes corrupt. Value 5 can return bogus data,
                      and 6 can permanently corrupt data.
  --innodb-ft-aux-table=name
                      FTS internal auxiliary table to be checked
  --innodb-ft-being-deleted[=name]
                      Enable or disable INNODB_FT_BEING_DELETED plugin. One of:
                      ON, OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-ft-cache-size=#
                      InnoDB Fulltext search cache size in bytes
  --innodb-ft-config[=name]
                      Enable or disable INNODB_FT_CONFIG plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-ft-default-stopword[=name]
                      Enable or disable INNODB_FT_DEFAULT_STOPWORD plugin. One
                      of: ON, OFF, FORCE (don't start if the plugin fails to
                      load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin
                      can not be uninstalled).
  --innodb-ft-deleted[=name]
                      Enable or disable INNODB_FT_DELETED plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-ft-enable-diag-print
                      Whether to enable additional FTS diagnostic printout
  --innodb-ft-enable-stopword
                      Create FTS index with stopword.
                      (Defaults to on; use --skip-innodb-ft-enable-stopword to disable.)
  --innodb-ft-index-cache[=name]
                      Enable or disable INNODB_FT_INDEX_CACHE plugin. One of:
                      ON, OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-ft-index-table[=name]
                      Enable or disable INNODB_FT_INDEX_TABLE plugin. One of:
                      ON, OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-ft-max-token-size=#
                      InnoDB Fulltext search maximum token size in characters
  --innodb-ft-min-token-size=#
                      InnoDB Fulltext search minimum token size in characters
  --innodb-ft-num-word-optimize[=#]
                      InnoDB Fulltext search number of words to optimize for
                      each optimize table call
  --innodb-ft-result-cache-limit=#
                      InnoDB Fulltext search query result cache limit in bytes
  --innodb-ft-server-stopword-table[=name]
                      The user supplied stopword table name.
  --innodb-ft-sort-pll-degree=#
                      InnoDB Fulltext search parallel sort degree, will round
                      up to nearest power of 2 number
  --innodb-ft-total-cache-size=#
                      Total memory allocated for InnoDB Fulltext Search cache
  --innodb-ft-user-stopword-table[=name]
                      User supplied stopword table name, effective in the
                      session level.
  --innodb-immediate-scrub-data-uncompressed
                      Enable scrubbing of data
  --innodb-instant-alter-column-allowed=name
                      File format constraint for ALTER TABLE. One of: never,
                      add_last, add_drop_reorder
  --innodb-io-capacity=#
                      Number of IOPs the server can do. Tunes the background IO
                      rate
  --innodb-io-capacity-max=#
                      Limit to which innodb_io_capacity can be inflated.
  --innodb-large-prefix=name
                      Deprecated parameter with no effect.
  --innodb-lock-schedule-algorithm=name
                      The algorithm Innodb uses for deciding which locks to
                      grant next when a lock is released. Possible values are
                      FCFS grant the locks in First-Come-First-Served order;
                      VATS use the Variance-Aware-Transaction-Scheduling
                      algorithm, which uses an Eldest-Transaction-First
                      heuristic.. One of: fcfs, vats
  --innodb-lock-wait-timeout=#
                      Timeout in seconds an InnoDB transaction may wait for a
                      lock before being rolled back. Values above 100000000
                      disable the timeout.
  --innodb-lock-waits[=name]
                      Enable or disable INNODB_LOCK_WAITS plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-locks[=name]
                      Enable or disable INNODB_LOCKS plugin. One of: ON, OFF,
                      FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-log-buffer-size=#
                      The size of the buffer which InnoDB uses to write log to
                      the log files on disk.
  --innodb-log-checksums
                      Deprecated parameter with no effect.
                      (Defaults to on; use --skip-innodb-log-checksums to disable.)
  --innodb-log-compressed-pages
                      Deprecated parameter with no effect.
                      (Defaults to on; use --skip-innodb-log-compressed-pages to disable.)
  --innodb-log-file-size=#
                      Size of each log file in a log group.
  --innodb-log-files-in-group=#
                      Deprecated parameter with no effect.
  --innodb-log-group-home-dir=name
                      Path to InnoDB log files.
  --innodb-log-optimize-ddl
                      Deprecated parameter with no effect.
  --innodb-log-write-ahead-size=#
                      Redo log write ahead unit size to avoid read-on-write, it
                      should match the OS cache block IO size
  --innodb-lru-flush-size=#
                      How many pages to flush on LRU eviction
  --innodb-lru-scan-depth=#
                      How deep to scan LRU to keep it clean
  --innodb-max-dirty-pages-pct=#
                      Percentage of dirty pages allowed in bufferpool.
  --innodb-max-dirty-pages-pct-lwm=#
                      Percentage of dirty pages at which flushing kicks in. The
                      value 0 (default) means 'refer to
                      innodb_max_dirty_pages_pct'.
  --innodb-max-purge-lag=#
                      Desired maximum length of the purge queue (0 = no limit)
  --innodb-max-purge-lag-delay=#
                      Maximum delay of user threads in micro-seconds
  --innodb-max-purge-lag-wait=#
                      Wait until History list length is below the specified
                      limit
  --innodb-max-undo-log-size[=#]
                      Desired maximum UNDO tablespace size in bytes
  --innodb-metrics[=name]
                      Enable or disable INNODB_METRICS plugin. One of: ON, OFF,
                      FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-monitor-disable=name
                      Turn off a monitor counter
  --innodb-monitor-enable=name
                      Turn on a monitor counter
  --innodb-monitor-reset=name
                      Reset a monitor counter
  --innodb-monitor-reset-all=name
                      Reset all values for a monitor counter
  --innodb-mutexes[=name]
                      Enable or disable INNODB_MUTEXES plugin. One of: ON, OFF,
                      FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-old-blocks-pct=#
                      Percentage of the buffer pool to reserve for 'old'
                      blocks.
  --innodb-old-blocks-time=#
                      Move blocks to the 'new' end of the buffer pool if the
                      first access was at least this many milliseconds ago. The
                      timeout is disabled if 0.
  --innodb-online-alter-log-max-size=#
                      Maximum modification log file size for online index
                      creation
  --innodb-open-files=#
                      How many files at the maximum InnoDB keeps open at the
                      same time.
  --innodb-optimize-fulltext-only
                      Only optimize the Fulltext index of the table
  --innodb-page-cleaners=#
                      Deprecated parameter with no effect.
  --innodb-page-size[=#]
                      Page size to use for all InnoDB tablespaces.
  --innodb-prefix-index-cluster-optimization
                      Enable prefix optimization to sometimes avoid cluster
                      index lookups.
  --innodb-print-all-deadlocks
                      Print all deadlocks to MariaDB error log (off by default)
  --innodb-purge-batch-size[=#]
                      Number of UNDO log pages to purge in one batch from the
                      history list.
  --innodb-purge-rseg-truncate-frequency[=#]
                      Dictates rate at which UNDO records are purged. Value N
                      means purge rollback segment(s) on every Nth iteration of
                      purge invocation
  --innodb-purge-threads[=#]
                      Number of tasks for purging transaction history
  --innodb-random-read-ahead
                      Whether to use read ahead for random access within an
                      extent.
  --innodb-read-ahead-threshold=#
                      Number of pages that must be accessed sequentially for
                      InnoDB to trigger a readahead.
  --innodb-read-io-threads=#
                      Number of background read I/O threads in InnoDB.
  --innodb-read-only  Start InnoDB in read only mode (off by default)
  --innodb-replication-delay=#
                      Deprecated parameter with no effect.
  --innodb-rollback-on-timeout
                      Roll back the complete transaction on lock wait timeout,
                      for 4.x compatibility (disabled by default)
  --innodb-scrub-log  Deprecated parameter with no effect.
  --innodb-scrub-log-speed[=#]
                      Deprecated parameter with no effect.
  --innodb-sort-buffer-size=#
                      Memory buffer size for index creation
  --innodb-spin-wait-delay[=#]
                      Maximum delay between polling for a spin lock (4 by
                      default)
  --innodb-stats-auto-recalc
                      InnoDB automatic recalculation of persistent statistics
                      enabled for all tables unless overridden at table level
                      (automatic recalculation is only done when InnoDB decides
                      that the table has changed too much and needs a new
                      statistics)
                      (Defaults to on; use --skip-innodb-stats-auto-recalc to disable.)
  --innodb-stats-include-delete-marked
                      Include delete marked records when calculating persistent
                      statistics
  --innodb-stats-method=name
                      Specifies how InnoDB index statistics collection code
                      should treat NULLs. Possible values are NULLS_EQUAL
                      (default), NULLS_UNEQUAL and NULLS_IGNORED. One of:
                      nulls_equal, nulls_unequal, nulls_ignored
  --innodb-stats-modified-counter=#
                      The number of rows modified before we calculate new
                      statistics (default 0 = current limits)
  --innodb-stats-on-metadata
                      Enable statistics gathering for metadata commands such as
                      SHOW TABLE STATUS for tables that use transient
                      statistics (off by default)
  --innodb-stats-persistent
                      InnoDB persistent statistics enabled for all tables
                      unless overridden at table level
                      (Defaults to on; use --skip-innodb-stats-persistent to disable.)
  --innodb-stats-persistent-sample-pages=#
                      The number of leaf index pages to sample when calculating
                      persistent statistics (by ANALYZE, default 20)
  --innodb-stats-traditional
                      Enable traditional statistic calculation based on number
                      of configured pages (default true)
                      (Defaults to on; use --skip-innodb-stats-traditional to disable.)
  --innodb-stats-transient-sample-pages=#
                      The number of leaf index pages to sample when calculating
                      transient statistics (if persistent statistics are not
                      used, default 8)
  --innodb-status-file
                      Enable SHOW ENGINE INNODB STATUS output in the
                      innodb_status.<pid> file
  --innodb-status-output
                      Enable InnoDB monitor output to the error log.
  --innodb-status-output-locks
                      Enable InnoDB lock monitor output to the error log.
                      Requires innodb_status_output=ON.
  --innodb-strict-mode
                      Use strict mode when evaluating create options.
                      (Defaults to on; use --skip-innodb-strict-mode to disable.)
  --innodb-sync-array-size[=#]
                      Size of the mutex/lock wait array.
  --innodb-sync-spin-loops=#
                      Count of spin-loop rounds in InnoDB mutexes (30 by
                      default)
  --innodb-sys-columns[=name]
                      Enable or disable INNODB_SYS_COLUMNS plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-sys-datafiles[=name]
                      Enable or disable INNODB_SYS_DATAFILES plugin. One of:
                      ON, OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-sys-fields[=name]
                      Enable or disable INNODB_SYS_FIELDS plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-sys-foreign[=name]
                      Enable or disable INNODB_SYS_FOREIGN plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-sys-foreign-cols[=name]
                      Enable or disable INNODB_SYS_FOREIGN_COLS plugin. One of:
                      ON, OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-sys-indexes[=name]
                      Enable or disable INNODB_SYS_INDEXES plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-sys-semaphore-waits[=name]
                      Enable or disable INNODB_SYS_SEMAPHORE_WAITS plugin. One
                      of: ON, OFF, FORCE (don't start if the plugin fails to
                      load), FORCE_PLUS_PERMANENT (like FORCE, but the plugin
                      can not be uninstalled).
  --innodb-sys-tables[=name]
                      Enable or disable INNODB_SYS_TABLES plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-sys-tablespaces[=name]
                      Enable or disable INNODB_SYS_TABLESPACES plugin. One of:
                      ON, OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-sys-tablestats[=name]
                      Enable or disable INNODB_SYS_TABLESTATS plugin. One of:
                      ON, OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-sys-virtual[=name]
                      Enable or disable INNODB_SYS_VIRTUAL plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-table-locks
                      Enable InnoDB locking in LOCK TABLES
                      (Defaults to on; use --skip-innodb-table-locks to disable.)
  --innodb-tablespaces-encryption[=name]
                      Enable or disable INNODB_TABLESPACES_ENCRYPTION plugin.
                      One of: ON, OFF, FORCE (don't start if the plugin fails
                      to load), FORCE_PLUS_PERMANENT (like FORCE, but the
                      plugin can not be uninstalled).
  --innodb-temp-data-file-path=name
                      Path to files and their sizes making temp-tablespace.
  --innodb-thread-concurrency=#
                      Deprecated parameter with no effect.
  --innodb-thread-sleep-delay=#
                      Deprecated parameter with no effect.
  --innodb-tmpdir[=name]
                      Directory for temporary non-tablespace files.
  --innodb-trx[=name] Enable or disable INNODB_TRX plugin. One of: ON, OFF,
                      FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --innodb-undo-directory=name
                      Directory where undo tablespace files live, this path can
                      be absolute.
  --innodb-undo-log-truncate
                      Enable or Disable Truncate of UNDO tablespace.
  --innodb-undo-logs[=#]
                      Deprecated parameter with no effect.
  --innodb-undo-tablespaces=#
                      Number of undo tablespaces to use.
  --innodb-use-atomic-writes
                      Enable atomic writes, instead of using the doublewrite
                      buffer, for files on devices that supports atomic writes.
                      This option only works on Linux with either FusionIO
                      cards using the directFS filesystem or with Shannon cards
                      using any file system.
                      (Defaults to on; use --skip-innodb-use-atomic-writes to disable.)
  --innodb-use-native-aio
                      Use native AIO if supported on this platform.
                      (Defaults to on; use --skip-innodb-use-native-aio to disable.)
  --innodb-write-io-threads=#
                      Number of background write I/O threads in InnoDB.
  --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-password-errors=#
                      If there is more than this number of failed connect
                      attempts due to invalid password, user will be blocked
                      from further connections until FLUSH_PRIVILEGES.
  --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-rowid-filter-size=#
                      The maximum size of the container of a rowid filter
  --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
  --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[=name]
                      Alias for alter_algorithm. Deprecated. Use
                      --alter-algorithm instead.. One of: DEFAULT, COPY,
                      INPLACE, NOCOPY, INSTANT
  --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-max-sel-arg-weight=#
                      The maximum weight of the SEL_ARG graph. Set to 0 for no
                      limit
  --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,
                      condition_pushdown_for_subquery, rowid_filter,
                      condition_pushdown_from_having, not_null_range_scan
  --optimizer-trace=name
                      Controls tracing of the Optimizer:
                      optimizer_trace=option=val[,option=val...], where option
                      is one of {enabled} and val is one of {on, off, default}
  --optimizer-trace-max-mem-size=#
                      Maximum allowed size of an optimizer trace
  --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
  --partition[=name]  Enable or disable partition plugin. One of: ON, OFF,
                      FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --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.
  --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-transactions-current
                      Default startup value for the events_transactions_current
                      consumer.
  --performance-schema-consumer-events-transactions-history
                      Default startup value for the events_transactions_history
                      consumer.
  --performance-schema-consumer-events-transactions-history-long
                      Default startup value for the
                      events_transactions_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-transactions-history-long-size=#
                      Number of rows in EVENTS_TRANSACTIONS_HISTORY_LONG. Use 0
                      to disable, -1 for automated sizing.
  --performance-schema-events-transactions-history-size=#
                      Number of rows per thread in EVENTS_TRANSACTIONS_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-index-stat=#
                      Maximum number of index statistics for instrumented
                      tables. Use 0 to disable, -1 for automated scaling.
  --performance-schema-max-memory-classes=#
                      Maximum number of memory pool instruments.
  --performance-schema-max-metadata-locks=#
                      Maximum number of metadata locks. Use 0 to disable, -1
                      for automated scaling.
  --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-prepared-statements-instances=#
                      Maximum number of instrumented prepared statements. Use 0
                      to disable, -1 for automated scaling.
  --performance-schema-max-program-instances=#
                      Maximum number of instrumented programs. Use 0 to
                      disable, -1 for automated scaling.
  --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-sql-text-length=#
                      Maximum length of displayed sql text.
  --performance-schema-max-stage-classes=#
                      Maximum number of stage instruments.
  --performance-schema-max-statement-classes=#
                      Maximum number of statement instruments.
  --performance-schema-max-statement-stack=#
                      Number of rows per thread in EVENTS_STATEMENTS_CURRENT.
  --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-table-lock-stat=#
                      Maximum number of lock statistics for instrumented
                      tables. Use 0 to disable, -1 for automated scaling.
  --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
  --require-secure-transport
                      When this option is enabled, connections attempted using
                      insecure transport will be rejected. Secure transports
                      are SSL/TLS, Unix sockets or named pipes.
  --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
  --secure-timestamp=name
                      Restricts direct setting of a session timestamp. Possible
                      levels are: YES - timestamp cannot deviate from the
                      system clock, REPLICATION - replication thread can adjust
                      timestamp to match the master's, SUPER - a user with this
                      privilege and a replication thread can adjust timestamp,
                      NO - historical behavior, anyone can modify session
                      timestamp
  --sequence[=name]   Enable or disable SEQUENCE plugin. One of: ON, OFF, FORCE
                      (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --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 with the 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-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, LOGGING and ENFORCE. 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. ENFORCE means that
                      triggers will always be run on the slave, even if there
                      are triggers on the master. ENFORCE implies LOGGING.
  --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 error, elapsed lock wait timeout,
                      net read error, net read timeout, net write error, net
                      write timeout, connect error and 2 types of lost
                      connection error 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,
                      TIME_ROUND_FRACTIONAL
  --sql-safe-updates  If set to 1, UPDATEs and DELETEs need either a key in the
                      WHERE clause, or a LIMIT clause, or else they will
                      aborted. Prevents the common mistake of accidentally
                      deleting or updating every row in a table.
  --ssl               Enable SSL for connection (automatically enabled if an
                      ssl option is used).
  --ssl-ca=name       CA file in PEM format (check OpenSSL docs, implies --ssl)
  --ssl-capath=name   CA directory (check OpenSSL docs, implies --ssl)
  --ssl-cert=name     X509 cert in PEM format (implies --ssl)
  --ssl-cipher=name   SSL cipher to use (implies --ssl)
  --ssl-crl=name      CRL file in PEM format (check OpenSSL docs, implies
                      --ssl)
  --ssl-crlpath=name  CRL directory (check OpenSSL docs, implies --ssl)
  --ssl-key=name      X509 key in PEM format (implies --ssl)
  --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.
                      (Defaults to on; use --skip-symbolic-links to disable.)
  --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 seconds, 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)
  --tcp-nodelay       Set option TCP_NODELAY (disable Nagle's algorithm) on
                      socket
                      (Defaults to on; use --skip-tcp-nodelay to disable.)
  --temp-pool         Using this option will cause most temporary files created
                      to use a small set of names, rather than a unique name
                      for each new file. Deprecated.
  --thread-cache-size=#
                      How many threads we should keep in a cache for reuse.
                      These are freed after 5 minutes of idle time
  --thread-handling=name
                      Define threads usage for handling queries. One of:
                      one-thread-per-connection, no-threads, pool-of-threads
  --thread-pool-dedicated-listener
                      If set to 1,listener thread will not pick up queries
  --thread-pool-exact-stats
                      If set to 1, provides better statistics in
                      information_schema threadpool tables
  --thread-pool-groups[=name]
                      Enable or disable THREAD_POOL_GROUPS plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --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-queues[=name]
                      Enable or disable THREAD_POOL_QUEUES plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --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-pool-stats[=name]
                      Enable or disable THREAD_POOL_STATS plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --thread-pool-waits[=name]
                      Enable or disable THREAD_POOL_WAITS plugin. One of: ON,
                      OFF, FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --thread-stack=#    The stack size for each thread
  --time-format=name  The TIME format (ignored)
  --tls-version=name  TLS protocol version for secure connections.. Any
                      combination of: TLSv1.0, TLSv1.1, TLSv1.2, TLSv1.3
  --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.
  --unix-socket[=name]
                      Enable or disable unix_socket plugin. One of: ON, OFF,
                      FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --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,
                      COMPLEMENTARY_FOR_QUERIES, PREFERABLY_FOR_QUERIES
  -u, --user=name     Run mysqld daemon as user.
  --user-variables[=name]
                      Enable or disable user_variables plugin. One of: ON, OFF,
                      FORCE (don't start if the plugin fails to load),
                      FORCE_PLUS_PERMANENT (like FORCE, but the plugin can not
                      be uninstalled).
  --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
  --wsrep-OSU-method[=name]
                      Method for Online Schema Upgrade. One of: TOI, RSU
  --wsrep-SR-store=name
                      Storage for streaming replication fragments. One of: none,
                      table
  --wsrep-auto-increment-control
                      To automatically control the assignment of autoincrement
                      variables
                      (Defaults to on; use --skip-wsrep-auto-increment-control to disable.)
  --wsrep-causal-reads
                      Setting this variable is equivalent to setting
                      wsrep_sync_wait READ flag
  --wsrep-certification-rules=name
                      Certification rules to use in the cluster. Possible
                      values are: "strict": stricter rules that could result in
                      more certification failures. "optimized": relaxed rules
                      that allow more concurrency and cause less certification
                      failures.
  --wsrep-certify-nonPK
                      Certify tables with no primary key
                      (Defaults to on; use --skip-wsrep-certify-nonPK to disable.)
  --wsrep-cluster-address=name
                      Address to initially connect to cluster
  --wsrep-cluster-name=name
                      Name for the cluster
  --wsrep-convert-LOCK-to-trx
                      To convert locking sessions into transactions
  --wsrep-data-home-dir=name
                      home directory for wsrep provider
  --wsrep-dbug-option=name
                      DBUG options to provider library
  --wsrep-debug=name  WSREP debug level logging. One of: NONE, SERVER,
                      TRANSACTION, STREAMING, CLIENT
  --wsrep-desync      To desynchronize the node from the cluster
  --wsrep-dirty-reads Allow reads even when the node is not in the primary
                      component.
  --wsrep-drupal-282555-workaround
                      Enable a workaround to handle the cases where inserting a
                      DEFAULT value into an auto-increment column could fail
                      with duplicate key error
  --wsrep-forced-binlog-format=name
                      binlog format to take effect over user's choice. One of:
                      MIXED, STATEMENT, ROW, NONE
  --wsrep-gtid-domain-id=#
                      When wsrep_gtid_mode is set, this value is used as
                      gtid_domain_id for galera transactions and also copied to
                      the joiner nodes during state transfer. It is ignored,
                      otherwise.
  --wsrep-gtid-mode   Automatically update the (joiner) node's
                      wsrep_gtid_domain_id value with that of donor's (received
                      during state transfer) and use it in place of
                      gtid_domain_id for all galera transactions. When OFF
                      (default), wsrep_gtid_domain_id is simply ignored
                      (backward compatibility).
  --wsrep-ignore-apply-errors=#
                      Ignore replication errors
  --wsrep-load-data-splitting
                      To commit LOAD DATA transaction after every 10K rows
                      inserted (deprecated)
  --wsrep-log-conflicts
                      To log multi-master conflicts
  --wsrep-max-ws-rows=#
                      Max number of rows in write set
  --wsrep-max-ws-size=#
                      Max write set size (bytes)
  --wsrep-mysql-replication-bundle=#
                      mysql replication group commit
  --wsrep-new-cluster Bootstrap a cluster. It works by overriding the current
                      value of wsrep_cluster_address. It is recommended not to
                      add this option to the config file as this will trigger
                      bootstrap on every server start.
  --wsrep-node-address=name
                      Specifies the node's network address, in the format ip
                      address[:port]. Used in situations where autoguessing is
                      not reliable. As of MariaDB 10.1.8, supports IPv6.
  --wsrep-node-incoming-address=name
                      Client connection address
  --wsrep-node-name=name
                      Name of this node. This name can be used in
                      wsrep_sst_donor as a preferred donor. Note that multiple
                      nodes in a cluster can have the same name.
  --wsrep-notify-cmd=name
  --wsrep-on          To enable wsrep replication
  --wsrep-provider=name
                      Path to replication provider library
  --wsrep-provider-options=name
                      Semicolon (;) separated list of wsrep options (see
                      wsrep_provider_options documentation).
  --wsrep-recover     Recover database state after crash and exit
  --wsrep-reject-queries[=name]
                      Variable to set to reject queries. One of: NONE, ALL,
                      ALL_KILL
  --wsrep-replicate-myisam
                      To enable myisam replication
  --wsrep-restart-slave
                      Should MariaDB slave be restarted automatically, when
                      node joins back to cluster
  --wsrep-retry-autocommit=#
                      Max number of times to retry a failed autocommit
                      statement
  --wsrep-slave-FK-checks
                      Should slave thread do foreign key constraint checks
                      (Defaults to on; use --skip-wsrep-slave-FK-checks to disable.)
  --wsrep-slave-UK-checks
                      Should slave thread do secondary index uniqueness checks
  --wsrep-slave-threads=#
                      Number of slave appliers to launch
  --wsrep-sst-auth=name
                      Authentication for SST connection
  --wsrep-sst-donor=name
                      preferred donor node for the SST
  --wsrep-sst-donor-rejects-queries
                      Reject client queries when donating state snapshot
                      transfer
  --wsrep-sst-method=name
                      State snapshot transfer method
  --wsrep-sst-receive-address=name
                      Address where node is waiting for SST contact
  --wsrep-start-position=name
                      global transaction position to start from
  --wsrep-strict-ddl  If set, reject DDL on affected tables not supporting
                      Galera replication
  --wsrep-sync-wait[=#]
                      Ensure "synchronous" read view before executing an
                      operation of the type specified by bitmask: 1 -
                      READ(includes SELECT, SHOW and BEGIN/START TRANSACTION);
                      2 - UPDATE and DELETE; 4 - INSERT and REPLACE
  --wsrep-trx-fragment-size=#
                      Size of transaction fragments for streaming replication
                      (measured in units of 'wsrep_trx_fragment_unit')
  --wsrep-trx-fragment-unit=name
                      Unit for streaming replication transaction fragments'
                      size: bytes, rows, statements

Variables (--variable-name=value)
and boolean options {FALSE|TRUE}                             Value (after reading options)
------------------------------------------------------------ -------------
allow-suspicious-udfs                                        FALSE
alter-algorithm                                              DEFAULT
analyze-sample-percentage                                    100
aria-block-size                                              8192
aria-checkpoint-interval                                     0
aria-checkpoint-log-activity                                 1048576
aria-encrypt-tables                                          FALSE
aria-force-start-after-recovery-failures                     0
aria-group-commit                                            none
aria-group-commit-interval                                   0
aria-log-dir-path                                            /var/lib/mysql/
aria-log-file-size                                           1073741824
aria-log-purge-type                                          immediate
aria-max-sort-file-size                                      9223372036853727232
aria-page-checksum                                           TRUE
aria-pagecache-age-threshold                                 300
aria-pagecache-buffer-size                                   134217728
aria-pagecache-division-limit                                100
aria-pagecache-file-hash-size                                512
aria-recover-options
aria-repair-threads                                          1
aria-sort-buffer-size                                        268434432
aria-stats-method                                            nulls_unequal
aria-sync-log-dir                                            NEWFILE
auto-increment-increment                                     1
auto-increment-offset                                        1
autocommit                                                   TRUE
automatic-sp-privileges                                      TRUE
back-log                                                     80
basedir                                                      /usr
big-tables                                                   FALSE
bind-address                                                 127.0.0.1
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-row-metadata                                          NO_LOG
binlog-stmt-cache-size                                       32768
bulk-insert-buffer-size                                      8388608
character-set-client-handshake                               TRUE
character-set-filesystem                                     binary
character-set-server                                         utf8mb4
character-sets-dir                                           /usr/share/mysql/charsets/
chroot                                                       (No default value)
collation-server                                             utf8mb4_general_ci
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
connect-timeout                                              10
console                                                      FALSE
datadir                                                      /var/lib/mysql/
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
debug
debug-abort-slave-event-count                                0
debug-disconnect-slave-event-count                           0
debug-gdb                                                    FALSE
debug-max-binlog-dump-events                                 0
debug-no-sync                                                FALSE
debug-no-thread-alarm                                        FALSE
debug-sporadic-binlog-dump-fail                              FALSE
default-password-lifetime                                    0
default-regex-flags
default-storage-engine                                       InnoDB
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
des-key-file                                                 (No default value)
disconnect-on-expired-password                               FALSE
div-precision-increment                                      4
encrypt-binlog                                               FALSE
encrypt-tmp-disk-tables                                      FALSE
encrypt-tmp-files                                            FALSE
enforce-storage-engine                                       (No default value)
eq-range-index-dive-limit                                    200
event-scheduler                                              OFF
expensive-subquery-limit                                     100
expire-logs-days                                             10
explicit-defaults-for-timestamp                              FALSE
external-locking                                             FALSE
extra-max-connections                                        1
extra-port                                                   0
feedback                                                     ON
feedback-http-proxy                                          (No default value)
feedback-send-retry-wait                                     60
feedback-send-timeout                                        60
feedback-url                                                 https://mariadb.org/feedback_plugin/post
feedback-user-info
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
general-log-file                                             kk.log
getopt-prefix-matching                                       TRUE
group-concat-max-len                                         1048576
gtid-cleanup-batch-size                                      64
gtid-domain-id                                               0
gtid-ignore-duplicates                                       FALSE
gtid-pos-auto-engines
gtid-strict-mode                                             FALSE
help                                                         TRUE
histogram-size                                               254
histogram-type                                               DOUBLE_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
in-predicate-conversion-threshold                            1000
init-connect
init-file                                                    (No default value)
init-rpl-role                                                MASTER
init-slave
innodb                                                       ON
innodb-adaptive-flushing                                     TRUE
innodb-adaptive-flushing-lwm                                 10
innodb-adaptive-hash-index                                   FALSE
innodb-adaptive-hash-index-parts                             8
innodb-adaptive-max-sleep-delay                              0
innodb-autoextend-increment                                  64
innodb-autoinc-lock-mode                                     1
innodb-background-scrub-data-check-interval                  0
innodb-background-scrub-data-compressed                      FALSE
innodb-background-scrub-data-interval                        0
innodb-background-scrub-data-uncompressed                    FALSE
innodb-buf-dump-status-frequency                             0
innodb-buffer-page                                           ON
innodb-buffer-page-lru                                       ON
innodb-buffer-pool-chunk-size                                134217728
innodb-buffer-pool-dump-at-shutdown                          TRUE
innodb-buffer-pool-dump-now                                  FALSE
innodb-buffer-pool-dump-pct                                  25
innodb-buffer-pool-filename                                  ib_buffer_pool
innodb-buffer-pool-instances                                 0
innodb-buffer-pool-load-abort                                FALSE
innodb-buffer-pool-load-at-startup                           TRUE
innodb-buffer-pool-load-now                                  FALSE
innodb-buffer-pool-size                                      134217728
innodb-buffer-pool-stats                                     ON
innodb-change-buffer-max-size                                25
innodb-change-buffering                                      none
innodb-checksum-algorithm                                    full_crc32
innodb-cmp                                                   ON
innodb-cmp-per-index                                         ON
innodb-cmp-per-index-enabled                                 FALSE
innodb-cmp-per-index-reset                                   ON
innodb-cmp-reset                                             ON
innodb-cmpmem                                                ON
innodb-cmpmem-reset                                          ON
innodb-commit-concurrency                                    0
innodb-compression-algorithm                                 zlib
innodb-compression-default                                   FALSE
innodb-compression-failure-threshold-pct                     5
innodb-compression-level                                     6
innodb-compression-pad-pct-max                               50
innodb-concurrency-tickets                                   0
innodb-data-file-path                                        ibdata1:12M:autoextend
innodb-data-home-dir                                         (No default value)
innodb-deadlock-detect                                       TRUE
innodb-default-encryption-key-id                             1
innodb-default-row-format                                    dynamic
innodb-defragment                                            FALSE
innodb-defragment-fill-factor                                0.9
innodb-defragment-fill-factor-n-recs                         20
innodb-defragment-frequency                                  40
innodb-defragment-n-pages                                    7
innodb-defragment-stats-accuracy                             0
innodb-disable-sort-file-cache                               FALSE
innodb-doublewrite                                           TRUE
innodb-encrypt-log                                           FALSE
innodb-encrypt-tables                                        OFF
innodb-encrypt-temporary-tables                              FALSE
innodb-encryption-rotate-key-age                             1
innodb-encryption-rotation-iops                              100
innodb-encryption-threads                                    0
innodb-fast-shutdown                                         1
innodb-fatal-semaphore-wait-threshold                        600
innodb-file-format                                           (No default value)
innodb-file-per-table                                        TRUE
innodb-fill-factor                                           100
innodb-flush-log-at-timeout                                  1
innodb-flush-log-at-trx-commit                               1
innodb-flush-method                                          fsync
innodb-flush-neighbors                                       1
innodb-flush-sync                                            TRUE
innodb-flushing-avg-loops                                    30
innodb-force-load-corrupted                                  FALSE
innodb-force-primary-key                                     FALSE
innodb-force-recovery                                        0
innodb-ft-aux-table                                          (No default value)
innodb-ft-being-deleted                                      ON
innodb-ft-cache-size                                         8000000
innodb-ft-config                                             ON
innodb-ft-default-stopword                                   ON
innodb-ft-deleted                                            ON
innodb-ft-enable-diag-print                                  FALSE
innodb-ft-enable-stopword                                    TRUE
innodb-ft-index-cache                                        ON
innodb-ft-index-table                                        ON
innodb-ft-max-token-size                                     84
innodb-ft-min-token-size                                     3
innodb-ft-num-word-optimize                                  2000
innodb-ft-result-cache-limit                                 2000000000
innodb-ft-server-stopword-table                              (No default value)
innodb-ft-sort-pll-degree                                    2
innodb-ft-total-cache-size                                   640000000
innodb-ft-user-stopword-table                                (No default value)
innodb-immediate-scrub-data-uncompressed                     FALSE
innodb-instant-alter-column-allowed                          add_drop_reorder
innodb-io-capacity                                           200
innodb-io-capacity-max                                       18446744073709551615
innodb-large-prefix                                          (No default value)
innodb-lock-schedule-algorithm                               fcfs
innodb-lock-wait-timeout                                     50
innodb-lock-waits                                            ON
innodb-locks                                                 ON
innodb-log-buffer-size                                       16777216
innodb-log-checksums                                         TRUE
innodb-log-compressed-pages                                  TRUE
innodb-log-file-size                                         100663296
innodb-log-files-in-group                                    1
innodb-log-group-home-dir                                    (No default value)
innodb-log-optimize-ddl                                      FALSE
innodb-log-write-ahead-size                                  8192
innodb-lru-flush-size                                        32
innodb-lru-scan-depth                                        1536
innodb-max-dirty-pages-pct                                   90
innodb-max-dirty-pages-pct-lwm                               0
innodb-max-purge-lag                                         0
innodb-max-purge-lag-delay                                   0
innodb-max-purge-lag-wait                                    4294967295
innodb-max-undo-log-size                                     10485760
innodb-metrics                                               ON
innodb-monitor-disable                                       (No default value)
innodb-monitor-enable                                        (No default value)
innodb-monitor-reset                                         (No default value)
innodb-monitor-reset-all                                     (No default value)
innodb-mutexes                                               ON
innodb-old-blocks-pct                                        37
innodb-old-blocks-time                                       1000
innodb-online-alter-log-max-size                             134217728
innodb-open-files                                            0
innodb-optimize-fulltext-only                                FALSE
innodb-page-cleaners                                         0
innodb-page-size                                             16384
innodb-prefix-index-cluster-optimization                     FALSE
innodb-print-all-deadlocks                                   FALSE
innodb-purge-batch-size                                      300
innodb-purge-rseg-truncate-frequency                         128
innodb-purge-threads                                         4
innodb-random-read-ahead                                     FALSE
innodb-read-ahead-threshold                                  56
innodb-read-io-threads                                       4
innodb-read-only                                             FALSE
innodb-replication-delay                                     0
innodb-rollback-on-timeout                                   FALSE
innodb-scrub-log                                             FALSE
innodb-scrub-log-speed                                       256
innodb-sort-buffer-size                                      1048576
innodb-spin-wait-delay                                       4
innodb-stats-auto-recalc                                     TRUE
innodb-stats-include-delete-marked                           FALSE
innodb-stats-method                                          nulls_equal
innodb-stats-modified-counter                                0
innodb-stats-on-metadata                                     FALSE
innodb-stats-persistent                                      TRUE
innodb-stats-persistent-sample-pages                         20
innodb-stats-traditional                                     TRUE
innodb-stats-transient-sample-pages                          8
innodb-status-file                                           FALSE
innodb-status-output                                         FALSE
innodb-status-output-locks                                   FALSE
innodb-strict-mode                                           TRUE
innodb-sync-array-size                                       1
innodb-sync-spin-loops                                       30
innodb-sys-columns                                           ON
innodb-sys-datafiles                                         ON
innodb-sys-fields                                            ON
innodb-sys-foreign                                           ON
innodb-sys-foreign-cols                                      ON
innodb-sys-indexes                                           ON
innodb-sys-semaphore-waits                                   ON
innodb-sys-tables                                            ON
innodb-sys-tablespaces                                       ON
innodb-sys-tablestats                                        ON
innodb-sys-virtual                                           ON
innodb-table-locks                                           TRUE
innodb-tablespaces-encryption                                ON
innodb-temp-data-file-path                                   ibtmp1:12M:autoextend
innodb-thread-concurrency                                    0
innodb-thread-sleep-delay                                    0
innodb-tmpdir                                                (No default value)
innodb-trx                                                   ON
innodb-undo-directory                                        (No default value)
innodb-undo-log-truncate                                     FALSE
innodb-undo-logs                                             128
innodb-undo-tablespaces                                      0
innodb-use-atomic-writes                                     TRUE
innodb-use-native-aio                                        TRUE
innodb-write-io-threads                                      4
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-files-support                                          TRUE
large-pages                                                  FALSE
lc-messages                                                  en_US
lc-messages-dir                                              /usr/share/mysql
lc-time-names                                                en_US
local-infile                                                 TRUE
lock-wait-timeout                                            86400
log-basename                                                 kk
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-tc-size                                                  24576
log-warnings                                                 2
long-query-time                                              10
low-priority-updates                                         FALSE
lower-case-file-system                                       FALSE
lower-case-table-names                                       0
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-password-errors                                          4294967295
max-prepared-stmt-count                                      16382
max-recursive-iterations                                     4294967295
max-relay-log-size                                           1073741824
max-rowid-filter-size                                        131072
max-seeks-for-key                                            4294967295
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                                         4294967295
memlock                                                      FALSE
metadata-locks-cache-size                                    1024
metadata-locks-hash-instances                                8
min-examined-row-limit                                       0
mrr-buffer-size                                              262144
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                                              DEFAULT
old-mode
old-passwords                                                FALSE
old-style-user-limits                                        FALSE
open-files-limit                                             32183
optimizer-max-sel-arg-weight                                 32000
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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on
optimizer-trace
optimizer-trace-max-mem-size                                 1048576
optimizer-use-condition-selectivity                          4
partition                                                    ON
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        FALSE
performance-schema-consumer-events-statements-history        FALSE
performance-schema-consumer-events-statements-history-long   FALSE
performance-schema-consumer-events-transactions-current      FALSE
performance-schema-consumer-events-transactions-history      FALSE
performance-schema-consumer-events-transactions-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-transactions-history-long-size     -1
performance-schema-events-transactions-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                          90
performance-schema-max-cond-instances                        -1
performance-schema-max-digest-length                         1024
performance-schema-max-file-classes                          80
performance-schema-max-file-handles                          32768
performance-schema-max-file-instances                        -1
performance-schema-max-index-stat                            -1
performance-schema-max-memory-classes                        320
performance-schema-max-metadata-locks                        -1
performance-schema-max-mutex-classes                         210
performance-schema-max-mutex-instances                       -1
performance-schema-max-prepared-statements-instances         -1
performance-schema-max-program-instances                     -1
performance-schema-max-rwlock-classes                        50
performance-schema-max-rwlock-instances                      -1
performance-schema-max-socket-classes                        10
performance-schema-max-socket-instances                      -1
performance-schema-max-sql-text-length                       1024
performance-schema-max-stage-classes                         160
performance-schema-max-statement-classes                     222
performance-schema-max-statement-stack                       10
performance-schema-max-table-handles                         -1
performance-schema-max-table-instances                       -1
performance-schema-max-table-lock-stat                       -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                         -1
performance-schema-setup-objects-size                        -1
performance-schema-users-size                                -1
pid-file                                                     /run/mysqld/mysqld.pid
plugin-dir                                                   /usr/lib/mysql/plugin/
plugin-maturity                                              gamma
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)
require-secure-transport                                     FALSE
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)
secure-timestamp                                             NO
sequence                                                     ON
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                                            FALSE
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-load-tmpdir                                            /tmp
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                               1158,1159,1160,1161,1205,1213,1429,2013,12701
slave-transaction-retry-interval                             0
slave-type-conversions
slow-launch-time                                             2
slow-query-log                                               FALSE
slow-query-log-file                                          kk-slow.log
socket                                                       /run/mysqld/mysqld.sock
sort-buffer-size                                             2097152
sql-mode                                                     STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
sql-safe-updates                                             FALSE
ssl                                                          FALSE
ssl-ca                                                       (No default value)
ssl-capath                                                   (No default value)
ssl-cert                                                     (No default value)
ssl-cipher                                                   (No default value)
ssl-crl                                                      (No default value)
ssl-crlpath                                                  (No default value)
ssl-key                                                      (No default value)
stack-trace                                                  TRUE
standard-compliant-cte                                       TRUE
stored-program-cache                                         256
strict-password-validation                                   TRUE
symbolic-links                                               TRUE
sync-binlog                                                  0
sync-frm                                                     TRUE
sync-master-info                                             10000
sync-relay-log                                               10000
sync-relay-log-info                                          10000
sysdate-is-now                                               FALSE
system-time-zone                                             IDT
system-versioning-alter-history                              ERROR
table-cache                                                  2000
table-definition-cache                                       400
table-open-cache                                             2000
table-open-cache-instances                                   8
tc-heuristic-recover                                         OFF
tcp-keepalive-interval                                       0
tcp-keepalive-probes                                         0
tcp-keepalive-time                                           0
tcp-nodelay                                                  TRUE
temp-pool                                                    FALSE
thread-cache-size                                            151
thread-handling                                              one-thread-per-connection
thread-pool-dedicated-listener                               FALSE
thread-pool-exact-stats                                      FALSE
thread-pool-groups                                           ON
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-queues                                           ON
thread-pool-size                                             1
thread-pool-stall-limit                                      500
thread-pool-stats                                            ON
thread-pool-waits                                            ON
thread-stack                                                 299008
time-format                                                  %H:%i:%s
tls-version                                                  TLSv1.1,TLSv1.2,TLSv1.3
tmp-disk-table-size                                          18446744073709551615
tmp-memory-table-size                                        16777216
tmp-table-size                                               16777216
tmpdir                                                       /tmp
transaction-alloc-block-size                                 8192
transaction-isolation                                        REPEATABLE-READ
transaction-prealloc-size                                    4096
transaction-read-only                                        FALSE
unix-socket                                                  ON
updatable-views-with-limit                                   YES
use-stat-tables                                              PREFERABLY_FOR_QUERIES
user-variables                                               ON
userstat                                                     FALSE
verbose                                                      TRUE
version                                                      10.5.15-MariaDB-0ubuntu0.21.10.1
version-comment                                              Ubuntu 21.10
version-compile-machine                                      aarch64
version-compile-os                                           debian-linux-gnu
version-malloc-library                                       system
version-source-revision                                      9aa3564e8a06c3d2027fc514213ecf42b049b06e
version-ssl-library                                          OpenSSL 1.1.1l  24 Aug 2021
wait-timeout                                                 28800
wsrep-OSU-method                                             TOI
wsrep-SR-store                                               table
wsrep-auto-increment-control                                 TRUE
wsrep-causal-reads                                           FALSE
wsrep-certification-rules                                    strict
wsrep-certify-nonPK                                          TRUE
wsrep-cluster-address
wsrep-cluster-name                                           my_wsrep_cluster
wsrep-convert-LOCK-to-trx                                    FALSE
wsrep-data-home-dir                                          /var/lib/mysql/
wsrep-dbug-option
wsrep-debug                                                  NONE
wsrep-desync                                                 FALSE
wsrep-dirty-reads                                            FALSE
wsrep-drupal-282555-workaround                               FALSE
wsrep-forced-binlog-format                                   NONE
wsrep-gtid-domain-id                                         0
wsrep-gtid-mode                                              FALSE
wsrep-ignore-apply-errors                                    7
wsrep-load-data-splitting                                    FALSE
wsrep-log-conflicts                                          FALSE
wsrep-max-ws-rows                                            0
wsrep-max-ws-size                                            2147483647
wsrep-mysql-replication-bundle                               0
wsrep-new-cluster                                            FALSE
wsrep-node-address
wsrep-node-incoming-address                                  AUTO
wsrep-node-name                                              kk
wsrep-notify-cmd
wsrep-on                                                     FALSE
wsrep-patch-version                                          wsrep_26.22
wsrep-provider                                               none
wsrep-provider-options
wsrep-recover                                                FALSE
wsrep-reject-queries                                         NONE
wsrep-replicate-myisam                                       FALSE
wsrep-restart-slave                                          FALSE
wsrep-retry-autocommit                                       1
wsrep-slave-FK-checks                                        TRUE
wsrep-slave-UK-checks                                        FALSE
wsrep-slave-threads                                          1
wsrep-sst-auth                                               (No default value)
wsrep-sst-donor
wsrep-sst-donor-rejects-queries                              FALSE
wsrep-sst-method                                             rsync
wsrep-sst-receive-address                                    AUTO
wsrep-start-position                                         00000000-0000-0000-0000-000000000000:-1
wsrep-strict-ddl                                             FALSE
wsrep-sync-wait                                              0
wsrep-trx-fragment-size                                      0
wsrep-trx-fragment-unit                                      bytes
To see what variables a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --verbose --help'.


See also[edit]

Advertising: