mysqld - 官方详细文档(MySQL社区版Ver 8.0.20 for Win64)_2

  --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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值