--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-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.
--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-in-core-file
This option has no effect if @@core_file is OFF. If
@@core_file is ON, and this option is OFF, then the core
dump file will be generated only if it is possible to
exclude buffer pool from it. As soon as it will be
determined that such exclusion is impossible a warning
will be emitted and @@core_file will be set to OFF to
prevent generating a core dump. If this option is enabled
(which is the default), then core dumping logic will not
be affected.
(Defaults to on; use --skip-innodb-buffer-pool-in-core-file to disable.)
--innodb-buffer-pool-instances=#
Number of buffer pool instances, set to higher value 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; 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-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-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-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-dedicated-server
Automatically scale innodb_buffer_pool_size and
innodb_log_file_size based on system memory. Also set
innodb_flush_method=O_DIRECT_NO_FSYNC, if supported
--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-directories=name
List of directories 'dir1;dir2;..;dirN' to scan for
tablespace files. Default is to scan
'innodb-data-home-dir;innodb-undo-directory;datadir'
--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-doublewrite-batch-size=#
Number of double write pages to write in a batch
--innodb-doublewrite-dir=name
Use a separate directory for the doublewrite buffer
files,
--innodb-doublewrite-files=#
Number of double write files
--innodb-doublewrite-pages=#
Number of double write pages per thread
--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-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-fsync-threshold=#
The value of this variable determines how often InnoDB
calls fsync when creating a new file. Default is zero
which would make InnoDB flush the entire file at once
before closing it.
--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-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-idle-flush-pct=#
Up to what percentage of dirty pages to be flushed when
server is found idle.
--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-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-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 bytes).
--innodb-log-files-in-group=#
Number of log files (when multiplied by
innodb_log_file_size gives total size of log files).
InnoDB writes to files in a circular fashion.
--innodb-log-group-home-dir=name
Path to InnoDB log files.
--innodb-log-spin-cpu-abs-lwm=#
Minimum value of cpu time for which spin-delay is used.
Expressed in percentage of single cpu core.
--innodb-log-spin-cpu-pct-hwm=#
Maximum value of cpu time for which spin-delay is used.
Expressed in percentage of all cpu cores.
--innodb-log-wait-for-flush-spin-hwm=#
Maximum value of average log flush time for which
spin-delay is used. When flushing takes longer, user
threads no longer spin when waiting forflushed redo.
Expressed in microseconds.
--innodb-log-write-ahead-size=#
Log write ahead unit size to avoid read-on-write, it
should match the OS cache block IO size.
--innodb-lru-scan-depth=#
How deep to scan LRU to keep it clean
--innodb-max-dirty-pages-pct=#
Percentage of dirty pages allowed in bufferpool.
--innodb-max-dirty-pages-pct-lwm=#
Percentage of dirty pages at which flushing kicks in.
--innodb-max-purge-lag=#
Desired maximum length of the purge queue (0 = no limit)
--innodb-max-purge-lag-delay=#
Maximum delay of user threads in micro-seconds
--innodb-max-undo-log-size[=#]
Maximum size of an UNDO tablespace in MB (If an 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-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-read-threads=#
Number of threads to do parallel read.
--innodb-print-all-deadlocks
Print all deadlocks to MySQL error log (off by default)
--innodb-print-ddl-logs
Print all DDl logs to MySQL error log (off by default)
--innodb-purge-batch-size[=#]
Number of UNDO log pages to purge in one batch from 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-archive-dirs=name
Limit the location of the redo log archive to the
semicolon separated list of labeled directories
--innodb-redo-log-encrypt
Enable or disable Encryption of REDO tablespace.
--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 per tablespace. This applies
to the system tablespace, the temporary tablespace & any
undo tablespace.
--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-spin-wait-pause-multiplier=#
Controls how many times in a row to use a PAUSE
instruction to achieve one unit of delay in a spin lock
(see @@innodb_spin_wait_delay), defaults to 50
--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-transient-sample-pages=#
The number of leaf index pages to sample when calculating
transient statistics (if persistent statistics are not
used, default 8)
--innodb-status-file
Enable SHOW ENGINE INNODB STATUS output in the
innodb_status.<pid> file
--innodb-status-output
Enable InnoDB monitor output to the error log.
--innodb-status-output-locks
Enable InnoDB lock monitor output to the error log.
Requires innodb_status_output=ON.
--innodb-strict-mode
Use strict mode when evaluating create options.
(Defaults to on; use --skip-innodb-strict-mode to disable.)
--innodb-sync-array-size[=#]
Size of the mutex/lock wait array.
--innodb-sync-spin-loops=#
Count of spin-loop rounds in InnoDB mutexes (30 by
default)
--innodb-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-tablespaces-dir=name
Directory where temp tablespace files live, this path can
be absolute.
--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-undo-directory=name
Directory where undo tablespace files live, this path can
be absolute.
--innodb-undo-log-encrypt
Enable or disable Encrypt of UNDO tablespace.
--innodb-undo-log-truncate
Enable or Disable Truncate of UNDO tablespace.
(Defaults to on; use --skip-innodb-undo-log-truncate to disable.)
--innodb-undo-tablespaces=#
Number of undo tablespaces to use. (deprecated)
--innodb-use-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-mem-storage-engine=name
The default storage engine for in-memory internal
temporary tables.
--join-buffer-size=#
The size of the buffer that is used for full joins
--keep-files-on-create
Don't overwrite stale .MYD and .MYI even if no directory
is specified
--key-buffer-size=# The size of the buffer used for index blocks for MyISAM
tables. Increase this to get better index handling (for
all reads and multiple writes) to as much as you can
afford
--key-cache-age-threshold=#
This characterizes the number of hits a hot block has to
be untouched until it is considered aged enough to be
downgraded to a warm block. This specifies the percentage
ratio of that number of hits to the total number of
blocks in key cache
--key-cache-block-size=#
The default size of key cache blocks
--key-cache-division-limit=#
The minimum percentage of warm blocks in key cache
--keyring-migration-destination=name
Keyring plugin to which the keys are migrated to. This
option must be specified along with
--keyring-migration-source.
--keyring-migration-host=name
Connect to host.
-p, --keyring-migration-password[=name]
Password to use when connecting to server during keyring
migration. If password value is not specified then it
will be asked from the tty.
--keyring-migration-port=#
Port number to use for connection.
--keyring-migration-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.
-L, --language=name Client error messages in given language. May be given as
a full path. Deprecated. Use --lc-messages-dir instead.
--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
--lock-wait-timeout=#
Timeout in seconds to wait for a lock before returning an
error.
--log-bin[=name] Configures the name prefix to use for binary log files.
If the --log-bin option is not supplied, the name prefix
defaults to "binlog". If the --log-bin option is supplied
without argument, the name prefix defaults to
"HOSTNAME-bin", where HOSTNAME is the machine's hostname.
To set a different name prefix for binary log files, use
--log-bin=name. To disable binary logging, use the
--skip-log-bin or --disable-log-bin option.
--log-bin-index=name
File that holds the names for binary log files.
--log-bin-trust-function-creators
If set to FALSE (the default), then when --log-bin is
used, creation of a stored function (or trigger) is
allowed only to users having the SUPER privilege and only
if this stored function (trigger) may not break binary
logging. Note that if ALL connections to this server
ALWAYS use row-based binary logging, the security issues
do not exist and the binary logging cannot break, so you
can safely set this to TRUE
--log-bin-use-v1-row-events
If equal to 1 then version 1 row events are written to a
row based binary log. If equal to 0, then the latest
version of events are written. This option is useful
during some upgrades.
--log-error[=name] Error log file
--log-error-services=name
Services that should be called when an error event is
received
mysqld - 官方详细文档(MySQL社区版Ver 8.0.20 for Win64)_2
最新推荐文章于 2024-05-16 16:07:10 发布