--- mysqld--help.result 2016-11-04 13:35:06.665881700 +0000 +++ mysqld--help,win.reject 2016-11-04 13:58:39.030512500 +0000 @@ -318,7 +318,6 @@ The number of segments in a 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. -L, --lc-messages-dir=name Directory where error messages are @@ -521,6 +520,7 @@ Use MySQL-5.6 (instead of MariaDB-5.3) format for TIME, DATETIME, TIMESTAMP columns. (Defaults to on; use --skip-mysql56-temporal-format to disable.) + --named-pipe Enable the named pipe (NT) --net-buffer-length=# Buffer length for TCP/IP and socket communication --net-read-timeout=# @@ -931,6 +931,9 @@ characteristics (isolation level, read only/read write,snapshot - but not any work done / data modified within the transaction). + --shared-memory Enable the shared memory + --shared-memory-base-name=name + Base name of shared memory --show-slave-auth-info Show user and password in SHOW SLAVE HOSTS on this master. @@ -1043,6 +1046,10 @@ 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 @@ -1061,6 +1068,7 @@ NO_ENGINE_SUBSTITUTION, PAD_CHAR_TO_FULL_LENGTH --stack-trace Print a symbolic stack trace on failure (Defaults to on; use --skip-stack-trace to disable.) + --standalone Dummy option to start as a standalone program (NT). --standard-compliant-cte Allow only standards compiant CTE (Defaults to on; use --skip-standards-compliant-cte to disable.) @@ -1109,6 +1117,11 @@ --thread-pool-max-threads=# Maximum allowed number of worker threads in the thread pool + --thread-pool-min-threads=# + Minimum number of threads in the thread pool. + --thread-pool-mode=name + Chose implementation of the threadpool. One of: windows, + generic --thread-pool-oversubscribe=# How many additional active worker threads in a group are allowed. @@ -1139,8 +1152,8 @@ size, MySQL will automatically convert it to an on-disk MyISAM or Aria table -t, --tmpdir=name Path for temporary files. Several paths may be specified, - separated by a colon (:), in this case they are used in a - round-robin fashion + 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 @@ -1264,7 +1277,6 @@ key-cache-division-limit 100 key-cache-file-hash-size 512 key-cache-segments 0 -large-pages FALSE lc-messages en_US lc-messages-dir MYSQL_SHAREDIR/ lc-time-names en_US @@ -1333,6 +1345,7 @@ myisam-stats-method NULLS_UNEQUAL myisam-use-mmap FALSE mysql56-temporal-format TRUE +named-pipe FALSE net-buffer-length 16384 net-read-timeout 30 net-retry-count 10 @@ -1434,6 +1447,8 @@ session-track-state-change FALSE session-track-system-variables session-track-transaction-info OFF +shared-memory FALSE +shared-memory-base-name MYSQL show-slave-auth-info FALSE silent-startup FALSE skip-grant-tables TRUE @@ -1458,6 +1473,7 @@ slave-type-conversions slow-launch-time 2 slow-query-log FALSE +slow-start-timeout 15000 sort-buffer-size 2097152 sql-mode NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION stack-trace TRUE @@ -1471,14 +1487,16 @@ sync-relay-log 10000 sync-relay-log-info 10000 sysdate-is-now FALSE -table-cache 431 +table-cache 2000 table-definition-cache 400 -table-open-cache 431 +table-open-cache 2000 table-open-cache-instances 8 tc-heuristic-recover OFF thread-cache-size 151 thread-pool-idle-timeout 60 thread-pool-max-threads 65536 +thread-pool-min-threads 1 +thread-pool-mode windows thread-pool-oversubscribe 3 thread-pool-prio-kickup-timer 1000 thread-pool-priority auto