mysql 5.6 配置文件详解_mysql5.6配置文件详解（一）

mysqld  Ver 5.6.11 for Linux on x86_64 (Source distribution)

Copyright (c) 2000, 2013, 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/local/mysql/etc/my.cnf ~/.my.cnf

The following groups are read: mysqld server mysqld-5.6

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

--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-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-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-p_w_picpath=name

Controls whether rows should be logged in 'FULL',

'NOBLOB' or 'MINIMAL' formats. 'FULL', means that all

columns in the before and after p_w_picpath 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 p_w_picpath, and only

changed columns are logged in the after p_w_picpath. (Default:

FULL).

--binlog-rows-query-log-events

Allow writing of Rows_query_log events into binary log.

--binlog-stmt-cache-size=#

The size of the statement cache for updates to

non-transactional engines for the binary log. If you

often use statements updating a great number of rows, you

can increase this to get more performance

--blackhole[=name]  Enable or disable BLACKHOLE plugin. Possible values are

ON, OFF, FORCE (don't start if the plugin fails to load).

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

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

-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

Defines what password- and authentication algorithm to

use per default

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

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

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

Prevents execution of statements that would be impossible

to log in a transactionally safe manner. Currently, the

disallowed statements include CREATE TEMPORARY TABLE

inside transactions, all updates to non-transactional

tables, and CREATE TABLE ... SELECT.

--eq-range-index-dive-limit=#

The optimizer will use existing index statistics instead

of doing index dives for equality ranges if the number of

equality ranges for the index is larger than or equal to

this number. If set to 0, index dives are always used.

--event-scheduler[=name]

Enable the event scheduler. Possible values are ON, OFF,

and DISABLED (keep the event scheduler completely

deactivated, it cannot be activated run-time)

-T, --exit-info[=#] Used for debugging. Use at your own risk.

--expire-logs-days=#

If non-zero, binary logs will be purged after

expire_logs_days days; 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.

--external-locking  Use system (external) locking (disabled by default).

With this option enabled you can run myisamchk to test

(not repair) tables while the MySQL server is running.

Disable with --skip-external-locking.

--federated[=name]  Enable or disable FEDERATED plugin. Possible values 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-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 logging to a file hostname.log or a table

mysql.general_logif --log-output=TABLE is used

--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-mode=name    Whether Global Transaction Identifiers (GTIDs) are

enabled. Can be ON or OFF.

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

--innodb[=name]     Enable or disable InnoDB plugin. Possible values are ON,

OFF, FORCE (don't start if the plugin fails to load).

--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-max-sleep-delay=#

The upper limit of the sleep delay in usec. Value of 0

disables it.

--innodb-additional-mem-pool-size=#

DEPRECATED. This option may be removed in future

releases, together with the option innodb_use_sys_malloc

and with the InnoDB's internal memory allocator. Size of

a memory pool InnoDB uses to store data dictionary

information and other internal data structures.

--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-buffer-page[=name]

Enable or disable INNODB_BUFFER_PAGE plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-buffer-page-lru[=name]

Enable or disable INNODB_BUFFER_PAGE_LRU plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-buffer-pool-dump-at-shutdown

Dump the buffer pool into a file named

@@innodb_buffer_pool_filename

--innodb-buffer-pool-dump-now

Trigger an immediate dump of the buffer pool into a file

named @@innodb_buffer_pool_filename

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

--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-buffer-pool-stats[=name]

Enable or disable INNODB_BUFFER_POOL_STATS plugin.

Possible values are ON, OFF, FORCE (don't start if the

plugin fails to load).

--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-cmp[=name] Enable or disable INNODB_CMP plugin. Possible values are

ON, OFF, FORCE (don't start if the plugin fails to load).

--innodb-cmp-per-index[=name]

Enable or disable INNODB_CMP_PER_INDEX plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-cmp-per-index-enabled

Enable INFORMATION_SCHEMA.innodb_cmp_per_index, may have

negative impact on performance (off by default)

--innodb-cmp-per-index-reset[=name]

Enable or disable INNODB_CMP_PER_INDEX_RESET plugin.

Possible values are ON, OFF, FORCE (don't start if the

plugin fails to load).

--innodb-cmp-reset[=name]

Enable or disable INNODB_CMP_RESET plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-cmpmem[=name]

Enable or disable INNODB_CMPMEM plugin. Possible values

are ON, OFF, FORCE (don't start if the plugin fails to

load).

--innodb-cmpmem-reset[=name]

Enable or disable INNODB_CMPMEM_RESET plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--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-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-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-io-threads=#

Number of file I/O threads in InnoDB.

--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-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-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 p_w_picpath of the

database becomes corrupt.

--innodb-ft-aux-table

FTS internal auxiliary table to be checked

--innodb-ft-being-deleted[=name]

Enable or disable INNODB_FT_BEING_DELETED plugin.

Possible values are ON, OFF, FORCE (don't start if the

plugin fails to load).

--innodb-ft-cache-size=#

InnoDB Fulltext search cache size in bytes

--innodb-ft-config[=name]

Enable or disable INNODB_FT_CONFIG plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-ft-default-stopword[=name]

Enable or disable INNODB_FT_DEFAULT_STOPWORD plugin.

Possible values are ON, OFF, FORCE (don't start if the

plugin fails to load).

--innodb-ft-deleted[=name]

Enable or disable INNODB_FT_DELETED plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--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-index-cache[=name]

Enable or disable INNODB_FT_INDEX_CACHE plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-ft-index-table[=name]

Enable or disable INNODB_FT_INDEX_TABLE plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--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-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-user-stopword-table[=name]

User supplied stopword table name, effective in the

session level.

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

Support large index prefix length of

REC_VERSION_56_MAX_INDEX_COL_LEN (3072) bytes.

--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-lock-waits[=name]

Enable or disable INNODB_LOCK_WAITS plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-locks[=name]

Enable or disable INNODB_LOCKS plugin. Possible values

are ON, OFF, FORCE (don't start if the plugin fails to

load).

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

Enables/disables the logging of entire compressed page

p_w_picpaths. 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-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-metrics[=name]

Enable or disable INNODB_METRICS plugin. Possible values

are ON, OFF, FORCE (don't start if the plugin fails to

load).

--innodb-mirrored-log-groups=#

Number of identical copies of log groups we keep for the

database. Currently this should be set to 1.

--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-size[=#]

Page size to use for all InnoDB tablespaces.

--innodb-print-all-deadlocks

Print all deadlocks 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-threads[=#]

Purge threads can be from 1 to 32. Default is 1.

--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-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 undo logs to use (deprecated).

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

--innodb-strict-mode

Use strict mode when evaluating create options.

--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-columns[=name]

Enable or disable INNODB_SYS_COLUMNS plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-sys-datafiles[=name]

Enable or disable INNODB_SYS_DATAFILES plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-sys-fields[=name]

Enable or disable INNODB_SYS_FIELDS plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-sys-foreign[=name]

Enable or disable INNODB_SYS_FOREIGN plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-sys-foreign-cols[=name]

Enable or disable INNODB_SYS_FOREIGN_COLS plugin.

Possible values are ON, OFF, FORCE (don't start if the

plugin fails to load).

--innodb-sys-indexes[=name]

Enable or disable INNODB_SYS_INDEXES plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-sys-tables[=name]

Enable or disable INNODB_SYS_TABLES plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-sys-tablespaces[=name]

Enable or disable INNODB_SYS_TABLESPACES plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-sys-tablestats[=name]

Enable or disable INNODB_SYS_TABLESTATS plugin. Possible

values are ON, OFF, FORCE (don't start if the plugin

fails to load).

--innodb-table-locks

Enable InnoDB locking in LOCK TABLES

(Defaults to on; use --skip-innodb-table-locks to disable.)

--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-trx[=name] Enable or disable INNODB_TRX plugin. Possible values are

ON, OFF, FORCE (don't start if the plugin fails to load).

--innodb-undo-directory=name

Directory where undo tablespace files live, this path can

be absolute.

--innodb-undo-logs[=#]

Number of undo logs to use.

--innodb-undo-tablespaces=#

Number of undo tablespaces to use.

--innodb-use-native-aio

Use native AIO if supported on this platform.

(Defaults to on; use --skip-innodb-use-native-aio to disable.)

--innodb-use-sys-malloc

DEPRECATED. This option may be removed in future

releases, together with the InnoDB's internal memory

allocator. Use OS memory allocator instead of InnoDB's

internal memory allocator

(Defaults to on; use --skip-innodb-use-sys-malloc 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

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

-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-error[=name]  Error log file

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

Log slow statements executed by slave thread to the slow

log if it is open.

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