安装mysql服务

安装mysql服务自动启动

mysqld.exe --install MySQL5.6

安装mysql服务手动启动

mysqld.exe --install-manual

启动服务：net start MySQL5.6

删除MySQL服务：

mysqld.exe --remove

使用帮助:

mysqld.exe --verbose --help

mysqld.exe Ver 5.6.24 for Win32 on x86 (MySQL Community Server (GPL))

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.exe [OPTIONS]

NT and Win32 specific options:

--install Install the default service (NT).

--install-manual Install the default service started manually (NT).

--install service_name Install an optional service (NT).

--install-manual service_name Install an optional service started manually (NT).

--remove Remove the default service from the service list (NT).

--remove service_name Remove the service_name from the service list (NT).

--enable-named-pipe Only to be used for the default server (NT).

--standalone Dummy option to start as a standalone server (NT).

Default options are read from the following files in the given order:

C:\WINDOWS\my.ini C:\WINDOWS\my.cnf C:\my.ini C:\my.cnf C:\Program Files\MySQL\MySQL Server 5.6\my.ini C:\Program Files\MySQL\MySQL Server 5.6\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.)

--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-gtid-simple-recovery

If this option is enabled, the server does not scan more

than one binary log for every iteration when initializing

GTID sets on server restart. Enabling this option is very

useful when restarting a server which has already

generated lots of binary logs without GTID events. Note:

If this option is enabled, GLOBAL.GTID_EXECUTED and

GLOBAL.GTID_PURGED cannot be initialized correctly if

binary log(s) with GTID events were generated before

binary log(s) without GTID events, for example if

gtid_mode is disabled when the server has already

generated binary log(s) with GTID events and not purged

them.

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

--binlogging-impossible-mode=name

On a fatal error when statements cannot be binlogged the

behaviour can be ignore the error and let the master

continue or abort the server. This variable is deprecated

and will be removed in a future release. Please use

binlog_error_action instead.

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

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

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

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

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

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

Size of unused metadata locks cache

--metadata-locks-hash-instances=#

Number of metadata locks hash instances

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

--named-pipe Enable the named pipe (NT)

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

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

block_nested_loop, batched_key_access,

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

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

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

--performance-schema-consumer-events-statements-history-long

Default startup value for the

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

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

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

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

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

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

--performance-schema-max-stage-classes=#

Maximum number of stage instruments.

--performance-schema-max-statement-classes=#

Maximum number of statement instruments.

--performance-schema-max-table-handles=#

Maximum number of opened instrumented tables. Use 0 to

disable, -1 for automated sizing.

--performance-schema-max-table-instances=#

Maximum number of instrumented tables. Use 0 to disable,

-1 for automated sizing.

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

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

--performance-schema-setup-objects-size=#

Maximum number of rows in SETUP_OBJECTS.

--performance-schema-users-size=#

Maximum number of instrumented users. Use 0 to disable,

-1 for automated sizing.

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

--query-alloc-block-size=#

Allocation block size for query parsing and execution

--query-cache-limit=#

Don't cache results that are bigger than this

--query-cache-min-res-unit=#

The minimum size for blocks allocated by the query cache

--query-cache-size=#

The memory allocated to store results from old queries

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

--query-cache-wlock-invalidate

Invalidate queries in query cache on LOCK for write

--query-prealloc-size=#

Persistent buffer for query parsing and execution

--range-alloc-block-size=#

Allocation block size for storing ranges during

optimization

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

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

(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

--shared-memory Enable the shared memory

--shared-memory-base-name=name

Base name of shared memory

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

--simplified-binlog-gtid-recovery

Alias for @@binlog_gtid_simple_recovery. Deprecated

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

specifed, ALL_SIGNED will take high 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-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-start-timeout=#

Maximum number of milliseconds that the service control

manager should wait before trying to kill the windows

service during startup(Default: 15000).

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

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

--standalone Dummy option to start as a standalone program (NT).

--stored-program-cache=#

The soft upper limit for number of cached stored routines

for one connection.

-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 (default) 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 COMMIT or ROLLBACK.

--temp-pool This option is ignored on this OS.

(Defaults to on; use --skip-temp-pool to disable.)

--thread-cache-size=#

How many threads we should keep in a cache for reuse

--thread-concurrency=#

Permits the application to give the threads system a hint

for the desired number of threads that should be run at

the same time. This variable has no effect, and is

deprecated. It will be removed in a future release.

--thread-handling=name

Define threads usage for handling queries, one of

one-thread-per-connection, no-threads, loaded-dynamically

--thread-stack=# The stack size for each thread

--time-format=name The TIME format (ignored)

--timed-mutexes Specify whether to time mutexes. Deprecated, has no

effect.

--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 semicolon (;), 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.

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

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

auto-increment-offset 1

autocommit TRUE

automatic-sp-privileges TRUE

avoid-temporal-upgrade FALSE

back-log 80

basedir C:\Program Files\MySQL\MySQL Server 5.6\

big-tables FALSE

bind-address *

binlog-cache-size 32768

binlog-checksum CRC32

binlog-direct-non-transactional-updates FALSE

binlog-error-action IGNORE_ERROR

binlog-format STATEMENT

binlog-gtid-simple-recovery FALSE

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-stmt-cache-size 32768

binlogging-impossible-mode IGNORE_ERROR

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 C:\Program Files\MySQL\MySQL Server 5.6\share\charsets\

chroot (No default value)

collation-server latin1_swedish_ci

completion-type NO_CHAIN

concurrent-insert AUTO

connect-timeout 10

console FALSE

datadir C:\Program Files\MySQL\MySQL Server 5.6\data\

date-format %Y-%m-%d

datetime-format %Y-%m-%d %H:%i:%s

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)

disconnect-on-expired-password TRUE

disconnect-slave-event-count 0

div-precision-increment 4

end-markers-in-json FALSE

enforce-gtid-consistency FALSE

eq-range-index-dive-limit 10

event-scheduler OFF

expire-logs-days 0

explicit-defaults-for-timestamp FALSE

external-locking FALSE

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-stopword-file (No default value)

gdb FALSE

general-log FALSE

general-log-file C:\Program Files\MySQL\MySQL Server 5.6\data\NW20150615155.log

group-concat-max-len 1024

gtid-mode OFF

help TRUE

host-cache-size 279

ignore-builtin-innodb FALSE

init-connect

init-file (No default value)

init-slave

innodb ON

innodb-adaptive-flushing TRUE

innodb-adaptive-flushing-lwm 10

innodb-adaptive-hash-index TRUE

innodb-adaptive-max-sleep-delay 150000

innodb-additional-mem-pool-size 8388608

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-buffer-page ON

innodb-buffer-page-lru ON

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

innodb-buffer-pool-dump-now FALSE

innodb-buffer-pool-filename ib_buffer_pool

innodb-buffer-pool-instances 0

innodb-buffer-pool-load-abort FALSE

innodb-buffer-pool-load-at-startup FALSE

innodb-buffer-pool-load-now FALSE

innodb-buffer-pool-size 134217728

innodb-buffer-pool-stats ON

innodb-change-buffer-max-size 25

innodb-change-buffering all

innodb-checksum-algorithm innodb

innodb-checksums TRUE

innodb-cmp ON

innodb-cmp-per-index ON

innodb-cmp-per-index-enabled FALSE

innodb-cmp-per-index-reset ON

innodb-cmp-reset ON

innodb-cmpmem ON

innodb-cmpmem-reset ON

innodb-commit-concurrency 0

innodb-compression-failure-threshold-pct 5

innodb-compression-level 6

innodb-compression-pad-pct-max 50

innodb-concurrency-tickets 5000

innodb-data-file-path (No default value)

innodb-data-home-dir (No default value)

innodb-disable-sort-file-cache FALSE

innodb-doublewrite TRUE

innodb-fast-shutdown 1

innodb-file-format Antelope

innodb-file-format-check TRUE

innodb-file-format-max Antelope

innodb-file-io-threads 4

innodb-file-per-table TRUE

innodb-flush-log-at-timeout 1

innodb-flush-log-at-trx-commit 1

innodb-flush-method (No default value)

innodb-flush-neighbors 1

innodb-flushing-avg-loops 30

innodb-force-load-corrupted FALSE

innodb-force-recovery 0

innodb-ft-aux-table (No default value)

innodb-ft-being-deleted ON

innodb-ft-cache-size 8000000

innodb-ft-config ON

innodb-ft-default-stopword ON

innodb-ft-deleted ON

innodb-ft-enable-diag-print FALSE

innodb-ft-enable-stopword TRUE

innodb-ft-index-cache ON

innodb-ft-index-table ON

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-io-capacity 200

innodb-io-capacity-max 4294967295

innodb-large-prefix FALSE

innodb-lock-wait-timeout 50

innodb-lock-waits ON

innodb-locks ON

innodb-locks-unsafe-for-binlog FALSE

innodb-log-buffer-size 8388608

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-lru-scan-depth 1024

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

innodb-mirrored-log-groups 0

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

innodb-print-all-deadlocks FALSE

innodb-purge-batch-size 300

innodb-purge-threads 1

innodb-random-read-ahead FALSE

innodb-read-ahead-threshold 56

innodb-read-io-threads 4

innodb-read-only FALSE

innodb-replication-delay 0

innodb-rollback-on-timeout FALSE

innodb-rollback-segments 128

innodb-sort-buffer-size 1048576

innodb-spin-wait-delay 6

innodb-stats-auto-recalc TRUE

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 FALSE

innodb-support-xa TRUE

innodb-sync-array-size 1

innodb-sync-spin-loops 30

innodb-sys-columns ON

innodb-sys-datafiles ON

innodb-sys-fields ON

innodb-sys-foreign ON

innodb-sys-foreign-cols ON

innodb-sys-indexes ON

innodb-sys-tables ON

innodb-sys-tablespaces ON

innodb-sys-tablestats ON

innodb-table-locks TRUE

innodb-thread-concurrency 0

innodb-thread-sleep-delay 10000

innodb-trx ON

innodb-undo-directory .

innodb-undo-logs 128

innodb-undo-tablespaces 0

innodb-use-native-aio TRUE

innodb-use-sys-malloc TRUE

innodb-write-io-threads 4

interactive-timeout 28800

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

language C:\Program Files\MySQL\MySQL Server 5.6\share\

lc-messages en_US

lc-messages-dir C:\Program Files\MySQL\MySQL Server 5.6\share\

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

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

log-tc tc.log

log-tc-size 24576

log-throttle-queries-not-using-indexes 0

log-warnings 1

long-query-time 10

low-priority-updates FALSE

lower-case-table-names 1

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-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-heap-table-size 16777216

max-join-size 18446744073709551615

max-length-for-sort-data 1024

max-prepared-stmt-count 16382

max-relay-log-size 0

max-seeks-for-key 4294967295

max-sort-length 1024

max-sp-recursion-depth 0

max-tmp-tables 32

max-user-connections 0

max-write-lock-count 4294967295

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 2146435072

myisam-mmap-size 4294967295

myisam-recover-options OFF

myisam-repair-threads 1

myisam-sort-buffer-size 8388608

myisam-stats-method nulls_unequal

myisam-use-mmap FALSE

named-pipe FALSE

net-buffer-length 16384

net-read-timeout 30

net-retry-count 10

net-write-timeout 60

new FALSE

old FALSE

old-alter-table FALSE

old-passwords 0

old-style-user-limits FALSE

open-files-limit 7048

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,subquery_materialization_cost_based=on,use_index_extensions=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

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 FALSE

performance-schema-consumer-events-statements-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-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-file-classes 50

performance-schema-max-file-handles 32768

performance-schema-max-file-instances -1

performance-schema-max-mutex-classes 200

performance-schema-max-mutex-instances -1

performance-schema-max-rwlock-classes 40

performance-schema-max-rwlock-instances -1

performance-schema-max-socket-classes 10

performance-schema-max-socket-instances -1

performance-schema-max-stage-classes 150

performance-schema-max-statement-classes 168

performance-schema-max-table-handles -1

performance-schema-max-table-instances -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 100

performance-schema-setup-objects-size 100

performance-schema-users-size -1

pid-file C:\Program Files\MySQL\MySQL Server 5.6\data\NW20150615155.pid

plugin-dir C:\Program Files\MySQL\MySQL Server 5.6\lib\plugin\

port 3306

port-open-timeout 0

preload-buffer-size 32768

profiling-history-size 15

query-alloc-block-size 8192

query-cache-limit 1048576

query-cache-min-res-unit 4096

query-cache-size 1048576

query-cache-type OFF

query-cache-wlock-invalidate FALSE

query-prealloc-size 8192

range-alloc-block-size 4096

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)

rpl-stop-slave-timeout 31536000

safe-user-create FALSE

secure-auth TRUE

secure-file-priv (No default value)

server-id 0

server-id-bits 32

shared-memory FALSE

shared-memory-base-name MYSQL

show-old-temporals FALSE

show-slave-auth-info FALSE

simplified-binlog-gtid-recovery FALSE

skip-grant-tables FALSE

skip-name-resolve FALSE

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 C:\DOCUME~1\201506~1\LOCALS~1\Temp

slave-max-allowed-packet 1073741824

slave-net-timeout 3600

slave-parallel-workers 0

slave-pending-jobs-size-max 16777216

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-file C:\Program Files\MySQL\MySQL Server 5.6\data\NW20150615155-slow.log

slow-start-timeout 15000

socket MySQL

sort-buffer-size 262144

sporadic-binlog-dump-fail FALSE

sql-mode NO_ENGINE_SUBSTITUTION

ssl FALSE

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

symbolic-links TRUE

sync-binlog 0

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 1

tc-heuristic-recover COMMIT

temp-pool FALSE

thread-cache-size 9

thread-concurrency 10

thread-handling one-thread-per-connection

thread-stack 196608

time-format %H:%i:%s

timed-mutexes FALSE

tmp-table-size 16777216

tmpdir C:\DOCUME~1\201506~1\LOCALS~1\Temp

transaction-alloc-block-size 8192

transaction-isolation REPEATABLE-READ

transaction-prealloc-size 4096

transaction-read-only FALSE

updatable-views-with-limit YES

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

posted on 2015-07-22 09:04 天下阅读(517) 评论(0) 编辑收藏引用所属分类: MySQL

只有注册用户登录后才能发表评论。
【推荐】100%开源！大型工业跨平台软件C++源码提供，建模，组态！

相关文章: Python和MySQL时间处理存储过程（2）存储过程（1） MySQL 触发器安装mysql服务

网站导航: 博客园 IT新闻 BlogJava 博问 Chat2DB 管理

天下

安装mysql服务

导航

统计

常用链接

留言簿(4)

随笔分类(378)

随笔档案(329)

链接

最新随笔

搜索

最新评论