mysqld--help-notwin.result

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,
 except for login file.
--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=#
 Also read groups with concat(group, suffix)
--login-path=# Read this path from the login file.

 --abort-slave-event-count=# 
 Option used by mysql-test for debugging and testing of
 replication.
 --activate-all-roles-on-login 
 Automatically set all granted roles as active after the
 user has authenticated successfully.
 --admin-address=name 
 IP address to bind to for service connection. Address can
 be an IPv4 address, IPv6 address, or host name. Wildcard
 values *, ::, 0.0.0.0 are not allowed. Address value can
 have following optional network namespace separated by
 the delimiter / from the address value. E.g., the
 following value 192.168.1.1/red specifies IP addresses to
 listen for incoming TCP connections that have to be
 placed into the namespace 'red'. Using of network
 namespace requires its support from underlying Operating
 System. Attempt to specify a network namespace for a
 platform that doesn't support it results in error during
 socket creation.
 --admin-port=#      Port number to use for service connection, built-in
 default (33062)
 --admin-ssl         Enable SSL for admin interface (automatically enabled
 with other flags).
 (Defaults to on; use --skip-admin-ssl to disable.)
 --admin-ssl-capath=name 
 --admin-ssl-cert=name 
 --admin-ssl-cipher=name 
 --admin-ssl-crl=name 
 CRL file in PEM format (check OpenSSL docs, implies
 --admin-ssl-crlpath=name 
 --admin-ssl-key=name 
 --admin-tls-ciphersuites=name 
 --admission-control-by-trx 
 Allow open transactions to go through admission control
 --admission-control-filter=name 
 Commands that are skipped in admission control checks.
 The legal values are: ALTER, BEGIN, COMMIT, CREATE,
 DELETE, DROP, INSERT, LOAD, SELECT, SET, REPLACE,
 ROLLBACK, TRUNCATE, UPDATE, SHOW and empty string
 --admission-control-queue[=#] 
 Determines which queue this request goes to during
 admission control. Allowed values are 0-9, since only 10
 queues are available.
 --admission-control-queue-timeout[=#] 
 Number of milliseconds to wait on admission control
 queue. 0 means immediate timeout. -1 means infinite
 timeout.
 --admission-control-weights[=name] 
 Determines the weight of each queue as a comma-separated
 list of integers, where the nth number is the nth queue's
 weight. The queue weight to total weight ratio determines
 what fraction of the running pool a queue can use.
 --allow-noncurrent-db-rw=name 
 Switch to allow/deny reads and writes to a table not in
 the current database.
 --allow-suspicious-udfs 
 Allows use of UDFs consisting of only one symbol xxx()
 without corresponding xxx_init() or xxx_deinit(). That
 also means that one can load any function from any
 library, for example exit() from libc.so
 -a, --ansi          Use ANSI SQL syntax instead of MySQL syntax. This mode
 will also set transaction isolation level 'serializable'.
 --apply-log=name    The location and name to use for apply logs for raft
 --apply-log-index=name 
 The location and name to use for the file that keeps a
 list of the last apply logs for raft
 --apply-log-retention-duration[=#] 
 Minimum duration (mins) that apply logs need to be
 retained.
 --apply-log-retention-num[=#] 
 Minimum number of apply logs that need to be retained.
 --audit-instrumented-event[=name] 
 audit is generated by server in case of error/warning
 events that are instrumented
 --authentication-policy=name 
 Defines policies around how user account can be
 configured with Multi Factor authentication methods
 during CREATE/ALTER USER statement. This variable accepts
 at-most 3 comma separated list of authentication plugin
 names where each value refers to what authentication
 plugin should be used in place of 1st Factor
 Authentication (FA), 2FA and 3FA method. Value *
 indicates any plugin is allowed for 1FA, 2FA and 3FA
 method. An empty value means nth FA method is optional.
 --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.)
 --avoid-temporal-upgrade 
 When this option is enabled, the pre-5.6.4 temporal types
 are not upgraded to the new format for ALTER TABLE
 requests ADD/CHANGE/MODIFY COLUMN, ADD INDEX or FORCE
 operation. This variable is deprecated and will be
 removed in a future release.
 --back-log=#        The number of outstanding connection requests MySQL can
 have. This comes into play when the main MySQL thread
 gets very many connection requests in a very short time
 -b, --basedir=name  Path to installation directory. All paths are usually
 resolved relative to this
 --big-tables        Allow big result sets by saving all temporary sets on
 file (Solves most 'table full' errors)
 --bind-address=name IP address(es) to bind to. Syntax: address[,address]...,
 where address can be an IPv4 address, IPv6 address, host
 name or one of the wildcard values *, ::, 0.0.0.0. In
 case more than one address is specified in a
 comma-separated list, wildcard values are not allowed.
 Every address can have optional network namespace
 separated by the delimiter / from the address value.
 E.g., the following value
 192.168.1.1/red,172.16.1.1/green,193.168.1.1 specifies
 three IP addresses to listen for incoming TCP connections
 two of that have to be placed in corresponding
 namespaces: the address 192.168.1.1 must be placed into
 the namespace red and the address 172.16.1.1 must be
 placed into the namespace green. Using of network
 namespace requires its support from underlying Operating
 System. Attempt to specify a network namespace for a
 platform that doesn't support it results in error during
 socket creation.
 --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. Possible values are NONE and
 CRC32; default is CRC32.
 --binlog-direct-non-transactional-updates 
 Causes updates to non-transactional engines using
 statement format to be written directly to binary log,
 after executing them and before committing the
 transaction. 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, replicas
 may diverge.
 --binlog-do-db=name Include only updates to the specified database when
 writing the binary log.
 --binlog-encryption Enable/disable binary and relay logs encryption.
 --binlog-error-action=name 
 When statements cannot be written to the binary log due
 to a fatal error, this option determines whether the
 server ignores the error and closes the binary log, or
 aborts.
 --binlog-expire-logs-seconds=# 
 If non-zero, binary logs will be purged after
 binlog_expire_logs_seconds seconds; If both this option
 and expire_logs_days are set to non-zero  values, this
 option takes priority. Purges happen at startup and at
 binary log rotation.
 --binlog-format=name 
 The format used when writing the binary log. ROW writes
 each changed row in a binary format. STATEMENT writes SQL
 statements. MIXED writes SQL statements for most
 statements, and row format for statements that cannot be
 replayed in a deterministic manner using SQL. If
 NDBCLUSTER is enabled and binlog-format is MIXED, the
 format switches to row-based and back implicitly for each
 query accessing an NDBCLUSTER table.
 --binlog-group-commit-sync-delay=# 
 The number of microseconds the server waits for the
 binary log group commit sync queue to fill before
 continuing. Default: 0. Min: 0. Max: 1000000.
 --binlog-group-commit-sync-no-delay-count=# 
 If there are this many transactions in the commit sync
 queue and the server is waiting for more transactions to
 be enqueued (as set using
 --binlog-group-commit-sync-delay), the commit procedure
 resumes.
 --binlog-gtid-simple-recovery 
 If this option is enabled, the server does not open more
 than two binary logs when initializing GTID_PURGED and
 GTID_EXECUTED, either during server restart or when
 binary logs are being purged. Enabling this option is
 useful when the server has already generated many binary
 logs without GTID events (e.g., having GTID_MODE = OFF).
 Note: If this option is enabled, GLOBAL.GTID_EXECUTED and
 GLOBAL.GTID_PURGED may be initialized wrongly in two
 cases: (1) All binary logs were generated by MySQL 5.7.5
 or older, and GTID_MODE was ON for some binary logs but
 OFF for the newest binary log. (2) The oldest existing
 binary log was generated by MySQL 5.7.5 or older, and SET
 GTID_PURGED was issued after the oldest binary log was
 generated. If a wrong set is computed in one of case (1)
 or case (2), it will remain wrong even if the server is
 later restarted with this option disabled.
 (Defaults to on; use --skip-binlog-gtid-simple-recovery to disable.)
 --binlog-ignore-db=name 
 Exclude updates to the specified database when writing
 the binary log.
 --binlog-max-flush-queue-time=# 
 The maximum time that the binary log group commit will
 keep reading transactions before it flush the
 transactions to the binary log (and optionally sync,
 depending on the value of sync_binlog).
 --binlog-order-commits 
 Issue internal commit calls in the same order as
 transactions are written to the binary log. Default is to
 order commits.
 (Defaults to on; use --skip-binlog-order-commits to disable.)
 --binlog-rotate-encryption-master-key-at-startup 
 Force binlog encryption master key rotation at startup
 --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',
 'COMPLETE', '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 (e.g. 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.
 'COMPLETE', means that all columns in the before and only
 changed columns in the after image are logged. (Default:
 FULL).
 --binlog-row-metadata=name 
 Controls how much type information is written to the
 binary log when using ROW format. FULL causes all
 metadata to be logged. MINIMAL means that only metadata
 actually needed by replicas is logged.
 --binlog-row-value-options=name 
 When set to PARTIAL_JSON, this option enables a
 space-efficient row-based binary log format for UPDATE
 statements that modify a JSON value using only the
 functions JSON_SET, JSON_REPLACE, and JSON_REMOVE. For
 such updates, only the modified parts of the JSON
 document are included in the binary log, so small changes
 of big documents may need significantly less space.
 --binlog-rows-event-max-rows[=#] 
 Max number of rows in a single rows event
 --binlog-rows-query-log-events 
 Allow writing of Rows_query_log events into binary 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
 --binlog-transaction-compression 
 Whether to compress transactions or not. Transactions are
 compressed using the ZSTD compression algorythm.
 --binlog-transaction-compression-level-zstd=# 
 Specifies the transaction compression level for ZSTD
 transaction compression in the binary log.
 --binlog-transaction-dependency-history-size=# 
 Maximum number of rows to keep in the writeset history.
 --binlog-transaction-dependency-tracking=name 
 Selects the source of dependency information from which
 to compute logical timestamps, which replicas can use to
 decide which transactions can be executed in parallel
 when using replica_parallel_type=LOGICAL_CLOCK. Possible
 values are COMMIT_ORDER, WRITESET and WRITESET_SESSION.
 --binlog-trx-meta-data 
 Log meta data about every trx in the binary log. This
 information is logged as a comment in a Rows_query_log
 event in JSON format.
 --block-encryption-mode=name 
 mode for AES_ENCRYPT/AES_DECRYPT
 --bulk-insert-buffer-size=# 
 Size of tree cache used in bulk insert optimisation. Note
 that this is a limit per thread!
 --caching-sha2-password-digest-rounds=# 
 Number of SHA2 rounds to be done when storing a password
 hash onto disk.
 --caching-sha2-password-private-key-path=name 
 A fully qualified path to the private RSA key used for
 authentication.
 --caching-sha2-password-public-key-path=name 
 A fully qualified path to the public RSA key used for
 authentication.
 --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
 --check-proxy-users If set to FALSE (the default), then proxy user identity
 will not be mapped for authentication plugins which
 support mapping from grant tables.  When set to TRUE,
 users associated with authentication plugins which signal
 proxy user mapping should be done according to GRANT
 PROXY privilege definition.
 -r, --chroot=name   Chroot mysqld daemon during startup.
 --collation-server=name 
 Set the default collation.
 --commit-consensus-error-action[=name] 
 Defines the server action when a thread fails inside
 ordered commit due to consensus error
 --completion-type=name 
 The transaction completion type, one of NO_CHAIN, CHAIN,
 RELEASE
 --concurrent-insert[=name] 
 Use concurrent insert with MyISAM. Possible values are
 NEVER, AUTO, ALWAYS
 --connect-timeout=# The number of seconds the mysqld server is waiting for a
 connect packet before responding with 'Bad handshake'
 --connection-memory-chunk-size=# 
 Chunk size regulating frequency of updating the global
 memory counter
 --connection-memory-limit=# 
 Maximum amount of memory connection can consume
 --console           Write error output on screen; don't remove the console
 window on windows.
 --core-file         Write core on errors.
 --create-admin-listener-thread 
 Use a dedicated thread for listening incoming connections
 on admin interface
 --cte-max-recursion-depth=# 
 Abort a recursive common table expression if it does more
 than this number of iterations.
 -D, --daemonize     Run mysqld as sysv daemon
 -h, --datadir=name  Path to the database root directory
 --default-authentication-plugin=name 
 The default authentication plugin used by the server to
 hash the password.
 --default-collation-for-utf8mb4-init=name 
 The default collation for utf8mb4 charsets
 --default-password-lifetime=# 
 The number of days after which the password will expire.
 --default-storage-engine=name 
 The default storage engine for new tables
 --default-table-encryption 
 Database and tablespace are created with this default
 encryption property unless the user specifies an explicit
 encryption property.
 --default-time-zone=name 
 Set the default time zone.
 --default-tmp-storage-engine=name 
 The default storage engine for new explicit temporary
 tables
 --default-week-format=# 
 The default week format used by WEEK() functions
 --delay-key-write[=name] 
 Type of DELAY_KEY_WRITE
 --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. This variable is deprecated along with
 INSERT DELAYED.
 --delayed-insert-timeout=# 
 How long a INSERT DELAYED thread should wait for INSERT
 statements before terminating. This variable is
 deprecated along with INSERT DELAYED.
 --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. This variable is deprecated
 along with INSERT DELAYED.
 --disable-raft-log-repointing 
 Enable/Disable repointing for raft logs
 --disabled-storage-engines=name 
 Limit CREATE TABLE for the storage engines listed
 --disallow-raft     Temporary variable wich blocks turning on raft. Will be
 removed later once raft is ready for 8.0
 (Defaults to on; use --skip-disallow-raft to disable.)
 --disconnect-on-expired-password 
 Give clients that don't signal password expiration
 support execution time error(s) instead of connection
 error
 (Defaults to on; use --skip-disconnect-on-expired-password to disable.)
 --disconnect-slave-event-count=# 
 Option used by mysql-test for debugging and testing of
 replication.
 --div-precision-increment=# 
 Precision of the result of '/' operator will be increased
 on that value
 --early-plugin-load=name 
 Optional semicolon-separated list of plugins to load
 before storage engine initialization, where each plugin
 is identified as name=library, where name is the plugin
 name and library is the plugin library in plugin_dir.
 --enable-acl-db-cache 
 Enable ACL db_cache lookup on (ip, user, db). Please
 issue FLUSH PRIVILEGES for the changes to take effect.
 (Defaults to on; use --skip-enable-acl-db-cache to disable.)
 --enable-acl-fast-lookup 
 Enable ACL fast lookup on exact user/db pairs. Please
 issue FLUSH PRIVILEGES for the changes to take effect.
 --enable-binlog-hlc Enable logging HLC timestamp as part of Metadata log
 event
 --enable-blind-replace 
 Optimize 'replace into' statement by doing a blind
 insert. Engine ignores primary key violations. This will
 avoid a delete and an insert. This is supported in
 MyRocks
 --enable-block-stale-hlc-read 
 Enable blocking reads with a requested HLC timestamp
 ahead of the engine HLC
 --enable-query-checksum 
 Enable query checksums for queries that have the checksum
 query attribute set. Uses a CRC32 checksum of the query
 contents, but not the attributes
 --enable-raft-plugin 
 Enables RAFT based consensus plugin. Replication will run
 through this plugin when it is enabled
 --enable-resultset-checksum 
 Enable CRC32 resultset checksums if requested by the
 client sending the checksum query attribute, set to the
 query checksum
 --enable-super-log-bin-read-only 
 If set, prevents super from writing to a read_only
 instance when sql_log_bin is also enabled
 --enable-user-tables-engine-check 
 Enable checking storage engine compatibilty of user table
 creation DDL.
 --end-markers-in-json 
 In JSON output ("EXPLAIN FORMAT=JSON" and optimizer
 trace), if variable is set to 1, repeats the structure's
 key (if it has one) near the closing bracket
 --enforce-gtid-consistency[=name] 
 Prevents execution of statements that would be impossible
 to log in a transactionally safe manner. Currently, the
 disallowed statements include CREATE TEMPORARY TABLE
 inside transactions, all updates to non-transactional
 tables, and CREATE TABLE ... SELECT.
 --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.
 --error-partial-strict 
 Throw error on partial strict mode violations
 --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)
 -T, --exit-info[=#] Used for debugging. Use at your own risk.
 --expire-logs-days=# 
 If non-zero, binary logs will be purged after
 expire_logs_days days; If this option alone is set on the
 command line or in a configuration file, it overrides the
 default value for binlog-expire-logs-seconds. If both
 options are set to nonzero values,
 binlog-expire-logs-seconds takes priority. 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. The old behavior is deprecated. The
 variable can only be set by users having the SUPER
 privilege.
 (Defaults to on; use --skip-explicit-defaults-for-timestamp to disable.)
 --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.
 --fast-integer-to-string 
 Optimized implementation of integer to string conversion
 --filesort-max-file-size=# 
 The max size of a file to use for filesort. Raise an
 error when this is exceeded. 0 means no limit.
 --flush             Flush MyISAM tables to disk between SQL commands
 --flush-only-old-table-cache-entries 
 Enable/disable flushing table and definition cache
 entries policy based on TTL specified by flush_time.
 --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
 --gap-lock-exceptions[=name] 
 List of tables (using regex) that are excluded from gap
 lock detection.
 --gap-lock-log-file=name 
 Log file path where queries using Gap Lock are written.
 gap_lock_write_log needs to be turned on to write logs
 --gap-lock-raise-error 
 Raising an error when executing queries relying on Gap
 Lock. Default is false.
 --gap-lock-write-log 
 Writing to gap_lock_log_file when executing queries
 relying on Gap Lock. Default is false.
 --gdb               Set up signals usable for debugging.
 --general-log       Log connections and queries to a table or log file.
 Defaults to logging to a file hostname.log, or if
 --log-output=TABLE is used, to a table mysql.general_log.
 --general-log-file=name 
 Log connections and queries to given file
 --generated-random-password-length=# 
 Determines the length randomly generated passwords in
 CREATE USER-,SET PASSWORD- or ALTER USER statements
 --global-connection-memory-limit=# 
 Maximum amount of memory all connections can consume
 --global-connection-memory-tracking 
 Enable updating the global memory counter and checking
 the global connection memory limit exceeding
 --group-concat-max-len=# 
 The maximum length of the result of function 
 GROUP_CONCAT()
 --group-replication-consistency[=name] 
 Transaction consistency guarantee, possible values:
 EVENTUAL, BEFORE_ON_PRIMARY_FAILOVER, BEFORE, AFTER,
 BEFORE_AND_AFTER
 --group-replication-plugin-hooks 
 Enable interfaces and codepaths used by group replication
 plugin
 --gtid-executed-compression-period[=#] 
 Compress the mysql.gtid_executed table whenever this
 number of transactions have been added, by waking up a
 foreground thread (compress_gtid_table). This compression
 method only operates when binary logging is disabled on
 the replica; if binary logging is enabled, the table is
 compressed every time the binary log is rotated, and this
 value is ignored. Before MySQL 8.0.23, the default is
 1000, and from MySQL 8.0.23, the default is zero, which
 disables this compression method. This is because in
 releases from MySQL 8.0.17, InnoDB transactions are
 written to the mysql.gtid_executed table by a separate
 process to non-InnoDB transactions. If the server has a
 mix of InnoDB and non-InnoDB transactions, attempting to
 compress the table with the compress_gtid_table thread
 can slow this process, so from MySQL 8.0.17 it is
 recommended that you set gtid_executed_compression_period
 to 0.
 --gtid-mode=name    Controls whether Global Transaction Identifiers (GTIDs)
 are enabled. Can be OFF, OFF_PERMISSIVE, ON_PERMISSIVE,
 or ON. OFF means that no transaction has a GTID.
 OFF_PERMISSIVE means that new transactions (committed in
 a client session using GTID_NEXT='AUTOMATIC') are not
 assigned any GTID, and replicated transactions are
 allowed to have or not have a GTID. ON_PERMISSIVE means
 that new transactions are assigned a GTID, and replicated
 transactions are allowed to have or not have a GTID. ON
 means that all transactions have a GTID. ON is required
 on a source before any replica can use
 SOURCE_AUTO_POSITION=1. To safely switch from OFF to ON,
 first set all servers to OFF_PERMISSIVE, then set all
 servers to ON_PERMISSIVE, then wait for all transactions
 without a GTID to be replicated and executed on all
 servers, and finally set all servers to GTID_MODE = ON.
 -?, --help          Display this help and exit.
 --high-precision-processlist 
 If set, MySQL will display the time in 1/1000000 of a
 second precision
 --high-priority-ddl Setting this flag will allow DDL commands to kill
 conflicting connections (effective for admin user only).
 --high-priority-lock-wait-timeout=# 
 Timeout in seconds to wait for a lock before returning an
 error. This timeout is specifically for high_priority
 commands (DDLs), when the high_priority_ddl variable is
 turned on. The argument will be treated as a decimal
 value with nanosecond precision.
 --histogram-generation-max-mem-size=# 
 Maximum amount of memory available for generating
 histograms
 --host-cache-size=# How many host names should be cached to avoid resolving.
 --improved-dup-key-error 
 Include the table name in the error text when receiving a
 duplicate key error and log the query into a new
 duplicate key query log file.
 --information-schema-engine[=name] 
 Specify information_schema engine
 --information-schema-stats-expiry=# 
 The number of seconds after which mysqld server will
 fetch data from storage engine and replace the data in
 cache.
 --init-connect=name Command(s) that are executed for each new connection
 --init-file=name    Read SQL commands from this file at startup
 --init-replica=name Command(s) that are executed by the replication applier
 thread each time the applier threads start.
 --init-slave=name   This option is deprecated. Use init_replica instead.
 -I, --initialize    Create the default database and exit. Create a super user
 with a random expired password and store it into the log.
 --initialize-insecure 
 Create the default database and exit. Create a super user
 with empty password.
 --interactive-timeout=# 
 The number of seconds the server waits for activity on an
 interactive connection before closing it
 --internal-tmp-mem-storage-engine=name 
 The default storage engine for in-memory internal
 temporary tables.
 --join-buffer-size=# 
 The size of the buffer that is used for full joins
 --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
 --keyring-migration-destination=name 
 Keyring plugin or component to which the keys are
 migrated to.
 --keyring-migration-host=name 
 Connect to host.
 -p, --keyring-migration-password[=name] 
 Password to use when connecting to server during keyring
 migration. If password value is not specified then it
 will be asked from the tty.
 --keyring-migration-port=# 
 Port number to use for connection.
 --keyring-migration-source=name 
 Keyring plugin from where the keys needs to be migrated
 to. This option must be specified along with
 --keyring-migration-destination.
 --keyring-migration-to-component 
 Migrate from keyring plugin to keyring component.
 --keyring-migration-user=name 
 User to login to server.
 --kill-conflicting-connections 
 Setting this session only flag will instruct the the
 session to kill all conflicting connections (effective
 for admin user only) for any command executed by the
 current session. The connections are killed only after
 waiting for wait_lock_timeout. Only connections holding
 the lock will be killed, but there could be more
 connections in the queue which will take the lock before
 the current session and the current session will wait for
 1 more second before aborting if the lock won't be
 granted.
 --kill-conflicting-connections-timeout[=#] 
 Timeout in seconds of holding lock after issuing killing
 conflicting connections.
 -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.
 --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.
 --legacy-global-read-lock-mode 
 Uses the legacy global read lock mode which will block
 setting global read lock when a long transaction is
 running
 (Defaults to on; use --skip-legacy-global-read-lock-mode to disable.)
 --local-infile      Enable LOAD DATA LOCAL INFILE
 --lock-wait-timeout=# 
 Timeout in seconds to wait for a lock before returning an
 error. The argument will be treated as a decimal value
 with nanosecond precision.
 --log-bin[=name]    Configures the name prefix to use for binary log files.
 If the --log-bin option is not supplied, the name prefix
 defaults to "binlog". If the --log-bin option is supplied
 without argument, the name prefix defaults to
 "HOSTNAME-bin", where HOSTNAME is the machine's hostname.
 To set a different name prefix for binary log files, use
 --log-bin=name. To disable binary logging, use the
 --skip-log-bin or --disable-log-bin option.
 --log-bin-index=name 
 File that holds the names for 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-bin-use-v1-row-events 
 If equal to 1 then version 1 row events are written to a
 row based binary log.  If equal to 0, then the latest
 version of events are written.  This option is useful
 during some upgrades.
 --log-column-names  Writes column name information in table map log events.
 --log-datagram      Enable logging queries to a unix local datagram socket
 --log-datagram-usecs=# 
 Log queries longer than log-datagram-usecs to a unix
 local datagram socket
 --log-ddl           Log ddls in slow query log.
 --log-error[=name]  Error log file
 --log-error-services=name 
 Services that should be called when an error event is
 received
 --log-error-suppression-list=name 
 Comma-separated list of error-codes. Error messages
 corresponding to these codes will not be included in the
 error log. Only events with a severity of Warning or
 Information can be suppressed; events with System or
 Error severity will always be included. Requires the
 filter 'log_filter_internal' to be set in
 @@global.log_error_services, which is the default.
 --log-error-verbosity=# 
 How detailed the error log should be. 1, log errors only.
 2, log errors and warnings. 3, log errors, warnings, and
 notes. 4, log errors, warnings, notes, and debug.
 Messages sent to the client are unaffected by this
 setting.
 --log-global-var-changes 
 All the value changes of global variables will be logged
 into server log when this is set to TRUE.
 --log-isam[=name]   Log all MyISAM changes to file.
 --log-only-query-comments 
 Writes only the comments part at the beginning of the
 query in Rows_query_log_events.
 (Defaults to on; use --skip-log-only-query-comments to disable.)
 --log-output=name   Syntax: log-output=value[,value...], where "value" could
 be TABLE, FILE or NONE
 --log-queries-not-using-indexes 
 Log queries that are executed without benefit of any
 index to the slow log if it is open
 --log-raw           Log to general log before any rewriting of the query. For
 use in debugging, not production as sensitive information
 may be logged.
 --log-replica-updates 
 If enabled, the replication applier threads will write to
 this server's binary log.
 (Defaults to on; use --skip-log-replica-updates to disable.)
 --log-short-format  Don't log extra information to update and slow-query
 logs.
 --log-slave-updates This option is deprecated. Use log_replica_updates
 instead.
 (Defaults to on; use --skip-log-slave-updates to disable.)
 --log-slow-admin-statements 
 Log slow OPTIMIZE, ANALYZE, ALTER and other
 administrative statements to the slow log if it is open.
 --log-slow-extra    Print more attributes to the slow query log file. Has no
 effect on logging to table.
 --log-slow-replica-statements 
 Log slow statements executed by the replication applier
 threads to the slow log if it is open.
 --log-slow-slave-statements 
 This option is deprecated. Use
 log_slow_replica_statements instead.
 --log-statements-unsafe-for-binlog 
 Log statements considered unsafe when using statement
 based binary logging.
 (Defaults to on; use --skip-log-statements-unsafe-for-binlog to disable.)
 --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.
 --log-throttle-ddl[=#] 
 Log at most this many DDL entries per minute to the slow
 log. Any further warnings will be condensed into a single
 summary line. A value of 0 disables throttling. Option
 has no effect unless --log_ddl is set.
 --log-throttle-queries-not-using-indexes=# 
 Log at most this many 'not using index' warnings per
 minute to the slow log. Any further warnings will be
 condensed into a single summary line. A value of 0
 disables throttling. Option has no effect unless
 --log_queries_not_using_indexes is set.
 --log-timestamps=name 
 UTC to timestamp log files in zulu time, for more concise
 timestamps and easier correlation of logs from servers
 from multiple time zones, or SYSTEM to use the system's
 local time. This affects only log files, not log tables,
 as the timestamp columns of the latter can be converted
 at will.
 --long-query-time=# Log all queries that have taken more than long_query_time
 seconds to execute to file. This also includes lock wait
 time. 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
 --lz4f-net-compression-level[=#] 
 Compression level for compressed protocol when lz4f
 library is selected.
 --maintain-database-hlc 
 Enable maintaining of max HLC applied per database
 --mandatory-roles=name 
 All the specified roles are always considered granted to
 every user and they can't be revoked. Mandatory roles
 still require activation unless they are made into
 default roles. The granted roles will not be visible in
 the mysql.role_edges table.
 --master-info-file=name 
 The path and filename where the replication receiver
 thread stores connection configuration and positions, in
 case --master-info-repository=FILE. This option is
 deprecated and will be removed in a future version.
 --master-info-repository=name 
 The repository format for the replication connection
 configuration.
 --master-retry-count=# 
 The number of times this replica will attempt to connect
 to a source before giving up. This option is deprecated
 and will be removed in a future version. Use 'CHANGE
 REPLICATION SOURCE TO SOURCE_RETRY_COUNT = <num>'
 instead.
 --master-verify-checksum 
 This option is deprecated. Use source_verify_checksum
 instead.
 --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-dump-events=# 
 Option used by mysql-test for debugging and testing of
 replication.
 --max-binlog-size=# Binary log will be rotated automatically when the size
 exceeds this value. Will also apply to relay logs if
 max_relay_log_size is 0
 --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. This variable is deprecated along with
 INSERT DELAYED.
 --max-digest-length=# 
 Maximum length considered for digest text.
 --max-error-count=# Max number of errors/warnings to store for a statement
 --max-execution-time=# 
 Kill SELECT statement that takes over the specified
 number of milliseconds
 --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=# 
 This variable is deprecated and will be removed in a
 future release.
 --max-nonsuper-connections=# 
 The maximum number of total active connections for
 non-super user (0 = no limit)
 --max-points-in-geometry[=#] 
 Maximum number of points in a geometry
 --max-prepared-stmt-count=# 
 Maximum number of prepared statements in the server
 --max-relay-log-size=# 
 If non-zero: relay log will be rotated automatically when
 the size exceeds this value; if zero: when the size
 exceeds max_binlog_size
 --max-running-queries=# 
 The maximum number of running queries allowed for a
 database. If this value is 0, no such limits are applied.
 --max-seeks-for-key=# 
 Limit assumed max number of seeks when looking up rows
 based on a key
 --max-slowlog-size=# 
 Slow query log will be rotated automatically when the
 size exceeds this value. The default is 0, don't limit
 the size.
 --max-sort-length=# The number of bytes to use when sorting long values with
 PAD SPACE collations (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=# 
 redirects to max_execution_time
 --max-user-connections=# 
 The maximum number of active connections for a single
 user (0 = no limit)
 --max-waiting-queries=# 
 The maximum number of waiting queries allowed for a
 database.If this value is 0, no such limits are applied.
 --max-write-lock-count=# 
 After this many write locks, allow some read locks to run
 in between
 --maximum-hlc-drift-ns[=#] 
 Maximum value that the local HLC can be allowed to drift
 forward from the wall clock (in nanoseconds). This limit
 is only used when setting a lower/minimum bound on HLC
 using minimum_hlc_ns system variable. The default value
 is 300 secs
 --memlock           Lock mysqld in memory.
 --min-examined-row-limit=# 
 Don't write queries to slow log that examine fewer rows
 than that
 --minimum-hlc-ns[=#] 
 Sets the minimum HLC value for the instance (in
 nanoseconds). Any HLC timestamp doled out after
 minimum_hlc_ns is successfully updated is guranteed to be
 greater than this value. The maximum allowed drift 
 (forward) is controlled by maximum_hlc_drift_ns
 --mts-dependency-max-keys[=#] 
 Max number of keys in a transaction after which it will
 be executed in isolation. This limits the amount of
 metadata we'll need to maintain.
 --mts-dependency-refill-threshold[=#] 
 Capacity in percentage at which to start refilling the
 dependency buffer
 --mts-dependency-replication[=name] 
 Use dependency based replication
 --mts-dependency-size[=#] 
 Max size of the dependency buffer
 --mts-dynamic-rebalance 
 Shuffle DB's within workers periodically for load
 balancing
 --mts-imbalance-threshold[=#] 
 Threshold to trigger worker thread rebalancing. This
 parameter denotes the percent load on the most loaded
 worker.
 --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] 
 Syntax: myisam-recover-options[=option[,option...]],
 where option can be DEFAULT, BACKUP, FORCE, QUICK, or 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
 --mysql-native-password-proxy-users 
 If set to FALSE (the default), then the
 mysql_native_password plugin will not signal for
 authenticated users to be checked for mapping to proxy
 users.  When set to TRUE, the plugin will flag associated
 authenticated accounts to be mapped to proxy users when
 the server option check_proxy_users is enabled.
 --net-buffer-length=# 
 Buffer length for TCP/IP and socket communication
 --net-compression-level=# 
 Compression level for compressed master/slave protocol
 (when enabled) and client connections (when requested). 0
 is no compression (for testing), 1 is fastest, 9 is
 slowest, 6 is default.
 --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
 -n, --new           Use very new possible "unsafe" functions
 --no-dd-upgrade     Abort restart if automatic upgrade or downgrade of the
 data dictionary is needed. Deprecated option. Use
 --upgrade=NONE instead.
 --offline-mode      Make the server into offline mode
 --old               Use compatible behavior
 --old-alter-table   Use old, non-optimized alter table
 --old-style-user-limits 
 Enable old-style user limits (before 5.0.3, user
 resources were counted for 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 then mysqld will reserve max_connections*5 or
 max_connections + table_open_cache*2 (whichever is
 larger) number of file descriptors
 --optimizer-force-index-for-range 
 If enabled, FORCE INDEX will also try to force a range
 plan.
 --optimizer-full-scan 
 Enable full table and index scans.
 (Defaults to on; use --skip-optimizer-full-scan to disable.)
 --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-switch=name 
 optimizer_switch=option=val[,option=val...], where option
 is one of {index_merge, index_merge_union,
 index_merge_sort_union, index_merge_intersection,
 engine_condition_pushdown, index_condition_pushdown, mrr,
 mrr_cost_based, materialization, semijoin, loosescan,
 firstmatch, duplicateweedout,
 subquery_materialization_cost_based, skip_scan,
 block_nested_loop, batched_key_access,
 use_index_extensions, condition_fanout_filter,
 derived_merge, hash_join, subquery_to_derived,
 prefer_ordering_index, derived_condition_pushdown} and
 val is one of {on, off, default}
 --optimizer-trace=name 
 Controls tracing of the Optimizer:
 optimizer_trace=option=val[,option=val...], where option
 is one of {enabled, one_line} and val is one of {on,
 default}
 --optimizer-trace-features=name 
 Enables/disables tracing of selected features of the
 Optimizer:
 optimizer_trace_features=option=val[,option=val...],
 where option is one of {greedy_search, range_optimizer,
 dynamic_range, repeated_subselect} and val is one of {on,
 off, default}
 --optimizer-trace-limit=# 
 Maximum number of shown optimizer traces
 --optimizer-trace-max-mem-size=# 
 Maximum allowed cumulated size of stored optimizer traces
 --optimizer-trace-offset=# 
 Offset of first optimizer trace to show; see manual
 --override-enable-raft-check 
 Disable some strict raft checks. Use with caution
 --parser-max-mem-size=# 
 Maximum amount of memory available to the parser
 --parthandler-allow-drop-partition 
 If set, partition handler allows partitions to be dropped
 (Defaults to on; use --skip-parthandler-allow-drop-partition to disable.)
 --partial-revokes   Access of database objects can be restricted, even if
 user has global privileges granted.
 --password-history=# 
 The number of old passwords to check in the history. Set
 to 0 (the default) to turn the checks off
 --password-require-current 
 Current password is needed to be specified in order to
 change it
 --password-reuse-interval=# 
 The minimum number of days that need to pass before a
 password can be reused. Set to 0 (the default) to turn
 the checks off
 --per-user-session-var-default-val[=name] 
 Per user session variable default value
 --per-user-session-var-user-name-delimiter[=name] 
 Per user session variable user name delimiter
 --performance-schema 
 Enable the performance schema.
 (Defaults to on; use --skip-performance-schema to disable.)
 --performance-schema-accounts-size=# 
 Maximum number of instrumented user@host accounts. Use 0
 to disable, -1 for automated scaling.
 --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-cpu 
 Default startup value for the events_statements_cpu
 consumer.
 --performance-schema-consumer-events-statements-current 
 Default startup value for the events_statements_current
 consumer.
 (Defaults to on; use --skip-performance-schema-consumer-events-statements-current to disable.)
 --performance-schema-consumer-events-statements-history 
 Default startup value for the events_statements_history
 consumer.
 (Defaults to on; use --skip-performance-schema-consumer-events-statements-history to disable.)
 --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.
 (Defaults to on; use --skip-performance-schema-consumer-events-transactions-current to disable.)
 --performance-schema-consumer-events-transactions-history 
 Default startup value for the events_transactions_history
 consumer.
 (Defaults to on; use --skip-performance-schema-consumer-events-transactions-history to disable.)
 --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-error-size=# 
 Number of server errors instrumented.
 --performance-schema-esms-by-all 
 Enables the events_statements_summary_by_all and disables
 events_statements_summary_by_digest.
 --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 scaling.
 --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 scaling.
 --performance-schema-max-digest-length=# 
 Maximum length considered for digest text, when stored in
 performance_schema tables.
 --performance-schema-max-digest-sample-age=# 
 The time in seconds after which a previous query sample
 is considered old. When the value is 0, queries are
 sampled once. When the value is greater than zero,
 queries are re sampled if the last sample is more than
 performance_schema_max_digest_sample_age seconds old.
 --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 scaling.
 --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 scaling.
 --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 scaling.
 --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 scaling.
 --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 scaling.
 --performance-schema-max-table-instances=# 
 Maximum number of instrumented tables. Use 0 to disable,
 -1 for automated scaling.
 --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 scaling.
 --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. Use 0 to disable,
 -1 for automated scaling.
 --performance-schema-setup-objects-size=# 
 Maximum number of rows in SETUP_OBJECTS. Use 0 to
 disable, -1 for automated scaling.
 --performance-schema-show-processlist 
 Default startup value to enable SHOW PROCESSLIST in the
 performance schema.
 --performance-schema-users-size=# 
 Maximum number of instrumented users. Use 0 to disable,
 -1 for automated scaling.
 --persist-only-admin-x509-subject[=name] 
 The client peer certificate name required to enable
 setting all system variables via SET PERSIST[_ONLY]
 --persisted-globals-load 
 When this option is enabled, config file mysqld-auto.cnf
 is read and applied to server, else this file is ignored
 even if present.
 (Defaults to on; use --skip-persisted-globals-load to disable.)
 --pid-file=name     Pid file used by safe_mysqld
 --plugin-dir=name   Directory for plugins
 --plugin-load=name  Optional semicolon-separated list of plugins to load,
 where each plugin is identified as name=library, where
 name is the plugin name and library is the plugin library
 in plugin_dir.
 --plugin-load-add=name 
 Optional semicolon-separated list of plugins to load,
 where each plugin is identified as name=library, where
 name is the plugin name and library is the plugin library
 in plugin_dir. This option adds to the list specified by
 --plugin-load in an incremental way. Multiple
 --plugin-load-add are supported.
 -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
 --print-identified-with-as-hex 
 SHOW CREATE USER will print the AS clause as HEX if it
 contains non-prinable characters
 --profiling-history-size=# 
 Limit of query profiling memory
 --protocol-compression-algorithms=name 
 List of compression algorithms supported by server.
 Supported values are any combination of zlib, zstd,
 uncompressed. Command line clients may use the
 --compression-algorithms flag to specify a set of
 algorithms, and the connection will use an algorithm
 supported by both client and server. It picks zlib if
 both client and server support it; otherwise it picks
 zstd if both support it; otherwise it picks uncompressed
 if both support it; otherwise it fails.
 --protocol-mode=name 
 Syntax: protocol-mode=mode. See the manual for the
 complete list of valid protocol modes
 --query-alloc-block-size=# 
 Allocation block size for query parsing and execution
 --query-prealloc-size=# 
 Persistent buffer for query parsing and execution
 --range-alloc-block-size=# 
 Allocation block size for storing ranges during
 optimization
 --range-optimizer-max-mem-size=# 
 Maximum amount of memory used by the range optimizer to
 allocate predicates during range analysis. The larger the
 number, more memory may be consumed during range
 analysis. If the value is too low to completed range
 optimization of a query, index range scan will not be
 considered for this query. A value of 0 means range
 optimizer does not have any cap on memory. 
 --rbr-column-type-mismatch-whitelist[=name] 
 List of db.table.col (comma separated) where type
 mismatches are expected. The slave will not fail it the
 conversion is lossless.This variable is overridden by
 slave_type_conversions. Default: ''. A value of '.*'
 means all cols are in the whitelist.
 --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 applier threads and users with
 the SUPER privilege.
 --read-only-error-msg-extra[=name] 
 Set this variable to print out extra error information,
 which will be appended to read_only error messages.
 --read-only-slave   Blocks disabling read_only if the server is a slave. This
 is helpful in asserting that read_only is never disabled
 on a slave. Slave with read_only=0 may generate new GTID
 on its own breaking replication or may cause a split
 brain. 
 (Defaults to on; use --skip-read-only-slave to disable.)
 --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
 --regexp-stack-limit=# 
 Stack size limit for regular expressions matches
 --regexp-time-limit=# 
 Timeout for regular expressions matches, in steps of the
 match engine, typically on the order of milliseconds.
 --relay-log=name    The location and name to use for relay logs
 --relay-log-index=name 
 File that holds the names for relay log files.
 --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-info-repository=name 
 Defines the type of the repository for the relay log
 information and associated workers.
 --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 
 If enabled, existing relay logs will be skipped by the
 replication threads. The receiver will start a new relay
 log and the applier will start reading from the beginning
 of that file. The receiver's position relative to the
 source will be reset to the applier's position relative
 to the source; the receiver uses this in case
 SOURCE_AUTO_POSITION=0.
 --relay-log-space-limit=# 
 Maximum space to use for all relay logs
 --replica-allow-batching 
 Allow this replica to batch requests when using the NDB
 storage engine.
 --replica-checkpoint-group=# 
 When using multi-threaded applier
 (replica_parallel_workers>0), it will update the worker
 progress status periodically. This option specifies the
 maximum number of committed transactions between updates.
 --replica-checkpoint-period=# 
 When using a multi-threaded applier
 (replica_parallel_workers>0), it will update the worker
 progress status periodically. This option specifies the
 maximum number of milliseconds between updates.
 --replica-compressed-protocol 
 Use compression in the source/replica protocol.
 --replica-exec-mode=name 
 Modes for how replication events should be executed.
 Legal values are STRICT (default) and IDEMPOTENT. In
 IDEMPOTENT mode, replication will ignore duplicate key
 errors and key not found errors. In STRICT mode,
 replication will stop at those errors.
 --replica-load-tmpdir=name 
 The location where this replica will store temporary
 files when replicating a LOAD DATA INFILE command from a
 source having binlog_format=STATEMENT.
 --replica-max-allowed-packet=# 
 The maximum size of packets sent from an upstream source
 server to this server.
 --replica-net-timeout=# 
 Number of seconds to wait for more data from a
 replication connection before aborting the read.
 --replica-parallel-type=name 
 The method used by the replication applier to parallelize
 transactions. DATABASE, indicates that it may apply
 transactions in parallel in case they update different
 databases. LOGICAL_CLOCK, which is the default, indicates
 that it decides whether two transactions can be applied
 in parallel using the logical timestamps computed by the
 source, according to
 binlog_transaction_dependency_tracking.
 --replica-parallel-workers=# 
 Number of worker threads for executing events in parallel
 --replica-pending-jobs-size-max=# 
 Soft limit on the size, in bytes, of per-worker queues of
 events that have not yet been applied. The queue size may
 exceed this limit in case a single event is bigger than
 the limit.
 --replica-preserve-commit-order 
 Force replication worker threads to commit in the same
 order as on the source. Enabled by default
 (Defaults to on; use --skip-replica-preserve-commit-order to disable.)
 --replica-skip-errors=name 
 Comma-separated list of error numbers. If an applier
 thread on this replica encounters one of these errors
 while applying a Query_log_event, it will ignore the
 error, rather than stop.
 --replica-sql-verify-checksum 
 Force checksum verification of replication events after
 reading them from relay log. Note: The replica always
 verifies checksums for events received from the network,
 if the event has a checksum at all, before it writes the
 event to the relay log. Enabled by default.
 (Defaults to on; use --skip-replica-sql-verify-checksum to disable.)
 --replica-transaction-retries=# 
 Number of times the replication applier will retry a
 transaction in case it failed with a deadlock or other
 transient error, before it gives up and stops.
 --replica-type-conversions=name 
 Set of type conversions that may be used by the
 replication applier thread for row events. Allowed values
 are: ALL_LOSSY to enable lossy conversions, ALL_NON_LOSSY
 to enable non-lossy conversions, ALL_UNSIGNED to treat
 all integer column type data to be unsigned values, and
 ALL_SIGNED to treat all integer column type data to be
 signed values. Default treatment is ALL_SIGNED. If
 ALL_SIGNED and ALL_UNSIGNED both are specified,
 ALL_SIGNED will take higher priority than ALL_UNSIGNED.
 If the variable is assigned the empty set, no conversions
 are allowed and it is expected that the types match
 exactly.
 --replicate-do-db=name 
 Make replication applier threads apply only changes 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 
 Make replication applier threads apply only changes to
 the specified table. To specify more than one table, use
 the directive multiple times, once for each table. This
 will work for cross-database updates, in contrast to
 replicate-do-db.
 --replicate-ignore-db=name 
 Make replication applier threads skip changes to the
 specified database. To specify more than one database to
 ignore, use this option multiple times, once for each
 database. If there are statements that update multiple
 databases, this will work correctly only when the source
 server uses binlog_format=ROW.
 --replicate-ignore-table=name 
 Make replication applier threads skip changes to the
 specified table.To ignore more than one table, use the
 option multiple times, once for each table. If there are
 statements that update multiple tables, this will work
 correctly only when the source server uses
 binlog_format=ROW.
 --replicate-rewrite-db=name 
 Make replication applier threads rename a database, so
 changes in one database on the source will be applied in
 another database on this replica. Example:
 replicate-rewrite-db=source_db_name->replica_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-replica-updates is used.
 --replicate-wild-do-table=name 
 Make replication applier threads apply changes only in
 tables that match the specified wildcard pattern. To
 specify more than one pattern, use the option multiple
 times, once for each pattern. If there are statements
 that update both tables that are included and excluded by
 the pattern, this will only work correctly when the
 source server uses binlog_format=ROW. 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 
 Make replication applier threads skip changes to tables
 that match the specified wildcard pattern. To specify
 more than one pattern, use the option multiple times,
 once for each pattern. If there are statements that
 update both tables that are included and tables that are
 excluded by the pattern, this will only work correctly
 when the source server uses binlog_format=ROW. Example:
 when using replicate-wild-ignore-table=foo%.bar%, the
 applier thread will not apply updates to tables in
 databases that start with foo and whose table names start
 with bar.
 --replication-optimize-for-static-plugin-config 
 Optional flag that blocks plugin install/uninstall and
 allows skipping the acquisition of the lock to read from
 the plugin list and the usage of read-optimized
 spin-locks. Use only when plugin hook callback needs
 optimization (a lot of semi-sync replicas, for instance).
 --replication-sender-observe-commit-only 
 Optional flag that allows for only calling back observer
 hooks at commit.
 --report-host=name  Hostname or IP that this replica will report to the
 source while initiating the replication connection. Will
 appear in the output of SHOW REPLICAS. Leave this unset
 if you do not want the replica to register itself with
 the source. Note that it is not sufficient for the source
 to simply read the IP of the replica off the socket once
 the replica connects: in the presence of NAT other
 routing features, that IP may not be valid for connecting
 to the replica from the source or other hosts.
 --report-password=name 
 The account password that this replica will report to the
 source while initiating the replication connection.
 --report-port=#     The port for connecting to the replica, which this
 replica will report to the source while initiating the
 replication connection. Set it only if the replica is
 listening on a non-default port or if you have a special
 tunnel from the source or other clients to this replica.
 If not sure, leave this option unset.
 --report-user=name  The account user name that this replica will report to
 the source while initiating the replication connection.
 --require-secure-transport 
 When this option is enabled, connections attempted using
 insecure transport will be rejected.  Secure transports
 are SSL/TLS, Unix socket or Shared Memory (on Windows).
 --reset-seconds-behind-master 
 When TRUE reset Seconds_Behind_Master to 0 when SQL
 thread catches up to the IO thread. This is the original
 behavior but also causes reported lag to flip-flop
 between 0 and the real lag when the IO thread is the
 bottleneck.
 (Defaults to on; use --skip-reset-seconds-behind-master to disable.)
 --response-attrs-contain-hlc 
 If this is enabled, then the HLC timestamp of a RW
 transaction is sent back to clients as part of OK packet
 in session response attribute. HLC is sent as a key-value
 pair - 'hlc_ts' is the key and the value is the
 stringified HLC timestamp. Note that HLC should be
 enabled by setting enable_binlog_hlc
 --rocksdb[=name]    Enable or disable ROCKSDB plugin. Possible values are ON,
 OFF, FORCE (don't start if the plugin fails to load).
 --rocksdb-access-hint-on-compaction-start=# 
 DBOptions::access_hint_on_compaction_start for RocksDB
 --rocksdb-active-compaction-stats[=name] 
 Enable or disable ROCKSDB_ACTIVE_COMPACTION_STATS plugin.
 Possible values are ON, OFF, FORCE (don't start if the
 plugin fails to load).
 --rocksdb-advise-random-on-open 
 DBOptions::advise_random_on_open for RocksDB
 (Defaults to on; use --skip-rocksdb-advise-random-on-open to disable.)
 --rocksdb-allow-concurrent-memtable-write 
 DBOptions::allow_concurrent_memtable_write for RocksDB
 --rocksdb-allow-mmap-reads 
 DBOptions::allow_mmap_reads for RocksDB
 --rocksdb-allow-mmap-writes 
 DBOptions::allow_mmap_writes for RocksDB
 --rocksdb-allow-to-start-after-corruption 
 Allow server still to start successfully even if RocksDB
 corruption is detected.
 --rocksdb-blind-delete-primary-key 
 Deleting rows by primary key lookup, without reading rows
 (Blind Deletes). Blind delete is disabled if the table
 has secondary key
 --rocksdb-block-cache-size=# 
 block_cache size for RocksDB
 --rocksdb-block-restart-interval=# 
 BlockBasedTableOptions::block_restart_interval for
 RocksDB
 --rocksdb-block-size=# 
 BlockBasedTableOptions::block_size for RocksDB
 --rocksdb-block-size-deviation=# 
 BlockBasedTableOptions::block_size_deviation for RocksDB
 --rocksdb-bulk-load Use bulk-load mode for inserts. This disables
 unique_checks and enables rocksdb_commit_in_the_middle.
 --rocksdb-bulk-load-allow-sk 
 Allow bulk loading of sk keys during bulk-load. Can be
 changed only when bulk load is disabled.
 --rocksdb-bulk-load-allow-unsorted 
 Allow unsorted input during bulk-load. Can be changed
 only when bulk load is disabled.
 --rocksdb-bulk-load-size=# 
 Max #records in a batch for bulk-load mode
 --rocksdb-bypass-rejected-query-history[=name] 
 Enable or disable ROCKSDB_BYPASS_REJECTED_QUERY_HISTORY
 plugin. Possible values are ON, OFF, FORCE (don't start
 if the plugin fails to load).
 --rocksdb-bytes-per-sync=# 
 DBOptions::bytes_per_sync for RocksDB
 --rocksdb-cache-dump 
 Include RocksDB block cache content in core dump.
 (Defaults to on; use --skip-rocksdb-cache-dump to disable.)
 --rocksdb-cache-high-pri-pool-ratio=# 
 Specify the size of block cache high-pri pool
 --rocksdb-cache-index-and-filter-blocks 
 BlockBasedTableOptions::cache_index_and_filter_blocks for
 RocksDB
 (Defaults to on; use --skip-rocksdb-cache-index-and-filter-blocks to disable.)
 --rocksdb-cache-index-and-filter-with-high-priority 
 cache_index_and_filter_blocks_with_high_priority for
 RocksDB
 (Defaults to on; use --skip-rocksdb-cache-index-and-filter-with-high-priority to disable.)
 --rocksdb-cf-options[=name] 
 Enable or disable ROCKSDB_CF_OPTIONS plugin. Possible
 values are ON, OFF, FORCE (don't start if the plugin
 fails to load).
 --rocksdb-cfstats[=name] 
 Enable or disable ROCKSDB_CFSTATS plugin. Possible values
 are ON, OFF, FORCE (don't start if the plugin fails to
 load).
 --rocksdb-checksums-pct=# 
 How many percentages of rows to be checksummed
 --rocksdb-collect-sst-properties 
 Enables collecting SST file properties on each flush
 (Defaults to on; use --skip-rocksdb-collect-sst-properties to disable.)
 --rocksdb-commit-in-the-middle 
 Commit rows implicitly every rocksdb_bulk_load_size, on
 bulk load/insert, update and delete
 --rocksdb-commit-time-batch-for-recovery 
 TransactionOptions::commit_time_batch_for_recovery for
 RocksDB
 (Defaults to on; use --skip-rocksdb-commit-time-batch-for-recovery to disable.)
 --rocksdb-compact-cf=name 
 Compact column family
 --rocksdb-compaction-history[=name] 
 Enable or disable ROCKSDB_COMPACTION_HISTORY plugin.
 Possible values are ON, OFF, FORCE (don't start if the
 plugin fails to load).
 --rocksdb-compaction-readahead-size=# 
 DBOptions::compaction_readahead_size for RocksDB
 --rocksdb-compaction-sequential-deletes=# 
 RocksDB will trigger compaction for the file if it has
 more than this number sequential deletes per window
 --rocksdb-compaction-sequential-deletes-count-sd 
 Counting SingleDelete as
 rocksdb_compaction_sequential_deletes
 --rocksdb-compaction-sequential-deletes-file-size=# 
 Minimum file size required for
 compaction_sequential_deletes
 --rocksdb-compaction-sequential-deletes-window=# 
 Size of the window for counting
 rocksdb_compaction_sequential_deletes
 --rocksdb-compaction-stats[=name] 
 Enable or disable ROCKSDB_COMPACTION_STATS plugin.
 Possible values are ON, OFF, FORCE (don't start if the
 plugin fails to load).
 --rocksdb-create-checkpoint=name 
 Checkpoint directory
 --rocksdb-create-if-missing 
 DBOptions::create_if_missing for RocksDB
 (Defaults to on; use --skip-rocksdb-create-if-missing to disable.)
 --rocksdb-create-missing-column-families 
 DBOptions::create_missing_column_families for RocksDB
 --rocksdb-datadir[=name] 
 RocksDB data directory
 --rocksdb-db-write-buffer-size=# 
 DBOptions::db_write_buffer_size for RocksDB
 --rocksdb-dbstats[=name] 
 Enable or disable ROCKSDB_DBSTATS plugin. Possible values
 are ON, OFF, FORCE (don't start if the plugin fails to
 load).
 --rocksdb-ddl[=name] 
 Enable or disable ROCKSDB_DDL plugin. Possible values are
 ON, OFF, FORCE (don't start if the plugin fails to load).
 --rocksdb-deadlock[=name] 
 Enable or disable ROCKSDB_DEADLOCK plugin. Possible
 values are ON, OFF, FORCE (don't start if the plugin
 fails to load).
 --rocksdb-deadlock-detect 
 Enables deadlock detection
 --rocksdb-deadlock-detect-depth=# 
 Number of transactions deadlock detection will traverse
 through before assuming deadlock
 --rocksdb-debug-cardinality-multiplier=# 
 Cardinality multiplier used in tests
 --rocksdb-debug-manual-compaction-delay=# 
 For debugging purposes only. Sleeping specified seconds
 for simulating long running compactions.
 --rocksdb-debug-optimizer-n-rows=# 
 Test only to override rocksdb estimates of table size in
 a memtable
 --rocksdb-debug-optimizer-no-zero-cardinality 
 In case if cardinality is zero, overrides it with some
 value
 (Defaults to on; use --skip-rocksdb-debug-optimizer-no-zero-cardinality to disable.)
 --rocksdb-debug-ttl-ignore-pk 
 For debugging purposes only. If true, compaction
 filtering will not occur on PK TTL data. This variable is
 a no-op in non-debug builds.
 --rocksdb-debug-ttl-read-filter-ts=# 
 For debugging purposes only.  Overrides the TTL read
 filtering time to time + debug_ttl_read_filter_ts. A
 value of 0 denotes that the variable is not set. This
 variable is a no-op in non-debug builds.
 --rocksdb-debug-ttl-rec-ts=# 
 For debugging purposes only.  Overrides the TTL of
 records to now() + debug_ttl_rec_ts.  The value can be
 +/- to simulate a record inserted in the past vs a record
 inserted in the 'future'. A value of 0 denotes that the
 variable is not set. This variable is a no-op in
 non-debug builds.
 --rocksdb-debug-ttl-snapshot-ts=# 
 For debugging purposes only.  Sets the snapshot during
 compaction to now() + debug_set_ttl_snapshot_ts.  The
 value can be +/- to simulate a snapshot in the past vs a
 snapshot created in the 'future'. A value of 0 denotes
 that the variable is not set. This variable is a no-op in
 non-debug builds.
 --rocksdb-default-cf-options=name 
 default cf options for RocksDB
 --rocksdb-delayed-write-rate=# 
 DBOptions::delayed_write_rate
 --rocksdb-delete-cf=name 
 Delete column family
 --rocksdb-delete-obsolete-files-period-micros=# 
 DBOptions::delete_obsolete_files_period_micros for
 RocksDB
 --rocksdb-disable-file-deletions 
 Prevent file deletions
 --rocksdb-enable-2pc 
 Enable two phase commit for MyRocks
 (Defaults to on; use --skip-rocksdb-enable-2pc to disable.)
 --rocksdb-enable-bulk-load-api 
 Enables using SstFileWriter for bulk loading
 (Defaults to on; use --skip-rocksdb-enable-bulk-load-api to disable.)
 --rocksdb-enable-insert-with-update-caching 
 Whether to enable optimization where we cache the read
 from a failed insertion attempt in INSERT ON DUPLICATE
 KEY UPDATE
 (Defaults to on; use --skip-rocksdb-enable-insert-with-update-caching to disable.)
 --rocksdb-enable-iterate-bounds 
 Enable rocksdb iterator upper/lower bounds in read
 options.
 (Defaults to on; use --skip-rocksdb-enable-iterate-bounds to disable.)
 --rocksdb-enable-remove-orphaned-dropped-cfs 
 Enables removing dropped cfs from metadata if it doesn't
 exist in cf manager
 (Defaults to on; use --skip-rocksdb-enable-remove-orphaned-dropped-cfs to disable.)
 --rocksdb-enable-thread-tracking 
 DBOptions::enable_thread_tracking for RocksDB
 (Defaults to on; use --skip-rocksdb-enable-thread-tracking to disable.)
 --rocksdb-enable-ttl 
 Enable expired TTL records to be dropped during
 compaction.
 (Defaults to on; use --skip-rocksdb-enable-ttl to disable.)
 --rocksdb-enable-ttl-read-filtering 
 For tables with TTL, expired records are skipped/filtered
 out during processing and in query results. Disabling
 this will allow these records to be seen, but as a result
 rows may disappear in the middle of transactions as they
 are dropped during compaction. Use with caution.
 (Defaults to on; use --skip-rocksdb-enable-ttl-read-filtering to disable.)
 --rocksdb-enable-write-thread-adaptive-yield 
 DBOptions::enable_write_thread_adaptive_yield for RocksDB
 --rocksdb-error-if-exists 
 DBOptions::error_if_exists for RocksDB
 --rocksdb-error-on-suboptimal-collation 
 Raise an error instead of warning if a sub-optimal
 collation is used
 (Defaults to on; use --skip-rocksdb-error-on-suboptimal-collation to disable.)
 --rocksdb-fault-injection-options=name 
 Fault injection options for running rocksdb tests
 --rocksdb-flush-log-at-trx-commit=# 
 Sync on transaction commit. Similar to
 innodb_flush_log_at_trx_commit. 1: sync on commit, 0,2:
 not sync on commit
 --rocksdb-force-compute-memtable-stats 
 Force to always compute memtable stats
 (Defaults to on; use --skip-rocksdb-force-compute-memtable-stats to disable.)
 --rocksdb-force-compute-memtable-stats-cachetime=# 
 Time in usecs to cache memtable estimates
 --rocksdb-force-flush-memtable-and-lzero-now 
 Acts similar to force_flush_memtable_now, but also
 compacts all L0 files.
 --rocksdb-force-flush-memtable-now 
 Forces memstore flush which may block all write requests
 so be careful
 (Defaults to on; use --skip-rocksdb-force-flush-memtable-now to disable.)
 --rocksdb-force-index-records-in-range=# 
 Used to override the result of records_in_range() when
 FORCE INDEX is used.
 --rocksdb-global-info[=name] 
 Enable or disable ROCKSDB_GLOBAL_INFO plugin. Possible
 values are ON, OFF, FORCE (don't start if the plugin
 fails to load).
 --rocksdb-ignore-unknown-options 
 Enable ignoring unknown options passed to RocksDB
 (Defaults to on; use --skip-rocksdb-ignore-unknown-options to disable.)
 --rocksdb-index-file-map[=name] 
 Enable or disable ROCKSDB_INDEX_FILE_MAP plugin. Possible
 values are ON, OFF, FORCE (don't start if the plugin
 fails to load).
 --rocksdb-index-type=name 
 BlockBasedTableOptions::index_type for RocksDB
 --rocksdb-info-log-level=name 
 Filter level for info logs to be written mysqld error
 log. Valid values include 'debug_level', 'info_level',
 'warn_level''error_level' and 'fatal_level'.
 --rocksdb-io-write-timeout=# 
 Timeout for experimental I/O watchdog.
 --rocksdb-is-fd-close-on-exec 
 DBOptions::is_fd_close_on_exec for RocksDB
 (Defaults to on; use --skip-rocksdb-is-fd-close-on-exec to disable.)
 --rocksdb-keep-log-file-num=# 
 DBOptions::keep_log_file_num for RocksDB
 --rocksdb-large-prefix 
 Support large index prefix length of 3072 bytes. If off,
 the maximum index prefix length is 767.
 --rocksdb-lock-scanned-rows 
 Take and hold locks on rows that are scanned but not
 updated
 --rocksdb-lock-wait-timeout=# 
 Number of seconds to wait for lock
 --rocksdb-locks[=name] 
 Enable or disable ROCKSDB_LOCKS plugin. Possible values
 are ON, OFF, FORCE (don't start if the plugin fails to
 load).
 --rocksdb-log-file-time-to-roll=# 
 DBOptions::log_file_time_to_roll for RocksDB
 --rocksdb-manifest-preallocation-size=# 
 DBOptions::manifest_preallocation_size for RocksDB
 --rocksdb-manual-compaction-threads=# 
 How many rocksdb threads to run for manual compactions
 --rocksdb-manual-wal-flush 
 DBOptions::manual_wal_flush for RocksDB
 (Defaults to on; use --skip-rocksdb-manual-wal-flush to disable.)
 --rocksdb-master-skip-tx-api 
 Skipping holding any lock on row access. Not effective on
 slave.
 --rocksdb-max-background-compactions=# 
 DBOptions::max_background_compactions for RocksDB
 --rocksdb-max-background-flushes=# 
 DBOptions::max_background_flushes for RocksDB
 --rocksdb-max-background-jobs=# 
 DBOptions::max_background_jobs for RocksDB
 --rocksdb-max-bottom-pri-background-compactions=# 
 Creating specified number of threads, setting lower CPU
 priority, and letting Lmax compactions use them. Maximum
 total compaction concurrency continues to be capped to
 rocksdb_max_background_compactions or
 rocksdb_max_background_jobs. In addition to that, Lmax
 compaction concurrency is capped to
 rocksdb_max_bottom_pri_background_compactions. Default
 value is 0, which means all compactions are under
 concurrency of rocksdb_max_background_compactions|jobs.
 If you set very low
 rocksdb_max_bottom_pri_background_compactions (e.g. 1 or
 2), compactions may not be able to keep up. Since Lmax
 normally has 90 percent of data, it is recommended to set
 closer number to rocksdb_max_background_compactions|jobs.
 This option is helpful to give more CPU resources to
 other threads (e.g. query processing).
 --rocksdb-max-compaction-history[=#] 
 Track history for at most this many completed
 compactions. The history is in the
 INFORMATION_SCHEMA.ROCKSDB_COMPACTION_HISTORY table.
 --rocksdb-max-latest-deadlocks=# 
 Maximum number of recent deadlocks to store
 --rocksdb-max-log-file-size=# 
 DBOptions::max_log_file_size for RocksDB
 --rocksdb-max-manifest-file-size=# 
 DBOptions::max_manifest_file_size for RocksDB
 --rocksdb-max-manual-compactions=# 
 Maximum number of pending + ongoing number of manual
 compactions.
 --rocksdb-max-open-files=# 
 DBOptions::max_open_files for RocksDB
 --rocksdb-max-row-locks=# 
 Maximum number of locks a transaction can have
 --rocksdb-max-subcompactions=# 
 DBOptions::max_subcompactions for RocksDB
 --rocksdb-max-total-wal-size=# 
 DBOptions::max_total_wal_size for RocksDB
 --rocksdb-merge-buf-size=# 
 Size to allocate for merge sort buffers written out to
 disk during inplace index creation.
 --rocksdb-merge-combine-read-size=# 
 Size that we have to work with during combine (reading
 from disk) phase of external sort during fast index
 creation.
 --rocksdb-merge-tmp-file-removal-delay-ms=# 
 Fast index creation creates a large tmp file on disk
 during index creation.  Removing this large file all at
 once when index creation is complete can cause trim
 stalls on Flash.  This variable specifies a duration to
 sleep (in milliseconds) between calling chsize() to
 truncate the file in chunks.  The chunk size is  the same
 as merge_buf_size.
 --rocksdb-mrr-batch-size=# 
 maximum number of keys to fetch during each MRR
 --rocksdb-no-block-cache 
 BlockBasedTableOptions::no_block_cache for RocksDB
 --rocksdb-override-cf-options=name 
 option overrides per cf for RocksDB
 --rocksdb-paranoid-checks 
 DBOptions::paranoid_checks for RocksDB
 (Defaults to on; use --skip-rocksdb-paranoid-checks to disable.)
 --rocksdb-pause-background-work 
 Disable all rocksdb background operations
 --rocksdb-perf-context[=name] 
 Enable or disable ROCKSDB_PERF_CONTEXT plugin. Possible
 values are ON, OFF, FORCE (don't start if the plugin
 fails to load).
 --rocksdb-perf-context-global[=name] 
 Enable or disable ROCKSDB_PERF_CONTEXT_GLOBAL plugin.
 Possible values are ON, OFF, FORCE (don't start if the
 plugin fails to load).
 --rocksdb-perf-context-level=# 
 Perf Context Level for rocksdb internal timer stat
 collection
 --rocksdb-persistent-cache-path=name 
 Path for BlockBasedTableOptions::persistent_cache for
 RocksDB
 --rocksdb-persistent-cache-size-mb=# 
 Size of cache in MB for
 BlockBasedTableOptions::persistent_cache for RocksDB
 --rocksdb-pin-l0-filter-and-index-blocks-in-cache 
 pin_l0_filter_and_index_blocks_in_cache for RocksDB
 (Defaults to on; use --skip-rocksdb-pin-l0-filter-and-index-blocks-in-cache to disable.)
 --rocksdb-print-snapshot-conflict-queries 
 Logging queries that got snapshot conflict errors into
 *.err log
 --rocksdb-rate-limiter-bytes-per-sec=# 
 DBOptions::rate_limiter bytes_per_sec for RocksDB
 --rocksdb-read-free-rpl=name 
 Use read-free replication on the slave (i.e. no row
 lookup during replication). Default is OFF, PK_SK will
 enable it on all tables with primary key. PK_ONLY will
 enable it on tables where the only key is the primary key
 (i.e. no secondary keys).
 --rocksdb-read-free-rpl-tables=name 
 List of tables that will use read-free replication on the
 slave (i.e. not lookup a row during replication)
 --rocksdb-records-in-range=# 
 Used to override the result of records_in_range(). Set to
 a positive number to override
 --rocksdb-reset-stats 
 Reset the RocksDB internal statistics without restarting
 the DB.
 --rocksdb-rollback-on-timeout 
 Whether to roll back the complete transaction or a single
 statement on lock wait timeout (a single statement by
 default)
 --rocksdb-seconds-between-stat-computes=# 
 Sets a number of seconds to wait between optimizer stats
 recomputation. Only changed indexes will be refreshed.
 --rocksdb-select-bypass-allow-filters 
 Allow non-optimal filters in SELECT bypass queries
 (Defaults to on; use --skip-rocksdb-select-bypass-allow-filters to disable.)
 --rocksdb-select-bypass-debug-row-delay=# 
 Test only to inject delays in bypass select to simulate
 long queries for each row sent
 --rocksdb-select-bypass-fail-unsupported 
 Select bypass would fail for unsupported SELECT commands
 (Defaults to on; use --skip-rocksdb-select-bypass-fail-unsupported to disable.)
 --rocksdb-select-bypass-log-failed 
 Log failed SELECT bypass queries
 --rocksdb-select-bypass-log-rejected 
 Log rejected SELECT bypass queries
 (Defaults to on; use --skip-rocksdb-select-bypass-log-rejected to disable.)
 --rocksdb-select-bypass-multiget-min=# 
 Minimum number of items to use RocksDB MultiGet API.
 Default is SIZE_T_MAX meaning it is turned off. Set to 0
 to enable always using MultiGet
 --rocksdb-select-bypass-policy=name 
 Change bypass SELECT related policy and allow directly
 talk to RocksDB. Valid values include 'always_off',
 'always_on', 'opt_in', 'opt_out'. 
 --rocksdb-select-bypass-rejected-query-history-size=# 
 History size of rejected bypass queries in
 information_schema.bypass_rejected_query_history. Set to
 0 to turn off
 --rocksdb-signal-drop-index-thread 
 Wake up drop index thread
 --rocksdb-sim-cache-size=# 
 Simulated cache size for RocksDB
 --rocksdb-skip-bloom-filter-on-read 
 Skip using bloom filter for reads
 --rocksdb-skip-fill-cache 
 Skip filling block cache on read requests
 --rocksdb-skip-locks-if-skip-unique-check 
 Skip row locking when unique checks are disabled.
 --rocksdb-sst-mgr-rate-bytes-per-sec=# 
 DBOptions::sst_file_manager rate_bytes_per_sec for
 RocksDB
 --rocksdb-sst-props[=name] 
 Enable or disable ROCKSDB_SST_PROPS plugin. Possible
 values are ON, OFF, FORCE (don't start if the plugin
 fails to load).
 --rocksdb-stats-dump-period-sec=# 
 DBOptions::stats_dump_period_sec for RocksDB
 --rocksdb-stats-level=# 
 Statistics Level for RocksDB. Default is 1
 (kExceptHistogramOrTimers)
 --rocksdb-stats-recalc-rate=# 
 The number of indexes per second to recalculate
 statistics for. 0 to disable background recalculation.
 --rocksdb-store-row-debug-checksums 
 Include checksums when writing index/table records
 --rocksdb-strict-collation-check 
 Enforce case sensitive collation for MyRocks indexes
 (Defaults to on; use --skip-rocksdb-strict-collation-check to disable.)
 --rocksdb-strict-collation-exceptions=name 
 List of tables (using regex) that are excluded from the
 case sensitive collation enforcement
 --rocksdb-table-cache-numshardbits=# 
 DBOptions::table_cache_numshardbits for RocksDB
 --rocksdb-table-stats-background-thread-nice-value=# 
 nice value for index stats
 --rocksdb-table-stats-max-num-rows-scanned=# 
 The maximum number of rows to scan in table scan based
 cardinality calculation
 --rocksdb-table-stats-recalc-threshold-count=# 
 Number of modified rows to trigger stats recalculation
 --rocksdb-table-stats-recalc-threshold-pct=# 
 Percentage of number of modified rows over total number
 of rows to trigger stats recalculation
 --rocksdb-table-stats-sampling-pct=# 
 Percentage of entries to sample when collecting
 statistics about table properties. Specify either 0 to
 sample everything or percentage [1..100]. By default 10%
 of entries are sampled.
 --rocksdb-table-stats-use-table-scan 
 Enable table scan based index calculation.
 --rocksdb-tmpdir[=name] 
 Directory for temporary files during DDL operations.
 --rocksdb-trace-block-cache-access=name 
 Block cache trace option string. The format is
 sampling_frequency:max_trace_file_size:trace_file_name.
 sampling_frequency and max_trace_file_size are positive
 integers. The block accesses are saved to the
 rocksdb_datadir/block_cache_traces/trace_file_name.
 --rocksdb-trace-sst-api 
 Generate trace output in the log for each call to the
 SstFileWriter
 --rocksdb-track-and-verify-wals-in-manifest 
 DBOptions::track_and_verify_wals_in_manifest for RocksDB
 (Defaults to on; use --skip-rocksdb-track-and-verify-wals-in-manifest to disable.)
 --rocksdb-trx[=name] 
 Enable or disable ROCKSDB_TRX plugin. Possible values are
 ON, OFF, FORCE (don't start if the plugin fails to load).
 --rocksdb-two-write-queues 
 DBOptions::two_write_queues for RocksDB
 (Defaults to on; use --skip-rocksdb-two-write-queues to disable.)
 --rocksdb-unsafe-for-binlog 
 Allowing statement based binary logging which may break
 consistency
 --rocksdb-update-cf-options=name 
 Option updates per column family for RocksDB
 --rocksdb-use-adaptive-mutex 
 DBOptions::use_adaptive_mutex for RocksDB
 --rocksdb-use-clock-cache 
 Use ClockCache instead of default LRUCache for RocksDB
 --rocksdb-use-default-sk-cf 
 Use default_sk for secondary keys
 --rocksdb-use-direct-io-for-flush-and-compaction 
 DBOptions::use_direct_io_for_flush_and_compaction for
 RocksDB
 --rocksdb-use-direct-reads 
 DBOptions::use_direct_reads for RocksDB
 --rocksdb-use-fsync DBOptions::use_fsync for RocksDB
 --rocksdb-validate-tables=# 
 Verify all DD tables match all RocksDB tables (0 means no
 verification, 1 means verify and fail on error, and 2
 means verify but continue
 --rocksdb-verify-row-debug-checksums 
 Verify checksums when reading index/table records
 --rocksdb-wal-bytes-per-sync=# 
 DBOptions::wal_bytes_per_sync for RocksDB
 --rocksdb-wal-dir=name 
 DBOptions::wal_dir for RocksDB
 --rocksdb-wal-recovery-mode=# 
 DBOptions::wal_recovery_mode for RocksDB. Default is
 kPointInTimeRecovery
 --rocksdb-wal-size-limit-mb=# 
 DBOptions::WAL_size_limit_MB for RocksDB
 --rocksdb-wal-ttl-seconds=# 
 DBOptions::WAL_ttl_seconds for RocksDB
 --rocksdb-whole-key-filtering 
 BlockBasedTableOptions::whole_key_filtering for RocksDB
 (Defaults to on; use --skip-rocksdb-whole-key-filtering to disable.)
 --rocksdb-write-batch-max-bytes=# 
 Maximum size of write batch in bytes. 0 means no limit.
 --rocksdb-write-disable-wal 
 WriteOptions::disableWAL for RocksDB
 --rocksdb-write-ignore-missing-column-families 
 WriteOptions::ignore_missing_column_families for RocksDB
 --rocksdb-write-policy=name 
 DBOptions::write_policy for RocksDB
 --rocksdb-wsenv-path=name 
 Path for RocksDB WSEnv
 --rpl-read-size=#   The size for reads done from the binlog and relay log. It
 must be a multiple of 4kb. Making it larger might help
 with IO stalls while reading these files when they are
 not in the OS buffer cache
 --rpl-receive-buffer-size=# 
 The size of input buffer for the socket used during
 receving events from a master.
 --rpl-send-buffer-size=# 
 The size of output buffer for the socket used during
 sending events to a slave.
 --rpl-skip-tx-api   Use write batches for replication thread instead of tx
 api
 --rpl-slave-flow-control 
 If this is set then underrun and overrun based flow
 control between coordinator and worker threads in slave
 instance will be enabled. Does not affect master instance
 (Defaults to on; use --skip-rpl-slave-flow-control to disable.)
 --rpl-stop-replica-timeout=# 
 Timeout in seconds to wait for replication threads to
 stop, before STOP REPLICA returns a warning.
 --rpl-stop-slave-timeout=# 
 This option is deprecated. Use rpl_stop_replica_timeout
 instead.
 --rpl-wait-for-semi-sync-ack 
 Wait for events to be acked by a semi-sync slave before
 sending them to the async slaves
 --safe-user-create  Don't allow new user creation by the user who has no
 write privileges to the mysql.user table.
 --schema-definition-cache=# 
 The number of cached schema definitions
 --secondary-engine-cost-threshold[=#] 
 Controls which statements to consider for execution in a
 secondary storage engine. Only statements that have a
 cost estimate higher than this value will be attempted
 executed in a secondary storage engine.
 --secure-file-priv=name 
 Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to
 files within specified directory
 --select-into-buffer-size[=#] 
 Buffer size for SELECT INTO OUTFILE/DUMPFILE.
 --select-into-disk-sync 
 Synchronize flushed buffer with disk for SELECT INTO
 OUTFILE/DUMPFILE.
 --select-into-disk-sync-delay[=#] 
 The delay in milliseconds after each buffer sync for
 SELECT INTO OUTFILE/DUMPFILE. Requires
 select_into_sync_disk = ON.
 --select-into-file-fsync-size[=#] 
 Do an fsync to disk when the buffer grows by these many
 bytes for SELECT INTO OUTFILE. Set 0 to disable.
 --select-into-file-fsync-timeout[=#] 
 The timeout/sleep in milliseconds after each fsync with
 SELECT INTO OUTFILE
 --send-error-before-closing-timed-out-connection 
 Send error before closing connections due to timeout.
 (Defaults to on; use --skip-send-error-before-closing-timed-out-connection to disable.)
 --serialize-fb-json-raise-error 
 Raise an error if the query tries to serialize legacy
 json values from FB json functions.
 --server-id=#       Uniquely identifies the server instance in the community
 of replication partners
 --server-id-bits=#  Set number of significant bits in server-id
 --session-track-gtids=name 
 Controls the amount of global transaction ids to be
 included in the response packet sent by the
 server.(Default: OFF).
 --session-track-response-attributes 
 Track response attribute'.
 --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).
 --sha256-password-proxy-users 
 If set to FALSE (the default), then the sha256_password
 authentication plugin will not signal for authenticated
 users to be checked for mapping to proxy users.  When set
 to TRUE, the plugin will flag associated authenticated
 accounts to be mapped to proxy users when the server
 option check_proxy_users is enabled.
 --show-create-table-verbosity 
 When this option is enabled, it increases the verbosity
 of 'SHOW CREATE TABLE'.
 --show-old-temporals 
 When this option is enabled, the pre-5.6.4 temporal types
 will be marked in the 'SHOW CREATE TABLE' and
 'INFORMATION_SCHEMA.COLUMNS' table as a comment in
 COLUMN_TYPE field. This variable is deprecated and will
 be removed in a future release.
 --show-replica-auth-info 
 Include user and password in SHOW REPLICAS statements.
 --show-slave-auth-info 
 This option is deprecated and will be removed in a future
 version. Use show-replica-auth-info instead.
 --skip-core-dump-on-error 
 If set, MySQL skips dumping the core if it hits an error
 (e.g,IO)
 (Defaults to on; use --skip-skip-core-dump-on-error to disable.)
 --skip-flush-master-info 
 Increase performance by not flushing the master info on
 each replica event
 --skip-flush-relay-worker-info 
 Increase performance by not flushing the relay/worker
 info on each replica transaction
 --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-master-info-check-for-read-only-error-msg-extra 
 Skip master info validaton check for read only error
 messages
 --skip-name-resolve Don't resolve hostnames. All hostnames are IP's or
 'localhost'.
 --skip-networking   Don't allow connection with TCP/IP
 --skip-new          Don't use new, possibly wrong routines.
 --skip-replica-start 
 Do not start replication threads automatically when the
 server starts.
 --skip-show-database 
 Don't allow 'SHOW DATABASE' commands
 --skip-slave-start  This option is deprecated. Use skip_replica_start
 instead.
 --skip-stack-trace  Don't print a stack trace on failure.
 --slave-allow-batching 
 This option is deprecated. Use replica_allow_batching
 instead.
 --slave-check-before-image-consistency[=name] 
 On the slave, when using row based replication, check if
 the before images of relay logs match the database state
 before applying row changes. After the check either just
 count the inconsistencies (COUNT) in a status var
 (Slave_before_image_inconsistencies) or in addition to
 that stop the slave (ON). Default OFF.
 --slave-checkpoint-group=# 
 This option is deprecated. Use replica_checkpoint_group
 instead.
 --slave-checkpoint-period=# 
 This option is deprecated. Use replica_checkpoint_period
 instead.
 --slave-compressed-protocol 
 This option is deprecated. Use
 replica_compressed_protocol instead.
 --slave-compression-lib[=name] 
 Compression library for replication stream. 0 is zlib, 1
 is zstd, 2 is zstd_stream, 3 is lz4f_stream.
 --slave-dump-thread-wait-sleep-usec[=#] 
 Time (in microsecs) to sleep on the master's dump thread
 before waiting for new data on the latest binlog.
 --slave-exec-mode=name 
 This option is deprecated. Use replica_exec_mode instead.
 --slave-high-priority-ddl 
 Setting this flag will allow DDL commands to kill
 conflictingconnections during replication (effective for
 admin user only).
 --slave-high-priority-lock-wait-timeout=# 
 Timeout in seconds to wait for a lock before returning an
 error. This timeout is specifically for high_priority
 commands (DDLs), when the slave_high_priority_ddl
 variable is turned on. The argument will be treated as a
 decimal value with nanosecond precision.
 --slave-load-tmpdir=name 
 This option is deprecated. Use replica_load_tmpdir
 instead.
 --slave-max-allowed-packet=# 
 This option is deprecated. Use replica_max_allowed_packet
 instead.
 --slave-net-timeout=# 
 This option is deprecated. Use replica_net_timeout
 instead.
 --slave-parallel-type=name 
 This option is deprecated. Use replica_parallel_type
 instead.
 --slave-parallel-workers=# 
 This option is deprecated. Use replica_parallel_workers
 instead.
 --slave-pending-jobs-size-max=# 
 This option is deprecated. Use
 replica_pending_jobs_size_max instead.
 --slave-preserve-commit-order 
 This option is deprecated. Use
 replica_preserve_commit_order instead.
 (Defaults to on; use --skip-slave-preserve-commit-order to disable.)
 --slave-rows-search-algorithms=name 
 The set of algorithms used by the replication applier
 while searching the table for rows to update or delete.
 Possible values are: INDEX_SCAN, TABLE_SCAN and
 HASH_SCAN. Any combination is allowed, and the applier
 picks the most efficient among them for any given
 scenario. (Default: INDEX_SCAN, HASH_SCAN).
 --slave-run-triggers-for-rbr=name 
 Modes for how triggers in row-base replication on slave
 side will be executed. Legal values are NO (default), YES
 and LOGGING. NO means that trigger for RBR will not be
 running on slave. YES and LOGGING means that triggers
 will be running on slave, if there was not triggers
 running on the master for the statement. LOGGING also
 means results of that the executed triggers work will be
 written to the binlog.
 --slave-skip-errors=name 
 This option is deprecated. Use replica_skip_errors
 instead.
 --slave-sql-verify-checksum 
 This option is deprecated. Use
 replica_sql_verify_checksum instead.
 (Defaults to on; use --skip-slave-sql-verify-checksum to disable.)
 --slave-transaction-retries=# 
 This option is deprecated. Use
 replica_transaction_retries instead.
 --slave-tx-isolation=name 
 Slave thread transaction isolation level
 --slave-type-conversions=name 
 This option is deprecated. Use replica_type_conversions
 instead.
 --slave-use-idempotent-for-recovery=name 
 Modes for how replication events should be executed
 during recovery. Legal values are NO (default) and YES.
 YES means replication will not stop for operations that
 are idempotent. Note that binlog format must be ROW and
 GTIDs should be enabled for this option to have effect.
 --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
 --slowlog-space-limit=# 
 Maximum space to use for all slow query logs. Works only
 with max_slowlog_size enabled. Default is 0, this feature
 is disabled.
 --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
 --source-verify-checksum 
 Force checksum verification of events in binary log
 before sending them to replicas or printing them in
 output of SHOW BINLOG EVENTS. Disabled by default.
 --sporadic-binlog-dump-fail 
 Option used by mysql-test for debugging and testing of
 replication.
 --sql-log-bin-triggers 
 The row changes generated by execution of triggers are
 not logged inbinlog if this option is false.
 (Defaults to on; use --skip-sql-log-bin-triggers to disable.)
 --sql-mode=name     Syntax: sql-mode=mode[,mode[,mode...]]. See the manual
 for the complete list of valid sql modes
 --sql-require-primary-key 
 When set, tables must be created with a primary key, and
 an existing primary key cannot be removed with 'ALTER
 TABLE'. Attempts to do so will result in an error.
 --stored-program-cache=# 
 The soft upper limit for number of cached stored routines
 for one connection.
 --stored-program-definition-cache=# 
 The number of cached stored program definitions
 --super-read-only   Make all non-temporary tables read-only, with the
 exception for replication applier threads.  Users with
 the SUPER privilege are affected, unlike read_only. 
 Setting super_read_only to ON also sets read_only to ON.
 -s, --symbolic-links 
 Enable symbolic link support (deprecated and will be 
 removed in a future release).
 --sync-binlog=#     Synchronously flush binary log to disk after every #th
 write to the file. Use 0 to disable synchronous flushing
 --sync-master-info=# 
 This option is deprecated. Use sync_source_info instead.
 --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
 --sync-source-info=# 
 Synchronize replication receiver positions to disk
 periodically, after the specified number of events. Use 0
 to disable periodic synchronization.
 --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.
 --table-definition-cache=# 
 The number of cached table definitions
 --table-encryption-privilege-check 
 Indicates if server enables privilege check when user
 tries to use non-default value for CREATE DATABASE or
 CREATE TABLESPACE or when user tries to do CREATE TABLE
 with ENCRYPTION option which deviates from per-database
 default.
 --table-open-cache=# 
 The number of cached open tables (total for all table
 cache instances)
 --table-open-cache-instances=# 
 The number of table cache instances
 --tablespace-definition-cache=# 
 The number of cached tablespace definitions
 --tc-heuristic-recover=name 
 Decision to use in heuristic recover process. Possible
 values are OFF, COMMIT or ROLLBACK.
 --temptable-max-mmap=# 
 Maximum amount of memory (in bytes) the TempTable storage
 engine is allowed to allocate from MMAP-backed files
 before starting to store data on disk.
 --temptable-max-ram=# 
 Maximum amount of memory (in bytes) the TempTable storage
 engine is allowed to allocate from the main memory (RAM)
 before starting to store data on disk.
 --temptable-use-mmap 
 Use mmap files for temptables. This variable is
 deprecated and will be removed in a future release.
 (Defaults to on; use --skip-temptable-use-mmap to disable.)
 --terminology-use-previous=name 
 Make monitoring tables and statements use the identifiers
 that were in use before they were changed in a given
 release. That includes names for mutexes, read/write
 locks, condition variables, memory allocations, thread
 names, thread stages, and thread commands. When the
 session option is set to BEFORE_8_0_26, the session uses
 the names that were in use until 8.0.25, when it selects
 from performance_schema tables, or selects from
 INFORMATION_SCHEMA.PROCESSLIST, or issues SHOW
 PROCESSLIST or SHOW REPLICA STATUS. When the global
 option is set to BEFORE_8_0_26, new sessions use
 BEFORE_8_0_26 as default for the session option, and in
 addition the thread commands that were in use until
 8.0.25 are written to the slow query log.
 --thread-cache-size=# 
 How many threads we should keep in a cache for reuse
 --thread-handling=name 
 Define threads usage for handling queries, one of
 one-thread-per-connection, no-threads, loaded-dynamically
 --thread-stack=#    The stack size for each thread
 --tls-ciphersuites=name 
 --tmp-table-size=#  If an internal in-memory temporary table in the MEMORY or
 TempTable storage engine exceeds this size, MySQL will
 automatically convert it to an on-disk 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.
 --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.
 --transaction-write-set-extraction[=name] 
 This option is used to let the server know when to
 extract the write set which will be used for various
 purposes. 
 --trim-binlog-to-recover 
 Trim the last binlog (if required) to the position until
 which the engine has successfully committed all
 transactions.
 --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)
 --update-binlog-pos-threshold=# 
 Storage engine updates its binlog positions when its
 current position falls behind by # bytes
 --upgrade=name      Set server upgrade mode. NONE to abort server if
 automatic upgrade of the server is needed; MINIMAL to
 start the server, but skip upgrade steps that are not
 absolutely necessary; AUTO (default) to upgrade the
 server if required; FORCE to force upgrade server.
 --use-fb-json-functions=name 
 Use legacy behavior of FB json functions implemented in
 5.6
 -u, --user=name     Run mysqld daemon as user.
 --validate-config   Validate the server configuration specified by the user.
 --validate-user-plugins 
 Turns on additional validation of authentication plugins
 assigned to user accounts. 
 (Defaults to on; use --skip-validate-user-plugins to disable.)
 -v, --verbose       Used with --help option for detailed help.
 -V, --version       Output version information and exit.
 --wait-timeout=#    The number of seconds the server waits for activity on a
 connection before closing it
 --windowing-use-high-precision 
 For SQL window functions, determines whether to enable
 inversion optimization for moving window frames also for
 floating values.
 (Defaults to on; use --skip-windowing-use-high-precision to disable.)
 --write-stats-count[=#] 
 Maximum number of most recent data points to be collected
 for information_schema.write_statistics &
 information_schema.replica_statistics time series.
 --write-stats-frequency[=#] 
 This variable determines the frequency(seconds) at which
 write stats and replica lag stats are collected on
 primaries
 --zstd-net-compression-level[=#] 
 Compression level for compressed protocol when zstd
 library is selected.

Variables (--variable-name=value)
abort-slave-event-count 0
activate-all-roles-on-login FALSE
admin-address (No default value)
admin-port 33062
admin-ssl TRUE
admin-ssl-ca (No default value)
admin-ssl-capath (No default value)
admin-ssl-cert (No default value)
admin-ssl-cipher (No default value)
admin-ssl-crl (No default value)
admin-ssl-crlpath (No default value)
admin-ssl-key (No default value)
admin-tls-ciphersuites (No default value)
admission-control-by-trx FALSE
admission-control-filter 
admission-control-queue 0
admission-control-queue-timeout -1
admission-control-weights (No default value)
allow-noncurrent-db-rw ON
allow-suspicious-udfs FALSE
apply-log (No default value)
apply-log-index (No default value)
apply-log-retention-duration 15
apply-log-retention-num 10
audit-instrumented-event AUDIT_OFF
authentication-policy *,,
auto-increment-increment 1
auto-increment-offset 1
autocommit TRUE
automatic-sp-privileges TRUE
avoid-temporal-upgrade FALSE
back-log 151
big-tables FALSE
bind-address *
binlog-cache-size 32768
binlog-checksum CRC32
binlog-direct-non-transactional-updates FALSE
binlog-encryption FALSE
binlog-error-action ABORT_SERVER
binlog-expire-logs-seconds 2592000
binlog-format ROW
binlog-group-commit-sync-delay 0
binlog-group-commit-sync-no-delay-count 0
binlog-gtid-simple-recovery TRUE
binlog-max-flush-queue-time 0
binlog-order-commits TRUE
binlog-rotate-encryption-master-key-at-startup FALSE
binlog-row-event-max-size 8192
binlog-row-image FULL
binlog-row-metadata FACEBOOK
binlog-row-value-options 
binlog-rows-event-max-rows 18446744073709551615
binlog-rows-query-log-events FALSE
binlog-stmt-cache-size 32768
binlog-transaction-compression FALSE
binlog-transaction-compression-level-zstd 3
binlog-transaction-dependency-history-size 25000
binlog-transaction-dependency-tracking COMMIT_ORDER
binlog-trx-meta-data FALSE
block-encryption-mode aes-128-ecb
bulk-insert-buffer-size 8388608
caching-sha2-password-digest-rounds 5000
caching-sha2-password-private-key-path private_key.pem
caching-sha2-password-public-key-path public_key.pem
character-set-client-handshake TRUE
character-set-filesystem binary
character-set-server utf8mb4
character-sets-dir MYSQL_CHARSETSDIR/
check-proxy-users FALSE
chroot (No default value)
collation-server utf8mb4_0900_ai_ci
commit-consensus-error-action ROLLBACK_TRXS_IN_GROUP
completion-type NO_CHAIN
concurrent-insert AUTO
connect-timeout 10
connection-memory-chunk-size 8912
connection-memory-limit 18446744073709551615
console FALSE
create-admin-listener-thread FALSE
cte-max-recursion-depth 1000
daemonize FALSE
default-authentication-plugin caching_sha2_password
default-collation-for-utf8mb4-init (No default value)
default-password-lifetime 0
default-storage-engine InnoDB
default-table-encryption FALSE
default-time-zone (No default value)
default-tmp-storage-engine InnoDB
default-week-format 0
delay-key-write ON
delayed-insert-limit 100
delayed-insert-timeout 300
delayed-queue-size 1000
disable-raft-log-repointing FALSE
disabled-storage-engines 
disallow-raft TRUE
disconnect-on-expired-password TRUE
disconnect-slave-event-count 0
div-precision-increment 4
enable-acl-db-cache TRUE
enable-acl-fast-lookup FALSE
enable-binlog-hlc FALSE
enable-blind-replace FALSE
enable-block-stale-hlc-read FALSE
enable-query-checksum FALSE
enable-raft-plugin FALSE
enable-resultset-checksum FALSE
enable-super-log-bin-read-only FALSE
enable-user-tables-engine-check FALSE
end-markers-in-json FALSE
enforce-gtid-consistency FALSE
eq-range-index-dive-limit 200
error-partial-strict FALSE
event-scheduler ON
expire-logs-days 0
explicit-defaults-for-timestamp TRUE
external-locking FALSE
fast-integer-to-string FALSE
filesort-max-file-size 0
flush FALSE
flush-only-old-table-cache-entries 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)
gap-lock-exceptions (No default value)
gap-lock-raise-error FALSE
gap-lock-write-log FALSE
gdb FALSE
general-log FALSE
generated-random-password-length 20
global-connection-memory-limit 18446744073709551615
global-connection-memory-tracking FALSE
group-concat-max-len 1024
group-replication-consistency EVENTUAL
group-replication-plugin-hooks FALSE
gtid-executed-compression-period 0
gtid-mode OFF
help TRUE
high-precision-processlist FALSE
high-priority-ddl FALSE
high-priority-lock-wait-timeout 1
histogram-generation-max-mem-size 20000000
host-cache-size 279
improved-dup-key-error FALSE
information-schema-engine TempTable
information-schema-stats-expiry 86400
init-connect 
init-file (No default value)
init-replica 
init-slave 
initialize TRUE
initialize-insecure TRUE
interactive-timeout 28800
internal-tmp-mem-storage-engine TempTable
join-buffer-size 262144
keep-files-on-create FALSE
key-buffer-size 8388608
key-cache-age-threshold 300
key-cache-block-size 1024
key-cache-division-limit 100
keyring-migration-destination (No default value)
keyring-migration-host (No default value)
keyring-migration-port 0
keyring-migration-source (No default value)
keyring-migration-to-component FALSE
keyring-migration-user (No default value)
kill-conflicting-connections FALSE
kill-conflicting-connections-timeout 1
large-pages FALSE
lc-messages en_US
lc-time-names en_US
legacy-global-read-lock-mode TRUE
local-infile FALSE
lock-wait-timeout 3.1536e+07
log-bin (No default value)
log-bin-index (No default value)
log-bin-trust-function-creators FALSE
log-bin-use-v1-row-events FALSE
log-column-names FALSE
log-datagram FALSE
log-datagram-usecs 0
log-ddl FALSE
log-error stderr
log-error-services log_filter_internal; log_sink_internal
log-error-suppression-list 
log-error-verbosity 2
log-global-var-changes FALSE
log-isam myisam.log
log-only-query-comments TRUE
log-output FILE
log-queries-not-using-indexes FALSE
log-raw FALSE
log-replica-updates FALSE
log-short-format FALSE
log-slave-updates FALSE
log-slow-admin-statements FALSE
log-slow-extra FALSE
log-slow-replica-statements FALSE
log-slow-slave-statements FALSE
log-statements-unsafe-for-binlog TRUE
log-tc tc.log
log-tc-size #####
log-throttle-ddl 0
log-throttle-queries-not-using-indexes 0
log-timestamps UTC
long-query-time 10
low-priority-updates FALSE
lower-case-table-names 1
lz4f-net-compression-level 0
maintain-database-hlc FALSE
mandatory-roles 
master-info-file master.info
master-info-repository TABLE
master-retry-count 86400
master-verify-checksum FALSE
max-allowed-packet 67108864
max-binlog-cache-size 18446744073709547520
max-binlog-dump-events 0
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 1024
max-execution-time 0
max-heap-table-size 16777216
max-join-size 18446744073709551615
max-length-for-sort-data 4096
max-nonsuper-connections 0
max-points-in-geometry 65536
max-prepared-stmt-count 16382
max-relay-log-size 0
max-running-queries 0
max-seeks-for-key 18446744073709551615
max-slowlog-size 0
max-sort-length 1024
max-sp-recursion-depth 0
max-statement-time 0
max-user-connections 0
max-waiting-queries 0
max-write-lock-count 18446744073709551615
maximum-hlc-drift-ns 300000000000
memlock FALSE
min-examined-row-limit 0
minimum-hlc-ns 0
mts-dependency-max-keys 100000
mts-dependency-refill-threshold 60
mts-dependency-replication TBL
mts-dependency-size 1000
mts-dynamic-rebalance FALSE
mts-imbalance-threshold 90
myisam-block-size 1024
myisam-data-pointer-size 6
myisam-max-sort-file-size 9223372036853727232
myisam-mmap-size 18446744073709551615
myisam-recover-options OFF
myisam-repair-threads 1
myisam-sort-buffer-size 8388608
myisam-stats-method nulls_unequal
myisam-use-mmap FALSE
mysql-native-password-proxy-users FALSE
net-buffer-length 16384
net-compression-level 6
net-read-timeout 30
net-retry-count 10
net-write-timeout 60
new FALSE
no-dd-upgrade FALSE
offline-mode FALSE
old FALSE
old-alter-table FALSE
old-style-user-limits FALSE
optimizer-force-index-for-range FALSE
optimizer-full-scan TRUE
optimizer-prune-level 1
optimizer-search-depth 62
optimizer-switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,use_invisible_indexes=off,skip_scan=on,hash_join=on,subquery_to_derived=off,prefer_ordering_index=on,hypergraph_optimizer=off,derived_condition_pushdown=on
optimizer-trace 
optimizer-trace-features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
optimizer-trace-limit 1
optimizer-trace-max-mem-size 1048576
optimizer-trace-offset -1
override-enable-raft-check FALSE
parser-max-mem-size 18446744073709551615
parthandler-allow-drop-partition TRUE
partial-revokes ####
password-history 0
password-require-current FALSE
password-reuse-interval 0
per-user-session-var-default-val (No default value)
per-user-session-var-user-name-delimiter :
performance-schema TRUE
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-cpu FALSE
performance-schema-consumer-events-statements-current TRUE
performance-schema-consumer-events-statements-history TRUE
performance-schema-consumer-events-statements-history-long FALSE
performance-schema-consumer-events-transactions-current TRUE
performance-schema-consumer-events-transactions-history TRUE
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-error-size ####
performance-schema-esms-by-all FALSE
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 150
performance-schema-max-cond-instances -1
performance-schema-max-digest-length 1024
performance-schema-max-digest-sample-age 60
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 450
performance-schema-max-metadata-locks -1
performance-schema-max-mutex-classes 350
performance-schema-max-mutex-instances -1
performance-schema-max-prepared-statements-instances -1
performance-schema-max-program-instances -1
performance-schema-max-rwlock-classes 60
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 175
performance-schema-max-statement-classes 232
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 100
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-show-processlist FALSE
performance-schema-users-size -1
persist-only-admin-x509-subject 
persisted-globals-load TRUE
port ####
port-open-timeout 0
preload-buffer-size 32768
print-identified-with-as-hex FALSE
profiling-history-size 15
protocol-compression-algorithms zlib,zstd,zstd_stream,lz4f_stream,uncompressed
protocol-mode 
query-alloc-block-size 8192
query-prealloc-size 8192
range-alloc-block-size 4096
range-optimizer-max-mem-size 8388608
rbr-column-type-mismatch-whitelist 
read-buffer-size 131072
read-only FALSE
read-only-error-msg-extra 
read-only-slave TRUE
read-rnd-buffer-size 262144
regexp-stack-limit 8000000
regexp-time-limit 32
relay-log relaylog
relay-log-index relaylog.index
relay-log-info-file relay-log.info
relay-log-info-repository TABLE
relay-log-purge TRUE
relay-log-recovery FALSE
relay-log-space-limit 0
replica-allow-batching FALSE
replica-checkpoint-group 512
replica-checkpoint-period 300
replica-compressed-protocol FALSE
replica-exec-mode STRICT
replica-max-allowed-packet 1073741824
replica-net-timeout 60
replica-parallel-type LOGICAL_CLOCK
replica-parallel-workers 4
replica-pending-jobs-size-max 134217728
replica-preserve-commit-order TRUE
replica-skip-errors (No default value)
replica-sql-verify-checksum TRUE
replica-transaction-retries 10
replica-type-conversions 
replicate-same-server-id FALSE
replication-optimize-for-static-plugin-config FALSE
replication-sender-observe-commit-only FALSE
report-host (No default value)
report-password (No default value)
report-port 0
report-user (No default value)
require-secure-transport FALSE
reset-seconds-behind-master TRUE
response-attrs-contain-hlc FALSE
rocksdb ON
rocksdb-access-hint-on-compaction-start 1
rocksdb-active-compaction-stats ON
rocksdb-advise-random-on-open TRUE
rocksdb-allow-concurrent-memtable-write FALSE
rocksdb-allow-mmap-reads FALSE
rocksdb-allow-mmap-writes FALSE
rocksdb-allow-to-start-after-corruption FALSE
rocksdb-blind-delete-primary-key FALSE
rocksdb-block-cache-size 536870912
rocksdb-block-restart-interval 16
rocksdb-block-size 4096
rocksdb-block-size-deviation 10
rocksdb-bulk-load FALSE
rocksdb-bulk-load-allow-sk FALSE
rocksdb-bulk-load-allow-unsorted FALSE
rocksdb-bulk-load-size 1000
rocksdb-bypass-rejected-query-history ON
rocksdb-bytes-per-sync 0
rocksdb-cache-dump TRUE
rocksdb-cache-high-pri-pool-ratio 0
rocksdb-cache-index-and-filter-blocks TRUE
rocksdb-cache-index-and-filter-with-high-priority TRUE
rocksdb-cf-options ON
rocksdb-cfstats ON
rocksdb-checksums-pct 100
rocksdb-collect-sst-properties TRUE
rocksdb-commit-in-the-middle FALSE
rocksdb-commit-time-batch-for-recovery TRUE
rocksdb-compact-cf 
rocksdb-compaction-history ON
rocksdb-compaction-readahead-size 0
rocksdb-compaction-sequential-deletes 0
rocksdb-compaction-sequential-deletes-count-sd FALSE
rocksdb-compaction-sequential-deletes-file-size 0
rocksdb-compaction-sequential-deletes-window 0
rocksdb-compaction-stats ON
rocksdb-create-checkpoint 
rocksdb-create-if-missing TRUE
rocksdb-create-missing-column-families FALSE
rocksdb-datadir ./.rocksdb
rocksdb-db-write-buffer-size 0
rocksdb-dbstats ON
rocksdb-ddl ON
rocksdb-deadlock ON
rocksdb-deadlock-detect FALSE
rocksdb-deadlock-detect-depth 50
rocksdb-debug-cardinality-multiplier 2
rocksdb-debug-manual-compaction-delay 0
rocksdb-debug-optimizer-n-rows 0
rocksdb-debug-optimizer-no-zero-cardinality TRUE
rocksdb-debug-ttl-ignore-pk FALSE
rocksdb-debug-ttl-read-filter-ts 0
rocksdb-debug-ttl-rec-ts 0
rocksdb-debug-ttl-snapshot-ts 0
rocksdb-default-cf-options 
rocksdb-delayed-write-rate 0
rocksdb-delete-cf 
rocksdb-delete-obsolete-files-period-micros 21600000000
rocksdb-disable-file-deletions FALSE
rocksdb-enable-2pc TRUE
rocksdb-enable-bulk-load-api TRUE
rocksdb-enable-insert-with-update-caching TRUE
rocksdb-enable-iterate-bounds TRUE
rocksdb-enable-remove-orphaned-dropped-cfs TRUE
rocksdb-enable-thread-tracking TRUE
rocksdb-enable-ttl TRUE
rocksdb-enable-ttl-read-filtering TRUE
rocksdb-enable-write-thread-adaptive-yield FALSE
rocksdb-error-if-exists FALSE
rocksdb-error-on-suboptimal-collation TRUE
rocksdb-fault-injection-options (No default value)
rocksdb-flush-log-at-trx-commit 1
rocksdb-force-compute-memtable-stats TRUE
rocksdb-force-compute-memtable-stats-cachetime 60000000
rocksdb-force-flush-memtable-and-lzero-now FALSE
rocksdb-force-flush-memtable-now TRUE
rocksdb-force-index-records-in-range 0
rocksdb-global-info ON
rocksdb-ignore-unknown-options TRUE
rocksdb-index-file-map ON
rocksdb-index-type kBinarySearch
rocksdb-info-log-level error_level
rocksdb-io-write-timeout 0
rocksdb-is-fd-close-on-exec TRUE
rocksdb-keep-log-file-num 1000
rocksdb-large-prefix FALSE
rocksdb-lock-scanned-rows FALSE
rocksdb-lock-wait-timeout 1
rocksdb-locks ON
rocksdb-log-file-time-to-roll 0
rocksdb-manifest-preallocation-size 4194304
rocksdb-manual-compaction-threads 0
rocksdb-manual-wal-flush TRUE
rocksdb-master-skip-tx-api FALSE
rocksdb-max-background-compactions -1
rocksdb-max-background-flushes -1
rocksdb-max-background-jobs 2
rocksdb-max-bottom-pri-background-compactions 0
rocksdb-max-compaction-history 64
rocksdb-max-latest-deadlocks 5
rocksdb-max-log-file-size 0
rocksdb-max-manifest-file-size 1073741824
rocksdb-max-manual-compactions 10
rocksdb-max-open-files -2
rocksdb-max-row-locks 1048576
rocksdb-max-subcompactions 1
rocksdb-max-total-wal-size 0
rocksdb-merge-buf-size 67108864
rocksdb-merge-combine-read-size 1073741824
rocksdb-merge-tmp-file-removal-delay-ms 0
rocksdb-mrr-batch-size 100
rocksdb-no-block-cache FALSE
rocksdb-override-cf-options 
rocksdb-paranoid-checks TRUE
rocksdb-pause-background-work FALSE
rocksdb-perf-context ON
rocksdb-perf-context-global ON
rocksdb-perf-context-level 0
rocksdb-persistent-cache-path 
rocksdb-persistent-cache-size-mb 0
rocksdb-pin-l0-filter-and-index-blocks-in-cache TRUE
rocksdb-print-snapshot-conflict-queries FALSE
rocksdb-rate-limiter-bytes-per-sec 0
rocksdb-read-free-rpl OFF
rocksdb-read-free-rpl-tables .*
rocksdb-records-in-range 0
rocksdb-reset-stats FALSE
rocksdb-rollback-on-timeout FALSE
rocksdb-seconds-between-stat-computes 3600
rocksdb-select-bypass-allow-filters TRUE
rocksdb-select-bypass-debug-row-delay 0
rocksdb-select-bypass-fail-unsupported TRUE
rocksdb-select-bypass-log-failed FALSE
rocksdb-select-bypass-log-rejected TRUE
rocksdb-select-bypass-multiget-min 18446744073709551615
rocksdb-select-bypass-policy always_off
rocksdb-select-bypass-rejected-query-history-size 0
rocksdb-signal-drop-index-thread FALSE
rocksdb-sim-cache-size 0
rocksdb-skip-bloom-filter-on-read FALSE
rocksdb-skip-fill-cache FALSE
rocksdb-skip-locks-if-skip-unique-check FALSE
rocksdb-sst-mgr-rate-bytes-per-sec 0
rocksdb-sst-props ON
rocksdb-stats-dump-period-sec 600
rocksdb-stats-level 1
rocksdb-stats-recalc-rate 0
rocksdb-store-row-debug-checksums FALSE
rocksdb-strict-collation-check TRUE
rocksdb-strict-collation-exceptions 
rocksdb-table-cache-numshardbits 6
rocksdb-table-stats-background-thread-nice-value 19
rocksdb-table-stats-max-num-rows-scanned 0
rocksdb-table-stats-recalc-threshold-count 100
rocksdb-table-stats-recalc-threshold-pct 10
rocksdb-table-stats-sampling-pct 10
rocksdb-table-stats-use-table-scan FALSE
rocksdb-tmpdir 
rocksdb-trace-block-cache-access 
rocksdb-trace-sst-api FALSE
rocksdb-track-and-verify-wals-in-manifest TRUE
rocksdb-trx ON
rocksdb-two-write-queues TRUE
rocksdb-unsafe-for-binlog FALSE
rocksdb-update-cf-options (No default value)
rocksdb-use-adaptive-mutex FALSE
rocksdb-use-clock-cache FALSE
rocksdb-use-default-sk-cf FALSE
rocksdb-use-direct-io-for-flush-and-compaction FALSE
rocksdb-use-direct-reads FALSE
rocksdb-use-fsync FALSE
rocksdb-validate-tables 1
rocksdb-verify-row-debug-checksums FALSE
rocksdb-wal-bytes-per-sync 0
rocksdb-wal-dir 
rocksdb-wal-recovery-mode 2
rocksdb-wal-size-limit-mb 0
rocksdb-wal-ttl-seconds 0
rocksdb-whole-key-filtering TRUE
rocksdb-write-batch-max-bytes 0
rocksdb-write-disable-wal FALSE
rocksdb-write-ignore-missing-column-families FALSE
rocksdb-write-policy write_committed
rocksdb-wsenv-path 
rpl-read-size 8192
rpl-receive-buffer-size 2097152
rpl-send-buffer-size 2097152
rpl-skip-tx-api FALSE
rpl-slave-flow-control TRUE
rpl-stop-replica-timeout 31536000
rpl-stop-slave-timeout 31536000
rpl-wait-for-semi-sync-ack FALSE
safe-user-create FALSE
schema-definition-cache 256
secondary-engine-cost-threshold 100000
select-into-buffer-size 131072
select-into-disk-sync FALSE
select-into-disk-sync-delay 0
select-into-file-fsync-size 0
select-into-file-fsync-timeout 0
send-error-before-closing-timed-out-connection TRUE
serialize-fb-json-raise-error FALSE
server-id 1
server-id-bits 32
session-track-gtids OFF
session-track-response-attributes FALSE
session-track-schema TRUE
session-track-state-change FALSE
session-track-system-variables time_zone,autocommit,character_set_client,character_set_results,character_set_connection
session-track-transaction-info OFF
sha256-password-proxy-users FALSE
show-create-table-verbosity FALSE
show-old-temporals FALSE
show-replica-auth-info FALSE
show-slave-auth-info FALSE
skip-core-dump-on-error TRUE
skip-flush-master-info FALSE
skip-flush-relay-worker-info FALSE
skip-grant-tables TRUE
skip-master-info-check-for-read-only-error-msg-extra FALSE
skip-name-resolve FALSE
skip-networking FALSE
skip-replica-start FALSE
skip-show-database FALSE
skip-slave-start FALSE
slave-allow-batching FALSE
slave-check-before-image-consistency OFF
slave-checkpoint-group 512
slave-checkpoint-period 300
slave-compressed-protocol FALSE
slave-compression-lib zlib
slave-dump-thread-wait-sleep-usec 0
slave-exec-mode STRICT
slave-high-priority-ddl FALSE
slave-high-priority-lock-wait-timeout 1
slave-max-allowed-packet 1073741824
slave-net-timeout 60
slave-parallel-type LOGICAL_CLOCK
slave-parallel-workers 4
slave-pending-jobs-size-max 134217728
slave-preserve-commit-order TRUE
slave-rows-search-algorithms INDEX_SCAN,HASH_SCAN
slave-run-triggers-for-rbr NO
slave-skip-errors (No default value)
slave-sql-verify-checksum TRUE
slave-transaction-retries 10
slave-tx-isolation REPEATABLE-READ
slave-type-conversions 
slave-use-idempotent-for-recovery NO
slow-launch-time 2
slow-query-log FALSE
slowlog-space-limit 0
sort-buffer-size 262144
source-verify-checksum FALSE
sporadic-binlog-dump-fail FALSE
sql-log-bin-triggers TRUE
sql-mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
sql-require-primary-key FALSE
stored-program-cache 256
stored-program-definition-cache 256
super-read-only FALSE
symbolic-links FALSE
sync-binlog 1
sync-master-info 10000
sync-relay-log 10000
sync-relay-log-info 10000
sync-source-info 10000
sysdate-is-now FALSE
table-encryption-privilege-check FALSE
table-open-cache-instances 16
tablespace-definition-cache 256
tc-heuristic-recover OFF
temptable-max-mmap 1073741824
temptable-max-ram 1073741824
temptable-use-mmap TRUE
terminology-use-previous NONE
thread-cache-size 9
thread-handling one-thread-per-connection
thread-stack 1048576
tls-ciphersuites (No default value)
tmp-table-size 16777216
transaction-alloc-block-size 8192
transaction-isolation REPEATABLE-READ
transaction-prealloc-size 4096
transaction-read-only FALSE
transaction-write-set-extraction XXHASH64
trim-binlog-to-recover FALSE
updatable-views-with-limit YES
update-binlog-pos-threshold 5242880
upgrade AUTO
use-fb-json-functions 
validate-config FALSE
validate-user-plugins TRUE
verbose TRUE
wait-timeout 28800
windowing-use-high-precision TRUE
write-stats-count 0
write-stats-frequency 0
zstd-net-compression-level 3

To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --verbose --help'.