Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # docker run -it --rm percona:5 --verbose --help
- mysqld Ver 5.7.25-28 for Linux on x86_64 (Percona Server (GPL), Release 28, Revision c335905)
- Copyright (c) 2009-2019 Percona LLC and/or its affiliates
- Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
- 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 /usr/etc/my.cnf ~/.my.cnf
- The following groups are read: mysqld server mysqld-5.7
- The following options may be given as the first argument:
- --print-defaults Print the program argument list and exit.
- --no-defaults Don't read default options from any option file,
- except for login file.
- --defaults-file=# Only read default options from the given file #.
- --defaults-extra-file=# Read this file after the global files are read.
- --defaults-group-suffix=#
- Also read groups with concat(group, suffix)
- --login-path=# Read this path from the login file.
- --abort-slave-event-count=#
- Option used by mysql-test for debugging and testing of
- replication.
- --allow-suspicious-udfs
- Allows use of UDFs consisting of only one symbol xxx()
- without corresponding xxx_init() or xxx_deinit(). That
- also means that one can load any function from any
- library, for example exit() from libc.so
- -a, --ansi Use ANSI SQL syntax instead of MySQL syntax. This mode
- will also set transaction isolation level 'serializable'.
- --archive[=name] Enable or disable ARCHIVE plugin. Possible values are ON,
- OFF, FORCE (don't start if the plugin fails to load).
- --auto-generate-certs
- Auto generate SSL certificates at server startup if --ssl
- is set to ON and none of the other SSL system variables
- are specified and certificate/key files are not present
- in 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 when
- auto-increment-increment != 1
- --autocommit Set default value for autocommit (0 or 1)
- (Defaults to on; use --skip-autocommit to disable.)
- --automatic-sp-privileges
- Creating and dropping stored procedures alters ACLs
- (Defaults to on; use --skip-automatic-sp-privileges to disable.)
- --avoid-temporal-upgrade
- When this option is enabled, the pre-5.6.4 temporal types
- are not upgraded to the new format for ALTER TABLE
- requests ADD/CHANGE/MODIFY COLUMN, ADD INDEX or FORCE
- operation. This variable is deprecated and will be
- removed in a future release.
- --back-log=# The number of outstanding connection requests MySQL can
- have. This comes into play when the main MySQL thread
- gets very many connection requests in a very short time
- -b, --basedir=name Path to installation directory. All paths are usually
- resolved relative to this
- --big-tables Allow big result sets by saving all temporary sets on
- file (Solves most 'table full' errors)
- --bind-address=name IP address to bind to.
- --binlog-cache-size=#
- The size of the transactional cache for updates to
- transactional engines for the binary log. If you often
- use transactions containing many statements, you can
- increase this to get more performance
- --binlog-checksum=name
- Type of BINLOG_CHECKSUM_ALG. Include checksum for log
- events in the binary log. Possible values are NONE and
- CRC32; default is CRC32.
- --binlog-direct-non-transactional-updates
- Causes updates to non-transactional engines using
- statement format to be written directly to binary log.
- Before using this option make sure that there are no
- dependencies between transactional and non-transactional
- tables such as in the statement INSERT INTO t_myisam
- SELECT * FROM t_innodb; otherwise, slaves may diverge
- from the master.
- --binlog-do-db=name Tells the master it should log updates for the specified
- database, and exclude all others not explicitly
- mentioned.
- --binlog-error-action=name
- When statements cannot be written to the binary log due
- to a fatal error, the server can either ignore the error
- and let the master continue, or abort.
- --binlog-format=name
- What form of binary logging the master will use: either
- ROW for row-based binary logging, STATEMENT for
- statement-based binary logging, or MIXED. MIXED is
- statement-based binary logging except for those
- statements where only row-based is correct: those which
- involve user-defined functions (i.e. UDFs) or the UUID()
- function; for those, row-based binary logging is
- automatically used. If NDBCLUSTER is enabled and
- binlog-format is MIXED, the format switches to row-based
- and back implicitly per each query accessing an
- NDBCLUSTER table
- --binlog-group-commit-sync-delay=#
- The number of microseconds the server waits for the
- binary log group commit sync queue to fill before
- continuing. Default: 0. Min: 0. Max: 1000000.
- --binlog-group-commit-sync-no-delay-count=#
- If there are this many transactions in the commit sync
- queue and the server is waiting for more transactions to
- be enqueued (as set using
- --binlog-group-commit-sync-delay), the commit procedure
- resumes.
- --binlog-gtid-simple-recovery
- If this option is enabled, the server does not open more
- than two binary logs when initializing GTID_PURGED and
- GTID_EXECUTED, either during server restart or when
- binary logs are being purged. Enabling this option is
- useful when the server has already generated many binary
- logs without GTID events (e.g., having GTID_MODE = OFF).
- Note: If this option is enabled, GLOBAL.GTID_EXECUTED and
- GLOBAL.GTID_PURGED may be initialized wrongly in two
- cases: (1) All binary logs were generated by MySQL 5.7.5
- or older, and GTID_MODE was ON for some binary logs but
- OFF for the newest binary log. (2) The oldest existing
- binary log was generated by MySQL 5.7.5 or older, and SET
- GTID_PURGED was issued after the oldest binary log was
- generated. If a wrong set is computed in one of case (1)
- or case (2), it will remain wrong even if the server is
- later restarted with this option disabled.
- (Defaults to on; use --skip-binlog-gtid-simple-recovery to disable.)
- --binlog-ignore-db=name
- Tells the master that updates to the given database
- should not be logged to the binary log.
- --binlog-max-flush-queue-time=#
- The maximum time that the binary log group commit will
- keep reading transactions before it flush the
- transactions to the binary log (and optionally sync,
- depending on the value of sync_binlog).
- --binlog-order-commits
- Issue internal commit calls in the same order as
- transactions are written to the binary log. Default is to
- order commits.
- (Defaults to on; use --skip-binlog-order-commits to disable.)
- --binlog-row-event-max-size=#
- The maximum size of a row-based binary log event in
- bytes. Rows will be grouped into events smaller than this
- size if possible. The value has to be a multiple of 256.
- --binlog-row-image=name
- Controls whether rows should be logged in 'FULL',
- 'NOBLOB' or 'MINIMAL' formats. 'FULL', means that all
- columns in the before and after image are logged.
- 'NOBLOB', means that mysqld avoids logging blob columns
- whenever possible (eg, blob column was not changed or is
- not part of primary key). 'MINIMAL', means that a PK
- equivalent (PK columns or full row if there is no PK in
- the table) is logged in the before image, and only
- changed columns are logged in the after image. (Default:
- FULL).
- --binlog-rows-query-log-events
- Allow writing of Rows_query_log events into binary log.
- --binlog-skip-flush-commands
- If set to TRUE, FLUSH <XXX> commands will not be be
- written to the binary log
- --binlog-space-limit=#
- Maximum space to use for all binary logs. Default is 0,
- this feature is disabled.
- --binlog-stmt-cache-size=#
- The size of the statement cache for updates to
- non-transactional engines for the binary log. If you
- often use statements updating a great number of rows, you
- can increase this to get more performance
- --binlog-transaction-dependency-history-size=#
- Maximum number of rows to keep in the writeset history.
- --binlog-transaction-dependency-tracking=name
- Selects the source of dependency information from which
- to assess which transactions can be executed in parallel
- by the slave's multi-threaded applier. Possible values
- are COMMIT_ORDER, WRITESET and WRITESET_SESSION.
- --blackhole[=name] Enable or disable BLACKHOLE plugin. Possible values are
- ON, OFF, FORCE (don't start if the plugin fails to load).
- --block-encryption-mode=name
- mode for AES_ENCRYPT/AES_DECRYPT
- --bootstrap Used by mysql installation scripts.
- --bulk-insert-buffer-size=#
- Size of tree cache used in bulk insert optimisation. Note
- that this is a limit per thread!
- --character-set-client-handshake
- Don't ignore client side character set value sent during
- handshake.
- (Defaults to on; use --skip-character-set-client-handshake to disable.)
- --character-set-filesystem=name
- Set the filesystem character set.
- -C, --character-set-server=name
- Set the default character set.
- --character-sets-dir=name
- Directory where character sets are
- --check-proxy-users If set to FALSE (the default), then proxy user identity
- will not be mapped for authentication plugins which
- support mapping from grant tables. When set to TRUE,
- users associated with authentication plugins which signal
- proxy user mapping should be done according to GRANT
- PROXY privilege definition.
- -r, --chroot=name Chroot mysqld daemon during startup.
- --collation-server=name
- Set the default collation.
- --completion-type=name
- The transaction completion type, one of NO_CHAIN, CHAIN,
- RELEASE
- --concurrent-insert[=name]
- Use concurrent insert with MyISAM. Possible values are
- NEVER, AUTO, ALWAYS
- --connect-timeout=# The number of seconds the mysqld server is waiting for a
- connect packet before responding with 'Bad handshake'
- --console Write error output on screen; don't remove the console
- window on windows.
- --core-file Write core on errors.
- --csv-mode=name Control CSV parser mode: []: default, ietf_quotes:
- standards-compatible embedded quote and comma parsing
- --daemonize Run mysqld as sysv daemon
- -h, --datadir=name Path to the database root directory
- --date-format=name The DATE format (ignored)
- --datetime-format=name
- The DATETIME format (ignored)
- --default-authentication-plugin=name
- The default authentication plugin used by the server to
- hash the password.
- --default-password-lifetime=#
- The number of days after which the password will expire.
- --default-storage-engine=name
- The default storage engine for new tables
- --default-time-zone=name
- Set the default time zone.
- --default-tmp-storage-engine=name
- The default storage engine for new explict temporary
- tables
- --default-week-format=#
- The default week format used by WEEK() functions
- --delay-key-write[=name]
- Type of DELAY_KEY_WRITE
- --delayed-insert-limit=#
- After inserting delayed_insert_limit rows, the INSERT
- DELAYED handler will check if there are any SELECT
- statements pending. If so, it allows these to execute
- before continuing. This variable is deprecated along with
- INSERT DELAYED.
- --delayed-insert-timeout=#
- How long a INSERT DELAYED thread should wait for INSERT
- statements before terminating. This variable is
- deprecated along with INSERT DELAYED.
- --delayed-queue-size=#
- What size queue (in rows) should be allocated for
- handling INSERT DELAYED. If the queue becomes full, any
- client that does INSERT DELAYED will wait until there is
- room in the queue again. This variable is deprecated
- along with INSERT DELAYED.
- --des-key-file=name Load keys for des_encrypt() and des_encrypt from given
- file.
- --disable-partition-engine-check
- Skip the check for non-natively partitioned tables during
- bootstrap. This option is deprecated along with the
- partition engine.
- (Defaults to on; use --skip-disable-partition-engine-check to disable.)
- --disabled-storage-engines=name
- Limit CREATE TABLE for the storage engines listed
- --disconnect-on-expired-password
- Give clients that don't signal password expiration
- support execution time error(s) instead of connection
- error
- (Defaults to on; use --skip-disconnect-on-expired-password to disable.)
- --disconnect-slave-event-count=#
- Option used by mysql-test for debugging and testing of
- replication.
- --div-precision-increment=#
- Precision of the result of '/' operator will be increased
- on that value
- --early-plugin-load=name
- Optional semicolon-separated list of plugins to load
- before storage engine initialization, where each plugin
- is identified as name=library, where name is the plugin
- name and library is the plugin library in plugin_dir.
- --encrypt-binlog Encrypt binary logs (including relay logs)
- --encrypt-tmp-files Encrypt temporary files (created for filesort, binary log
- cache, etc)
- --end-markers-in-json
- In JSON output ("EXPLAIN FORMAT=JSON" and optimizer
- trace), if variable is set to 1, repeats the structure's
- key (if it has one) near the closing bracket
- --enforce-gtid-consistency[=name]
- Prevents execution of statements that would be impossible
- to log in a transactionally safe manner. Currently, the
- disallowed statements include CREATE TEMPORARY TABLE
- inside transactions, all updates to non-transactional
- tables, and CREATE TABLE ... SELECT.
- --enforce-storage-engine=name
- Force the use of a storage engine for new tables
- --eq-range-index-dive-limit=#
- The optimizer will use existing index statistics instead
- of doing index dives for equality ranges if the number of
- equality ranges for the index is larger than or equal to
- this number. If set to 0, index dives are always used.
- --event-scheduler[=name]
- Enable the event scheduler. Possible values are ON, OFF,
- and DISABLED (keep the event scheduler completely
- deactivated, it cannot be activated run-time)
- -T, --exit-info[=#] Used for debugging. Use at your own risk.
- --expand-fast-index-creation
- Enable/disable improvements to the InnoDB fast index
- creation functionality. Has no effect when fast index
- creation is disabled with the fast-index-creation option
- --expire-logs-days=#
- If non-zero, binary logs will be purged after
- expire_logs_days days; possible purges happen at startup
- and at binary log rotation
- --explicit-defaults-for-timestamp
- This option causes CREATE TABLE to create all TIMESTAMP
- columns as NULL with DEFAULT NULL attribute, Without this
- option, TIMESTAMP columns are NOT NULL and have implicit
- DEFAULT clauses. The old behavior is deprecated. The
- variable can only be set by users having the SUPER
- privilege.
- --external-locking Use system (external) locking (disabled by default).
- With this option enabled you can run myisamchk to test
- (not repair) tables while the MySQL server is running.
- Disable with --skip-external-locking.
- --extra-max-connections=#
- The number of connections on extra-port
- --extra-port=# Extra port number to use for tcp connections in a
- one-thread-per-connection manner. 0 means don't use
- another port
- --federated[=name] Enable or disable FEDERATED plugin. Possible values are
- ON, 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 the
- given interval
- --ft-boolean-syntax=name
- List of operators for MATCH ... AGAINST ( ... IN BOOLEAN
- MODE)
- --ft-max-word-len=# The maximum length of the word to be included in a
- FULLTEXT index. Note: FULLTEXT indexes must be rebuilt
- after changing this variable
- --ft-min-word-len=# The minimum length of the word to be included in a
- FULLTEXT index. Note: FULLTEXT indexes must be rebuilt
- after changing this variable
- --ft-query-expansion-limit=#
- Number of best matches to use for query expansion
- --ft-query-extra-word-chars
- If enabled, all non-whitespace characters are considered
- word symbols for full text search queries
- --ft-stopword-file=name
- Use 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=name
- Log connections and queries to given file
- --group-concat-max-len=#
- The maximum length of the result of function
- GROUP_CONCAT()
- --gtid-executed-compression-period[=#]
- When binlog is disabled, a background thread wakes up to
- compress the gtid_executed table every
- gtid_executed_compression_period transactions, as a
- special case, if variable is 0, the thread never wakes up
- to compress the gtid_executed table.
- --gtid-mode=name Controls whether Global Transaction Identifiers (GTIDs)
- are enabled. Can be OFF, OFF_PERMISSIVE, ON_PERMISSIVE,
- or ON. OFF means that no transaction has a GTID.
- OFF_PERMISSIVE means that new transactions (committed in
- a client session using GTID_NEXT='AUTOMATIC') are not
- assigned any GTID, and replicated transactions are
- allowed to have or not have a GTID. ON_PERMISSIVE means
- that new transactions are assigned a GTID, and replicated
- transactions are allowed to have or not have a GTID. ON
- means that all transactions have a GTID. ON is required
- on a master before any slave can use
- MASTER_AUTO_POSITION=1. To safely switch from OFF to ON,
- first set all servers to OFF_PERMISSIVE, then set all
- servers to ON_PERMISSIVE, then wait for all transactions
- without a GTID to be replicated and executed on all
- servers, and finally set all servers to GTID_MODE = ON.
- -?, --help Display this help and exit.
- --host-cache-size=# How many host names should be cached to avoid resolving.
- --ignore-builtin-innodb
- IGNORED. This option will be removed in future releases.
- Disable initialization of builtin InnoDB plugin
- --ignore-db-dir=name
- Specifies a directory to add to the ignore list when
- collecting database names from the datadir. Put a blank
- argument to reset the list accumulated so far.
- --init-connect=name Command(s) that are executed for each new connection
- --init-file=name Read SQL commands from this file at startup
- --init-slave=name Command(s) that are executed by a slave server each time
- the SQL thread starts
- --initialize Create the default database and exit. Create a super user
- with a random expired password and store it into the log.
- --initialize-insecure
- Create the default database and exit. Create a super user
- with empty password.
- --innodb Deprecated option. Provided for backward compatibility
- only. The option has no effect on the server behaviour.
- InnoDB is always enabled. The option will be removed in a
- future release.
- --innodb-adaptive-flushing
- Attempt flushing dirty pages to avoid IO bursts at
- checkpoints.
- (Defaults to on; use --skip-innodb-adaptive-flushing to disable.)
- --innodb-adaptive-flushing-lwm=#
- Percentage of log capacity below which no adaptive
- flushing happens.
- --innodb-adaptive-hash-index
- Enable InnoDB adaptive hash index (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 Adapative Hash Index Partitions.
- (default = 8).
- --innodb-adaptive-max-sleep-delay=#
- The upper limit of the sleep delay in usec. Value of 0
- disables it.
- --innodb-api-bk-commit-interval[=#]
- Background commit interval in seconds
- --innodb-api-disable-rowlock
- Disable row lock when direct access InnoDB through InnoDB
- APIs
- --innodb-api-enable-binlog
- Enable binlog for applications direct access InnoDB
- through InnoDB APIs
- --innodb-api-enable-mdl
- Enable MDL for applications direct access InnoDB through
- InnoDB 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 => Old
- style AUTOINC locking (for backward compatibility); 1 =>
- New style AUTOINC locking; 2 => No AUTOINC locking
- (unsafe for SBR)
- --innodb-background-scrub-data-check-interval=#
- check if spaces needs scrubbing every
- innodb_background_scrub_data_check_interval seconds
- --innodb-background-scrub-data-compressed
- Enable scrubbing of compressed data by background threads
- (same as encryption_threads)
- --innodb-background-scrub-data-interval=#
- scrub spaces that were last scrubbed longer than
- innodb_background_scrub_data_interval seconds ago
- --innodb-background-scrub-data-uncompressed
- Enable scrubbing of uncompressed data by background
- threads (same as encryption_threads)
- --innodb-buffer-pool-chunk-size=#
- Size of a single memory chunk within each buffer pool
- instance for resizing buffer pool. Online buffer pool
- resizing happens at this granularity. 0 means disable
- resizing buffer pool.
- --innodb-buffer-pool-dump-at-shutdown
- Dump the buffer pool into a file named
- @@innodb_buffer_pool_filename
- (Defaults to on; use --skip-innodb-buffer-pool-dump-at-shutdown to disable.)
- --innodb-buffer-pool-dump-now
- Trigger an immediate dump of the buffer pool into a file
- named @@innodb_buffer_pool_filename
- --innodb-buffer-pool-dump-pct=#
- Dump only the hottest N% of each buffer pool, defaults to
- 25
- --innodb-buffer-pool-filename=name
- Filename to/from which to dump/load the InnoDB buffer
- pool
- --innodb-buffer-pool-instances=#
- Number of buffer pool instances, set to higher value on
- high-end machines to increase scalability
- --innodb-buffer-pool-load-abort
- Abort a currently running load of the buffer pool
- --innodb-buffer-pool-load-at-startup
- Load the buffer pool from a file named
- @@innodb_buffer_pool_filename
- (Defaults to on; use --skip-innodb-buffer-pool-load-at-startup to disable.)
- --innodb-buffer-pool-load-now
- Trigger an immediate load of the buffer pool from a file
- named @@innodb_buffer_pool_filename
- --innodb-buffer-pool-size=#
- The size of the memory buffer InnoDB uses to cache data
- and indexes of its tables.
- --innodb-change-buffer-max-size=#
- Maximum on-disk size of change buffer in terms of
- percentage of the buffer pool.
- --innodb-change-buffering=name
- Buffer changes to reduce random access: OFF, ON,
- inserting, deleting, changing, or purging.
- --innodb-checksum-algorithm=name
- The algorithm InnoDB uses for page checksumming. Possible
- values are CRC32 (hardware accelerated if the CPU
- supports it) write crc32, allow any of the other
- checksums to match when reading; STRICT_CRC32 write
- crc32, do not allow other algorithms to match when
- reading; INNODB write a software calculated checksum,
- allow any other checksums to match when reading;
- STRICT_INNODB write a software calculated checksum, do
- not allow other algorithms to match when reading; NONE
- write a constant magic number, do not do any checksum
- verification when reading (same as innodb_checksums=OFF);
- STRICT_NONE write a constant magic number, do not allow
- values other than that magic number when reading; Files
- updated when this option is set to crc32 or strict_crc32
- will not be readable by MySQL versions older than 5.6.3
- --innodb-checksums DEPRECATED. Use innodb_checksum_algorithm=NONE instead of
- setting this to OFF. Enable InnoDB checksums validation
- (enabled by default). Disable with
- --skip-innodb-checksums.
- (Defaults to on; use --skip-innodb-checksums to disable.)
- --innodb-cleaner-lsn-age-factor[=name]
- The formula for LSN age factor for page cleaner adaptive
- flushing. LEGACY: Original Oracle MySQL 5.6 formula.
- HIGH_CHECKPOINT: (the default) Percona Server 5.6
- formula.
- --innodb-cmp-per-index-enabled
- Enable INFORMATION_SCHEMA.innodb_cmp_per_index, may have
- negative impact on performance (off by default)
- --innodb-commit-concurrency=#
- Helps in performance tuning in heavily concurrent
- environments.
- --innodb-compressed-columns-threshold=#
- Compress column data if its length exceeds this value.
- Default is 96
- --innodb-compressed-columns-zip-level=#
- Compression level used for compressed columns. 0 is no
- compression, 1 is fastest and 9 is best compression.
- Default is 6.
- --innodb-compression-failure-threshold-pct[=#]
- If the compression failure rate of a table is greater
- than this number more padding is added to the pages to
- reduce the failures. A value of zero implies no padding
- --innodb-compression-level=#
- Compression level used for compressed row format. 0 is
- no compression, 1 is fastest, 9 is best compression and
- default is 6.
- --innodb-compression-pad-pct-max[=#]
- Percentage of empty space on a data page that can be
- reserved to make the page compressible.
- --innodb-concurrency-tickets=#
- Number of times a thread is allowed to enter InnoDB
- within the same SQL query after it has once got the
- ticket
- --innodb-corrupt-table-action=name
- Warn corruptions of user tables as 'corrupt table'
- instead of not crashing itself, when used with
- file_per_table. All file io for the datafile after
- detected as corrupt are disabled, except for the
- deletion.
- --innodb-data-file-path=name
- Path to individual files and their sizes.
- --innodb-data-home-dir=name
- The common part for InnoDB table spaces.
- --innodb-deadlock-detect
- Enable/disable InnoDB deadlock detector (default ON). if
- set to OFF, deadlock detection is skipped, and we rely on
- innodb_lock_wait_timeout in case of deadlock.
- (Defaults to on; use --skip-innodb-deadlock-detect to disable.)
- --innodb-default-encryption-key-id=#
- Default encryption key id used for table encryption.
- --innodb-default-row-format=name
- The default ROW FORMAT for all innodb tables created
- without explicit ROW_FORMAT. Possible values are
- REDUNDANT, COMPACT, and DYNAMIC. The ROW_FORMAT value
- COMPRESSED is not allowed
- --innodb-disable-sort-file-cache
- Whether to disable OS system file cache for sort I/O
- --innodb-doublewrite
- Enable InnoDB doublewrite buffer (enabled by default).
- Disable with --skip-innodb-doublewrite.
- (Defaults to on; use --skip-innodb-doublewrite to disable.)
- --innodb-empty-free-list-algorithm[=name]
- The algorithm to use for empty free list handling.
- Allowed values: LEGACY: (default) Original Oracle MySQL
- 5.6 handling with single page flushes; BACKOFF: Wait
- until cleaner produces a free page.
- --innodb-encrypt-online-alter-logs
- Encrypt online alter logs.
- --innodb-encrypt-tables[=name]
- Enable encryption for tables. When turned ON, all tables
- are created encrypted unless otherwise specified. When
- it's set to FORCE, only encrypted tables can be
- created.The FORCE setting also disables non inplace
- alteration of unencrypted, tables without encrypting them
- in the process.
- --innodb-encryption-rotate-key-age=#
- Key rotation - re-encrypt in background all pages that
- were encrypted with a key that many (or more) versions
- behind. Value 0 indicates that key rotation is disabled.
- --innodb-encryption-rotation-iops=#
- Use this many iops for background key rotation
- --innodb-encryption-threads=#
- Number of threads performing background key rotation and
- scrubbing
- --innodb-fast-shutdown[=#]
- Speeds up the shutdown process of the InnoDB storage
- engine. Possible values are 0, 1 (faster) or 2 (fastest -
- crash-like).
- --innodb-file-format=name
- File format to use for new tables in .ibd files.
- --innodb-file-format-check
- Whether to perform system file format check.
- (Defaults to on; use --skip-innodb-file-format-check to disable.)
- --innodb-file-format-max[=name]
- The highest file format in the tablespace.
- --innodb-file-per-table
- Stores each InnoDB table to an .ibd file in the database
- dir.
- (Defaults to on; use --skip-innodb-file-per-table to disable.)
- --innodb-fill-factor=#
- Percentage of B-tree page filled during bulk insert
- --innodb-flush-log-at-timeout[=#]
- Write and flush logs every (n) second.
- --innodb-flush-log-at-trx-commit[=#]
- Set to 0 (write and flush once per second), 1 (write and
- flush at each commit) or 2 (write at commit, flush once
- per second).
- --innodb-flush-method=name
- With 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 (flush
- neighbors from buffer pool), when flushing a block
- --innodb-flush-sync Allow IO bursts at the checkpoints ignoring io_capacity
- setting.
- (Defaults to on; use --skip-innodb-flush-sync to disable.)
- --innodb-flushing-avg-loops=#
- Number of iterations over which the background flushing
- is averaged.
- --innodb-force-load-corrupted
- Force InnoDB to load metadata of corrupted table.
- --innodb-force-recovery=#
- Helps to save your data in case the disk image of the
- database becomes corrupt.
- --innodb-ft-aux-table
- FTS internal auxiliary table to be checked
- --innodb-ft-cache-size=#
- InnoDB Fulltext search cache size in bytes
- --innodb-ft-enable-diag-print
- Whether to enable additional FTS diagnostic printout
- --innodb-ft-enable-stopword
- Create FTS index with stopword.
- (Defaults to on; use --skip-innodb-ft-enable-stopword to disable.)
- --innodb-ft-ignore-stopwords
- Instruct FTS to ignore stopwords.
- --innodb-ft-max-token-size=#
- InnoDB Fulltext search maximum token size in characters
- --innodb-ft-min-token-size=#
- InnoDB Fulltext search minimum token size in characters
- --innodb-ft-num-word-optimize[=#]
- InnoDB Fulltext search number of words to optimize for
- each optimize table call
- --innodb-ft-result-cache-limit=#
- InnoDB Fulltext search query result cache limit in bytes
- --innodb-ft-server-stopword-table[=name]
- The user supplied stopword table name.
- --innodb-ft-sort-pll-degree=#
- InnoDB Fulltext search parallel sort degree, will round
- up to nearest power of 2 number
- --innodb-ft-total-cache-size=#
- Total memory allocated for InnoDB Fulltext Search cache
- --innodb-ft-user-stopword-table[=name]
- User supplied stopword table name, effective in the
- session level.
- --innodb-immediate-scrub-data-uncompressed
- Enable scrubbing of data
- --innodb-io-capacity=#
- Number of IOPs the server can do. Tunes the background IO
- rate
- --innodb-io-capacity-max=#
- Limit to which innodb_io_capacity can be inflated.
- --innodb-kill-idle-transaction=#
- A deprecated alias of kill_idle_transaction server
- variable.
- --innodb-large-prefix
- Support large index prefix length of
- REC_VERSION_56_MAX_INDEX_COL_LEN (3072) bytes.
- (Defaults to on; use --skip-innodb-large-prefix to disable.)
- --innodb-lock-wait-timeout=#
- Timeout in seconds an InnoDB transaction may wait for a
- lock before being rolled back. Values above 100000000
- disable the timeout.
- --innodb-locks-unsafe-for-binlog
- DEPRECATED. This option may be removed in future
- releases. Please use READ COMMITTED transaction isolation
- level instead. Force InnoDB to not use next-key locking,
- to use only row-level locking.
- --innodb-log-buffer-size=#
- The size of the buffer which InnoDB uses to write log to
- the log files on disk.
- --innodb-log-checksums
- Whether to compute and require checksums for InnoDB redo
- log blocks
- (Defaults to on; use --skip-innodb-log-checksums to disable.)
- --innodb-log-compressed-pages
- Enables/disables the logging of entire compressed page
- images. InnoDB logs the compressed pages to prevent
- corruption if the zlib compression algorithm changes.
- When turned OFF, InnoDB will assume that the zlib
- compression algorithm doesn't change.
- (Defaults to on; use --skip-innodb-log-compressed-pages to disable.)
- --innodb-log-file-size=#
- Size of each log file in a log group.
- --innodb-log-files-in-group=#
- Number of log files in the log group. InnoDB writes to
- the files in a circular fashion.
- --innodb-log-group-home-dir=name
- Path to InnoDB log files.
- --innodb-log-write-ahead-size=#
- Redo log write ahead unit size to avoid read-on-write, it
- should match the OS cache block IO size
- --innodb-lru-scan-depth=#
- How deep to scan LRU to keep it clean
- --innodb-max-bitmap-file-size=#
- The maximum size of changed page bitmap files
- --innodb-max-changed-pages=#
- The maximum number of rows for
- INFORMATION_SCHEMA.INNODB_CHANGED_PAGES table, 0 -
- unlimited
- --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 UNDO tablespace in MB (If UNDO tablespace
- grows beyond this size it will be truncated in due
- course).
- --innodb-monitor-disable=name
- Turn off a monitor counter
- --innodb-monitor-enable=name
- Turn on a monitor counter
- --innodb-monitor-reset=name
- Reset a monitor counter
- --innodb-monitor-reset-all=name
- Reset all values for a monitor counter
- --innodb-numa-interleave
- Use NUMA interleave memory policy to allocate InnoDB
- buffer 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 the
- first access was at least this many milliseconds ago. The
- timeout is disabled if 0.
- --innodb-online-alter-log-max-size=#
- Maximum modification log file size for online index
- creation
- --innodb-open-files=#
- How many files at the maximum InnoDB keeps open at the
- same time.
- --innodb-optimize-fulltext-only
- Only optimize the Fulltext index of the table
- --innodb-page-cleaners[=#]
- 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-dblwr-encrypt
- Enable or disable encryption of parallel doublewrite
- buffer file.
- --innodb-parallel-doublewrite-path=name
- Path to the parallel doublewrite file. If a relative path
- or a filename only is given, it's relative to the server
- data directory.
- --innodb-print-all-deadlocks
- Print all deadlocks to MySQL error log (off by default)
- --innodb-print-lock-wait-timeout-info
- Print lock wait timeout info to MySQL error log (off by
- default)
- --innodb-purge-batch-size[=#]
- Number of UNDO log pages to purge in one batch from the
- history list.
- --innodb-purge-rseg-truncate-frequency[=#]
- Dictates rate at which UNDO records are purged. Value N
- means purge rollback segment(s) on every Nth iteration of
- purge invocation
- --innodb-purge-threads[=#]
- Purge threads can be from 1 to 32. Default is 4.
- --innodb-random-read-ahead
- Whether to use read ahead for random access within an
- extent.
- --innodb-read-ahead-threshold=#
- Number of pages that must be accessed sequentially for
- InnoDB to trigger a readahead.
- --innodb-read-io-threads=#
- Number of background read I/O threads in InnoDB.
- --innodb-read-only Start InnoDB in read only mode (off by default)
- --innodb-redo-log-encrypt[=name]
- Enable or disable Encryption of REDO tablespace. Possible
- values: OFF, MASTER_KEY, KEYRING_KEY.
- --innodb-replication-delay=#
- Replication thread delay (ms) on the slave server if
- innodb_thread_concurrency is reached (0 by default)
- --innodb-rollback-on-timeout
- Roll back the complete transaction on lock wait timeout,
- for 4.x compatibility (disabled by default)
- --innodb-rollback-segments[=#]
- Number of rollback segments to use for storing undo logs.
- --innodb-scrub-log Enable background redo log (ib_logfile0, ib_logfile1...)
- scrubbing
- --innodb-scrub-log-speed[=#]
- Background redo log scrubbing speed in bytes/sec
- --innodb-show-locks-held=#
- Number of locks held to print for each InnoDB transaction
- in SHOW INNODB STATUS.
- --innodb-show-verbose-locks[=#]
- Whether to show records locked in SHOW INNODB STATUS.
- --innodb-sort-buffer-size=#
- Memory buffer size for index creation
- --innodb-spin-wait-delay[=#]
- Maximum delay between polling for a spin lock (6 by
- default)
- --innodb-stats-auto-recalc
- InnoDB automatic recalculation of persistent statistics
- enabled for all tables unless overridden at table level
- (automatic recalculation is only done when InnoDB decides
- that the table has changed too much and needs a new
- statistics)
- (Defaults to on; use --skip-innodb-stats-auto-recalc to disable.)
- --innodb-stats-include-delete-marked
- Include delete marked records when calculating persistent
- statistics
- --innodb-stats-method=name
- Specifies how InnoDB index statistics collection code
- should treat NULLs. Possible values are NULLS_EQUAL
- (default), NULLS_UNEQUAL and NULLS_IGNORED
- --innodb-stats-on-metadata
- Enable statistics gathering for metadata commands such as
- SHOW TABLE STATUS for tables that use transient
- statistics (off by default)
- --innodb-stats-persistent
- InnoDB persistent statistics enabled for all tables
- unless overridden at table level
- (Defaults to on; use --skip-innodb-stats-persistent to disable.)
- --innodb-stats-persistent-sample-pages=#
- The number of leaf index pages to sample when calculating
- persistent statistics (by ANALYZE, default 20)
- --innodb-stats-sample-pages=#
- Deprecated, use innodb_stats_transient_sample_pages
- instead
- --innodb-stats-transient-sample-pages=#
- The number of leaf index pages to sample when calculating
- transient statistics (if persistent statistics are not
- used, default 8)
- --innodb-status-file
- Enable SHOW ENGINE INNODB STATUS output in the
- innodb_status.<pid> file
- --innodb-status-output
- Enable InnoDB monitor output to the error log.
- --innodb-status-output-locks
- Enable InnoDB lock monitor output to the error log.
- Requires innodb_status_output=ON.
- --innodb-strict-mode
- Use strict mode when evaluating create options.
- (Defaults to on; use --skip-innodb-strict-mode to disable.)
- --innodb-support-xa Enable InnoDB support for the XA two-phase commit
- (Defaults to on; use --skip-innodb-support-xa to disable.)
- --innodb-sync-array-size[=#]
- Size of the mutex/lock wait array.
- --innodb-sync-spin-loops=#
- Count of spin-loop rounds in InnoDB mutexes (30 by
- default)
- --innodb-sys-tablespace-encrypt
- Enable this option at bootstrap to encrypt system
- tablespace.
- --innodb-table-locks
- Enable InnoDB locking in LOCK TABLES
- (Defaults to on; use --skip-innodb-table-locks to disable.)
- --innodb-temp-data-file-path=name
- Path to files and their sizes making temp-tablespace.
- --innodb-temp-tablespace-encrypt
- Enable or disable encryption of temporary tablespace.
- --innodb-thread-concurrency=#
- Helps in performance tuning in heavily concurrent
- environments. Sets the maximum number of threads allowed
- inside InnoDB. Value 0 will disable the thread
- throttling.
- --innodb-thread-sleep-delay=#
- Time of innodb thread sleeping before joining InnoDB
- queue (usec). Value 0 disable a sleep
- --innodb-tmpdir[=name]
- Directory for temporary non-tablespace files.
- --innodb-track-changed-pages
- Track the redo log for changed pages and output a changed
- page bitmap
- --innodb-undo-directory=name
- Directory where undo tablespace files live, this path can
- be absolute.
- --innodb-undo-log-encrypt
- Enable or disable Encryption of UNDO tablespaces.
- --innodb-undo-log-truncate
- Enable or Disable Truncate of UNDO tablespace.
- --innodb-undo-logs[=#]
- Number of rollback segments to use for storing undo logs.
- (deprecated)
- --innodb-undo-tablespaces=#
- Number of undo tablespaces to use. (deprecated)
- --innodb-use-global-flush-log-at-trx-commit
- Use global innodb_flush_log_at_trx_commit value.
- (default: ON).
- (Defaults to on; use --skip-innodb-use-global-flush-log-at-trx-commit to disable.)
- --innodb-use-native-aio
- Use native AIO if supported on this platform.
- (Defaults to on; use --skip-innodb-use-native-aio to disable.)
- --innodb-write-io-threads=#
- Number of background write I/O threads in InnoDB.
- --interactive-timeout=#
- The number of seconds the server waits for activity on an
- interactive connection before closing it
- --internal-tmp-disk-storage-engine[=name]
- The default storage engine for on-disk internal tmp table
- --join-buffer-size=#
- The size of the buffer that is used for full joins
- --keep-files-on-create
- Don't overwrite stale .MYD and .MYI even if no directory
- is specified
- --key-buffer-size=# The size of the buffer used for index blocks for MyISAM
- tables. Increase this to get better index handling (for
- all reads and multiple writes) to as much as you can
- afford
- --key-cache-age-threshold=#
- This characterizes the number of hits a hot block has to
- be untouched until it is considered aged enough to be
- downgraded to a warm block. This specifies the percentage
- ratio of that number of hits to the total number of
- blocks in key cache
- --key-cache-block-size=#
- The default size of key cache blocks
- --key-cache-division-limit=#
- The minimum percentage of warm blocks in key cache
- --keyring-migration-destination=name
- Keyring plugin to which the keys are migrated to. This
- option must be specified along with
- --keyring-migration-source.
- --keyring-migration-host=name
- Connect to host.
- --keyring-migration-password[=name]
- Password to use when connecting to server during keyring
- migration. If password value is not specified then it
- will be asked from the tty.
- --keyring-migration-port=#
- Port number to use for connection.
- --keyring-migration-socket=name
- The socket file to use for connection.
- --keyring-migration-source=name
- Keyring plugin from where the keys needs to be migrated
- to. This option must be specified along with
- --keyring-migration-destination.
- --keyring-migration-user=name
- User to login to server.
- --kill-idle-transaction=#
- If non-zero, number of seconds to wait before killing
- idle connections that have open transactions
- -L, --language=name Client error messages in given language. May be given as
- a full path. Deprecated. Use --lc-messages-dir instead.
- --large-pages Enable support for large pages
- --lc-messages=name Set the language used for the error messages.
- --lc-messages-dir=name
- Directory where error messages are
- --lc-time-names=name
- Set the language used for the month names and the days of
- the week.
- --local-infile Enable LOAD DATA LOCAL INFILE
- (Defaults to on; use --skip-local-infile to disable.)
- --lock-wait-timeout=#
- Timeout in seconds to wait for a lock before returning an
- error.
- --log-bin[=name] Log update queries in binary format. Optional (but
- strongly recommended to avoid replication problems if
- server's hostname changes) argument should be the chosen
- location for the binary log files.
- --log-bin-index=name
- File that holds the names for binary log files.
- --log-bin-trust-function-creators
- If set to FALSE (the default), then when --log-bin is
- used, creation of a stored function (or trigger) is
- allowed only to users having the SUPER privilege and only
- if this stored function (trigger) may not break binary
- logging. Note that if ALL connections to this server
- ALWAYS use row-based binary logging, the security issues
- do not exist and the binary logging cannot break, so you
- can safely set this to TRUE
- --log-bin-use-v1-row-events
- If equal to 1 then version 1 row events are written to a
- row based binary log. If equal to 0, then the latest
- version of events are written. This option is useful
- during some upgrades.
- --log-builtin-as-identified-by-password
- Controls logging of CREATE/ALTER/GRANT and SET PASSWORD
- user statements in replication binlogs, general query
- logs and audit logs.
- --log-error[=name] Error log file
- --log-error-verbosity=#
- How detailed the error log should be. 1, log errors only.
- 2, log errors and warnings. 3, log errors, warnings, and
- notes. Messages sent to the client are unaffected by this
- setting.
- --log-isam[=name] Log all MyISAM changes to file.
- --log-output=name Syntax: log-output=value[,value...], where "value" could
- be TABLE, FILE or NONE
- --log-queries-not-using-indexes
- Log queries that are executed without benefit of any
- index to the slow log if it is open
- --log-raw Log to general log before any rewriting of the query. For
- use in debugging, not production as sensitive information
- may be logged.
- --log-short-format Don't log extra information to update and slow-query
- logs.
- --log-slave-updates Tells the slave to log the updates from the slave thread
- to the binary log. You will need to turn it on if you
- plan to daisy-chain the slaves
- --log-slow-admin-statements
- Log slow OPTIMIZE, ANALYZE, ALTER and other
- administrative statements to the slow log if it is open.
- --log-slow-filter=name
- Log only the queries that followed certain execution
- plan. Multiple flags allowed in a comma-separated string.
- [qc_miss, full_scan, full_join, tmp_table,
- tmp_table_on_disk, filesort, filesort_on_disk]
- --log-slow-rate-limit=#
- Rate limit statement writes to slow log to only those
- from every (1/log_slow_rate_limit) session.
- --log-slow-rate-type=name
- Choose the log_slow_rate_limit behavior: session or
- query. When you choose 'session' - every
- %log_slow_rate_limit connection will be processed to slow
- query log. When you choose 'query' - every
- %log_slow_rate_limit query will be processed to slow
- query log. [session, query]
- --log-slow-slave-statements
- Log slow statements executed by slave thread to the slow
- log if it is open.
- --log-slow-sp-statements[=name]
- Choice between logging slow CALL statements, logging
- individual slow statements inside stored procedures or
- skipping the logging of stored procedures into the slow
- log entirely. Values are OFF, ON and OFF_NO_CALLS
- respectively.
- --log-slow-verbosity=name
- Choose how verbose the messages to your slow log will be.
- Multiple flags allowed in a comma-separated string.
- [microtime, query_plan, innodb, profiling,
- profiling_use_getrusage]
- --log-statements-unsafe-for-binlog
- Log statements considered unsafe when using statement
- based binary logging.
- (Defaults to on; use --skip-log-statements-unsafe-for-binlog to disable.)
- --log-syslog Errors, warnings, and similar issues eligible for MySQL's
- error log file may additionally be sent to the host
- operating system's system log ("syslog").
- --log-syslog-facility=name
- When logging issues using the host operating system's
- syslog, identify as a facility of the given type (to aid
- in log filtering).
- --log-syslog-include-pid
- When logging issues using the host operating system's
- syslog, include this MySQL server's process ID (PID).
- This setting does not affect MySQL's own error log file.
- (Defaults to on; use --skip-log-syslog-include-pid to disable.)
- --log-syslog-tag=name
- When logging issues using the host operating system's
- syslog, tag the entries from this particular MySQL server
- with this ident. This will help distinguish entries from
- MySQL servers co-existing on the same host machine. A
- non-empty tag will be appended to the default ident of
- 'mysqld', connected by a hyphen.
- --log-tc=name Path to transaction coordinator log (used for
- transactions that affect more than one storage engine,
- when binary log is disabled).
- --log-tc-size=# Size of transaction coordinator log.
- --log-throttle-queries-not-using-indexes=#
- Log at most this many 'not using index' warnings per
- minute to the slow log. Any further warnings will be
- condensed into a single summary line. A value of 0
- disables throttling. Option has no effect unless
- --log_queries_not_using_indexes is set.
- --log-timestamps=name
- UTC to timestamp log files in zulu time, for more concise
- timestamps and easier correlation of logs from servers
- from multiple time zones, or SYSTEM to use the system's
- local time. This affects only log files, not log tables,
- as the timestamp columns of the latter can be converted
- at will.
- -W, --log-warnings[=#]
- Log some not critical warnings to the log file
- --long-query-time=# Log all queries that have taken more than long_query_time
- seconds to execute to file. The argument will be treated
- as a decimal value with microsecond precision
- --low-priority-updates
- INSERT/DELETE/UPDATE has lower priority than selects
- --lower-case-table-names[=#]
- If set to 1 table names are stored in lowercase on disk
- and table names will be case-insensitive. Should be set
- to 2 if you are using a case insensitive file system
- --master-info-file=name
- The location and name of the file that remembers the
- master and where the I/O replication thread is in the
- master's binlogs.
- --master-info-repository=name
- Defines the type of the repository for the master
- information.
- --master-retry-count=#
- The number of tries the slave will make to connect to the
- master before giving up. Deprecated option, use 'CHANGE
- MASTER TO master_retry_count = <num>' instead.
- --master-verify-checksum
- Force checksum verification of logged events in binary
- log before sending them to slaves or printing them in
- output of SHOW BINLOG EVENTS. Disabled by default.
- --max-allowed-packet=#
- Max packet length to send to or receive from the server
- --max-binlog-cache-size=#
- Sets the total size of the transactional cache
- --max-binlog-dump-events=#
- Option used by mysql-test for debugging and testing of
- replication.
- --max-binlog-files=#
- Maximum number of binlog files. Used with
- --max-binlog-size this can be used to limit the total
- amount of disk space used for the binlog. Default is 0,
- don't limit. This variable is deprecated and will be
- removed in a future release.
- --max-binlog-size=# Binary log will be rotated automatically when the size
- exceeds this value. Will also apply to relay logs if
- max_relay_log_size is 0
- --max-binlog-stmt-cache-size=#
- Sets the total size of the statement cache
- --max-connect-errors=#
- If there is more than this number of interrupted
- connections from a host this host will be blocked from
- further connections
- --max-connections=# The number of simultaneous clients allowed
- --max-delayed-threads=#
- Don't start more than this number of threads to handle
- INSERT DELAYED statements. If set to zero INSERT DELAYED
- will be not used. This variable is deprecated along with
- INSERT DELAYED.
- --max-digest-length=#
- Maximum length considered for digest text.
- --max-error-count=# Max number of errors/warnings to store for a statement
- --max-execution-time=#
- Kill SELECT statement that takes over the specified
- number of milliseconds
- --max-heap-table-size=#
- Don't allow creation of heap tables bigger than this
- --max-join-size=# Joins that are probably going to read more than
- max_join_size records return an error
- --max-length-for-sort-data=#
- Max number of bytes in sorted records
- --max-points-in-geometry[=#]
- Maximum number of points in a geometry
- --max-prepared-stmt-count=#
- Maximum number of prepared statements in the server
- --max-relay-log-size=#
- If non-zero: relay log will be rotated automatically when
- the size exceeds this value; if zero: when the size
- exceeds max_binlog_size
- --max-seeks-for-key=#
- Limit assumed max number of seeks when looking up rows
- based on a key
- --max-slowlog-files=#
- Maximum number of slow query log files. Used with
- --max-slowlog-size this can be used to limit the total
- amount of disk space used for the slow query log. Default
- is 0, don't limit.
- --max-slowlog-size=#
- Slow query log will be rotated automatically when the
- size exceeds this value. The default is 0, don't limit
- the size.
- --max-sort-length=# The number of bytes to use when sorting BLOB or TEXT
- values (only the first max_sort_length bytes of each
- value are used; the rest are ignored)
- --max-sp-recursion-depth[=#]
- Maximum stored procedure recursion depth
- --max-tmp-tables=# Maximum number of temporary tables a client can keep open
- at a time
- --max-user-connections=#
- The maximum number of active connections for a single
- user (0 = no limit)
- --max-write-lock-count=#
- After this many write locks, allow some read locks to run
- in between
- --memlock Lock mysqld in memory.
- --metadata-locks-cache-size=#
- Has no effect, deprecated
- --metadata-locks-hash-instances=#
- Has no effect, deprecated
- --min-examined-row-limit=#
- Don't write queries to slow log that examine fewer rows
- than that
- --multi-range-count=#
- Number of key ranges to request at once. This variable
- has no effect, and is deprecated. It will be removed in a
- future release.
- --myisam-block-size=#
- Block size to be used for MyISAM index pages
- --myisam-data-pointer-size=#
- Default pointer size to be used for MyISAM tables
- --myisam-max-sort-file-size=#
- Don't use the fast sort index method to created index if
- the temporary file would get bigger than this
- --myisam-mmap-size=#
- Restricts the total memory used for memory mapping of
- MySQL tables
- --myisam-recover-options[=name]
- Syntax: myisam-recover-options[=option[,option...]],
- where option can be DEFAULT, BACKUP, FORCE, QUICK, or OFF
- --myisam-repair-threads=#
- If larger than 1, when repairing a MyISAM table all
- indexes will be created in parallel, with one thread per
- index. The value of 1 disables parallel repair
- --myisam-sort-buffer-size=#
- The buffer that is allocated when sorting the index when
- doing a REPAIR or when creating indexes with CREATE INDEX
- or ALTER TABLE
- --myisam-stats-method=name
- Specifies how MyISAM index statistics collection code
- should treat NULLs. Possible values of name are
- NULLS_UNEQUAL (default behavior for 4.1 and later),
- NULLS_EQUAL (emulate 4.0 behavior), and NULLS_IGNORED
- --myisam-use-mmap Use memory mapping for reading and writing MyISAM tables
- --mysql-native-password-proxy-users
- If set to FALSE (the default), then the
- mysql_native_password plugin will not signal for
- authenticated users to be checked for mapping to proxy
- users. When set to TRUE, the plugin will flag associated
- authenticated accounts to be mapped to proxy users when
- the server option check_proxy_users is enabled.
- --net-buffer-length=#
- Buffer length for TCP/IP and socket communication
- --net-read-timeout=#
- Number of seconds to wait for more data from a connection
- before aborting the read
- --net-retry-count=# If a read on a communication port is interrupted, retry
- this many times before giving up
- --net-write-timeout=#
- Number of seconds to wait for a block to be written to a
- connection before aborting the write
- -n, --new Use very new possible "unsafe" functions
- --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 in
- characters
- --offline-mode Make the server into offline mode
- --old Use compatible behavior
- --old-alter-table Use old, non-optimized alter table
- --old-passwords=# Determine which hash algorithm to use when generating
- passwords using the PASSWORD() function
- --old-style-user-limits
- Enable old-style user limits (before 5.0.3, user
- resources were counted per each user+host vs. per
- account).
- --open-files-limit=#
- If this is not 0, then mysqld will use this value to
- reserve file descriptors to use with setrlimit(). If this
- value is 0 then mysqld will reserve max_connections*5 or
- max_connections + table_open_cache*2 (whichever is
- larger) number of file descriptors
- --optimizer-prune-level=#
- Controls the heuristic(s) applied during query
- optimization to prune less-promising partial plans from
- the optimizer search space. Meaning: 0 - do not apply any
- heuristic, thus perform exhaustive search; 1 - prune
- plans based on number of retrieved rows
- --optimizer-search-depth=#
- Maximum depth of search performed by the query optimizer.
- Values larger than the number of relations in a query
- result in better query plans, but take longer to compile
- a query. Values smaller than the number of tables in a
- relation result in faster optimization, but may produce
- very bad query plans. If set to 0, the system will
- automatically pick a reasonable value
- --optimizer-switch=name
- optimizer_switch=option=val[,option=val...], where option
- is one of {index_merge, index_merge_union,
- index_merge_sort_union, index_merge_intersection,
- engine_condition_pushdown, index_condition_pushdown, mrr,
- mrr_cost_based, materialization, semijoin, loosescan,
- firstmatch, duplicateweedout,
- subquery_materialization_cost_based, block_nested_loop,
- batched_key_access, use_index_extensions,
- condition_fanout_filter, derived_merge} and val is one of
- {on, off, default}
- --optimizer-trace=name
- Controls tracing of the Optimizer:
- optimizer_trace=option=val[,option=val...], where option
- is one of {enabled, one_line} and val is one of {on,
- default}
- --optimizer-trace-features=name
- Enables/disables tracing of selected features of the
- Optimizer:
- optimizer_trace_features=option=val[,option=val...],
- where option is one of {greedy_search, range_optimizer,
- dynamic_range, repeated_subselect} and val is one of {on,
- off, default}
- --optimizer-trace-limit=#
- Maximum number of shown optimizer traces
- --optimizer-trace-max-mem-size=#
- Maximum allowed cumulated size of stored optimizer traces
- --optimizer-trace-offset=#
- Offset of first optimizer trace to show; see manual
- --parser-max-mem-size=#
- Maximum amount of memory available to the parser
- --partition[=name] Enable or disable partition plugin. Possible values are
- ON, OFF, FORCE (don't start if the plugin fails to load).
- --performance-schema
- Enable the performance schema.
- (Defaults to on; use --skip-performance-schema to disable.)
- --performance-schema-accounts-size=#
- Maximum number of instrumented user@host accounts. Use 0
- to disable, -1 for automated scaling.
- --performance-schema-consumer-events-stages-current
- Default startup value for the events_stages_current
- consumer.
- --performance-schema-consumer-events-stages-history
- Default startup value for the events_stages_history
- consumer.
- --performance-schema-consumer-events-stages-history-long
- Default startup value for the events_stages_history_long
- consumer.
- --performance-schema-consumer-events-statements-current
- Default startup value for the events_statements_current
- consumer.
- (Defaults to on; use --skip-performance-schema-consumer-events-statements-current to disable.)
- --performance-schema-consumer-events-statements-history
- Default startup value for the events_statements_history
- consumer.
- (Defaults to on; use --skip-performance-schema-consumer-events-statements-history to disable.)
- --performance-schema-consumer-events-statements-history-long
- Default startup value for the
- events_statements_history_long consumer.
- --performance-schema-consumer-events-transactions-current
- Default startup value for the events_transactions_current
- consumer.
- --performance-schema-consumer-events-transactions-history
- Default startup value for the events_transactions_history
- consumer.
- --performance-schema-consumer-events-transactions-history-long
- Default startup value for the
- events_transactions_history_long consumer.
- --performance-schema-consumer-events-waits-current
- Default startup value for the events_waits_current
- consumer.
- --performance-schema-consumer-events-waits-history
- Default startup value for the events_waits_history
- consumer.
- --performance-schema-consumer-events-waits-history-long
- Default startup value for the events_waits_history_long
- consumer.
- --performance-schema-consumer-global-instrumentation
- Default startup value for the global_instrumentation
- consumer.
- (Defaults to on; use --skip-performance-schema-consumer-global-instrumentation to disable.)
- --performance-schema-consumer-statements-digest
- Default startup value for the statements_digest consumer.
- (Defaults to on; use --skip-performance-schema-consumer-statements-digest to disable.)
- --performance-schema-consumer-thread-instrumentation
- Default startup value for the thread_instrumentation
- consumer.
- (Defaults to on; use --skip-performance-schema-consumer-thread-instrumentation to disable.)
- --performance-schema-digests-size=#
- Size of the statement digest. Use 0 to disable, -1 for
- automated sizing.
- --performance-schema-events-stages-history-long-size=#
- Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to
- disable, -1 for automated sizing.
- --performance-schema-events-stages-history-size=#
- Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0
- to disable, -1 for automated sizing.
- --performance-schema-events-statements-history-long-size=#
- Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. Use 0
- to disable, -1 for automated sizing.
- --performance-schema-events-statements-history-size=#
- Number of rows per thread in EVENTS_STATEMENTS_HISTORY.
- Use 0 to disable, -1 for automated sizing.
- --performance-schema-events-transactions-history-long-size=#
- Number of rows in EVENTS_TRANSACTIONS_HISTORY_LONG. Use 0
- to disable, -1 for automated sizing.
- --performance-schema-events-transactions-history-size=#
- Number of rows per thread in EVENTS_TRANSACTIONS_HISTORY.
- Use 0 to disable, -1 for automated sizing.
- --performance-schema-events-waits-history-long-size=#
- Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to
- disable, -1 for automated sizing.
- --performance-schema-events-waits-history-size=#
- Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0
- to disable, -1 for automated sizing.
- --performance-schema-hosts-size=#
- Maximum number of instrumented hosts. Use 0 to disable,
- -1 for automated scaling.
- --performance-schema-instrument[=name]
- Default startup value for a performance schema
- instrument.
- --performance-schema-max-cond-classes=#
- Maximum number of condition instruments.
- --performance-schema-max-cond-instances=#
- Maximum number of instrumented condition objects. Use 0
- to disable, -1 for automated scaling.
- --performance-schema-max-digest-length=#
- Maximum length considered for digest text, when stored in
- performance_schema tables.
- --performance-schema-max-file-classes=#
- Maximum number of file instruments.
- --performance-schema-max-file-handles=#
- Maximum number of opened instrumented files.
- --performance-schema-max-file-instances=#
- Maximum number of instrumented files. Use 0 to disable,
- -1 for automated scaling.
- --performance-schema-max-index-stat=#
- Maximum number of index statistics for instrumented
- tables. Use 0 to disable, -1 for automated scaling.
- --performance-schema-max-memory-classes=#
- Maximum number of memory pool instruments.
- --performance-schema-max-metadata-locks=#
- Maximum number of metadata locks. Use 0 to disable, -1
- for automated scaling.
- --performance-schema-max-mutex-classes=#
- Maximum number of mutex instruments.
- --performance-schema-max-mutex-instances=#
- Maximum number of instrumented MUTEX objects. Use 0 to
- disable, -1 for automated scaling.
- --performance-schema-max-prepared-statements-instances=#
- Maximum number of instrumented prepared statements. Use 0
- to disable, -1 for automated scaling.
- --performance-schema-max-program-instances=#
- Maximum number of instrumented programs. Use 0 to
- disable, -1 for automated scaling.
- --performance-schema-max-rwlock-classes=#
- Maximum number of rwlock instruments.
- --performance-schema-max-rwlock-instances=#
- Maximum number of instrumented RWLOCK objects. Use 0 to
- disable, -1 for automated scaling.
- --performance-schema-max-socket-classes=#
- Maximum number of socket instruments.
- --performance-schema-max-socket-instances=#
- Maximum number of opened instrumented sockets. Use 0 to
- disable, -1 for automated scaling.
- --performance-schema-max-sql-text-length=#
- Maximum length of displayed sql text.
- --performance-schema-max-stage-classes=#
- Maximum number of stage instruments.
- --performance-schema-max-statement-classes=#
- Maximum number of statement instruments.
- --performance-schema-max-statement-stack=#
- Number of rows per thread in EVENTS_STATEMENTS_CURRENT.
- --performance-schema-max-table-handles=#
- Maximum number of opened instrumented tables. Use 0 to
- disable, -1 for automated scaling.
- --performance-schema-max-table-instances=#
- Maximum number of instrumented tables. Use 0 to disable,
- -1 for automated scaling.
- --performance-schema-max-table-lock-stat=#
- Maximum number of lock statistics for instrumented
- tables. Use 0 to disable, -1 for automated scaling.
- --performance-schema-max-thread-classes=#
- Maximum number of thread instruments.
- --performance-schema-max-thread-instances=#
- Maximum number of instrumented threads. Use 0 to disable,
- -1 for automated scaling.
- --performance-schema-session-connect-attrs-size=#
- Size of session attribute string buffer per thread. Use 0
- to disable, -1 for automated sizing.
- --performance-schema-setup-actors-size=#
- Maximum number of rows in SETUP_ACTORS. Use 0 to disable,
- -1 for automated scaling.
- --performance-schema-setup-objects-size=#
- Maximum number of rows in SETUP_OBJECTS. Use 0 to
- disable, -1 for automated scaling.
- --performance-schema-users-size=#
- Maximum number of instrumented users. Use 0 to disable,
- -1 for automated scaling.
- --pid-file=name Pid file used by safe_mysqld
- --plugin-dir=name Directory for plugins
- --plugin-load=name Optional semicolon-separated list of plugins to load,
- where each plugin is identified as name=library, where
- name is the plugin name and library is the plugin library
- in plugin_dir.
- --plugin-load-add=name
- Optional semicolon-separated list of plugins to load,
- where each plugin is identified as name=library, where
- name is the plugin name and library is the plugin library
- in plugin_dir. This option adds to the list specified by
- --plugin-load in an incremental way. Multiple
- --plugin-load-add are supported.
- -P, --port=# Port number to use for connection or 0 to default to,
- my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default
- (3306), whatever comes first
- --port-open-timeout=#
- Maximum time in seconds to wait for the port to become
- free. (Default: No wait).
- --preload-buffer-size=#
- The size of the buffer that is allocated when preloading
- indexes
- --profiling-history-size=#
- Limit of query profiling memory
- --proxy-protocol-networks=name
- Enable proxy protocol for these source networks. The
- syntax is a comma separated list of IPv4 and IPv6
- networks. If the network doesn't contain mask, it is
- considered to be a single host. "*" represents all
- networks and must the only directive on the line.
- --query-alloc-block-size=#
- Allocation block size for query parsing and execution
- --query-cache-limit=#
- Don't cache results that are bigger than this. This
- variable is deprecated and will be removed in a future
- release.
- --query-cache-min-res-unit=#
- The minimum size for blocks allocated by the query cache.
- This variable is deprecated and will be removed in a
- future release.
- --query-cache-size=#
- The memory allocated to store results from old queries.
- This variable is deprecated and will be removed in a
- future release.
- --query-cache-strip-comments
- Enable and disable optimisation "strip comment for query
- cache" - optimisation strip all comments from query while
- search query result in query cache
- --query-cache-type=name
- OFF = Don't cache or retrieve results. ON = Cache all
- results except SELECT SQL_NO_CACHE ... queries. DEMAND =
- Cache only SELECT SQL_CACHE ... queries. This variable is
- deprecated and will be removed in a future release.
- --query-cache-wlock-invalidate
- Invalidate queries in query cache on LOCK for write. This
- variable is deprecated and will be removed in a future
- release.
- --query-prealloc-size=#
- Persistent buffer for query parsing and execution
- --range-alloc-block-size=#
- Allocation block size for storing ranges during
- optimization
- --range-optimizer-max-mem-size=#
- Maximum amount of memory used by the range optimizer to
- allocate predicates during range analysis. The larger the
- number, more memory may be consumed during range
- analysis. If the value is too low to completed range
- optimization of a query, index range scan will not be
- considered for this query. A value of 0 means range
- optimizer does not have any cap on memory.
- --read-buffer-size=#
- Each thread that does a sequential scan allocates a
- buffer of this size for each table it scans. If you do
- many sequential scans, you may want to increase this
- value
- --read-only Make all non-temporary tables read-only, with the
- exception for replication (slave) threads and users with
- the SUPER privilege
- --read-rnd-buffer-size=#
- When reading rows in sorted order after a sort, the rows
- are read through this buffer to avoid a disk seeks
- --relay-log=name The location and name to use for relay logs
- --relay-log-index=name
- File that holds the names for relay log files.
- --relay-log-info-file=name
- The location and name of the file that remembers where
- the SQL replication thread is in the relay logs
- --relay-log-info-repository=name
- Defines the type of the repository for the relay log
- information and associated workers.
- --relay-log-purge if disabled - do not purge relay logs. if enabled - purge
- them as soon as they are no more needed
- (Defaults to on; use --skip-relay-log-purge to disable.)
- --relay-log-recovery
- Enables automatic relay log recovery right after the
- database startup, which means that the IO Thread starts
- re-fetching from the master right after the last
- transaction processed
- --relay-log-space-limit=#
- Maximum space to use for all relay logs
- --replicate-do-db=name
- Tells the slave thread to restrict replication to the
- specified database. To specify more than one database,
- use the directive multiple times, once for each database.
- Note that this will only work if you do not use
- cross-database queries such as UPDATE some_db.some_table
- SET foo='bar' while having selected a different or no
- database. If you need cross database updates to work,
- make sure you have 3.23.28 or later, and use
- replicate-wild-do-table=db_name.%.
- --replicate-do-table=name
- Tells the slave thread to restrict replication to the
- specified table. To specify more than one table, use the
- directive multiple times, once for each table. This will
- work for cross-database updates, in contrast to
- replicate-do-db.
- --replicate-ignore-db=name
- Tells the slave thread to not replicate to the specified
- database. To specify more than one database to ignore,
- use the directive multiple times, once for each database.
- This option will not work if you use cross database
- updates. If you need cross database updates to work, make
- sure you have 3.23.28 or later, and use
- replicate-wild-ignore-table=db_name.%.
- --replicate-ignore-table=name
- Tells the slave thread to not replicate to the specified
- table. To specify more than one table to ignore, use the
- directive multiple times, once for each table. This will
- work for cross-database updates, in contrast to
- replicate-ignore-db.
- --replicate-rewrite-db=name
- Updates to a database with a different name than the
- original. Example:
- replicate-rewrite-db=master_db_name->slave_db_name.
- --replicate-same-server-id
- In replication, if set to 1, do not skip events having
- our server id. Default value is 0 (to break infinite
- loops in circular replication). Can't be set to 1 if
- --log-slave-updates is used.
- --replicate-wild-do-table=name
- Tells the slave thread to restrict replication to the
- tables that match the specified wildcard pattern. To
- specify more than one table, use the directive multiple
- times, once for each table. This will work for
- cross-database updates. Example:
- replicate-wild-do-table=foo%.bar% will replicate only
- updates to tables in all databases that start with foo
- and whose table names start with bar.
- --replicate-wild-ignore-table=name
- Tells the slave thread to not replicate to the tables
- that match the given wildcard pattern. To specify more
- than one table to ignore, use the directive multiple
- times, once for each table. This will work for
- cross-database updates. Example:
- replicate-wild-ignore-table=foo%.bar% will not do updates
- to tables in databases that start with foo and whose
- table names start with bar.
- --report-host=name Hostname or IP of the slave to be reported to the master
- during slave registration. Will appear in the output of
- SHOW SLAVE HOSTS. Leave unset if you do not want the
- slave to register itself with the master. Note that it is
- not sufficient for the master to simply read the IP of
- the slave off the socket once the slave connects. Due to
- NAT and other routing issues, that IP may not be valid
- for connecting to the slave from the master or other
- hosts
- --report-password=name
- The account password of the slave to be reported to the
- master during slave registration
- --report-port=# Port for connecting to slave reported to the master
- during slave registration. Set it only if the slave is
- listening on a non-default port or if you have a special
- tunnel from the master or other clients to the slave. If
- not sure, leave this option unset
- --report-user=name The account user name of the slave to be reported to the
- master during slave registration
- --require-secure-transport
- When this option is enabled, connections attempted using
- insecure transport will be rejected. Secure transports
- are SSL/TLS, Unix socket or Shared Memory (on Windows).
- --rpl-stop-slave-timeout=#
- Timeout in seconds to wait for slave to stop before
- returning a warning.
- --safe-user-create Don't allow new user creation by the user who has no
- write privileges to the mysql.user table.
- --secure-auth Disallow authentication for accounts that have old
- (pre-4.1) passwords. Deprecated. Always TRUE.
- (Defaults to on; use --skip-secure-auth to disable.)
- --secure-file-priv=name
- Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to
- files within specified directory
- --server-id=# Uniquely identifies the server instance in the community
- of replication partners
- --server-id-bits=# Set number of significant bits in server-id
- --session-track-gtids=name
- Controls the amount of global transaction ids to be
- included in the response packet sent by the
- server.(Default: OFF).
- --session-track-schema
- Track changes to the 'default schema'.
- (Defaults to on; use --skip-session-track-schema to disable.)
- --session-track-state-change
- Track changes to the 'session state'.
- --session-track-system-variables=name
- Track changes in registered system variables.
- --session-track-transaction-info=name
- Track changes to the transaction attributes. OFF to
- disable; STATE to track just transaction state (Is there
- an active transaction? Does it have any data? etc.);
- CHARACTERISTICS to track transaction state and report all
- statements needed to start a transaction with the same
- characteristics (isolation level, read only/read write,
- snapshot - but not any work done / data modified within
- the transaction).
- --sha256-password-auto-generate-rsa-keys
- Auto generate RSA keys at server startup if correpsonding
- system variables are not specified and key files are not
- present at the default location.
- (Defaults to on; use --skip-sha256-password-auto-generate-rsa-keys to disable.)
- --sha256-password-private-key-path=name
- A fully qualified path to the private RSA key used for
- authentication
- --sha256-password-proxy-users
- If set to FALSE (the default), then the sha256_password
- authentication plugin will not signal for authenticated
- users to be checked for mapping to proxy users. When set
- to TRUE, the plugin will flag associated authenticated
- accounts to be mapped to proxy users when the server
- option check_proxy_users is enabled.
- --sha256-password-public-key-path=name
- A fully qualified path to the public RSA key used for
- authentication
- --show-compatibility-56
- SHOW commands / INFORMATION_SCHEMA tables compatible with
- MySQL 5.6
- --show-create-table-verbosity
- When this option is enabled, it increases the verbosity
- of 'SHOW CREATE TABLE'.
- --show-old-temporals
- When this option is enabled, the pre-5.6.4 temporal types
- will be marked in the 'SHOW CREATE TABLE' and
- 'INFORMATION_SCHEMA.COLUMNS' table as a comment in
- COLUMN_TYPE field. This variable is deprecated and will
- be removed in a future release.
- --show-slave-auth-info
- Show user and password in SHOW SLAVE HOSTS on this
- master.
- --skip-grant-tables Start without grant tables. This gives all users FULL
- ACCESS to all tables.
- --skip-host-cache Don't cache host names.
- --skip-name-resolve Don't resolve hostnames. All hostnames are IP's or
- 'localhost'.
- --skip-networking Don't allow connection with TCP/IP
- --skip-new Don't use new, possibly wrong routines.
- --skip-show-database
- Don't allow 'SHOW DATABASE' commands
- --skip-slave-start If set, slave is not autostarted.
- --skip-stack-trace Don't print a stack trace on failure.
- --slave-allow-batching
- Allow slave to batch requests
- --slave-checkpoint-group=#
- Maximum number of processed transactions by
- Multi-threaded slave before a checkpoint operation is
- called to update progress status.
- --slave-checkpoint-period=#
- Gather workers' activities to Update progress status of
- Multi-threaded slave and flush the relay log info to disk
- after every #th milli-seconds.
- --slave-compressed-protocol
- Use compression on master/slave protocol
- --slave-exec-mode=name
- Modes for how replication events should be executed.
- Legal values are STRICT (default) and IDEMPOTENT. In
- IDEMPOTENT mode, replication will not stop for operations
- that are idempotent. In STRICT mode, replication will
- stop on any unexpected difference between the master and
- the slave
- --slave-load-tmpdir=name
- The location where the slave should put its temporary
- files when replicating a LOAD DATA INFILE command
- --slave-max-allowed-packet=#
- The maximum packet length to sent successfully from the
- master to slave.
- --slave-net-timeout=#
- Number of seconds to wait for more data from a
- master/slave connection before aborting the read
- --slave-parallel-type=name
- Specifies if the slave will use database partitioning or
- information from master to parallelize
- transactions.(Default: DATABASE).
- --slave-parallel-workers=#
- Number of worker threads for executing events in parallel
- --slave-pending-jobs-size-max=#
- Max size of Slave Worker queues holding yet not applied
- events.The least possible value must be not less than the
- master side max_allowed_packet.
- --slave-preserve-commit-order
- Force slave workers to make commits in the same order as
- on the master. Disabled by default.
- --slave-rows-search-algorithms=name
- Set of searching algorithms that the slave will use while
- searching for records from the storage engine to either
- updated or deleted them. Possible values are: INDEX_SCAN,
- TABLE_SCAN and HASH_SCAN. Any combination is allowed, and
- the slave will always pick the most suitable algorithm
- for any given scenario. (Default: INDEX_SCAN,
- TABLE_SCAN).
- --slave-skip-errors=name
- Tells the slave thread to continue replication when a
- query event returns an error from the provided list
- --slave-sql-verify-checksum
- Force checksum verification of replication events after
- reading them from relay log. Note: Events are always
- checksum-verified by slave on receiving them from the
- network before writing them to the relay log. Enabled by
- default.
- (Defaults to on; use --skip-slave-sql-verify-checksum to disable.)
- --slave-transaction-retries=#
- Number of times the slave SQL thread will retry a
- transaction in case it failed with a deadlock or elapsed
- lock wait timeout, before giving up and stopping
- --slave-type-conversions=name
- Set of slave type conversions that are enabled. Legal
- values are: ALL_LOSSY to enable lossy conversions,
- ALL_NON_LOSSY to enable non-lossy conversions,
- ALL_UNSIGNED to treat all integer column type data to be
- unsigned values, and ALL_SIGNED to treat all integer
- column type data to be signed values. Default treatment
- is ALL_SIGNED. If ALL_SIGNED and ALL_UNSIGNED both are
- specified, ALL_SIGNED will take higher priority than
- ALL_UNSIGNED. If the variable is assigned the empty set,
- no conversions are allowed and it is expected that the
- types match exactly.
- --slow-launch-time=#
- If creating the thread takes longer than this value (in
- seconds), the Slow_launch_threads counter will be
- incremented
- --slow-query-log Log slow queries to a table or log file. Defaults logging
- to a file hostname-slow.log or a table mysql.slow_log if
- --log-output=TABLE is used. Must be enabled to activate
- other slow log options
- --slow-query-log-always-write-time=#
- Log queries which run longer than specified by this value
- regardless of the log_slow_rate_limit valiue.
- --slow-query-log-file=name
- Log slow queries to given log file. Defaults logging to
- hostname-slow.log. Must be enabled to activate other slow
- log options
- --slow-query-log-use-global-control=name
- Choose flags, wich always use the global variables.
- Multiple flags allowed in a comma-separated string.
- [none, log_slow_filter, log_slow_rate_limit,
- log_slow_verbosity, long_query_time,
- min_examined_row_limit, all]
- --socket=name Socket file to use for connection
- --sort-buffer-size=#
- Each thread that needs to do a sort allocates a buffer of
- this size
- --sporadic-binlog-dump-fail
- Option used by mysql-test for debugging and testing of
- replication.
- --sql-mode=name Syntax: sql-mode=mode[,mode[,mode...]]. See the manual
- for the complete list of valid sql modes
- --ssl Enable SSL for connection (automatically enabled with
- other 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-key=name X509 key in PEM format (implies --ssl)
- --stored-program-cache=#
- The soft upper limit for number of cached stored routines
- for one connection.
- --super-large-pages Enable support for super large pages.
- --super-read-only Make all non-temporary tables read-only, with the
- exception for replication (slave) threads. Users with
- the SUPER privilege are affected, unlike read_only.
- Setting super_read_only to ON also sets read_only to ON.
- -s, --symbolic-links
- Enable symbolic link support.
- (Defaults to on; use --skip-symbolic-links to disable.)
- --sync-binlog=# Synchronously flush binary log to disk after every #th
- write to the file. Use 0 to disable synchronous flushing
- --sync-frm Sync .frm files to disk on creation
- (Defaults to on; use --skip-sync-frm to disable.)
- --sync-master-info=#
- Synchronously flush master info to disk after every #th
- event. Use 0 to disable synchronous flushing
- --sync-relay-log=# Synchronously flush relay log to disk after every #th
- event. Use 0 to disable synchronous flushing
- --sync-relay-log-info=#
- Synchronously flush relay log info to disk after every
- #th transaction. Use 0 to disable synchronous flushing
- --sysdate-is-now Non-default option to alias SYSDATE() to NOW() to make it
- safe-replicable. Since 5.0, SYSDATE() returns a `dynamic'
- value different for different invocations, even within
- the same statement.
- --table-definition-cache=#
- The number of cached table definitions
- --table-open-cache=#
- The number of cached open tables (total for all table
- cache instances)
- --table-open-cache-instances=#
- The number of table cache instances
- --tc-heuristic-recover=name
- Decision to use in heuristic recover process. Possible
- values are OFF, COMMIT or ROLLBACK.
- --temp-pool This option is deprecated and will be removed in a future
- version. Using this option will cause most temporary
- files created to use a small set of names, rather than a
- unique name for each new file.
- (Defaults to on; use --skip-temp-pool to disable.)
- --thread-cache-size=#
- How many threads we should keep in a cache for reuse
- --thread-handling=name
- Define threads usage for handling queries, one of
- one-thread-per-connection, no-threads, pool-of-threads
- --thread-pool-high-prio-mode=name
- High priority queue mode: one of 'transactions',
- 'statements' or 'none'. In the 'transactions' mode the
- thread pool uses both high- and low-priority queues
- depending on whether an event is generated by an already
- started transaction or a connection holding a MDL, table,
- user, or a global read or backup lock and whether it has
- any high priority tickets (see
- thread_pool_high_prio_tickets). In the 'statements' mode
- all events (i.e. individual statements) always go to the
- high priority queue, regardless of the current
- transaction and lock state and high priority tickets.
- 'none' is the opposite of 'statements', i.e. disables the
- high priority queue completely.
- --thread-pool-high-prio-tickets=#
- Number of tickets to enter the high priority event queue
- for each transaction.
- --thread-pool-idle-timeout=#
- Timeout in seconds for an idle thread in the thread
- pool.Worker thread will be shut down after timeout
- --thread-pool-max-threads=#
- Maximum allowed number of worker threads in the thread
- pool
- --thread-pool-oversubscribe=#
- How many additional active worker threads in a group are
- allowed.
- --thread-pool-size=#
- Number of thread groups in the pool. This parameter is
- roughly equivalent to maximum number of concurrently
- executing threads (threads in a waiting state do not
- count as executing).
- --thread-pool-stall-limit=#
- Maximum query execution time in milliseconds,before an
- executing non-yielding thread is considered stalled.If a
- worker thread is stalled, additional worker thread may be
- created to handle remaining clients.
- --thread-stack=# The stack size for each thread
- --thread-statistics Control TABLE_STATISTICS running, when userstat is
- enabled
- --time-format=name The TIME format (ignored)
- --tls-version=name TLS version, permitted values are TLSv1, TLSv1.1,
- TLSv1.2(Only for openssl)
- --tmp-table-size=# If an internal in-memory temporary table exceeds this
- size, MySQL will automatically convert it to an on-disk
- MyISAM table
- -t, --tmpdir=name Path for temporary files. Several paths may be specified,
- separated by a colon (:), in this case they are used in a
- round-robin fashion
- --transaction-alloc-block-size=#
- Allocation block size for transactions to be stored in
- binary log
- --transaction-isolation=name
- Default transaction isolation level.
- --transaction-prealloc-size=#
- Persistent buffer for transactions to be stored in binary
- log
- --transaction-read-only
- Default transaction access mode. True if transactions are
- read-only.
- --transaction-write-set-extraction[=name]
- This option is used to let the server know when to
- extract the write set which will be used for various
- purposes.
- --updatable-views-with-limit=name
- YES = Don't issue an error message (warning only) if a
- VIEW without presence of a key of the underlying table is
- used in queries with a LIMIT clause for updating. NO =
- Prohibit update of a VIEW, which does not contain a key
- of the underlying table and the query uses a LIMIT clause
- (usually get from GUI tools)
- -u, --user=name Run mysqld daemon as user.
- --userstat Control USER_STATISTICS, CLIENT_STATISTICS,
- THREAD_STATISTICS, INDEX_STATISTICS and TABLE_STATISTICS
- running
- --utility-user=name Specifies a MySQL user that will be added to the internal
- list of users and recognized as the utility user.
- --utility-user-password=name
- Specifies the password required for the utility user.
- --utility-user-privileges=name
- Specifies the privileges that the utility user will have
- in a comma delimited list. See the manual for a complete
- list of privileges.
- --utility-user-schema-access=name
- Specifies the schemas that the utility user has access to
- in a comma delimited list.
- --validate-user-plugins
- Turns on additional validation of authentication plugins
- assigned to user accounts.
- (Defaults to on; use --skip-validate-user-plugins to disable.)
- -v, --verbose Used with --help option for detailed help.
- -V, --version Output version information and exit.
- --wait-timeout=# The number of seconds the server waits for activity on a
- connection before closing it
- Variables (--variable-name=value)
- and boolean options {FALSE|TRUE} Value (after reading options)
- ------------------------------------------------------------ -------------
- abort-slave-event-count 0
- allow-suspicious-udfs FALSE
- archive ON
- auto-generate-certs TRUE
- auto-increment-increment 1
- auto-increment-offset 1
- autocommit TRUE
- automatic-sp-privileges TRUE
- avoid-temporal-upgrade FALSE
- back-log 80
- basedir /usr/
- big-tables FALSE
- bind-address *
- binlog-cache-size 32768
- binlog-checksum CRC32
- binlog-direct-non-transactional-updates FALSE
- binlog-error-action ABORT_SERVER
- 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-row-event-max-size 8192
- binlog-row-image FULL
- binlog-rows-query-log-events FALSE
- binlog-skip-flush-commands FALSE
- binlog-space-limit 0
- binlog-stmt-cache-size 32768
- 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
- character-set-client-handshake TRUE
- character-set-filesystem binary
- character-set-server latin1
- character-sets-dir /usr/share/percona-server/charsets/
- check-proxy-users FALSE
- chroot (No default value)
- collation-server latin1_swedish_ci
- completion-type NO_CHAIN
- concurrent-insert AUTO
- connect-timeout 10
- console FALSE
- csv-mode
- daemonize FALSE
- datadir /var/lib/mysql/
- date-format %Y-%m-%d
- datetime-format %Y-%m-%d %H:%i:%s
- default-authentication-plugin mysql_native_password
- default-password-lifetime 0
- default-storage-engine InnoDB
- 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
- des-key-file (No default value)
- disable-partition-engine-check TRUE
- disabled-storage-engines
- disconnect-on-expired-password TRUE
- disconnect-slave-event-count 0
- div-precision-increment 4
- encrypt-binlog FALSE
- encrypt-tmp-files FALSE
- end-markers-in-json FALSE
- enforce-gtid-consistency FALSE
- enforce-storage-engine (No default value)
- eq-range-index-dive-limit 200
- event-scheduler OFF
- expand-fast-index-creation FALSE
- expire-logs-days 0
- explicit-defaults-for-timestamp FALSE
- external-locking FALSE
- extra-max-connections 1
- extra-port 0
- federated ON
- flush FALSE
- flush-time 0
- ft-boolean-syntax + -><()~*:""&|
- ft-max-word-len 84
- ft-min-word-len 4
- ft-query-expansion-limit 20
- ft-query-extra-word-chars FALSE
- ft-stopword-file (No default value)
- gdb FALSE
- general-log FALSE
- general-log-file /var/lib/mysql/9dda8c80bfd8.log
- group-concat-max-len 1024
- gtid-executed-compression-period 1000
- gtid-mode OFF
- help TRUE
- host-cache-size 279
- ignore-builtin-innodb FALSE
- init-connect
- init-file (No default value)
- 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 1
- innodb-background-scrub-data-check-interval 3600
- innodb-background-scrub-data-compressed FALSE
- innodb-background-scrub-data-interval 604800
- innodb-background-scrub-data-uncompressed FALSE
- innodb-buffer-pool-chunk-size 134217728
- innodb-buffer-pool-dump-at-shutdown TRUE
- innodb-buffer-pool-dump-now FALSE
- innodb-buffer-pool-dump-pct 25
- innodb-buffer-pool-filename ib_buffer_pool
- innodb-buffer-pool-instances 0
- innodb-buffer-pool-load-abort FALSE
- innodb-buffer-pool-load-at-startup TRUE
- innodb-buffer-pool-load-now FALSE
- innodb-buffer-pool-size 134217728
- innodb-change-buffer-max-size 25
- innodb-change-buffering all
- innodb-checksum-algorithm crc32
- innodb-checksums TRUE
- innodb-cleaner-lsn-age-factor high_checkpoint
- innodb-cmp-per-index-enabled FALSE
- innodb-commit-concurrency 0
- innodb-compressed-columns-threshold 96
- innodb-compressed-columns-zip-level 6
- innodb-compression-failure-threshold-pct 5
- innodb-compression-level 6
- innodb-compression-pad-pct-max 50
- innodb-concurrency-tickets 5000
- innodb-corrupt-table-action assert
- innodb-data-file-path (No default value)
- innodb-data-home-dir (No default value)
- innodb-deadlock-detect TRUE
- innodb-default-encryption-key-id 0
- innodb-default-row-format dynamic
- innodb-disable-sort-file-cache FALSE
- innodb-doublewrite TRUE
- innodb-empty-free-list-algorithm backoff
- innodb-encrypt-online-alter-logs FALSE
- innodb-encrypt-tables OFF
- innodb-encryption-rotate-key-age 1
- innodb-encryption-rotation-iops 100
- innodb-encryption-threads 0
- innodb-fast-shutdown 1
- innodb-file-format Barracuda
- innodb-file-format-check TRUE
- innodb-file-format-max Antelope
- 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 (No default value)
- innodb-flush-neighbors 1
- innodb-flush-sync TRUE
- innodb-flushing-avg-loops 30
- innodb-force-load-corrupted FALSE
- innodb-force-recovery 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-ignore-stopwords FALSE
- innodb-ft-max-token-size 84
- innodb-ft-min-token-size 3
- innodb-ft-num-word-optimize 2000
- innodb-ft-result-cache-limit 2000000000
- innodb-ft-server-stopword-table (No default value)
- innodb-ft-sort-pll-degree 2
- innodb-ft-total-cache-size 640000000
- innodb-ft-user-stopword-table (No default value)
- innodb-immediate-scrub-data-uncompressed FALSE
- innodb-io-capacity 200
- innodb-io-capacity-max 18446744073709551615
- innodb-kill-idle-transaction 0
- innodb-large-prefix TRUE
- innodb-lock-wait-timeout 50
- innodb-locks-unsafe-for-binlog FALSE
- 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-write-ahead-size 8192
- innodb-lru-scan-depth 1024
- innodb-max-bitmap-file-size 104857600
- innodb-max-changed-pages 1000000
- innodb-max-dirty-pages-pct 75
- innodb-max-dirty-pages-pct-lwm 0
- 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-dblwr-encrypt FALSE
- innodb-parallel-doublewrite-path xb_doublewrite
- innodb-print-all-deadlocks FALSE
- innodb-print-lock-wait-timeout-info 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-encrypt off
- innodb-replication-delay 0
- innodb-rollback-on-timeout FALSE
- innodb-rollback-segments 128
- innodb-scrub-log FALSE
- innodb-scrub-log-speed 256
- innodb-show-locks-held 10
- innodb-show-verbose-locks 0
- innodb-sort-buffer-size 1048576
- innodb-spin-wait-delay 6
- 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-sample-pages 8
- innodb-stats-transient-sample-pages 8
- innodb-status-file FALSE
- innodb-status-output FALSE
- innodb-status-output-locks FALSE
- innodb-strict-mode TRUE
- innodb-support-xa TRUE
- innodb-sync-array-size 1
- innodb-sync-spin-loops 30
- innodb-sys-tablespace-encrypt FALSE
- innodb-table-locks TRUE
- innodb-temp-data-file-path (No default value)
- innodb-temp-tablespace-encrypt FALSE
- innodb-thread-concurrency 0
- innodb-thread-sleep-delay 10000
- innodb-tmpdir (No default value)
- innodb-track-changed-pages FALSE
- innodb-undo-directory (No default value)
- innodb-undo-log-encrypt FALSE
- innodb-undo-log-truncate FALSE
- innodb-undo-logs 128
- innodb-undo-tablespaces 0
- innodb-use-global-flush-log-at-trx-commit TRUE
- innodb-use-native-aio TRUE
- innodb-write-io-threads 4
- interactive-timeout 28800
- internal-tmp-disk-storage-engine InnoDB
- join-buffer-size 262144
- keep-files-on-create FALSE
- key-buffer-size 8388608
- key-cache-age-threshold 300
- key-cache-block-size 1024
- key-cache-division-limit 100
- keyring-migration-destination (No default value)
- keyring-migration-host (No default value)
- keyring-migration-port 0
- keyring-migration-socket (No default value)
- keyring-migration-source (No default value)
- keyring-migration-user (No default value)
- kill-idle-transaction 0
- language /usr/share/percona-server/
- large-pages FALSE
- lc-messages en_US
- lc-messages-dir /usr/share/percona-server/
- lc-time-names en_US
- local-infile TRUE
- lock-wait-timeout 31536000
- log-bin (No default value)
- log-bin-index (No default value)
- log-bin-trust-function-creators FALSE
- log-bin-use-v1-row-events FALSE
- log-builtin-as-identified-by-password FALSE
- log-error stderr
- log-error-verbosity 1
- log-isam myisam.log
- log-output FILE
- log-queries-not-using-indexes FALSE
- log-raw FALSE
- log-short-format FALSE
- log-slave-updates FALSE
- log-slow-admin-statements FALSE
- log-slow-filter
- log-slow-rate-limit 1
- log-slow-rate-type session
- log-slow-slave-statements FALSE
- log-slow-sp-statements ON
- log-slow-verbosity
- log-statements-unsafe-for-binlog TRUE
- log-syslog FALSE
- log-syslog-facility daemon
- log-syslog-include-pid TRUE
- log-syslog-tag
- log-tc tc.log
- log-tc-size 24576
- log-throttle-queries-not-using-indexes 0
- log-timestamps UTC
- log-warnings 0
- long-query-time 10
- low-priority-updates FALSE
- lower-case-table-names 0
- master-info-file master.info
- master-info-repository FILE
- master-retry-count 86400
- master-verify-checksum FALSE
- max-allowed-packet 4194304
- max-binlog-cache-size 18446744073709547520
- max-binlog-dump-events 0
- max-binlog-files 0
- max-binlog-size 1073741824
- max-binlog-stmt-cache-size 18446744073709547520
- max-connect-errors 100
- max-connections 151
- max-delayed-threads 20
- max-digest-length 1024
- max-error-count 64
- max-execution-time 0
- max-heap-table-size 16777216
- max-join-size 18446744073709551615
- max-length-for-sort-data 1024
- max-points-in-geometry 65536
- max-prepared-stmt-count 16382
- max-relay-log-size 0
- max-seeks-for-key 18446744073709551615
- max-slowlog-files 0
- max-slowlog-size 0
- max-sort-length 1024
- max-sp-recursion-depth 0
- max-tmp-tables 32
- max-user-connections 0
- max-write-lock-count 18446744073709551615
- memlock FALSE
- metadata-locks-cache-size 1024
- metadata-locks-hash-instances 8
- min-examined-row-limit 0
- multi-range-count 256
- myisam-block-size 1024
- myisam-data-pointer-size 6
- myisam-max-sort-file-size 9223372036853727232
- myisam-mmap-size 18446744073709551615
- myisam-recover-options OFF
- myisam-repair-threads 1
- myisam-sort-buffer-size 8388608
- myisam-stats-method nulls_unequal
- myisam-use-mmap FALSE
- mysql-native-password-proxy-users FALSE
- net-buffer-length 16384
- net-read-timeout 30
- net-retry-count 10
- net-write-timeout 60
- new FALSE
- ngram ON
- ngram-token-size 2
- offline-mode FALSE
- old FALSE
- old-alter-table FALSE
- old-passwords 0
- old-style-user-limits FALSE
- open-files-limit 1048576
- 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
- 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 16384
- optimizer-trace-offset -1
- parser-max-mem-size 18446744073709551615
- partition ON
- 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-current TRUE
- performance-schema-consumer-events-statements-history TRUE
- performance-schema-consumer-events-statements-history-long FALSE
- performance-schema-consumer-events-transactions-current FALSE
- performance-schema-consumer-events-transactions-history FALSE
- performance-schema-consumer-events-transactions-history-long FALSE
- performance-schema-consumer-events-waits-current FALSE
- performance-schema-consumer-events-waits-history FALSE
- performance-schema-consumer-events-waits-history-long FALSE
- performance-schema-consumer-global-instrumentation TRUE
- performance-schema-consumer-statements-digest TRUE
- performance-schema-consumer-thread-instrumentation TRUE
- performance-schema-digests-size -1
- performance-schema-events-stages-history-long-size -1
- performance-schema-events-stages-history-size -1
- performance-schema-events-statements-history-long-size -1
- performance-schema-events-statements-history-size -1
- performance-schema-events-transactions-history-long-size -1
- performance-schema-events-transactions-history-size -1
- performance-schema-events-waits-history-long-size -1
- performance-schema-events-waits-history-size -1
- performance-schema-hosts-size -1
- performance-schema-instrument
- performance-schema-max-cond-classes 80
- performance-schema-max-cond-instances -1
- performance-schema-max-digest-length 1024
- performance-schema-max-file-classes 80
- performance-schema-max-file-handles 32768
- performance-schema-max-file-instances -1
- performance-schema-max-index-stat -1
- performance-schema-max-memory-classes 400
- performance-schema-max-metadata-locks -1
- performance-schema-max-mutex-classes 250
- performance-schema-max-mutex-instances -1
- performance-schema-max-prepared-statements-instances -1
- performance-schema-max-program-instances -1
- performance-schema-max-rwlock-classes 50
- performance-schema-max-rwlock-instances -1
- performance-schema-max-socket-classes 10
- performance-schema-max-socket-instances -1
- performance-schema-max-sql-text-length 1024
- performance-schema-max-stage-classes 150
- performance-schema-max-statement-classes 203
- performance-schema-max-statement-stack 10
- performance-schema-max-table-handles -1
- performance-schema-max-table-instances -1
- performance-schema-max-table-lock-stat -1
- performance-schema-max-thread-classes 50
- performance-schema-max-thread-instances -1
- performance-schema-session-connect-attrs-size -1
- performance-schema-setup-actors-size -1
- performance-schema-setup-objects-size -1
- performance-schema-users-size -1
- pid-file /var/run/mysqld/mysqld.pid
- plugin-dir /usr/lib64/mysql/plugin/
- port 3306
- port-open-timeout 0
- preload-buffer-size 32768
- profiling-history-size 15
- proxy-protocol-networks
- query-alloc-block-size 8192
- query-cache-limit 1048576
- query-cache-min-res-unit 4096
- query-cache-size 1048576
- query-cache-strip-comments FALSE
- query-cache-type OFF
- query-cache-wlock-invalidate FALSE
- query-prealloc-size 8192
- range-alloc-block-size 4096
- range-optimizer-max-mem-size 8388608
- read-buffer-size 131072
- read-only FALSE
- read-rnd-buffer-size 262144
- relay-log (No default value)
- relay-log-index (No default value)
- relay-log-info-file relay-log.info
- relay-log-info-repository FILE
- relay-log-purge TRUE
- relay-log-recovery FALSE
- relay-log-space-limit 0
- replicate-same-server-id FALSE
- report-host (No default value)
- report-password (No default value)
- report-port 0
- report-user (No default value)
- require-secure-transport FALSE
- rpl-stop-slave-timeout 31536000
- safe-user-create FALSE
- secure-auth TRUE
- secure-file-priv /var/lib/mysql-files/
- server-id 0
- 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-compatibility-56 FALSE
- show-create-table-verbosity FALSE
- show-old-temporals FALSE
- show-slave-auth-info FALSE
- skip-grant-tables FALSE
- skip-name-resolve TRUE
- skip-networking FALSE
- skip-show-database FALSE
- skip-slave-start FALSE
- slave-allow-batching FALSE
- 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 DATABASE
- slave-parallel-workers 0
- slave-pending-jobs-size-max 16777216
- slave-preserve-commit-order FALSE
- slave-rows-search-algorithms TABLE_SCAN,INDEX_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-always-write-time 10
- slow-query-log-file /var/lib/mysql/9dda8c80bfd8-slow.log
- slow-query-log-use-global-control
- socket /var/lib/mysql/mysql.sock
- sort-buffer-size 262144
- sporadic-binlog-dump-fail FALSE
- sql-mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
- 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-key (No default value)
- stored-program-cache 256
- super-large-pages FALSE
- super-read-only FALSE
- symbolic-links FALSE
- sync-binlog 1
- sync-frm TRUE
- sync-master-info 10000
- sync-relay-log 10000
- sync-relay-log-info 10000
- sysdate-is-now FALSE
- table-definition-cache 1400
- table-open-cache 2000
- table-open-cache-instances 16
- tc-heuristic-recover OFF
- temp-pool TRUE
- thread-cache-size 9
- thread-handling one-thread-per-connection
- thread-pool-high-prio-mode transactions
- thread-pool-high-prio-tickets -1
- thread-pool-idle-timeout 60
- thread-pool-max-threads 100000
- thread-pool-oversubscribe 3
- thread-pool-size 2
- thread-pool-stall-limit 500
- thread-stack 262144
- thread-statistics FALSE
- time-format %H:%i:%s
- tls-version TLSv1,TLSv1.1,TLSv1.2
- 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 OFF
- updatable-views-with-limit YES
- userstat FALSE
- utility-user (No default value)
- utility-user-password (No default value)
- utility-user-privileges
- utility-user-schema-access (No default value)
- validate-user-plugins TRUE
- verbose TRUE
- wait-timeout 28800
- To see what values a running MySQL server is using, type
- 'mysqladmin variables' instead of 'mysqld --verbose --help'.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement