【MySQL】MySQL系统变量（system variables）列表（mysqld --verbose --help的结果例）

【免责声明】文章仅供学习交流，观点代表个人，与任何公司无关。
编辑|SQL和数据库技术(ID:SQLplusDB)

【MySQL】控制MySQL优化器行为方法之optimizer_switch系统变量
MySQL 8.0 OCP (1Z0-908) 考点精析-性能优化考点2：系统变量的确认
【MySQL】MySQL系统变量（system variables）列表（mysqld --verbose --help的结果例）
【MySQL】MySQL系统变量（system variables）列表（SHOW VARIABLES 的结果例）

【MySQL】MySQL系统变量（system variables）列表（mysqld --verbose --help的结果例）

可以通过一下几种方法查看MySQL数据库的所有系统变量列表。

1. 使用以下命令查看服务器系统变量，以及基于其编译默认值和读取的任何选项文件的值。

mysqld --verbose --help

2. 使用以下命令查看服务器系统变量，以及仅基于其编译默认值使用的值（忽略任何选项文件中的设置）

mysqld --no-defaults --verbose --help

3. 通过SHOW VARIABLES 命令查看正在运行的MySQL数据库的系统变量和其使用的值。

mysql> SHOW [GLOBAL | SESSION] VARIABLES[LIKE 'pattern' | WHERE expr]

4. 通过Performance Schema的系统变量表查看正在运行的MySQL数据库的系统变量和其使用的值。

mysql> select * from performance_schema.global_variables;
mysql> select * from performance_schema.session_variables;

mysqld --verbose --help的结果例

下面是mysqld --verbose --help的结果例

ubuntu@mysql-vm:~$ mysqld --verbose --help
mysqld  Ver 8.0.34-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))
BuildID[sha1]=6da44471e64652692eaa270c171582a6e8ed7791
Copyright (c) 2000, 2023, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Starts the MySQL database server.Usage: mysqld [OPTIONS]Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
The following groups are read: mysqld server mysqld-8.0
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 ofreplication.This option is deprecated and will be removedin a future version.--activate-all-roles-on-loginAutomatically set all granted roles as active after theuser has authenticated successfully.--admin-address=nameIP address to bind to for service connection. Address canbe an IPv4 address, IPv6 address, or host name. Wildcardvalues *, ::, 0.0.0.0 are not allowed. Address value canhave following optional network namespace separated bythe delimiter / from the address value. E.g., thefollowing value 192.168.1.1/red specifies IP addresses tolisten for incoming TCP connections that have to beplaced into the namespace 'red'. Using of networknamespace requires its support from underlying OperatingSystem. Attempt to specify a network namespace for aplatform that doesn't support it results in error duringsocket creation.--admin-port=#      Port number to use for service connection, built-indefault (33062)--admin-ssl         Enable SSL for admin interface (automatically enabledwith other flags).(Defaults to on; use --skip-admin-ssl to disable.)--admin-ssl-ca=name CA file in PEM format (check OpenSSL docs, implies --ssl)for --admin-port--admin-ssl-capath=nameCA directory (check OpenSSL docs, implies --ssl) for--admin-port--admin-ssl-cert=nameX509 cert in PEM format (implies --ssl) for --admin-port--admin-ssl-cipher=nameSSL cipher to use (implies --ssl) for --admin-port--admin-ssl-crl=nameCRL file in PEM format (check OpenSSL docs, implies--ssl) for --admin-port--admin-ssl-crlpath=nameCRL directory (check OpenSSL docs, implies --ssl) for--admin-port--admin-ssl-key=nameX509 key in PEM format (implies --ssl) for --admin-port--admin-tls-ciphersuites=nameTLS v1.3 ciphersuite to use (implies --ssl) for--admin-port--admin-tls-version=nameTLS version for --admin-port, permitted values areTLSv1.2, TLSv1.3--allow-suspicious-udfsAllows use of UDFs consisting of only one symbol xxx()without corresponding xxx_init() or xxx_deinit(). Thatalso means that one can load any function from anylibrary, for example exit() from libc.so-a, --ansi          Use ANSI SQL syntax instead of MySQL syntax. This modewill also set transaction isolation level 'serializable'.--archive[=name]    Enable or disable ARCHIVE plugin. Possible values are ON,OFF, FORCE (don't start if the plugin fails to load).--authentication-policy=nameDefines policies around how user account can beconfigured with Multi Factor authentication methodsduring CREATE/ALTER USER statement. This variable acceptsat-most 3 comma separated list of authentication pluginnames where each value refers to what authenticationplugin should be used in place of 1st FactorAuthentication (FA), 2FA and 3FA method. Value *indicates any plugin is allowed for 1FA, 2FA and 3FAmethod. An empty value means nth FA method is optional.--auto-generate-certsAuto generate SSL certificates at server startup if --sslis set to ON and none of the other SSL system variablesare specified and certificate/key files are not presentin data directory.(Defaults to on; use --skip-auto-generate-certs to disable.)--auto-increment-increment[=#]Auto-increment columns are incremented by this--auto-increment-offset[=#]Offset added to Auto-increment columns. Used whenauto-increment-increment != 1--autocommit        Set default value for autocommit (0 or 1)(Defaults to on; use --skip-autocommit to disable.)--automatic-sp-privilegesCreating and dropping stored procedures alters ACLs(Defaults to on; use --skip-automatic-sp-privileges to disable.)--avoid-temporal-upgradeWhen this option is enabled, the pre-5.6.4 temporal typesare not upgraded to the new format for ALTER TABLErequests ADD/CHANGE/MODIFY COLUMN, ADD INDEX or FORCEoperation. This variable is deprecated and will beremoved in a future release.--back-log=#        The number of outstanding connection requests MySQL canhave. This comes into play when the main MySQL threadgets very many connection requests in a very short time-b, --basedir=name  Path to installation directory. All paths are usuallyresolved relative to this--big-tables        Allow big result sets by saving all temporary sets onfile (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, hostname or one of the wildcard values *, ::, 0.0.0.0. Incase more than one address is specified in acomma-separated list, wildcard values are not allowed.Every address can have optional network namespaceseparated by the delimiter / from the address value.E.g., the following value192.168.1.1/red,172.16.1.1/green,193.168.1.1 specifiesthree IP addresses to listen for incoming TCP connectionstwo of that have to be placed in correspondingnamespaces: the address 192.168.1.1 must be placed intothe namespace red and the address 172.16.1.1 must beplaced into the namespace green. Using of networknamespace requires its support from underlying OperatingSystem. Attempt to specify a network namespace for aplatform that doesn't support it results in error duringsocket creation.--binlog-cache-size=#The size of the transactional cache for updates totransactional engines for the binary log. If you oftenuse transactions containing many statements, you canincrease this to get more performance--binlog-checksum=nameType of BINLOG_CHECKSUM_ALG. Include checksum for logevents in the binary log. Possible values are NONE andCRC32; default is CRC32.--binlog-direct-non-transactional-updatesCauses updates to non-transactional engines usingstatement format to be written directly to binary log,after executing them and before committing thetransaction. Before using this option make sure thatthere are no dependencies between transactional andnon-transactional tables such as in the statement INSERTINTO t_myisam SELECT * FROM t_innodb; otherwise, replicasmay diverge.--binlog-do-db=name Include only updates to the specified database whenwriting the binary log.--binlog-encryption Enable/disable binary and relay logs encryption.--binlog-error-action=nameWhen statements cannot be written to the binary log dueto a fatal error, this option determines whether theserver ignores the error and closes the binary log, oraborts.--binlog-expire-logs-auto-purgeControls whether the server shall automatically purgebinary log files or not. If this variable is set to FALSEthen the server will not purge binary log filesautomatically.(Defaults to on; use --skip-binlog-expire-logs-auto-purge to disable.)--binlog-expire-logs-seconds=#If non-zero, binary logs will be purged afterbinlog_expire_logs_seconds seconds; If both this optionand expire_logs_days are set to non-zero  values, thisoption takes priority. Purges happen at startup and atbinary log rotation.--binlog-format=nameThe format used when writing the binary log. ROW writeseach changed row in a binary format. STATEMENT writes SQLstatements. MIXED writes SQL statements for moststatements, and row format for statements that cannot bereplayed in a deterministic manner using SQL. IfNDBCLUSTER is enabled and binlog-format is MIXED, theformat switches to row-based and back implicitly for eachquery accessing an NDBCLUSTER table. This option isdeprecated and will be removed in a future version.--binlog-group-commit-sync-delay=#The number of microseconds the server waits for thebinary log group commit sync queue to fill beforecontinuing. Default: 0. Min: 0. Max: 1000000.--binlog-group-commit-sync-no-delay-count=#If there are this many transactions in the commit syncqueue and the server is waiting for more transactions tobe enqueued (as set using--binlog-group-commit-sync-delay), the commit procedureresumes.--binlog-gtid-simple-recoveryIf this option is enabled, the server does not open morethan two binary logs when initializing GTID_PURGED andGTID_EXECUTED, either during server restart or whenbinary logs are being purged. Enabling this option isuseful when the server has already generated many binarylogs without GTID events (e.g., having GTID_MODE = OFF).Note: If this option is enabled, GLOBAL.GTID_EXECUTED andGLOBAL.GTID_PURGED may be initialized wrongly in twocases: (1) All binary logs were generated by MySQL 5.7.5or older, and GTID_MODE was ON for some binary logs butOFF for the newest binary log. (2) The oldest existingbinary log was generated by MySQL 5.7.5 or older, and SETGTID_PURGED was issued after the oldest binary log wasgenerated. If a wrong set is computed in one of case (1)or case (2), it will remain wrong even if the server islater restarted with this option disabled.(Defaults to on; use --skip-binlog-gtid-simple-recovery to disable.)--binlog-ignore-db=nameExclude updates to the specified database when writingthe binary log.--binlog-max-flush-queue-time=#The maximum time that the binary log group commit willkeep reading transactions before it flush thetransactions to the binary log (and optionally sync,depending on the value of sync_binlog).--binlog-order-commitsIssue internal commit calls in the same order astransactions are written to the binary log. Default is toorder commits.(Defaults to on; use --skip-binlog-order-commits to disable.)--binlog-rotate-encryption-master-key-at-startupForce binlog encryption master key rotation at startup--binlog-row-event-max-size=#The maximum size of a row-based binary log event inbytes. Rows will be grouped into events smaller than thissize if possible. The value has to be a multiple of 256.--binlog-row-image=nameControls whether rows should be logged in 'FULL','NOBLOB' or 'MINIMAL' formats. 'FULL', means that allcolumns in the before and after image are logged.'NOBLOB', means that mysqld avoids logging blob columnswhenever possible (e.g. blob column was not changed or isnot part of primary key). 'MINIMAL', means that a PKequivalent (PK columns or full row if there is no PK inthe table) is logged in the before image, and onlychanged columns are logged in the after image. (Default:FULL).--binlog-row-metadata=nameControls how much type information is written to thebinary log when using ROW format. FULL causes allmetadata to be logged. MINIMAL means that only metadataactually needed by replicas is logged.--binlog-row-value-options=nameWhen set to PARTIAL_JSON, this option enables aspace-efficient row-based binary log format for UPDATEstatements that modify a JSON value using only thefunctions JSON_SET, JSON_REPLACE, and JSON_REMOVE. Forsuch updates, only the modified parts of the JSONdocument are included in the binary log, so small changesof big documents may need significantly less space.--binlog-rows-query-log-eventsAllow writing of Rows_query_log events into binary log.--binlog-stmt-cache-size=#The size of the statement cache for updates tonon-transactional engines for the binary log. If youoften use statements updating a great number of rows, youcan increase this to get more performance--binlog-transaction-compressionWhether to compress transactions or not. Transactions arecompressed using the ZSTD compression algorythm.--binlog-transaction-compression-level-zstd=#Specifies the transaction compression level for ZSTDtransaction compression in the binary log.--binlog-transaction-dependency-history-size=#Maximum number of rows to keep in the writeset history.--binlog-transaction-dependency-tracking=nameSelects the source of dependency information from whichto compute logical timestamps, which replicas can use todecide which transactions can be executed in parallelwhen using replica_parallel_type=LOGICAL_CLOCK. Possiblevalues are COMMIT_ORDER, WRITESET and WRITESET_SESSION.--blackhole[=name]  Enable or disable BLACKHOLE plugin. Possible values areON, OFF, FORCE (don't start if the plugin fails to load).--block-encryption-mode=namemode for AES_ENCRYPT/AES_DECRYPT--bulk-insert-buffer-size=#Size of tree cache used in bulk insert optimisation. Notethat this is a limit per thread!--caching-sha2-password-auto-generate-rsa-keysAuto generate RSA keys at server startup if correspondingsystem variables are not specified and key files are notpresent at the default location.(Defaults to on; use --skip-caching-sha2-password-auto-generate-rsa-keys to disable.)--caching-sha2-password-digest-rounds=#Number of SHA2 rounds to be done when storing a passwordhash onto disk.--caching-sha2-password-private-key-path=nameA fully qualified path to the private RSA key used forauthentication.--caching-sha2-password-public-key-path=nameA fully qualified path to the public RSA key used forauthentication.--character-set-client-handshakeDon't ignore client side character set value sent duringhandshake.(Defaults to on; use --skip-character-set-client-handshake to disable.)--character-set-filesystem=nameSet the filesystem character set.-C, --character-set-server=nameSet the default character set.--character-sets-dir=nameDirectory where character sets are--check-proxy-users If set to FALSE (the default), then proxy user identitywill not be mapped for authentication plugins whichsupport mapping from grant tables.  When set to TRUE,users associated with authentication plugins which signalproxy user mapping should be done according to GRANTPROXY privilege definition.-r, --chroot=name   Chroot mysqld daemon during startup.--collation-server=nameSet the default collation.--completion-type=nameThe transaction completion type, one of NO_CHAIN, CHAIN,RELEASE--concurrent-insert[=name]Use concurrent insert with MyISAM. Possible values areNEVER, AUTO, ALWAYS--connect-timeout=# The number of seconds the mysqld server is waiting for aconnect packet before responding with 'Bad handshake'--connection-memory-chunk-size=#Chunk size regulating frequency of updating the globalmemory counter--connection-memory-limit=#Maximum amount of memory connection can consume--console           Write error output on screen; don't remove the consolewindow on windows.--core-file         Write core on errors.--create-admin-listener-threadUse a dedicated thread for listening incoming connectionson admin interface--cte-max-recursion-depth=#Abort a recursive common table expression if it does morethan this number of iterations.-D, --daemonize     Run mysqld as sysv daemon-h, --datadir=name  Path to the database root directory--default-authentication-plugin=nameThe default authentication plugin used by the server tohash the password.--default-password-lifetime=#The number of days after which the password will expire.--default-storage-engine=nameThe default storage engine for new tables--default-table-encryptionDatabase and tablespace are created with this defaultencryption property unless the user specifies an explicitencryption property.--default-time-zone=nameSet the default time zone.--default-tmp-storage-engine=nameThe default storage engine for new explicit temporarytables--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 INSERTDELAYED handler will check if there are any SELECTstatements pending. If so, it allows these to executebefore continuing. This variable is deprecated along withINSERT DELAYED.--delayed-insert-timeout=#How long a INSERT DELAYED thread should wait for INSERTstatements before terminating. This variable isdeprecated along with INSERT DELAYED.--delayed-queue-size=#What size queue (in rows) should be allocated forhandling INSERT DELAYED. If the queue becomes full, anyclient that does INSERT DELAYED will wait until there isroom in the queue again. This variable is deprecatedalong with INSERT DELAYED.--disabled-storage-engines=nameLimit CREATE TABLE for the storage engines listed--disconnect-on-expired-passwordGive clients that don't signal password expirationsupport execution time error(s) instead of connectionerror(Defaults to on; use --skip-disconnect-on-expired-password to disable.)--disconnect-slave-event-count=#Option used by mysql-test for debugging and testing ofreplication.This option is deprecated and will be removedin a future version.--div-precision-increment=#Precision of the result of '/' operator will be increasedon that value--early-plugin-load=nameOptional semicolon-separated list of plugins to loadbefore storage engine initialization, where each pluginis identified as name=library, where name is the pluginname and library is the plugin library in plugin_dir.--end-markers-in-jsonIn JSON output ("EXPLAIN FORMAT=JSON" and optimizertrace), if variable is set to 1, repeats the structure'skey (if it has one) near the closing bracket--enforce-gtid-consistency[=name]Prevents execution of statements that would be impossibleto log in a transactionally safe manner. Currently, thedisallowed statements include CREATE TEMPORARY TABLEinside transactions, all updates to non-transactionaltables, and CREATE TABLE ... SELECT.--eq-range-index-dive-limit=#The optimizer will use existing index statistics insteadof doing index dives for equality ranges if the number ofequality ranges for the index is larger than or equal tothis number. If set to 0, index dives are always used.--event-scheduler[=name]Enable the event scheduler. Possible values are ON, OFF,and DISABLED (keep the event scheduler completelydeactivated, 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 afterexpire_logs_days days; If this option alone is set on thecommand line or in a configuration file, it overrides thedefault value for binlog-expire-logs-seconds. If bothoptions are set to nonzero values,binlog-expire-logs-seconds takes priority. Possiblepurges happen at startup and at binary log rotation.--explain-format[=name]The default format in which the EXPLAIN statementdisplays information. Valid values are TRADITIONAL(default), TREE, JSON and TRADITIONAL_STRICT.TRADITIONAL_STRICT is only used internally by the mtrtest suite, and is not meant to be used anywhere else.--explicit-defaults-for-timestampThis option causes CREATE TABLE to create all TIMESTAMPcolumns as NULL with DEFAULT NULL attribute, Without thisoption, TIMESTAMP columns are NOT NULL and have implicitDEFAULT clauses. The old behavior is deprecated. Thevariable can only be set by users having the SUPERprivilege.(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.--federated[=name]  Enable or disable FEDERATED plugin. Possible values areON, OFF, FORCE (don't start if the plugin fails to load).--flush             Flush MyISAM tables to disk between SQL commands--flush-time=#      A dedicated thread is created to flush all tables at thegiven interval--ft-boolean-syntax=nameList of operators for MATCH ... AGAINST ( ... IN BOOLEANMODE)--ft-max-word-len=# The maximum length of the word to be included in aFULLTEXT index. Note: FULLTEXT indexes must be rebuiltafter changing this variable--ft-min-word-len=# The minimum length of the word to be included in aFULLTEXT index. Note: FULLTEXT indexes must be rebuiltafter changing this variable--ft-query-expansion-limit=#Number of best matches to use for query expansion--ft-stopword-file=nameUse stopwords from this file instead of built-in list--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=nameLog connections and queries to given file--generated-random-password-length=#Determines the length randomly generated passwords inCREATE USER-,SET PASSWORD- or ALTER USER statements--global-connection-memory-limit=#Maximum amount of memory all connections can consume--global-connection-memory-trackingEnable updating the global memory counter and checkingthe global connection memory limit exceeding--group-concat-max-len=#The maximum length of the result of functionGROUP_CONCAT()--group-replication-consistency[=name]Transaction consistency guarantee, possible values:EVENTUAL, BEFORE_ON_PRIMARY_FAILOVER, BEFORE, AFTER,BEFORE_AND_AFTER--gtid-executed-compression-period[=#]Compress the mysql.gtid_executed table whenever thisnumber of transactions have been added, by waking up aforeground thread (compress_gtid_table). This compressionmethod only operates when binary logging is disabled onthe replica; if binary logging is enabled, the table iscompressed every time the binary log is rotated, and thisvalue is ignored. Before MySQL 8.0.23, the default is1000, and from MySQL 8.0.23, the default is zero, whichdisables this compression method. This is because inreleases from MySQL 8.0.17, InnoDB transactions arewritten to the mysql.gtid_executed table by a separateprocess to non-InnoDB transactions. If the server has amix of InnoDB and non-InnoDB transactions, attempting tocompress the table with the compress_gtid_table threadcan slow this process, so from MySQL 8.0.17 it isrecommended that you set gtid_executed_compression_periodto 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 ina client session using GTID_NEXT='AUTOMATIC') are notassigned any GTID, and replicated transactions areallowed to have or not have a GTID. ON_PERMISSIVE meansthat new transactions are assigned a GTID, and replicatedtransactions are allowed to have or not have a GTID. ONmeans that all transactions have a GTID. ON is requiredon a source before any replica can useSOURCE_AUTO_POSITION=1. To safely switch from OFF to ON,first set all servers to OFF_PERMISSIVE, then set allservers to ON_PERMISSIVE, then wait for all transactionswithout a GTID to be replicated and executed on allservers, and finally set all servers to GTID_MODE = ON.-?, --help          Display this help and exit.--histogram-generation-max-mem-size=#Maximum amount of memory available for generatinghistograms--host-cache-size=# How many host names should be cached to avoid resolving.--information-schema-stats-expiry=#The number of seconds after which mysqld server willfetch data from storage engine and replace the data incache.--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 applierthread 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 userwith a random expired password and store it into the log.--initialize-insecureCreate the default database and exit. Create a super userwith empty password.--innodb            Deprecated option. Provided for backward compatibilityonly. The option has no effect on the server behaviour.InnoDB is always enabled. The option will be removed in afuture release.--innodb-adaptive-flushingAttempt flushing dirty pages to avoid IO bursts atcheckpoints.(Defaults to on; use --skip-innodb-adaptive-flushing to disable.)--innodb-adaptive-flushing-lwm=#Percentage of log capacity below which no adaptiveflushing happens.--innodb-adaptive-hash-indexEnable InnoDB adaptive hash index (enabled by default).Disable with --skip-innodb-adaptive-hash-index.(Defaults to on; use --skip-innodb-adaptive-hash-index to disable.)--innodb-adaptive-hash-index-parts[=#]Number of InnoDB Adaptive Hash Index Partitions. (default= 8).--innodb-adaptive-max-sleep-delay=#The upper limit of the sleep delay in usec. Value of 0disables it.--innodb-api-bk-commit-interval[=#]Background commit interval in seconds--innodb-api-disable-rowlockDisable row lock when direct access InnoDB through InnoDBAPIs--innodb-api-enable-binlogEnable binlog for applications direct access InnoDBthrough InnoDB APIs--innodb-api-enable-mdlEnable MDL for applications direct access InnoDB throughInnoDB APIs--innodb-api-trx-level[=#]InnoDB API transaction isolation level--innodb-autoextend-increment=#Data file autoextend increment in megabytes--innodb-autoinc-lock-mode=#The AUTOINC lock modes supported by InnoDB: 0 => Oldstyle AUTOINC locking (for backward compatibility); 1 =>New style AUTOINC locking; 2 => No AUTOINC locking(unsafe for SBR)--innodb-buffer-pool-chunk-size=#Size of a single memory chunk within each buffer poolinstance for resizing buffer pool. Online buffer poolresizing happens at this granularity.--innodb-buffer-pool-dump-at-shutdownDump the buffer pool into a file named@@innodb_buffer_pool_filename(Defaults to on; use --skip-innodb-buffer-pool-dump-at-shutdown to disable.)--innodb-buffer-pool-dump-nowTrigger an immediate dump of the buffer pool into a filenamed @@innodb_buffer_pool_filename--innodb-buffer-pool-dump-pct=#Dump only the hottest N% of each buffer pool, defaults to25--innodb-buffer-pool-filename=nameFilename to/from which to dump/load the InnoDB bufferpool--innodb-buffer-pool-in-core-fileThis option has no effect if @@core_file is OFF. If@@core_file is ON, and this option is OFF, then the coredump file will be generated only if it is possible toexclude buffer pool from it. As soon as it will bedetermined that such exclusion is impossible a warningwill be emitted and @@core_file will be set to OFF toprevent generating a core dump. If this option is enabled(which is the default), then core dumping logic will notbe affected.(Defaults to on; use --skip-innodb-buffer-pool-in-core-file to disable.)--innodb-buffer-pool-instances=#Number of buffer pool instances, set to higher value onhigh-end machines to increase scalability--innodb-buffer-pool-load-abortAbort a currently running load of the buffer pool--innodb-buffer-pool-load-at-startupLoad the buffer pool from a file named@@innodb_buffer_pool_filename(Defaults to on; use --skip-innodb-buffer-pool-load-at-startup to disable.)--innodb-buffer-pool-load-nowTrigger an immediate load of the buffer pool from a filenamed @@innodb_buffer_pool_filename--innodb-buffer-pool-size=#The size of the memory buffer InnoDB uses to cache dataand indexes of its tables.--innodb-change-buffer-max-size=#Maximum on-disk size of change buffer in terms ofpercentage of the buffer pool.--innodb-change-buffering=nameBuffer changes to reduce random access: OFF, ON,inserting, deleting, changing, or purging.--innodb-checksum-algorithm=nameThe algorithm InnoDB uses for page checksumming. Possiblevalues are CRC32 (hardware accelerated if the CPUsupports it) write crc32, allow any of the otherchecksums to match when reading; STRICT_CRC32 writecrc32, do not allow other algorithms to match whenreading; INNODB write a software calculated checksum,allow any other checksums to match when reading;STRICT_INNODB write a software calculated checksum, donot allow other algorithms to match when reading; NONEwrite a constant magic number, do not do any checksumverification when reading; STRICT_NONE write a constantmagic number, do not allow values other than that magicnumber when reading; Files updated when this option isset to crc32 or strict_crc32 will not be readable byMySQL versions older than 5.6.3--innodb-cmp-per-index-enabledEnable INFORMATION_SCHEMA.innodb_cmp_per_index, may havenegative impact on performance (off by default)--innodb-commit-concurrency=#Helps in performance tuning in heavily concurrentenvironments.--innodb-compression-failure-threshold-pct[=#]If the compression failure rate of a table is greaterthan this number more padding is added to the pages toreduce the failures. A value of zero implies no padding--innodb-compression-level=#Compression level used for compressed row format.  0 isno compression, 1 is fastest, 9 is best compression anddefault is 6.--innodb-compression-pad-pct-max[=#]Percentage of empty space on a data page that can bereserved to make the page compressible.--innodb-concurrency-tickets=#Number of times a thread is allowed to enter InnoDBwithin the same SQL query after it has once got theticket--innodb-data-file-path=namePath to individual files and their sizes.--innodb-data-home-dir=nameThe common part for InnoDB table spaces.--innodb-ddl-buffer-size=#Maximum size of memory to use (in bytes) for DDL.--innodb-ddl-threads=#Maximum number of threads to use for  DDL.--innodb-deadlock-detectEnable/disable InnoDB deadlock detector (default ON). ifset to OFF, deadlock detection is skipped, and we rely oninnodb_lock_wait_timeout in case of deadlock.(Defaults to on; use --skip-innodb-deadlock-detect to disable.)--innodb-dedicated-serverAutomatically scale innodb_buffer_pool_size andinnodb_redo_log_capacity based on system memory. Also setinnodb_flush_method=O_DIRECT_NO_FSYNC, if supported--innodb-default-row-format=nameThe default ROW FORMAT for all innodb tables createdwithout explicit ROW_FORMAT. Possible values areREDUNDANT, COMPACT, and DYNAMIC. The ROW_FORMAT valueCOMPRESSED is not allowed--innodb-directories=nameList of directories 'dir1;dir2;..;dirN' to scan fortablespace files. Default is to scan'innodb-data-home-dir;innodb-undo-directory;datadir'--innodb-disable-sort-file-cacheWhether to disable OS system file cache for sort I/O--innodb-doublewrite[=name]Enable InnoDB doublewrite buffer (enabled by default).Disable with --skip-innodb-doublewrite.--innodb-doublewrite-batch-size=#Number of double write pages to write in a batch--innodb-doublewrite-dir=nameUse a separate directory for the doublewrite bufferfiles,--innodb-doublewrite-files=#Number of double write files--innodb-doublewrite-pages=#Number of double write pages per thread--innodb-extend-and-initializeInitialize the allocated space by writing zeros (enabledby default).(Defaults to on; use --skip-innodb-extend-and-initialize to disable.)--innodb-fast-shutdown[=#]Speeds up the shutdown process of the InnoDB storageengine. Possible values are 0, 1 (faster) or 2 (fastest -crash-like).--innodb-file-per-tableStores each InnoDB table to an .ibd file in the databasedir.(Defaults to on; use --skip-innodb-file-per-table to disable.)--innodb-fill-factor=#Percentage of B-tree page filled during bulk insert--innodb-flush-log-at-timeout[=#]Write and flush logs every (n) second.--innodb-flush-log-at-trx-commit[=#]Set to 0 (write and flush once per second), 1 (write andflush at each commit), or 2 (write at commit, flush onceper second).--innodb-flush-method=nameWith which method to flush data--innodb-flush-neighbors[=#]Set to 0 (don't flush neighbors from buffer pool), 1(flush contiguous neighbors from buffer pool) or 2 (flushneighbors from buffer pool), when flushing a block--innodb-flush-sync Allow IO bursts at the checkpoints ignoring io_capacitysetting.(Defaults to on; use --skip-innodb-flush-sync to disable.)--innodb-flushing-avg-loops=#Number of iterations over which the background flushingis averaged.--innodb-force-load-corruptedForce InnoDB to load metadata of corrupted table.--innodb-force-recovery=#Helps to save your data in case the disk image of thedatabase becomes corrupt.--innodb-fsync-threshold=#The value of this variable determines how often InnoDBcalls fsync when creating a new file. Default is zerowhich would make InnoDB flush the entire file at oncebefore closing it.--innodb-ft-aux-tableFTS internal auxiliary table to be checked--innodb-ft-cache-size=#InnoDB Fulltext search cache size in bytes--innodb-ft-enable-diag-printWhether to enable additional FTS diagnostic printout--innodb-ft-enable-stopwordCreate FTS index with stopword.(Defaults to on; use --skip-innodb-ft-enable-stopword to disable.)--innodb-ft-max-token-size=#InnoDB Fulltext search maximum token size in characters--innodb-ft-min-token-size=#InnoDB Fulltext search minimum token size in characters--innodb-ft-num-word-optimize[=#]InnoDB Fulltext search number of words to optimize foreach optimize table call--innodb-ft-result-cache-limit=#InnoDB Fulltext search query result cache limit in bytes--innodb-ft-server-stopword-table[=name]The user supplied stopword table name.--innodb-ft-sort-pll-degree=#InnoDB Fulltext search parallel sort degree, will roundup to nearest power of 2 number--innodb-ft-total-cache-size=#Total memory allocated for InnoDB Fulltext Search cache--innodb-ft-user-stopword-table[=name]User supplied stopword table name, effective in thesession level.--innodb-idle-flush-pct=#Up to what percentage of dirty pages to be flushed whenserver is found idle.--innodb-io-capacity=#Number of IOPs the server can do. Tunes the background IOrate--innodb-io-capacity-max=#Limit to which innodb_io_capacity can be inflated.--innodb-lock-wait-timeout=#Timeout in seconds an InnoDB transaction may wait for alock before being rolled back. Values above 100000000disable the timeout.--innodb-log-buffer-size=#The size of the buffer which InnoDB uses to write log tothe log files on disk.--innodb-log-checksumsWhether to compute and require checksums for InnoDB redolog blocks(Defaults to on; use --skip-innodb-log-checksums to disable.)--innodb-log-compressed-pagesEnables/disables the logging of entire compressed pageimages. InnoDB logs the compressed pages to preventcorruption if the zlib compression algorithm changes.When turned OFF, InnoDB will assume that the zlibcompression algorithm doesn't change.(Defaults to on; use --skip-innodb-log-compressed-pages to disable.)--innodb-log-file-size=#Size of each log file before upgrading to 8.0.30.Deprecated.--innodb-log-files-in-group=#Number of log files before upgrading to 8.0.30.Deprecated.--innodb-log-group-home-dir=namePath to InnoDB log files.--innodb-log-spin-cpu-abs-lwm=#Minimum value of cpu time for which spin-delay is used.Expressed in percentage of single cpu core.--innodb-log-spin-cpu-pct-hwm=#Maximum value of cpu time for which spin-delay is used.Expressed in percentage of all cpu cores.--innodb-log-wait-for-flush-spin-hwm=#Maximum value of average log flush time for whichspin-delay is used. When flushing takes longer, userthreads no longer spin when waiting forflushed redo.Expressed in microseconds.--innodb-log-write-ahead-size=#Log write ahead unit size to avoid read-on-write, itshould match the OS cache block IO size.--innodb-log-writer-threadsWhether the log writer threads should be activated (ON),or write/flush of the redo log should be done by eachthread individually (OFF).(Defaults to on; use --skip-innodb-log-writer-threads to disable.)--innodb-lru-scan-depth=#How deep to scan LRU to keep it clean--innodb-max-dirty-pages-pct=#Percentage of dirty pages allowed in bufferpool.--innodb-max-dirty-pages-pct-lwm=#Percentage of dirty pages at which flushing kicks in.--innodb-max-purge-lag=#Desired maximum length of the purge queue (0 = no limit)--innodb-max-purge-lag-delay=#Maximum delay of user threads in micro-seconds--innodb-max-undo-log-size[=#]Maximum size of an UNDO tablespace in MB (If an UNDOtablespace grows beyond this size it will be truncated indue course).--innodb-monitor-disable=nameTurn off a monitor counter--innodb-monitor-enable=nameTurn on a monitor counter--innodb-monitor-reset=nameReset a monitor counter--innodb-monitor-reset-all=nameReset all values for a monitor counter--innodb-numa-interleaveUse NUMA interleave memory policy to allocate InnoDBbuffer pool.--innodb-old-blocks-pct=#Percentage of the buffer pool to reserve for 'old'blocks.--innodb-old-blocks-time=#Move blocks to the 'new' end of the buffer pool if thefirst access was at least this many milliseconds ago. Thetimeout is disabled if 0.--innodb-online-alter-log-max-size=#Maximum modification log file size for online indexcreation--innodb-open-files=#How many files at the maximum InnoDB keeps open at thesame time.--innodb-optimize-fulltext-onlyOnly optimize the Fulltext index of the table--innodb-page-cleaners[=#]Page cleaner threads can be from 1 to 64. Default is 4.--innodb-page-size[=#]Page size to use for all InnoDB tablespaces.--innodb-parallel-read-threads=#Number of threads to do parallel read.--innodb-print-all-deadlocksPrint all deadlocks to MySQL error log (off by default)--innodb-print-ddl-logsPrint all DDl logs to MySQL error log (off by default)--innodb-purge-batch-size[=#]Number of UNDO log pages to purge in one batch from thehistory list.--innodb-purge-rseg-truncate-frequency[=#]Dictates rate at which UNDO records are purged. Value Nmeans purge rollback segment(s) on every Nth iteration ofpurge invocation--innodb-purge-threads[=#]Purge threads can be from 1 to 32. Default is 4.--innodb-random-read-aheadWhether to use read ahead for random access within anextent.--innodb-read-ahead-threshold=#Number of pages that must be accessed sequentially forInnoDB to trigger a readahead.--innodb-read-io-threads=#Number of background read I/O threads in InnoDB.--innodb-read-only  Start InnoDB in read only mode (off by default)--innodb-redo-log-archive-dirs=nameLimit the location of the redo log archive to thesemicolon separated list of labeled directories--innodb-redo-log-capacity=#Limitation for total size of redo log files on disk(expressed in bytes).--innodb-redo-log-encryptEnable or disable Encryption of REDO tablespace.--innodb-replication-delay=#Replication thread delay (ms) on the slave server ifinnodb_thread_concurrency is reached (0 by default)--innodb-rollback-on-timeoutRoll back the complete transaction on lock wait timeout,for 4.x compatibility (disabled by default)--innodb-rollback-segments[=#]Number of rollback segments per tablespace. This appliesto the system tablespace, the temporary tablespace & anyundo tablespace.--innodb-segment-reserve-factor[=#]The segment_reserve_factor is the ratio x/y expressed inpercentage, where x is the number of free pages in thesegment, and y is the total number of pages in thesegment.  The number of used pages in the segment isgiven by (y-x). The number of free pages in the segment(x) will be maintained such that the actualsegment_reserve_factor will be >= the requestedsegment_reserve_factor, which is contained in thisvariable.--innodb-sort-buffer-size=#Memory buffer size for index creation--innodb-spin-wait-delay[=#]Maximum delay between polling for a spin lock (6 bydefault)--innodb-spin-wait-pause-multiplier=#Controls how many times in a row to use a PAUSEinstruction to achieve one unit of delay in a spin lock(see @@innodb_spin_wait_delay), defaults to 50--innodb-stats-auto-recalcInnoDB automatic recalculation of persistent statisticsenabled for all tables unless overridden at table level(automatic recalculation is only done when InnoDB decidesthat the table has changed too much and needs a newstatistics)(Defaults to on; use --skip-innodb-stats-auto-recalc to disable.)--innodb-stats-include-delete-markedInclude delete marked records when calculating persistentstatistics--innodb-stats-method=nameSpecifies how InnoDB index statistics collection codeshould treat NULLs. Possible values are NULLS_EQUAL(default), NULLS_UNEQUAL and NULLS_IGNORED--innodb-stats-on-metadataEnable statistics gathering for metadata commands such asSHOW TABLE STATUS for tables that use transientstatistics (off by default)--innodb-stats-persistentInnoDB persistent statistics enabled for all tablesunless overridden at table level(Defaults to on; use --skip-innodb-stats-persistent to disable.)--innodb-stats-persistent-sample-pages=#The number of leaf index pages to sample when calculatingpersistent statistics (by ANALYZE, default 20)--innodb-stats-transient-sample-pages=#The number of leaf index pages to sample when calculatingtransient statistics (if persistent statistics are notused, default 8)--innodb-status-fileEnable SHOW ENGINE INNODB STATUS output in theinnodb_status.<pid> file--innodb-status-outputEnable InnoDB monitor output to the error log.--innodb-status-output-locksEnable InnoDB lock monitor output to the error log.Requires innodb_status_output=ON.--innodb-strict-modeUse strict mode when evaluating create options.(Defaults to on; use --skip-innodb-strict-mode to disable.)--innodb-sync-array-size[=#]Size of the mutex/lock wait array.--innodb-sync-spin-loops=#Count of spin-loop rounds in InnoDB mutexes (30 bydefault)--innodb-table-locksEnable InnoDB locking in LOCK TABLES(Defaults to on; use --skip-innodb-table-locks to disable.)--innodb-temp-data-file-path=namePath to files and their sizes making temp-tablespace.--innodb-temp-tablespaces-dir=nameDirectory where temp tablespace files live, this path canbe absolute.--innodb-thread-concurrency=#Helps in performance tuning in heavily concurrentenvironments. Sets the maximum number of threads allowedinside InnoDB. Value 0 will disable the threadthrottling.--innodb-thread-sleep-delay=#Time of innodb thread sleeping before joining InnoDBqueue (usec). Value 0 disable a sleep--innodb-tmpdir[=name]Directory for temporary non-tablespace files.--innodb-undo-directory=nameDirectory where undo tablespace files live, this path canbe absolute.--innodb-undo-log-encryptEnable or disable Encrypt of UNDO tablespace.--innodb-undo-log-truncateEnable or Disable Truncate of UNDO tablespace.(Defaults to on; use --skip-innodb-undo-log-truncate to disable.)--innodb-undo-tablespaces=#Number of undo tablespaces to use. (deprecated)--innodb-use-fdatasyncUse fdatasync() instead of the default fsync().--innodb-use-native-aioUse native AIO if supported on this platform.(Defaults to on; use --skip-innodb-use-native-aio to disable.)--innodb-validate-tablespace-pathsEnable validation of tablespace paths against the DD.(enabled by default). Disable with--skip-innodb-validate-tablespace-paths.(Defaults to on; use --skip-innodb-validate-tablespace-paths to disable.)--innodb-write-io-threads=#Number of background write I/O threads in InnoDB.--interactive-timeout=#The number of seconds the server waits for activity on aninteractive connection before closing it--internal-tmp-mem-storage-engine=nameThe default storage engine for in-memory internaltemporary tables.--join-buffer-size=#The size of the buffer that is used for full joins--keep-files-on-createDon't overwrite stale .MYD and .MYI even if no directoryis specified--key-buffer-size=# The size of the buffer used for index blocks for MyISAMtables. Increase this to get better index handling (forall reads and multiple writes) to as much as you canafford--key-cache-age-threshold=#This characterizes the number of hits a hot block has tobe untouched until it is considered aged enough to bedowngraded to a warm block. This specifies the percentageratio of that number of hits to the total number ofblocks 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=nameKeyring plugin or component to which the keys aremigrated to.--keyring-migration-host=nameConnect to host.-p, --keyring-migration-password[=name]Password to use when connecting to server during keyringmigration. If password value is not specified then itwill be asked from the tty.--keyring-migration-port=#Port number to use for connection.--keyring-migration-socket=nameThe socket file to use for connection.--keyring-migration-source=nameKeyring plugin from where the keys needs to be migratedto. This option must be specified along with--keyring-migration-destination.--keyring-migration-to-componentMigrate from keyring plugin to keyring component.--keyring-migration-user=nameUser to login to server.-L, --language=name Client error messages in given language. May be given asa 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=nameDirectory where error messages are--lc-time-names=nameSet the language used for the month names and the days ofthe week.--local-infile      Enable LOAD DATA LOCAL INFILE--lock-wait-timeout=#Timeout in seconds to wait for a lock before returning anerror.--log-bin[=name]    Configures the name prefix to use for binary log files.If the --log-bin option is not supplied, the name prefixdefaults to "binlog". If the --log-bin option is suppliedwithout 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=nameFile that holds the names for binary log files.--log-bin-trust-function-creatorsIf set to FALSE (the default), then when --log-bin isused, creation of a stored function (or trigger) isallowed only to users having the SUPER privilege and onlyif this stored function (trigger) may not break binarylogging. Note that if ALL connections to this serverALWAYS use row-based binary logging, the security issuesdo not exist and the binary logging cannot break, so youcan safely set this to TRUE. This variable is deprecatedand will be removed in a future version.--log-bin-use-v1-row-eventsIf equal to 1 then version 1 row events are written to arow based binary log.  If equal to 0, then the latestversion of events are written.  This option is usefulduring some upgrades.--log-error[=name]  Error log file--log-error-services=nameServices that should be called when an error event isreceived--log-error-suppression-list=nameComma-separated list of error-codes. Error messagescorresponding to these codes will not be included in theerror log. Only events with a severity of Warning orInformation can be suppressed; events with System orError severity will always be included. Requires thefilter '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, andnotes. Messages sent to the client are unaffected by thissetting.--log-isam[=name]   Log all MyISAM changes to file.--log-output=name   Syntax: log-output=value[,value...], where "value" couldbe TABLE, FILE or NONE--log-queries-not-using-indexesLog queries that are executed without benefit of anyindex to the slow log if it is open--log-raw           Log to general log before any rewriting of the query. Foruse in debugging, not production as sensitive informationmay be logged.--log-replica-updatesIf enabled, the replication applier threads will write tothis 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-querylogs.--log-slave-updates This option is deprecated. Use log_replica_updatesinstead.(Defaults to on; use --skip-log-slave-updates to disable.)--log-slow-admin-statementsLog slow OPTIMIZE, ANALYZE, ALTER and otheradministrative statements to the slow log if it is open.--log-slow-extra    Print more attributes to the slow query log file. Has noeffect on logging to table.--log-slow-replica-statementsLog slow statements executed by the replication applierthreads to the slow log if it is open.--log-slow-slave-statementsThis option is deprecated. Uselog_slow_replica_statements instead.--log-statements-unsafe-for-binlogLog statements considered unsafe when using statementbased binary logging. This variable is deprecated andwill be removed in a future version.(Defaults to on; use --skip-log-statements-unsafe-for-binlog to disable.)--log-tc=name       Path to transaction coordinator log (used fortransactions that affect more than one storage engine,when binary log is disabled).--log-tc-size=#     Size of transaction coordinator log.--log-throttle-queries-not-using-indexes=#Log at most this many 'not using index' warnings perminute to the slow log. Any further warnings will becondensed into a single summary line. A value of 0disables throttling. Option has no effect unless--log_queries_not_using_indexes is set.--log-timestamps=nameUTC to timestamp log files in zulu time, for more concisetimestamps and easier correlation of logs from serversfrom multiple time zones, or SYSTEM to use the system'slocal time. This affects only log files, not log tables,as the timestamp columns of the latter can be convertedat will.--long-query-time=# Log all queries that have taken more than long_query_timeseconds to execute to file. The argument will be treatedas a decimal value with microsecond precision--low-priority-updatesINSERT/DELETE/UPDATE has lower priority than selects--lower-case-table-names[=#]If set to 1 table names are stored in lowercase on diskand table names will be case-insensitive.  Should be setto 2 if you are using a case insensitive file system--mandatory-roles=nameAll the specified roles are always considered granted toevery user and they can't be revoked. Mandatory rolesstill require activation unless they are made intodefault roles. The granted roles will not be visible inthe mysql.role_edges table.--master-info-file=nameThe path and filename where the replication receiverthread stores connection configuration and positions, incase --master-info-repository=FILE. This option isdeprecated and will be removed in a future version.--master-info-repository=nameThe repository format for the replication connectionconfiguration.--master-retry-count=#The number of times this replica will attempt to connectto a source before giving up. This option is deprecatedand will be removed in a future version. Use 'CHANGEREPLICATION SOURCE TO SOURCE_RETRY_COUNT = <num>'instead.--master-verify-checksumThis option is deprecated. Use source_verify_checksuminstead.--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 ofreplication.--max-binlog-size=# Binary log will be rotated automatically when the sizeexceeds this value. Will also apply to relay logs ifmax_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 interruptedconnections from a host this host will be blocked fromfurther connections--max-connections=# The number of simultaneous clients allowed--max-delayed-threads=#Don't start more than this number of threads to handleINSERT DELAYED statements. If set to zero INSERT DELAYEDwill be not used. This variable is deprecated along withINSERT 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 specifiednumber 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 thanmax_join_size records return an error--max-length-for-sort-data=#This variable is deprecated and will be removed in afuture release.--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 whenthe size exceeds this value; if zero: when the sizeexceeds max_binlog_size--max-seeks-for-key=#Limit assumed max number of seeks when looking up rowsbased on a key--max-sort-length=# The number of bytes to use when sorting long values withPAD SPACE collations (only the first max_sort_lengthbytes of each value are used; the rest are ignored)--max-sp-recursion-depth[=#]Maximum stored procedure recursion depth--max-user-connections=#The maximum number of active connections for a singleuser (0 = no limit)--max-write-lock-count=#After this many write locks, allow some read locks to runin between--memlock           Lock mysqld in memory.--min-examined-row-limit=#Don't write queries to slow log that examine fewer rowsthan that--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 ifthe temporary file would get bigger than this--myisam-mmap-size=#Restricts the total memory used for memory mapping ofMySQL tables--myisam-recover-options[=name]Syntax: myisam-recover-options[=option[,option...]],where option can be DEFAULT, BACKUP, FORCE, QUICK, or OFF--myisam-sort-buffer-size=#The buffer that is allocated when sorting the index whendoing a REPAIR or when creating indexes with CREATE INDEXor ALTER TABLE--myisam-stats-method=nameSpecifies how MyISAM index statistics collection codeshould treat NULLs. Possible values of name areNULLS_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-usersIf set to FALSE (the default), then themysql_native_password plugin will not signal forauthenticated users to be checked for mapping to proxyusers.  When set to TRUE, the plugin will flag associatedauthenticated accounts to be mapped to proxy users whenthe server option check_proxy_users is enabled.--mysqlx[=name]     Enable or disable mysqlx plugin. Possible values are ON,OFF, FORCE (don't start if the plugin fails to load).--mysqlx-bind-address[=name]Address to which X Plugin should bind the TCP socketoptionally followed by a network namespace delimited with/. E.g., the string value 127.0.0.1/red specifies tolisten on IP address 127.0.0.1 from the network namespace'red'.--mysqlx-cache-cleaner[=name]Enable or disable mysqlx_cache_cleaner plugin. Possiblevalues are ON, OFF, FORCE (don't start if the pluginfails to load).--mysqlx-compression-algorithms[=name]Compression algorithms: where option can beDEFLATE_STREAM, LZ4_MESSAGE, ZSTD_STREAM--mysqlx-connect-timeout[=#]Maximum allowed waiting time for connection to setup asession (in seconds).--mysqlx-deflate-default-compression-level[=#]Default value of compression level for deflate algorithm--mysqlx-deflate-max-client-compression-level[=#]Max value of compression level for deflate algorithm--mysqlx-document-id-unique-prefix[=#]Unique prefix is a value assigned by InnoDB cluster tothe instance, which is meant to make document id uniqueacross all replicasets from the same cluster--mysqlx-enable-hello-noticeHello notice is a X Protocol message send by the serverafter connection establishment, using this variable itcan be disabled(Defaults to on; use --skip-mysqlx-enable-hello-notice to disable.)--mysqlx-idle-worker-thread-timeout[=#]Time after which an idle worker thread is terminated (inseconds).--mysqlx-interactive-timeout[=#]Default value for "mysqlx_wait_timeout", when theconnection is interactive. The value defines number orseconds that X Plugin must wait for activity oninteractive connection--mysqlx-lz4-default-compression-level[=#]Default value of compression level for lz4 algorithm--mysqlx-lz4-max-client-compression-level[=#]Max value of compression level for lz4 algorithm--mysqlx-max-allowed-packet[=#]Size of largest message that client is going to handle.--mysqlx-max-connections[=#]Maximum number of concurrent X protocol connections.Actual number of connections is also affected by thegeneral max_connections.--mysqlx-min-worker-threads[=#]Minimal number of worker threads.--mysqlx-port[=#]   Port on which X Plugin is going to accept incomingconnections.--mysqlx-port-open-timeout[=#]How long X Plugin is going to retry binding of serversocket (in case of failure)--mysqlx-read-timeout[=#]Number or seconds that X Plugin must wait for blockingread operation to complete--mysqlx-socket[=name]X Plugin's unix socket for local connection.--mysqlx-ssl-ca=nameCA file in PEM format.--mysqlx-ssl-capath=nameCA directory.--mysqlx-ssl-cert=nameX509 cert in PEM format.--mysqlx-ssl-cipher=nameSSL cipher to use.--mysqlx-ssl-crl=nameCertificate revocation list.--mysqlx-ssl-crlpath=nameCertificate revocation list path.--mysqlx-ssl-key=nameX509 key in PEM format.--mysqlx-wait-timeout[=#]Number or seconds that X Plugin must wait for activity onnoninteractive connection--mysqlx-write-timeout[=#]Number or seconds that X Plugin must wait for blockingwrite operation to complete--mysqlx-zstd-default-compression-level[=#]Default value of compression level for zstd algorithm--mysqlx-zstd-max-client-compression-level[=#]Max value of compression level for zstd algorithm--net-buffer-length=#Buffer length for TCP/IP and socket communication--net-read-timeout=#Number of seconds to wait for more data from a connectionbefore aborting the read--net-retry-count=# If a read on a communication port is interrupted, retrythis many times before giving up--net-write-timeout=#Number of seconds to wait for a block to be written to aconnection before aborting the write-n, --new           Use very new possible "unsafe" functions--ngram[=name]      Enable or disable ngram plugin. Possible values are ON,OFF, FORCE (don't start if the plugin fails to load).--ngram-token-size=#InnoDB ngram full text plugin parser token size incharacters--no-dd-upgrade     Abort restart if automatic upgrade or downgrade of thedata 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-limitsEnable old-style user limits (before 5.0.3, userresources were counted for each user + host vs. peraccount). This option is deprecated and will be removedin a future version.--open-files-limit=#If this is not 0, then mysqld will use this value toreserve file descriptors to use with setrlimit(). If thisvalue is 0 then mysqld will reserve max_connections*5 ormax_connections + table_open_cache*2 (whichever islarger) number of file descriptors--optimizer-max-subgraph-pairs=#Maximum depth of subgraph pairs a query can have beforethe hypergraph join optimizer starts reducing the searchspace heuristically. Larger values may result in betterquery plans for large queries, but also more time andmemory spent during planning. Increasing this larger thanthe actual number of subgraph pairs in the query willhave no further effect. Ignored by the old(non-hypergraph) join optimizer--optimizer-prune-level=#Controls the heuristic(s) applied during queryoptimization to prune less-promising partial plans fromthe optimizer search space. Meaning: 0 - do not apply anyheuristic, thus perform exhaustive search; 1 - pruneplans 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 queryresult in better query plans, but take longer to compilea query. Values smaller than the number of tables in arelation result in faster optimization, but may producevery bad query plans. If set to 0, the system willautomatically pick a reasonable value--optimizer-switch=nameoptimizer_switch=option=val[,option=val...], where optionis 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} andval is one of {on, off, default}--optimizer-trace=nameControls tracing of the Optimizer:optimizer_trace=option=val[,option=val...], where optionis one of {enabled, one_line} and val is one of {on,default}--optimizer-trace-features=nameEnables/disables tracing of selected features of theOptimizer: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--parser-max-mem-size=#Maximum amount of memory available to the parser--partial-revokes   Access of database objects can be restricted, even ifuser has global privileges granted.--password-history=#The number of old passwords to check in the history. Setto 0 (the default) to turn the checks off--password-require-currentCurrent password is needed to be specified in order tochange it--password-reuse-interval=#The minimum number of days that need to pass before apassword can be reused. Set to 0 (the default) to turnthe checks off--performance-schemaEnable the performance schema.(Defaults to on; use --skip-performance-schema to disable.)--performance-schema-accounts-size=#Maximum number of instrumented user@host accounts. Use 0to disable, -1 for automated scaling.--performance-schema-consumer-events-stages-currentDefault startup value for the events_stages_currentconsumer.--performance-schema-consumer-events-stages-historyDefault startup value for the events_stages_historyconsumer.--performance-schema-consumer-events-stages-history-longDefault startup value for the events_stages_history_longconsumer.--performance-schema-consumer-events-statements-cpuDefault startup value for the events_statements_cpuconsumer.--performance-schema-consumer-events-statements-currentDefault startup value for the events_statements_currentconsumer.(Defaults to on; use --skip-performance-schema-consumer-events-statements-current to disable.)--performance-schema-consumer-events-statements-historyDefault startup value for the events_statements_historyconsumer.(Defaults to on; use --skip-performance-schema-consumer-events-statements-history to disable.)--performance-schema-consumer-events-statements-history-longDefault startup value for theevents_statements_history_long consumer.--performance-schema-consumer-events-transactions-currentDefault startup value for the events_transactions_currentconsumer.(Defaults to on; use --skip-performance-schema-consumer-events-transactions-current to disable.)--performance-schema-consumer-events-transactions-historyDefault startup value for the events_transactions_historyconsumer.(Defaults to on; use --skip-performance-schema-consumer-events-transactions-history to disable.)--performance-schema-consumer-events-transactions-history-longDefault startup value for theevents_transactions_history_long consumer.--performance-schema-consumer-events-waits-currentDefault startup value for the events_waits_currentconsumer.--performance-schema-consumer-events-waits-historyDefault startup value for the events_waits_historyconsumer.--performance-schema-consumer-events-waits-history-longDefault startup value for the events_waits_history_longconsumer.--performance-schema-consumer-global-instrumentationDefault startup value for the global_instrumentationconsumer.(Defaults to on; use --skip-performance-schema-consumer-global-instrumentation to disable.)--performance-schema-consumer-statements-digestDefault startup value for the statements_digest consumer.(Defaults to on; use --skip-performance-schema-consumer-statements-digest to disable.)--performance-schema-consumer-thread-instrumentationDefault startup value for the thread_instrumentationconsumer.(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 forautomated sizing.--performance-schema-error-size=#Number of server errors instrumented.--performance-schema-events-stages-history-long-size=#Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 todisable, -1 for automated sizing.--performance-schema-events-stages-history-size=#Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0to disable, -1 for automated sizing.--performance-schema-events-statements-history-long-size=#Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. Use 0to 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 0to 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 todisable, -1 for automated sizing.--performance-schema-events-waits-history-size=#Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0to 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 schemainstrument.--performance-schema-max-cond-classes=#Maximum number of condition instruments.--performance-schema-max-cond-instances=#Maximum number of instrumented condition objects. Use 0to disable, -1 for automated scaling.--performance-schema-max-digest-length=#Maximum length considered for digest text, when stored inperformance_schema tables.--performance-schema-max-digest-sample-age=#The time in seconds after which a previous query sampleis considered old. When the value is 0, queries aresampled once. When the value is greater than zero,queries are re sampled if the last sample is more thanperformance_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 instrumentedtables. 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, -1for 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 todisable, -1 for automated scaling.--performance-schema-max-prepared-statements-instances=#Maximum number of instrumented prepared statements. Use 0to disable, -1 for automated scaling.--performance-schema-max-program-instances=#Maximum number of instrumented programs. Use 0 todisable, -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 todisable, -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 todisable, -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 todisable, -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 instrumentedtables. 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 0to 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 todisable, -1 for automated scaling.--performance-schema-show-processlistDefault startup value to enable SHOW PROCESSLIST in theperformance 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 enablesetting all system variables via SET PERSIST[_ONLY]--persist-sensitive-variables-in-plaintextIf set to FALSE, server will refuse to persist SENSITIVEvariables in plaintext and refuse to start if encryptedpart of persited file cannot be processed.(Defaults to on; use --skip-persist-sensitive-variables-in-plaintext to disable.)--persisted-globals-loadWhen this option is enabled, config file mysqld-auto.cnfis read and applied to server, else this file is ignoredeven 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, wherename is the plugin name and library is the plugin libraryin plugin_dir.--plugin-load-add=nameOptional semicolon-separated list of plugins to load,where each plugin is identified as name=library, wherename is the plugin name and library is the plugin libraryin 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 becomefree. (Default: No wait).--preload-buffer-size=#The size of the buffer that is allocated when preloadingindexes--print-identified-with-as-hexSHOW CREATE USER will print the AS clause as HEX if itcontains non-prinable characters--profiling-history-size=#Limit of query profiling memory--protocol-compression-algorithms=nameList 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 ofalgorithms, and the connection will use an algorithmsupported by both client and server. It picks zlib ifboth client and server support it; otherwise it pickszstd if both support it; otherwise it picks uncompressedif both support it; otherwise it fails.--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 duringoptimization--range-optimizer-max-mem-size=#Maximum amount of memory used by the range optimizer toallocate predicates during range analysis. The larger thenumber, more memory may be consumed during rangeanalysis. If the value is too low to completed rangeoptimization of a query, index range scan will not beconsidered for this query. A value of 0 means rangeoptimizer does not have any cap on memory.--read-buffer-size=#Each thread that does a sequential scan allocates abuffer of this size for each table it scans. If you domany sequential scans, you may want to increase thisvalue--read-only         Make all non-temporary tables read-only, with theexception for replication applier threads and users withthe SUPER privilege.--read-rnd-buffer-size=#When reading rows in sorted order after a sort, the rowsare 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 thematch engine, typically on the order of milliseconds.--relay-log=name    The location and name to use for relay logs--relay-log-index=nameFile that holds the names for relay log files.--relay-log-info-file=nameThe location and name of the file that remembers wherethe SQL replication thread is in the relay logs--relay-log-info-repository=nameDefines the type of the repository for the relay loginformation and associated workers.--relay-log-purge   if disabled - do not purge relay logs. if enabled - purgethem as soon as they are no more needed(Defaults to on; use --skip-relay-log-purge to disable.)--relay-log-recoveryIf enabled, existing relay logs will be skipped by thereplication threads. The receiver will start a new relaylog and the applier will start reading from the beginningof that file. The receiver's position relative to thesource will be reset to the applier's position relativeto the source; the receiver uses this in caseSOURCE_AUTO_POSITION=0.--relay-log-space-limit=#Maximum space to use for all relay logs--replica-allow-batchingAllow this replica to batch requests when using the NDBstorage engine.(Defaults to on; use --skip-replica-allow-batching to disable.)--replica-checkpoint-group=#When using multi-threaded applier(replica_parallel_workers>0), it will update the workerprogress status periodically. This option specifies themaximum number of committed transactions between updates.--replica-checkpoint-period=#When using a multi-threaded applier(replica_parallel_workers>0), it will update the workerprogress status periodically. This option specifies themaximum number of milliseconds between updates.--replica-compressed-protocolUse compression in the source/replica protocol.--replica-exec-mode=nameModes for how replication events should be executed.Legal values are STRICT (default) and IDEMPOTENT. InIDEMPOTENT mode, replication will ignore duplicate keyerrors and key not found errors. In STRICT mode,replication will stop at those errors.--replica-load-tmpdir=nameThe location where this replica will store temporaryfiles when replicating a LOAD DATA INFILE command from asource having binlog_format=STATEMENT.--replica-max-allowed-packet=#The maximum size of packets sent from an upstream sourceserver to this server.--replica-net-timeout=#Number of seconds to wait for more data from areplication connection before aborting the read.--replica-parallel-type=nameThe method used by the replication applier to parallelizetransactions. DATABASE, indicates that it may applytransactions in parallel in case they update differentdatabases. LOGICAL_CLOCK, which is the default, indicatesthat it decides whether two transactions can be appliedin parallel using the logical timestamps computed by thesource, according tobinlog_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 ofevents that have not yet been applied. The queue size mayexceed this limit in case a single event is bigger thanthe limit.--replica-preserve-commit-orderForce replication worker threads to commit in the sameorder as on the source. Enabled by default(Defaults to on; use --skip-replica-preserve-commit-order to disable.)--replica-skip-errors=nameComma-separated list of error numbers. If an applierthread on this replica encounters one of these errorswhile applying a Query_log_event, it will ignore theerror, rather than stop.--replica-sql-verify-checksumForce checksum verification of replication events afterreading them from relay log. Note: The replica alwaysverifies checksums for events received from the network,if the event has a checksum at all, before it writes theevent 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 atransaction in case it failed with a deadlock or othertransient error, before it gives up and stops.--replica-type-conversions=nameSet of type conversions that may be used by thereplication applier thread for row events. Allowed valuesare: ALL_LOSSY to enable lossy conversions, ALL_NON_LOSSYto enable non-lossy conversions, ALL_UNSIGNED to treatall integer column type data to be unsigned values, andALL_SIGNED to treat all integer column type data to besigned values. Default treatment is ALL_SIGNED. IfALL_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 conversionsare allowed and it is expected that the types matchexactly.--replicate-do-db=nameMake replication applier threads apply only changes tothe specified database. To specify more than onedatabase, use the directive multiple times, once for eachdatabase. Note that this will only work if you do not usecross-database queries such as UPDATE some_db.some_tableSET foo='bar' while having selected a different or nodatabase. If you need cross database updates to work,make sure you have 3.23.28 or later, and usereplicate-wild-do-table=db_name.%.--replicate-do-table=nameMake replication applier threads apply only changes tothe specified table. To specify more than one table, usethe directive multiple times, once for each table. Thiswill work for cross-database updates, in contrast toreplicate-do-db.--replicate-ignore-db=nameMake replication applier threads skip changes to thespecified database. To specify more than one database toignore, use this option multiple times, once for eachdatabase. If there are statements that update multipledatabases, this will work correctly only when the sourceserver uses binlog_format=ROW.--replicate-ignore-table=nameMake replication applier threads skip changes to thespecified table.To ignore more than one table, use theoption multiple times, once for each table. If there arestatements that update multiple tables, this will workcorrectly only when the source server usesbinlog_format=ROW.--replicate-rewrite-db=nameMake replication applier threads rename a database, sochanges in one database on the source will be applied inanother database on this replica. Example:replicate-rewrite-db=source_db_name->replica_db_name.--replicate-same-server-idIn replication, if set to 1, do not skip events havingour server id. Default value is 0 (to break infiniteloops in circular replication). Can't be set to 1 if--log-replica-updates is used.--replicate-wild-do-table=nameMake replication applier threads apply changes only intables that match the specified wildcard pattern. Tospecify more than one pattern, use the option multipletimes, once for each pattern. If there are statementsthat update both tables that are included and excluded bythe pattern, this will only work correctly when thesource server uses binlog_format=ROW. Example:replicate-wild-do-table=foo%.bar% will replicate onlyupdates to tables in all databases that start with fooand whose table names start with bar.--replicate-wild-ignore-table=nameMake replication applier threads skip changes to tablesthat match the specified wildcard pattern. To specifymore than one pattern, use the option multiple times,once for each pattern. If there are statements thatupdate both tables that are included and tables that areexcluded by the pattern, this will only work correctlywhen the source server uses binlog_format=ROW. Example:when using replicate-wild-ignore-table=foo%.bar%, theapplier thread will not apply updates to tables indatabases that start with foo and whose table names startwith bar.--replication-optimize-for-static-plugin-configOptional flag that blocks plugin install/uninstall andallows skipping the acquisition of the lock to read fromthe plugin list and the usage of read-optimizedspin-locks. Use only when plugin hook callback needsoptimization (a lot of semi-sync replicas, for instance).--replication-sender-observe-commit-onlyOptional flag that allows for only calling back observerhooks at commit.--report-host=name  Hostname or IP that this replica will report to thesource while initiating the replication connection. Willappear in the output of SHOW REPLICAS. Leave this unsetif you do not want the replica to register itself withthe source. Note that it is not sufficient for the sourceto simply read the IP of the replica off the socket oncethe replica connects: in the presence of NAT otherrouting features, that IP may not be valid for connectingto the replica from the source or other hosts.--report-password=nameThe account password that this replica will report to thesource while initiating the replication connection.--report-port=#     The port for connecting to the replica, which thisreplica will report to the source while initiating thereplication connection. Set it only if the replica islistening on a non-default port or if you have a specialtunnel 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 tothe source while initiating the replication connection.--require-secure-transportWhen this option is enabled, connections attempted usinginsecure transport will be rejected.  Secure transportsare SSL/TLS, Unix socket or Shared Memory (on Windows).--rpl-read-size=#   The size for reads done from the binlog and relay log. Itmust be a multiple of 4kb. Making it larger might helpwith IO stalls while reading these files when they arenot in the OS buffer cache--rpl-stop-replica-timeout=#Timeout in seconds to wait for replication threads tostop, before STOP REPLICA returns a warning.--rpl-stop-slave-timeout=#This option is deprecated. Use rpl_stop_replica_timeoutinstead.--safe-user-create  Don't allow new user creation by the user who has nowrite 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 asecondary storage engine. Only statements that have acost estimate higher than this value will be attemptedexecuted in a secondary storage engine.--secure-file-priv=nameLimit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() tofiles within specified directory--select-into-buffer-size[=#]Buffer size for SELECT INTO OUTFILE/DUMPFILE.--select-into-disk-syncSynchronize flushed buffer with disk for SELECT INTOOUTFILE/DUMPFILE.--select-into-disk-sync-delay[=#]The delay in milliseconds after each buffer sync forSELECT INTO OUTFILE/DUMPFILE. Requiresselect_into_sync_disk = ON.--server-id=#       Uniquely identifies the server instance in the communityof replication partners--server-id-bits=#  Set number of significant bits in server-id--session-track-gtids=nameControls the amount of global transaction ids to beincluded in the response packet sent by theserver.(Default: OFF).--session-track-schemaTrack changes to the 'default schema'.(Defaults to on; use --skip-session-track-schema to disable.)--session-track-state-changeTrack changes to the 'session state'.--session-track-system-variables=nameTrack changes in registered system variables.--session-track-transaction-info=nameTrack changes to the transaction attributes. OFF todisable; STATE to track just transaction state (Is therean active transaction? Does it have any data? etc.);CHARACTERISTICS to track transaction state and report allstatements needed to start a transaction with the samecharacteristics (isolation level, read only/read write,snapshot - but not any work done / data modified withinthe transaction).--sha256-password-auto-generate-rsa-keysAuto generate RSA keys at server startup if correspondingsystem variables are not specified and key files are notpresent at the default location.(Defaults to on; use --skip-sha256-password-auto-generate-rsa-keys to disable.)--sha256-password-private-key-path=nameA fully qualified path to the private RSA key used forauthentication--sha256-password-proxy-usersIf set to FALSE (the default), then the sha256_passwordauthentication plugin will not signal for authenticatedusers to be checked for mapping to proxy users.  When setto TRUE, the plugin will flag associated authenticatedaccounts to be mapped to proxy users when the serveroption check_proxy_users is enabled.--sha256-password-public-key-path=nameA fully qualified path to the public RSA key used forauthentication--show-create-table-verbosityWhen this option is enabled, it increases the verbosityof 'SHOW CREATE TABLE'.--show-gipk-in-create-table-and-information-schemaWhen set, if a primary key is generated for a table thenSHOW commands and INFORMATION_SCHEMA tables showsgenerated invisible primary key definition.(Defaults to on; use --skip-show-gipk-in-create-table-and-information-schema to disable.)--show-old-temporalsWhen this option is enabled, the pre-5.6.4 temporal typeswill be marked in the 'SHOW CREATE TABLE' and'INFORMATION_SCHEMA.COLUMNS' table as a comment inCOLUMN_TYPE field. This variable is deprecated and willbe removed in a future release.--show-replica-auth-infoInclude user and password in SHOW REPLICAS statements.--show-slave-auth-infoThis option is deprecated and will be removed in a futureversion. Use show-replica-auth-info instead.--skip-grant-tables Start without grant tables. This gives all users FULLACCESS to all tables.--skip-host-cache   Don't cache host names.--skip-name-resolve Don't resolve hostnames. All hostnames are IP's or'localhost'.--skip-networking   Don't allow connection with TCP/IP--skip-new          Don't use new, possibly wrong routines.--skip-replica-startDo not start replication threads automatically when theserver starts.--skip-show-databaseDon't allow 'SHOW DATABASE' commands--skip-slave-start  This option is deprecated. Use skip_replica_startinstead.--skip-stack-trace  Don't print a stack trace on failure.--slave-allow-batchingThis option is deprecated. Use replica_allow_batchinginstead.(Defaults to on; use --skip-slave-allow-batching to disable.)--slave-checkpoint-group=#This option is deprecated. Use replica_checkpoint_groupinstead.--slave-checkpoint-period=#This option is deprecated. Use replica_checkpoint_periodinstead.--slave-compressed-protocolThis option is deprecated. Usereplica_compressed_protocol instead.--slave-exec-mode=nameThis option is deprecated. Use replica_exec_mode instead.--slave-load-tmpdir=nameThis option is deprecated. Use replica_load_tmpdirinstead.--slave-max-allowed-packet=#This option is deprecated. Use replica_max_allowed_packetinstead.--slave-net-timeout=#This option is deprecated. Use replica_net_timeoutinstead.--slave-parallel-type=nameThis option is deprecated. Use replica_parallel_typeinstead.--slave-parallel-workers=#This option is deprecated. Use replica_parallel_workersinstead.--slave-pending-jobs-size-max=#This option is deprecated. Usereplica_pending_jobs_size_max instead.--slave-preserve-commit-orderThis option is deprecated. Usereplica_preserve_commit_order instead.(Defaults to on; use --skip-slave-preserve-commit-order to disable.)--slave-rows-search-algorithms=nameThe set of algorithms used by the replication applierwhile searching the table for rows to update or delete.Possible values are: INDEX_SCAN, TABLE_SCAN andHASH_SCAN. Any combination is allowed, and the applierpicks the most efficient among them for any givenscenario. (Default: INDEX_SCAN, HASH_SCAN).--slave-skip-errors=nameThis option is deprecated. Use replica_skip_errorsinstead.--slave-sql-verify-checksumThis option is deprecated. Usereplica_sql_verify_checksum instead.(Defaults to on; use --skip-slave-sql-verify-checksum to disable.)--slave-transaction-retries=#This option is deprecated. Usereplica_transaction_retries instead.--slave-type-conversions=nameThis option is deprecated. Use replica_type_conversionsinstead.--slow-launch-time=#If creating the thread takes longer than this value (inseconds), the Slow_launch_threads counter will beincremented--slow-query-log    Log slow queries to a table or log file. Defaults loggingto a file hostname-slow.log or a table mysql.slow_log if--log-output=TABLE is used. Must be enabled to activateother slow log options--slow-query-log-file=nameLog slow queries to given log file. Defaults logging tohostname-slow.log. Must be enabled to activate other slowlog options--socket=name       Socket file to use for connection--sort-buffer-size=#Each thread that needs to do a sort allocates a buffer ofthis size--source-verify-checksumForce checksum verification of events in binary logbefore sending them to replicas or printing them inoutput of SHOW BINLOG EVENTS. Disabled by default.--sporadic-binlog-dump-failOption used by mysql-test for debugging and testing ofreplication.--sql-generate-invisible-primary-keyWhen set, if a table is created without a primary keythen server generates invisible auto-increment column asa primary key for the table.--sql-mode=name     Syntax: sql-mode=mode[,mode[,mode...]]. See the manualfor the complete list of valid sql modes--sql-require-primary-keyWhen set, tables must be created with a primary key, andan existing primary key cannot be removed with 'ALTERTABLE'. Attempts to do so will result in an error.--ssl               Enable SSL for connection (automatically enabled withother flags).(Defaults to on; use --skip-ssl to disable.)--ssl-ca=name       CA file in PEM format (check OpenSSL docs, implies --ssl)--ssl-capath=name   CA directory (check OpenSSL docs, implies --ssl)--ssl-cert=name     X509 cert in PEM format (implies --ssl)--ssl-cipher=name   SSL cipher to use (implies --ssl)--ssl-crl=name      CRL file in PEM format (check OpenSSL docs, implies--ssl)--ssl-crlpath=name  CRL directory (check OpenSSL docs, implies --ssl)--ssl-fips-mode=nameSSL FIPS mode (applies only for OpenSSL); permittedvalues are: OFF, ON, STRICT--ssl-key=name      X509 key in PEM format (implies --ssl)--ssl-session-cache-modeIs TLS session cache enabled or not(Defaults to on; use --skip-ssl-session-cache-mode to disable.)--ssl-session-cache-timeout=#The timeout to expire sessions in the TLS session cache--stored-program-cache=#The soft upper limit for number of cached stored routinesfor one connection.--stored-program-definition-cache=#The number of cached stored program definitions--super-large-pages Enable support for super large pages.--super-read-only   Make all non-temporary tables read-only, with theexception for replication applier threads.  Users withthe SUPER privilege are affected, unlike read_only.Setting super_read_only to ON also sets read_only to ON.-s, --symbolic-linksEnable symbolic link support (deprecated and will beremoved in a future release).--sync-binlog=#     Synchronously flush binary log to disk after every #thwrite 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 #thevent. 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.This variable is deprecated and will be removed in afuture version.--sync-source-info=#Synchronize replication receiver positions to diskperiodically, after the specified number of events. Use 0to disable periodic synchronization.--sysdate-is-now    Non-default option to alias SYSDATE() to NOW() to make itsafe-replicable. Since 5.0, SYSDATE() returns a `dynamic'value different for different invocations, even withinthe same statement.--table-definition-cache=#The number of cached table definitions--table-encryption-privilege-checkIndicates if server enables privilege check when usertries to use non-default value for CREATE DATABASE orCREATE TABLESPACE or when user tries to do CREATE TABLEwith ENCRYPTION option which deviates from per-databasedefault.--table-open-cache=#The number of cached open tables (total for all tablecache instances)--table-open-cache-instances=#The number of table cache instances--tablespace-definition-cache=#The number of cached tablespace definitions--tc-heuristic-recover=nameDecision to use in heuristic recover process. Possiblevalues are OFF, COMMIT or ROLLBACK.--temptable-max-mmap=#Maximum amount of memory (in bytes) the TempTable storageengine is allowed to allocate from MMAP-backed filesbefore starting to store data on disk.--temptable-max-ram=#Maximum amount of memory (in bytes) the TempTable storageengine is allowed to allocate from the main memory (RAM)before starting to store data on disk.--temptable-use-mmapUse mmap files for temptables. This variable isdeprecated and will be removed in a future release.(Defaults to on; use --skip-temptable-use-mmap to disable.)--terminology-use-previous=nameMake monitoring tables and statements use the identifiersthat were in use before they were changed in a givenrelease. That includes names for mutexes, read/writelocks, condition variables, memory allocations, threadnames, thread stages, and thread commands. When thesession option is set to BEFORE_8_0_26, the session usesthe names that were in use until 8.0.25, when it selectsfrom performance_schema tables, or selects fromINFORMATION_SCHEMA.PROCESSLIST, or issues SHOWPROCESSLIST or SHOW REPLICA STATUS. When the globaloption is set to BEFORE_8_0_26, new sessions useBEFORE_8_0_26 as default for the session option, and inaddition the thread commands that were in use until8.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=nameDefine threads usage for handling queries, one ofone-thread-per-connection, no-threads, loaded-dynamically--thread-stack=#    The stack size for each thread--tls-ciphersuites=nameTLS v1.3 ciphersuite to use (implies --ssl)--tls-version=name  TLS version, permitted values are TLSv1.2, TLSv1.3--tmp-table-size=#  If an internal in-memory temporary table in the MEMORY orTempTable storage engine exceeds this size, MySQL willautomatically 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 around-robin fashion--transaction-alloc-block-size=#Allocation block size for transactions to be stored inbinary log--transaction-isolation=nameDefault transaction isolation level.--transaction-prealloc-size=#Persistent buffer for transactions to be stored in binarylog--transaction-read-onlyDefault transaction access mode. True if transactions areread-only.--transaction-write-set-extraction[=name]This option is used to let the server know when toextract the write set which will be used for variouspurposes.--updatable-views-with-limit=nameYES = Don't issue an error message (warning only) if aVIEW without presence of a key of the underlying table isused in queries with a LIMIT clause for updating. NO =Prohibit update of a VIEW, which does not contain a keyof the underlying table and the query uses a LIMIT clause(usually get from GUI tools)--upgrade=name      Set server upgrade mode. NONE to abort server ifautomatic upgrade of the server is needed; MINIMAL tostart the server, but skip upgrade steps that are notabsolutely necessary; AUTO (default) to upgrade theserver if required; FORCE to force upgrade server.-u, --user=name     Run mysqld daemon as user.--validate-config   Validate the server configuration specified by the user.--validate-user-pluginsTurns on additional validation of authentication pluginsassigned 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 aconnection before closing it--windowing-use-high-precisionFor SQL window functions, determines whether to enableinversion optimization for moving window frames also forfloating values.(Defaults to on; use --skip-windowing-use-high-precision to disable.)--xa-detach-on-prepareWhen set, XA transactions will be detached (AKAdissociated or disconnected) from connection as part ofXA PREPARE. This means that the XA transaction can becommitted/rolled back by any connection, even if thestarting connection has not terminated, and the startingconnection can start new transactions. As a side effect,temporary tables cannot be used inside XA transactions.When disabled, XA transactions are associated with thesame connection until the session disconnects. ON is theonly safe choice for replication.(Defaults to on; use --skip-xa-detach-on-prepare to disable.)Variables (--variable-name=value)
and boolean options {FALSE|TRUE}                             Value (after reading options)
------------------------------------------------------------ -------------
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)
admin-tls-version                                            TLSv1.2,TLSv1.3
allow-suspicious-udfs                                        FALSE
archive                                                      ON
authentication-policy                                        *,,
auto-generate-certs                                          TRUE
auto-increment-increment                                     1
auto-increment-offset                                        1
autocommit                                                   TRUE
automatic-sp-privileges                                      TRUE
avoid-temporal-upgrade                                       FALSE
back-log                                                     151
basedir                                                      /usr/
big-tables                                                   FALSE
bind-address                                                 127.0.0.1
binlog-cache-size                                            32768
binlog-checksum                                              CRC32
binlog-direct-non-transactional-updates                      FALSE
binlog-encryption                                            FALSE
binlog-error-action                                          ABORT_SERVER
binlog-expire-logs-auto-purge                                TRUE
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                                          MINIMAL
binlog-row-value-options
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
blackhole                                                    ON
block-encryption-mode                                        aes-128-ecb
bulk-insert-buffer-size                                      8388608
caching-sha2-password-auto-generate-rsa-keys                 TRUE
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                                           /usr/share/mysql/charsets/
check-proxy-users                                            FALSE
chroot                                                       (No default value)
collation-server                                             utf8mb4_0900_ai_ci
completion-type                                              NO_CHAIN
concurrent-insert                                            AUTO
connect-timeout                                              10
connection-memory-chunk-size                                 8192
connection-memory-limit                                      18446744073709551615
console                                                      FALSE
create-admin-listener-thread                                 FALSE
cte-max-recursion-depth                                      1000
daemonize                                                    FALSE
datadir                                                      /var/lib/mysql/
default-authentication-plugin                                caching_sha2_password
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
disabled-storage-engines
disconnect-on-expired-password                               TRUE
disconnect-slave-event-count                                 0
div-precision-increment                                      4
end-markers-in-json                                          FALSE
enforce-gtid-consistency                                     FALSE
eq-range-index-dive-limit                                    200
event-scheduler                                              ON
expire-logs-days                                             0
explain-format                                               TRADITIONAL
explicit-defaults-for-timestamp                              TRUE
external-locking                                             FALSE
federated                                                    OFF
flush                                                        FALSE
flush-time                                                   0
ft-boolean-syntax                                            + -><()~*:""&|
ft-max-word-len                                              84
ft-min-word-len                                              4
ft-query-expansion-limit                                     20
ft-stopword-file                                             (No default value)
gdb                                                          FALSE
general-log                                                  FALSE
general-log-file                                             /var/lib/mysql/mysql-vm.log
generated-random-password-length                             20
global-connection-memory-limit                               18446744073709551615
global-connection-memory-tracking                            FALSE
group-concat-max-len                                         1024
group-replication-consistency                                EVENTUAL
gtid-executed-compression-period                             0
gtid-mode                                                    OFF
help                                                         TRUE
histogram-generation-max-mem-size                            20000000
host-cache-size                                              279
information-schema-stats-expiry                              86400
init-connect
init-file                                                    (No default value)
init-replica
init-slave
initialize                                                   FALSE
initialize-insecure                                          FALSE
innodb-adaptive-flushing                                     TRUE
innodb-adaptive-flushing-lwm                                 10
innodb-adaptive-hash-index                                   TRUE
innodb-adaptive-hash-index-parts                             8
innodb-adaptive-max-sleep-delay                              150000
innodb-api-bk-commit-interval                                5
innodb-api-disable-rowlock                                   FALSE
innodb-api-enable-binlog                                     FALSE
innodb-api-enable-mdl                                        FALSE
innodb-api-trx-level                                         0
innodb-autoextend-increment                                  64
innodb-autoinc-lock-mode                                     2
innodb-buffer-pool-chunk-size                                134217728
innodb-buffer-pool-dump-at-shutdown                          TRUE
innodb-buffer-pool-dump-now                                  FALSE
innodb-buffer-pool-dump-pct                                  25
innodb-buffer-pool-filename                                  ib_buffer_pool
innodb-buffer-pool-in-core-file                              TRUE
innodb-buffer-pool-instances                                 0
innodb-buffer-pool-load-abort                                FALSE
innodb-buffer-pool-load-at-startup                           TRUE
innodb-buffer-pool-load-now                                  FALSE
innodb-buffer-pool-size                                      134217728
innodb-change-buffer-max-size                                25
innodb-change-buffering                                      all
innodb-checksum-algorithm                                    crc32
innodb-cmp-per-index-enabled                                 FALSE
innodb-commit-concurrency                                    0
innodb-compression-failure-threshold-pct                     5
innodb-compression-level                                     6
innodb-compression-pad-pct-max                               50
innodb-concurrency-tickets                                   5000
innodb-data-file-path                                        ibdata1:12M:autoextend
innodb-data-home-dir                                         (No default value)
innodb-ddl-buffer-size                                       1048576
innodb-ddl-threads                                           4
innodb-deadlock-detect                                       TRUE
innodb-dedicated-server                                      FALSE
innodb-default-row-format                                    dynamic
innodb-directories                                           (No default value)
innodb-disable-sort-file-cache                               FALSE
innodb-doublewrite                                           ON
innodb-doublewrite-batch-size                                0
innodb-doublewrite-dir                                       (No default value)
innodb-doublewrite-files                                     0
innodb-doublewrite-pages                                     0
innodb-extend-and-initialize                                 TRUE
innodb-fast-shutdown                                         1
innodb-file-per-table                                        TRUE
innodb-fill-factor                                           100
innodb-flush-log-at-timeout                                  1
innodb-flush-log-at-trx-commit                               1
innodb-flush-method                                          fsync
innodb-flush-neighbors                                       0
innodb-flush-sync                                            TRUE
innodb-flushing-avg-loops                                    30
innodb-force-load-corrupted                                  FALSE
innodb-force-recovery                                        0
innodb-fsync-threshold                                       0
innodb-ft-aux-table                                          (No default value)
innodb-ft-cache-size                                         8000000
innodb-ft-enable-diag-print                                  FALSE
innodb-ft-enable-stopword                                    TRUE
innodb-ft-max-token-size                                     84
innodb-ft-min-token-size                                     3
innodb-ft-num-word-optimize                                  2000
innodb-ft-result-cache-limit                                 2000000000
innodb-ft-server-stopword-table                              (No default value)
innodb-ft-sort-pll-degree                                    2
innodb-ft-total-cache-size                                   640000000
innodb-ft-user-stopword-table                                (No default value)
innodb-idle-flush-pct                                        100
innodb-io-capacity                                           200
innodb-io-capacity-max                                       4294967295
innodb-lock-wait-timeout                                     50
innodb-log-buffer-size                                       16777216
innodb-log-checksums                                         TRUE
innodb-log-compressed-pages                                  TRUE
innodb-log-file-size                                         50331648
innodb-log-files-in-group                                    2
innodb-log-group-home-dir                                    (No default value)
innodb-log-spin-cpu-abs-lwm                                  80
innodb-log-spin-cpu-pct-hwm                                  50
innodb-log-wait-for-flush-spin-hwm                           400
innodb-log-write-ahead-size                                  8192
innodb-log-writer-threads                                    TRUE
innodb-lru-scan-depth                                        1024
innodb-max-dirty-pages-pct                                   90
innodb-max-dirty-pages-pct-lwm                               10
innodb-max-purge-lag                                         0
innodb-max-purge-lag-delay                                   0
innodb-max-undo-log-size                                     1073741824
innodb-monitor-disable                                       (No default value)
innodb-monitor-enable                                        (No default value)
innodb-monitor-reset                                         (No default value)
innodb-monitor-reset-all                                     (No default value)
innodb-numa-interleave                                       FALSE
innodb-old-blocks-pct                                        37
innodb-old-blocks-time                                       1000
innodb-online-alter-log-max-size                             134217728
innodb-open-files                                            0
innodb-optimize-fulltext-only                                FALSE
innodb-page-cleaners                                         4
innodb-page-size                                             16384
innodb-parallel-read-threads                                 4
innodb-print-all-deadlocks                                   FALSE
innodb-print-ddl-logs                                        FALSE
innodb-purge-batch-size                                      300
innodb-purge-rseg-truncate-frequency                         128
innodb-purge-threads                                         4
innodb-random-read-ahead                                     FALSE
innodb-read-ahead-threshold                                  56
innodb-read-io-threads                                       4
innodb-read-only                                             FALSE
innodb-redo-log-archive-dirs                                 (No default value)
innodb-redo-log-capacity                                     104857600
innodb-redo-log-encrypt                                      FALSE
innodb-replication-delay                                     0
innodb-rollback-on-timeout                                   FALSE
innodb-rollback-segments                                     128
innodb-segment-reserve-factor                                12.5
innodb-sort-buffer-size                                      1048576
innodb-spin-wait-delay                                       6
innodb-spin-wait-pause-multiplier                            50
innodb-stats-auto-recalc                                     TRUE
innodb-stats-include-delete-marked                           FALSE
innodb-stats-method                                          nulls_equal
innodb-stats-on-metadata                                     FALSE
innodb-stats-persistent                                      TRUE
innodb-stats-persistent-sample-pages                         20
innodb-stats-transient-sample-pages                          8
innodb-status-file                                           FALSE
innodb-status-output                                         FALSE
innodb-status-output-locks                                   FALSE
innodb-strict-mode                                           TRUE
innodb-sync-array-size                                       1
innodb-sync-spin-loops                                       30
innodb-table-locks                                           TRUE
innodb-temp-data-file-path                                   ibtmp1:12M:autoextend
innodb-temp-tablespaces-dir                                  (No default value)
innodb-thread-concurrency                                    0
innodb-thread-sleep-delay                                    10000
innodb-tmpdir                                                (No default value)
innodb-undo-directory                                        (No default value)
innodb-undo-log-encrypt                                      FALSE
innodb-undo-log-truncate                                     TRUE
innodb-undo-tablespaces                                      2
innodb-use-fdatasync                                         FALSE
innodb-use-native-aio                                        TRUE
innodb-validate-tablespace-paths                             TRUE
innodb-write-io-threads                                      4
interactive-timeout                                          28800
internal-tmp-mem-storage-engine                              TempTable
join-buffer-size                                             262144
keep-files-on-create                                         FALSE
key-buffer-size                                              16777216
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-socket                                     (No default value)
keyring-migration-source                                     (No default value)
keyring-migration-to-component                               FALSE
keyring-migration-user                                       (No default value)
language                                                     /usr/share/mysql/
large-pages                                                  FALSE
lc-messages                                                  en_US
lc-messages-dir                                              /usr/share/mysql/
lc-time-names                                                en_US
local-infile                                                 FALSE
lock-wait-timeout                                            31536000
log-bin                                                      binlog
log-bin-index                                                binlog.index
log-bin-trust-function-creators                              FALSE
log-bin-use-v1-row-events                                    FALSE
log-error                                                    stderr
log-error-services                                           log_filter_internal; log_sink_internal
log-error-suppression-list
log-error-verbosity                                          1
log-isam                                                     myisam.log
log-output                                                   FILE
log-queries-not-using-indexes                                FALSE
log-raw                                                      FALSE
log-replica-updates                                          TRUE
log-short-format                                             FALSE
log-slave-updates                                            TRUE
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                                                  24576
log-throttle-queries-not-using-indexes                       0
log-timestamps                                               UTC
long-query-time                                              10
low-priority-updates                                         FALSE
lower-case-table-names                                       2
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                                              104857600
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-points-in-geometry                                       65536
max-prepared-stmt-count                                      16382
max-relay-log-size                                           0
max-seeks-for-key                                            18446744073709551615
max-sort-length                                              1024
max-sp-recursion-depth                                       0
max-user-connections                                         0
max-write-lock-count                                         18446744073709551615
memlock                                                      FALSE
min-examined-row-limit                                       0
myisam-block-size                                            1024
myisam-data-pointer-size                                     6
myisam-max-sort-file-size                                    9223372036853727232
myisam-mmap-size                                             18446744073709551615
myisam-recover-options                                       BACKUP
myisam-sort-buffer-size                                      8388608
myisam-stats-method                                          nulls_unequal
myisam-use-mmap                                              FALSE
mysql-native-password-proxy-users                            FALSE
mysqlx                                                       ON
mysqlx-bind-address                                          127.0.0.1
mysqlx-cache-cleaner                                         ON
mysqlx-compression-algorithms                                DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM
mysqlx-connect-timeout                                       30
mysqlx-deflate-default-compression-level                     3
mysqlx-deflate-max-client-compression-level                  5
mysqlx-document-id-unique-prefix                             0
mysqlx-enable-hello-notice                                   TRUE
mysqlx-idle-worker-thread-timeout                            60
mysqlx-interactive-timeout                                   28800
mysqlx-lz4-default-compression-level                         2
mysqlx-lz4-max-client-compression-level                      8
mysqlx-max-allowed-packet                                    67108864
mysqlx-max-connections                                       100
mysqlx-min-worker-threads                                    2
mysqlx-port                                                  33060
mysqlx-port-open-timeout                                     0
mysqlx-read-timeout                                          30
mysqlx-socket                                                (No default value)
mysqlx-ssl-ca                                                (No default value)
mysqlx-ssl-capath                                            (No default value)
mysqlx-ssl-cert                                              (No default value)
mysqlx-ssl-cipher                                            (No default value)
mysqlx-ssl-crl                                               (No default value)
mysqlx-ssl-crlpath                                           (No default value)
mysqlx-ssl-key                                               (No default value)
mysqlx-wait-timeout                                          28800
mysqlx-write-timeout                                         60
mysqlx-zstd-default-compression-level                        3
mysqlx-zstd-max-client-compression-level                     11
net-buffer-length                                            16384
net-read-timeout                                             30
net-retry-count                                              10
net-write-timeout                                            60
new                                                          FALSE
ngram                                                        ON
ngram-token-size                                             2
no-dd-upgrade                                                FALSE
offline-mode                                                 FALSE
old                                                          FALSE
old-alter-table                                              FALSE
old-style-user-limits                                        FALSE
open-files-limit                                             8161
optimizer-max-subgraph-pairs                                 100000
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
parser-max-mem-size                                          18446744073709551615
partial-revokes                                              FALSE
password-history                                             0
password-require-current                                     FALSE
password-reuse-interval                                      0
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                                5293
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                     219
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
persist-sensitive-variables-in-plaintext                     TRUE
persisted-globals-load                                       TRUE
pid-file                                                     /var/lib/mysql/mysql-vm.pid
plugin-dir                                                   /usr/lib/mysql/plugin/
port                                                         3306
port-open-timeout                                            0
preload-buffer-size                                          32768
print-identified-with-as-hex                                 FALSE
profiling-history-size                                       15
protocol-compression-algorithms                              zlib,zstd,uncompressed
query-alloc-block-size                                       8192
query-prealloc-size                                          8192
range-alloc-block-size                                       4096
range-optimizer-max-mem-size                                 8388608
read-buffer-size                                             131072
read-only                                                    FALSE
read-rnd-buffer-size                                         262144
regexp-stack-limit                                           8000000
regexp-time-limit                                            32
relay-log                                                    mysql-vm-relay-bin
relay-log-index                                              mysql-vm-relay-bin.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                                       TRUE
replica-checkpoint-group                                     512
replica-checkpoint-period                                    300
replica-compressed-protocol                                  FALSE
replica-exec-mode                                            STRICT
replica-load-tmpdir                                          /tmp
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
rpl-read-size                                                8192
rpl-stop-replica-timeout                                     31536000
rpl-stop-slave-timeout                                       31536000
safe-user-create                                             FALSE
schema-definition-cache                                      256
secondary-engine-cost-threshold                              100000
secure-file-priv                                             /var/lib/mysql-files
select-into-buffer-size                                      131072
select-into-disk-sync                                        FALSE
select-into-disk-sync-delay                                  0
server-id                                                    1
server-id-bits                                               32
session-track-gtids                                          OFF
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-auto-generate-rsa-keys                       TRUE
sha256-password-private-key-path                             private_key.pem
sha256-password-proxy-users                                  FALSE
sha256-password-public-key-path                              public_key.pem
show-create-table-verbosity                                  FALSE
show-gipk-in-create-table-and-information-schema             TRUE
show-old-temporals                                           FALSE
show-replica-auth-info                                       FALSE
show-slave-auth-info                                         FALSE
skip-grant-tables                                            FALSE
skip-name-resolve                                            FALSE
skip-networking                                              FALSE
skip-replica-start                                           FALSE
skip-show-database                                           FALSE
skip-slave-start                                             FALSE
slave-allow-batching                                         TRUE
slave-checkpoint-group                                       512
slave-checkpoint-period                                      300
slave-compressed-protocol                                    FALSE
slave-exec-mode                                              STRICT
slave-load-tmpdir                                            /tmp
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-skip-errors                                            (No default value)
slave-sql-verify-checksum                                    TRUE
slave-transaction-retries                                    10
slave-type-conversions
slow-launch-time                                             2
slow-query-log                                               FALSE
slow-query-log-file                                          /var/lib/mysql/mysql-vm-slow.log
socket                                                       /var/run/mysqld/mysqld.sock
sort-buffer-size                                             262144
source-verify-checksum                                       FALSE
sporadic-binlog-dump-fail                                    FALSE
sql-generate-invisible-primary-key                           FALSE
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
ssl                                                          TRUE
ssl-ca                                                       (No default value)
ssl-capath                                                   (No default value)
ssl-cert                                                     (No default value)
ssl-cipher                                                   (No default value)
ssl-crl                                                      (No default value)
ssl-crlpath                                                  (No default value)
ssl-fips-mode                                                OFF
ssl-key                                                      (No default value)
ssl-session-cache-mode                                       TRUE
ssl-session-cache-timeout                                    300
stored-program-cache                                         256
stored-program-definition-cache                              256
super-large-pages                                            FALSE
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-definition-cache                                       2000
table-encryption-privilege-check                             FALSE
table-open-cache                                             4000
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)
tls-version                                                  TLSv1.2,TLSv1.3
tmp-table-size                                               16777216
tmpdir                                                       /tmp
transaction-alloc-block-size                                 8192
transaction-isolation                                        REPEATABLE-READ
transaction-prealloc-size                                    4096
transaction-read-only                                        FALSE
transaction-write-set-extraction                             XXHASH64
updatable-views-with-limit                                   YES
upgrade                                                      AUTO
validate-config                                              FALSE
validate-user-plugins                                        TRUE
verbose                                                      TRUE
wait-timeout                                                 28800
windowing-use-high-precision                                 TRUE
xa-detach-on-prepare                                         TRUETo see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --verbose --help'.
ubuntu@mysql-vm:~$

参考

5.1.5 Server System Variable Reference
https://dev.mysql.com/doc/refman/8.0/en/server-system-variable-reference.html
5.1.8 Server System Variables
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html