From e293bdb2c19cacad91d4f5a846568ac595b3a48e Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Thu, 23 Feb 2012 09:24:11 +0100 Subject: instead of having win/notwin tests that only differ in results, use one test with two combinations (win/unix), where only one is enabled. Apply this technique to mysqld--help. --- mysql-test/include/mysqld--help.inc | 58 -- mysql-test/include/platform.combinations | 4 + mysql-test/include/platform.inc | 4 + mysql-test/r/mysqld--help,win.rdiff | 91 +++ mysql-test/r/mysqld--help-notwin.result | 1078 ------------------------ mysql-test/r/mysqld--help-win.result | 1089 ------------------------- mysql-test/r/mysqld--help-win.result.THIS | 1089 +++++++++++++++++++++++++ mysql-test/r/mysqld--help.result | 1078 ++++++++++++++++++++++++ mysql-test/suite.pm | 4 + mysql-test/suite/funcs_1/t/is_columns_is.test | 1 - mysql-test/t/mysqld--help-notwin.test | 9 - mysql-test/t/mysqld--help-win.test | 9 - mysql-test/t/mysqld--help.test | 60 ++ 13 files changed, 2330 insertions(+), 2244 deletions(-) delete mode 100644 mysql-test/include/mysqld--help.inc create mode 100644 mysql-test/include/platform.combinations create mode 100644 mysql-test/include/platform.inc create mode 100644 mysql-test/r/mysqld--help,win.rdiff delete mode 100644 mysql-test/r/mysqld--help-notwin.result delete mode 100644 mysql-test/r/mysqld--help-win.result create mode 100644 mysql-test/r/mysqld--help-win.result.THIS create mode 100644 mysql-test/r/mysqld--help.result delete mode 100644 mysql-test/t/mysqld--help-notwin.test delete mode 100644 mysql-test/t/mysqld--help-win.test create mode 100644 mysql-test/t/mysqld--help.test diff --git a/mysql-test/include/mysqld--help.inc b/mysql-test/include/mysqld--help.inc deleted file mode 100644 index 85f420f3c7b..00000000000 --- a/mysql-test/include/mysqld--help.inc +++ /dev/null @@ -1,58 +0,0 @@ -# -# mysqld --help -# ---source include/not_embedded.inc - -# -# force lower-case-table-names=1 (linux/macosx have different defaults) -# force symbolic-links=0 (valgrind build has a different default) -# - -exec $MYSQLD_BOOTSTRAP_CMD --symbolic-links=0 --lower-case-table-names=1 --help --verbose > $MYSQL_TMP_DIR/mysqld--help.txt 2>&1; - -# The inline perl code below will copy $MYSQL_TMP_DIR/mysqld--help.txt -# to output, but filter away some variable stuff (e.g. paths). - -perl; - # Variables which we don't want to display in the result file since - # their paths may vary: - @skipvars=qw/basedir open-files-limit general-log-file log plugin-dir - log-slow-queries pid-file slow-query-log-file log-basename - datadir slave-load-tmpdir tmpdir socket/; - - # Plugins which may or may not be there: - @plugins=qw/innodb ndb archive blackhole federated partition ndbcluster feedback debug temp-pool ssl des-key-file - xtradb thread-concurrency super-large-pages mutex-deadlock-detector null-audit maria aria pbxt oqgraph sphinx thread-handling thread-pool/; - - # And substitute the content some environment variables with their - # names: - @env=qw/MYSQLTEST_VARDIR MYSQL_TEST_DIR MYSQL_CHARSETSDIR MYSQL_SHAREDIR/; - - $re1=join('|', @skipvars, @plugins); - $re2=join('|', @plugins); - $skip=0; - open(F, '<', "$ENV{MYSQL_TMP_DIR}/mysqld--help.txt") or die; - while () { - next if 1../The following groups are read/; - # formatting, skip line consisting entirely of dashes and blanks - next if /^[\- ]+\s?$/; - next if /Value \(after reading options\)/; # skip table header - next if /^($re1) /; - next if /^($re2)-/; - $skip=0 if /^ -/ or /^$/; - $skip=1 if / --($re2)\b/; - y!\\!/!; - s/[ ]+/ /; # squeeze spaces to remove table formatting - # fixes for 32-bit - s/\b4294967295\b/18446744073709551615/; - s/\b2146435072\b/9223372036853727232/; - s/\b196608\b/262144/; - s/\b4294963200\b/18446744073709547520/; - foreach $var (@env) { s/$ENV{$var}/$var/ } - next if /use --skip-(use-)?symbolic-links to disable/; # for valgrind, again - next if $skip; - print; - } - close F; -EOF - diff --git a/mysql-test/include/platform.combinations b/mysql-test/include/platform.combinations new file mode 100644 index 00000000000..4681ac05314 --- /dev/null +++ b/mysql-test/include/platform.combinations @@ -0,0 +1,4 @@ +[win] + +[unix] + diff --git a/mysql-test/include/platform.inc b/mysql-test/include/platform.inc new file mode 100644 index 00000000000..1821021df6f --- /dev/null +++ b/mysql-test/include/platform.inc @@ -0,0 +1,4 @@ +# +# tests that include this file will be run for an appropriate combination. +# See platform.combinations for the list of combinations. +# diff --git a/mysql-test/r/mysqld--help,win.rdiff b/mysql-test/r/mysqld--help,win.rdiff new file mode 100644 index 00000000000..676393720a7 --- /dev/null +++ b/mysql-test/r/mysqld--help,win.rdiff @@ -0,0 +1,91 @@ +--- r/mysqld--help.result 2012-01-13 16:50:49.000000000 +0100 ++++ r/mysqld--help-win.result 2012-01-19 14:12:00.000000000 +0100 +@@ -240,7 +240,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 +@@ -436,6 +435,7 @@ + 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=# +@@ -695,6 +695,9 @@ + files within specified directory + --server-id=# Uniquely identifies the server instance in the community + of replication partners ++ --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. +@@ -759,6 +762,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 +@@ -767,6 +774,7 @@ + for the complete list of valid sql modes + --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). + -s, --symbolic-links + Enable symbolic link support. + --sync-binlog=# Synchronously flush binary log to disk after every #th +@@ -807,8 +815,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 +@@ -908,7 +916,6 @@ + key-cache-division-limit 100 + key-cache-segments 0 + language MYSQL_SHAREDIR/ +-large-pages FALSE + lc-messages en_US + lc-messages-dir MYSQL_SHAREDIR/ + lc-time-names en_US +@@ -971,6 +978,7 @@ + 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 +@@ -1035,6 +1043,8 @@ + secure-auth FALSE + secure-file-priv (No default value) + server-id 0 ++shared-memory FALSE ++shared-memory-base-name MYSQL + show-slave-auth-info FALSE + skip-grant-tables TRUE + skip-name-resolve FALSE +@@ -1050,6 +1060,7 @@ + slave-type-conversions + slow-launch-time 2 + slow-query-log FALSE ++slow-start-timeout 15000 + sort-buffer-size 2097152 + sql-mode + stack-trace TRUE diff --git a/mysql-test/r/mysqld--help-notwin.result b/mysql-test/r/mysqld--help-notwin.result deleted file mode 100644 index 94d7465d39b..00000000000 --- a/mysql-test/r/mysqld--help-notwin.result +++ /dev/null @@ -1,1078 +0,0 @@ -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. ---defaults-file=# Only read default options from the given file #. ---defaults-extra-file=# Read this file after the global files are read. - - --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'. - --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-annotate-row-events - Tells the master to annotate RBR events with the - statement that caused these events - --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 NONE. - --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-optimize-thread-scheduling - Run fast part of group commit in a single thread, to - optimize kernel thread scheduling. On by default. Disable - to run each transaction in group commit in its own - thread, which can be slower at very high concurrency. - This option is mostly for testing one algorithm versus - the other, and it should not normally be necessary to - change it. - (Defaults to on; use --skip-binlog-optimize-thread-scheduling 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-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 - --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) - --deadlock-search-depth-long=# - Long search depth for the two-step deadlock detection - --deadlock-search-depth-short=# - Short search depth for the two-step deadlock detection - --deadlock-timeout-long=# - Long timeout for the two-step deadlock detection (in - microseconds) - --deadlock-timeout-short=# - Short timeout for the two-step deadlock detection (in - microseconds) - --default-storage-engine=name - The default storage engine for new tables - --default-time-zone=name - Set the default time zone. - --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 - --delayed-insert-timeout=# - How long a INSERT DELAYED thread should wait for INSERT - statements before terminating - --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 - --div-precision-increment=# - Precision of the result of '/' operator will be increased - on that value - --engine-condition-pushdown - Push supported query conditions to the storage engine. - Deprecated, use --optimizer-switch instead. - (Defaults to on; use --skip-engine-condition-pushdown to disable.) - --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) - --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 - --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. - --extra-max-connections=# - The number of connections on extra-port - --extra-port=# Extra port number to use for tcp connections in a - one-thread-per-connection manner. 0 means don't use - another port - --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. Deprecated, use - --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() - -?, --help Display this help and exit. - --ignore-builtin-innodb - Disable initialization of builtin InnoDB plugin - --init-connect=name Command(s) that are executed for each new connection - (unless the user has SUPER privilege) - --init-file=name Read SQL commands from this file at startup - --init-rpl-role=name - Set the replication role. - --init-slave=name Command(s) that are executed by a slave server each time - the SQL thread starts - --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 joins - --join-buffer-space-limit=# - The limit of the space for all join buffers used by a - query - --join-cache-level=# - Controls what join operations can be executed with join - buffers. Odd numbers are used for plain join buffers - while even numbers are used for linked buffers - --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 - --key-cache-segments=# - 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 - --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. - -l, --log[=name] Log connections and queries to file (deprecated option, - use --general-log/--general-log-file instead). - --log-basename=name Basename for all log files and the .pid file. This sets - all log file names at once (in 'datadir') and is normally - the only option you need for specifying log files. Sets - names for --log-bin, --log-bin-index, --relay-log, - --relay-log-index, --general-log-file, - --log-slow-query-log-file, --log-error-file, and - --pid-file - --log-bin[=name] Log update queries in binary format. Optional argument - should be name for binary log. If not given - 'datadir'/'log-basename'-bin or 'datadir'/mysql-bin will - be used (the later if --log-basename is not specified). - We strongly recommend to use either --log-basename or - specify a filename to ensure that replication doesn't - stop if the real hostname of the computer changes. - --log-bin-index=name - File that holds the names for last 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-error[=name] Log errors to file (instead of stdout). If file name is - not specified then 'datadir'/'log-basename'.err or the - 'pid-file' path with extension .err is used - --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-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-filter=name - Log only certain types of queries. Multiple flags can be - specified, separated by commas. Valid values are admin, - slave, filesort, filesort_on_disk, full_join, full_scan, - query_cache, query_cache_miss, tmp_table, - tmp_table_on_disk - --log-slow-queries[=name] - Enable logging of slow queries (longer than - --long-query-time) to log file or table. Optional - argument is a file name for the slow log. If not given, - 'log-basename'-slow.log will be used. Use - --log-output=TABLE if you want to have the log in the - table mysql.slow_log. Deprecated option, use - --slow-query-log/--slow-query-log-file instead. - --log-slow-rate-limit=# - Write to slow log every #th slow query. Set to 1 to log - everything. Increase it to reduce the size of the slow or - the performance impact of slow logging - --log-slow-slave-statements - Log slow statements executed by slave thread to the slow - log if it is open. - --log-slow-verbosity=name - log-slow-verbosity=[value[,value ...]] where value is one - of 'innodb', 'query_plan' - --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. - -W, --log-warnings[=#] - Log some not critical warnings to the general log - file.Value can be between 0 and 11. Higher values mean - more verbosity - --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. Defaults to master.info - --master-retry-count=# - The number of tries the slave will make to connect to the - master before giving up. - --master-verify-checksum - Force checksum verification of logged events in the - binary log before sending them to slaves or printing them - in the output of SHOW BINLOG EVENTS - --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-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 - --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-long-data-size=# - The maximum BLOB length to send to server from - mysql_send_long_data API. Deprecated option; use - max_allowed_packet instead. - --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 - --min-examined-row-limit=# - Don't write queries to slow log that examine fewer rows - than that - --mrr-buffer-size=# Size of buffer to use when using MRR with range access - --multi-range-count=# - Ignored. Use mrr_buffer_size instead - --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, BACKUP_ALL, 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 - --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 - --old Use compatible behavior - --old-alter-table Use old, non-optimized alter table - --old-passwords Use old password encryption method (needed for 4.0 and - older clients) - --old-style-user-limits - Enable old-style user limits (before 5.0.3, user - resources were counted per each user+host vs. per - account). - --one-thread (Deprecated): Only use one thread (for debugging under - Linux). Use thread-handling=no-threads instead. - --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_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; if set to 63, the - optimizer will switch to the original find_best search. - NOTE: The value 63 and its associated behaviour is - deprecated - --optimizer-switch=name - optimizer_switch=option=val[,option=val...], where option - is one of {derived_merge, derived_with_keys, firstmatch, - in_to_exists, engine_condition_pushdown, - index_condition_pushdown, index_merge, - index_merge_intersection, index_merge_sort_intersection, - index_merge_sort_union, index_merge_union, - join_cache_bka, join_cache_hashed, - join_cache_incremental, loosescan, materialization, mrr, - mrr_cost_based, mrr_sort_keys, optimize_join_buffer_size, - outer_join_with_cache, partial_match_rowid_merge, - partial_match_table_scan, semijoin, semijoin_with_cache, - subquery_cache, table_elimination } and val is one of - {on, off, default} - --performance-schema - Enable the performance schema. - --performance-schema-events-waits-history-long-size=# - Number of rows in EVENTS_WAITS_HISTORY_LONG. - --performance-schema-events-waits-history-size=# - Number of rows per thread in EVENTS_WAITS_HISTORY. - --performance-schema-max-cond-classes=# - Maximum number of condition instruments. - --performance-schema-max-cond-instances=# - Maximum number of instrumented condition objects. - --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. - --performance-schema-max-mutex-classes=# - Maximum number of mutex instruments. - --performance-schema-max-mutex-instances=# - Maximum number of instrumented MUTEX objects. - --performance-schema-max-rwlock-classes=# - Maximum number of rwlock instruments. - --performance-schema-max-rwlock-instances=# - Maximum number of instrumented RWLOCK objects. - --performance-schema-max-table-handles=# - Maximum number of opened instrumented tables. - --performance-schema-max-table-instances=# - Maximum number of instrumented tables. - --performance-schema-max-thread-classes=# - Maximum number of thread instruments. - --performance-schema-max-thread-instances=# - Maximum number of instrumented threads. - --pid-file=name Pid file used by safe_mysqld - --plugin-dir=name Directory for plugins - --plugin-load=name Semicolon-separated list of plugins to load, where each - plugin is specified as ether a plugin_name=library_file - pair or only a library_file. If the latter case, all - plugins from a given library_file will be loaded. - --plugin-maturity=name - The lowest desirable plugin maturity (unknown, - experimental, alpha, beta, gamma, or stable). Plugins - less mature than that will not be installed or loaded. - -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 - --progress-report-time=# - Seconds between sending progress reports to the client - for time-consuming statements. Set to 0 to disable - progress reporting. - --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-strip-comments - Strip all comments from a query before storing it in the - query cache - --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 - The location and name to use for the file that keeps a - list of the last relay logs - --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-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-annotate-row-events - Tells the slave to write annotate rows events recieved - from the master to its own binary log. Ignored if - log_slave_updates is not set - --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 - --rowid-merge-buff-size=# - The size of the buffers used [NOT] IN evaluation via - partial matching - --rpl-recovery-rank=# - Unused, will be removed - --safe-mode Skip some optimize stages (for testing). - --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 - --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 - --show-slave-auth-info - Show user and password in SHOW SLAVE HOSTS on this - master. - --skip-bdb Deprecated option; Exist only for compatiblity with old - my.cnf files - --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-show-database - Don't allow 'SHOW DATABASE' commands - --skip-slave-start If set, slave is not autostarted. - --skip-thread-priority - Don't give threads different priorities. This option is - deprecated because it has no effect; the implied behavior - is already the default. - --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-net-timeout=# - Number of seconds to wait for more data from a - master/slave connection before aborting the read - --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 - (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 and - ALL_NON_LOSSY to enable non-lossy conversions. 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 - --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 - --sql-mode=name Syntax: sql-mode=mode[,mode[,mode...]]. See the manual - for the complete list of valid sql modes - --stack-trace Print a symbolic stack trace on failure - (Defaults to on; use --skip-stack-trace to disable.) - -s, --symbolic-links - Enable symbolic link support. - --sync-binlog=# Synchronously flush binary log to disk after every #th - event. 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 (default) to disable synchronous flushing - --sync-relay-log=# Synchronously flush relay log to disk after every #th - event. Use 0 (default) to disable synchronous flushing - --sync-relay-log-info=# - Synchronously flush relay log info to disk after every - #th transaction. Use 0 (default) 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-cache=# Deprecated; use --table-open-cache instead. - --table-definition-cache=# - The number of cached table definitions - --table-open-cache=# - The number of cached open tables - --tc-heuristic-recover=name - Decision to use in heuristic recover process. Possible - values are COMMIT or ROLLBACK. - --thread-cache-size=# - How many threads we should keep in a cache for reuse - --thread-stack=# The stack size for each thread - --time-format=name The TIME format (ignored) - --timed-mutexes Specify whether to time mutexes (only InnoDB mutexes are - currently supported) - --tmp-table-size=# If an internal in-memory temporary table exceeds this - 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 - --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 - --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. - --userstat Enables statistics gathering for USER_STATISTICS, - CLIENT_STATISTICS, INDEX_STATISTICS and TABLE_STATISTICS - tables in the INFORMATION_SCHEMA - -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) -allow-suspicious-udfs FALSE -auto-increment-increment 1 -auto-increment-offset 1 -autocommit TRUE -automatic-sp-privileges TRUE -back-log 50 -big-tables FALSE -bind-address (No default value) -binlog-annotate-row-events FALSE -binlog-cache-size 32768 -binlog-checksum NONE -binlog-direct-non-transactional-updates FALSE -binlog-format STATEMENT -binlog-optimize-thread-scheduling TRUE -binlog-row-event-max-size 1024 -binlog-stmt-cache-size 32768 -bulk-insert-buffer-size 8388608 -character-set-client-handshake TRUE -character-set-filesystem binary -character-set-server latin1 -character-sets-dir MYSQL_CHARSETSDIR/ -chroot (No default value) -collation-server latin1_swedish_ci -completion-type NO_CHAIN -concurrent-insert AUTO -connect-timeout 10 -console FALSE -date-format %Y-%m-%d -datetime-format %Y-%m-%d %H:%i:%s -deadlock-search-depth-long 15 -deadlock-search-depth-short 4 -deadlock-timeout-long 50000000 -deadlock-timeout-short 10000 -default-storage-engine myisam -default-time-zone (No default value) -default-week-format 0 -delay-key-write ON -delayed-insert-limit 100 -delayed-insert-timeout 300 -delayed-queue-size 1000 -div-precision-increment 4 -engine-condition-pushdown FALSE -event-scheduler OFF -expire-logs-days 0 -external-locking FALSE -extra-max-connections 1 -extra-port 0 -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 -group-concat-max-len 1024 -help TRUE -ignore-builtin-innodb FALSE -init-connect -init-file (No default value) -init-rpl-role MASTER -init-slave -interactive-timeout 28800 -join-buffer-size 131072 -join-buffer-space-limit 2097152 -join-cache-level 2 -keep-files-on-create FALSE -key-buffer-size 134217728 -key-cache-age-threshold 300 -key-cache-block-size 1024 -key-cache-division-limit 100 -key-cache-segments 0 -language MYSQL_SHAREDIR/ -large-pages FALSE -lc-messages en_US -lc-messages-dir MYSQL_SHAREDIR/ -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-error -log-isam myisam.log -log-output FILE -log-queries-not-using-indexes FALSE -log-short-format FALSE -log-slave-updates FALSE -log-slow-admin-statements FALSE -log-slow-filter admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk -log-slow-rate-limit 1 -log-slow-slave-statements FALSE -log-slow-verbosity -log-tc tc.log -log-tc-size 24576 -log-warnings 1 -long-query-time 10 -low-priority-updates FALSE -lower-case-table-names 1 -master-info-file master.info -master-retry-count 86400 -master-verify-checksum FALSE -max-allowed-packet 1048576 -max-binlog-cache-size 18446744073709547520 -max-binlog-size 1073741824 -max-binlog-stmt-cache-size 18446744073709547520 -max-connect-errors 10 -max-connections 151 -max-delayed-threads 20 -max-error-count 64 -max-heap-table-size 16777216 -max-join-size 18446744073709551615 -max-length-for-sort-data 1024 -max-long-data-size 1048576 -max-prepared-stmt-count 16382 -max-relay-log-size 0 -max-seeks-for-key 18446744073709551615 -max-sort-length 1024 -max-sp-recursion-depth 0 -max-tmp-tables 32 -max-user-connections 0 -max-write-lock-count 18446744073709551615 -memlock FALSE -metadata-locks-cache-size 1024 -min-examined-row-limit 0 -mrr-buffer-size 262144 -multi-range-count 256 -myisam-block-size 1024 -myisam-data-pointer-size 6 -myisam-max-sort-file-size 9223372036853727232 -myisam-mmap-size 18446744073709551615 -myisam-recover-options DEFAULT -myisam-repair-threads 1 -myisam-sort-buffer-size 8388608 -myisam-stats-method nulls_unequal -myisam-use-mmap FALSE -net-buffer-length 16384 -net-read-timeout 30 -net-retry-count 10 -net-write-timeout 60 -old FALSE -old-alter-table FALSE -old-passwords FALSE -old-style-user-limits FALSE -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,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on -performance-schema FALSE -performance-schema-events-waits-history-long-size 10000 -performance-schema-events-waits-history-size 10 -performance-schema-max-cond-classes 80 -performance-schema-max-cond-instances 1000 -performance-schema-max-file-classes 50 -performance-schema-max-file-handles 32768 -performance-schema-max-file-instances 10000 -performance-schema-max-mutex-classes 200 -performance-schema-max-mutex-instances 1000000 -performance-schema-max-rwlock-classes 30 -performance-schema-max-rwlock-instances 1000000 -performance-schema-max-table-handles 100000 -performance-schema-max-table-instances 50000 -performance-schema-max-thread-classes 50 -performance-schema-max-thread-instances 1000 -plugin-load (No default value) -plugin-maturity unknown -port 3306 -port-open-timeout 0 -preload-buffer-size 32768 -profiling-history-size 15 -progress-report-time 56 -query-alloc-block-size 8192 -query-cache-limit 1048576 -query-cache-min-res-unit 4096 -query-cache-size 0 -query-cache-strip-comments FALSE -query-cache-type ON -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-purge TRUE -relay-log-recovery FALSE -relay-log-space-limit 0 -replicate-annotate-row-events FALSE -replicate-same-server-id FALSE -report-host (No default value) -report-password (No default value) -report-port 3306 -report-user (No default value) -rowid-merge-buff-size 8388608 -rpl-recovery-rank 0 -safe-user-create FALSE -secure-auth FALSE -secure-file-priv (No default value) -server-id 0 -show-slave-auth-info FALSE -skip-grant-tables TRUE -skip-name-resolve FALSE -skip-networking FALSE -skip-show-database FALSE -skip-slave-start FALSE -slave-compressed-protocol FALSE -slave-exec-mode STRICT -slave-net-timeout 3600 -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 -sort-buffer-size 2097152 -sql-mode -stack-trace TRUE -symbolic-links FALSE -sync-binlog 0 -sync-frm FALSE -sync-master-info 0 -sync-relay-log 0 -sync-relay-log-info 0 -sysdate-is-now FALSE -table-cache 400 -table-definition-cache 400 -table-open-cache 400 -tc-heuristic-recover COMMIT -thread-cache-size 0 -thread-stack 294912 -time-format %H:%i:%s -timed-mutexes FALSE -tmp-table-size 16777216 -transaction-alloc-block-size 8192 -transaction-isolation REPEATABLE-READ -transaction-prealloc-size 4096 -updatable-views-with-limit YES -userstat FALSE -verbose TRUE -wait-timeout 28800 - -To see what values a running MySQL server is using, type -'mysqladmin variables' instead of 'mysqld --verbose --help'. diff --git a/mysql-test/r/mysqld--help-win.result b/mysql-test/r/mysqld--help-win.result deleted file mode 100644 index 05cbcda7129..00000000000 --- a/mysql-test/r/mysqld--help-win.result +++ /dev/null @@ -1,1089 +0,0 @@ -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. ---defaults-file=# Only read default options from the given file #. ---defaults-extra-file=# Read this file after the global files are read. - - --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'. - --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-annotate-row-events - Tells the master to annotate RBR events with the - statement that caused these events - --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 NONE. - --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-optimize-thread-scheduling - Run fast part of group commit in a single thread, to - optimize kernel thread scheduling. On by default. Disable - to run each transaction in group commit in its own - thread, which can be slower at very high concurrency. - This option is mostly for testing one algorithm versus - the other, and it should not normally be necessary to - change it. - (Defaults to on; use --skip-binlog-optimize-thread-scheduling 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-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 - --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) - --deadlock-search-depth-long=# - Long search depth for the two-step deadlock detection - --deadlock-search-depth-short=# - Short search depth for the two-step deadlock detection - --deadlock-timeout-long=# - Long timeout for the two-step deadlock detection (in - microseconds) - --deadlock-timeout-short=# - Short timeout for the two-step deadlock detection (in - microseconds) - --default-storage-engine=name - The default storage engine for new tables - --default-time-zone=name - Set the default time zone. - --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 - --delayed-insert-timeout=# - How long a INSERT DELAYED thread should wait for INSERT - statements before terminating - --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 - --div-precision-increment=# - Precision of the result of '/' operator will be increased - on that value - --engine-condition-pushdown - Push supported query conditions to the storage engine. - Deprecated, use --optimizer-switch instead. - (Defaults to on; use --skip-engine-condition-pushdown to disable.) - --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) - --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 - --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. - --extra-max-connections=# - The number of connections on extra-port - --extra-port=# Extra port number to use for tcp connections in a - one-thread-per-connection manner. 0 means don't use - another port - --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. Deprecated, use - --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() - -?, --help Display this help and exit. - --ignore-builtin-innodb - Disable initialization of builtin InnoDB plugin - --init-connect=name Command(s) that are executed for each new connection - (unless the user has SUPER privilege) - --init-file=name Read SQL commands from this file at startup - --init-rpl-role=name - Set the replication role. - --init-slave=name Command(s) that are executed by a slave server each time - the SQL thread starts - --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 joins - --join-buffer-space-limit=# - The limit of the space for all join buffers used by a - query - --join-cache-level=# - Controls what join operations can be executed with join - buffers. Odd numbers are used for plain join buffers - while even numbers are used for linked buffers - --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 - --key-cache-segments=# - 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. - --lc-messages=name Set the language used for the error messages. - -L, --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. - -l, --log[=name] Log connections and queries to file (deprecated option, - use --general-log/--general-log-file instead). - --log-basename=name Basename for all log files and the .pid file. This sets - all log file names at once (in 'datadir') and is normally - the only option you need for specifying log files. Sets - names for --log-bin, --log-bin-index, --relay-log, - --relay-log-index, --general-log-file, - --log-slow-query-log-file, --log-error-file, and - --pid-file - --log-bin[=name] Log update queries in binary format. Optional argument - should be name for binary log. If not given - 'datadir'/'log-basename'-bin or 'datadir'/mysql-bin will - be used (the later if --log-basename is not specified). - We strongly recommend to use either --log-basename or - specify a filename to ensure that replication doesn't - stop if the real hostname of the computer changes. - --log-bin-index=name - File that holds the names for last 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-error[=name] Log errors to file (instead of stdout). If file name is - not specified then 'datadir'/'log-basename'.err or the - 'pid-file' path with extension .err is used - --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-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-filter=name - Log only certain types of queries. Multiple flags can be - specified, separated by commas. Valid values are admin, - slave, filesort, filesort_on_disk, full_join, full_scan, - query_cache, query_cache_miss, tmp_table, - tmp_table_on_disk - --log-slow-queries[=name] - Enable logging of slow queries (longer than - --long-query-time) to log file or table. Optional - argument is a file name for the slow log. If not given, - 'log-basename'-slow.log will be used. Use - --log-output=TABLE if you want to have the log in the - table mysql.slow_log. Deprecated option, use - --slow-query-log/--slow-query-log-file instead. - --log-slow-rate-limit=# - Write to slow log every #th slow query. Set to 1 to log - everything. Increase it to reduce the size of the slow or - the performance impact of slow logging - --log-slow-slave-statements - Log slow statements executed by slave thread to the slow - log if it is open. - --log-slow-verbosity=name - log-slow-verbosity=[value[,value ...]] where value is one - of 'innodb', 'query_plan' - --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. - -W, --log-warnings[=#] - Log some not critical warnings to the general log - file.Value can be between 0 and 11. Higher values mean - more verbosity - --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. Defaults to master.info - --master-retry-count=# - The number of tries the slave will make to connect to the - master before giving up. - --master-verify-checksum - Force checksum verification of logged events in the - binary log before sending them to slaves or printing them - in the output of SHOW BINLOG EVENTS - --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-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 - --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-long-data-size=# - The maximum BLOB length to send to server from - mysql_send_long_data API. Deprecated option; use - max_allowed_packet instead. - --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 - --min-examined-row-limit=# - Don't write queries to slow log that examine fewer rows - than that - --mrr-buffer-size=# Size of buffer to use when using MRR with range access - --multi-range-count=# - Ignored. Use mrr_buffer_size instead - --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, BACKUP_ALL, 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 - --old Use compatible behavior - --old-alter-table Use old, non-optimized alter table - --old-passwords Use old password encryption method (needed for 4.0 and - older clients) - --old-style-user-limits - Enable old-style user limits (before 5.0.3, user - resources were counted per each user+host vs. per - account). - --one-thread (Deprecated): Only use one thread (for debugging under - Linux). Use thread-handling=no-threads instead. - --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_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; if set to 63, the - optimizer will switch to the original find_best search. - NOTE: The value 63 and its associated behaviour is - deprecated - --optimizer-switch=name - optimizer_switch=option=val[,option=val...], where option - is one of {derived_merge, derived_with_keys, firstmatch, - in_to_exists, engine_condition_pushdown, - index_condition_pushdown, index_merge, - index_merge_intersection, index_merge_sort_intersection, - index_merge_sort_union, index_merge_union, - join_cache_bka, join_cache_hashed, - join_cache_incremental, loosescan, materialization, mrr, - mrr_cost_based, mrr_sort_keys, optimize_join_buffer_size, - outer_join_with_cache, partial_match_rowid_merge, - partial_match_table_scan, semijoin, semijoin_with_cache, - subquery_cache, table_elimination } and val is one of - {on, off, default} - --performance-schema - Enable the performance schema. - --performance-schema-events-waits-history-long-size=# - Number of rows in EVENTS_WAITS_HISTORY_LONG. - --performance-schema-events-waits-history-size=# - Number of rows per thread in EVENTS_WAITS_HISTORY. - --performance-schema-max-cond-classes=# - Maximum number of condition instruments. - --performance-schema-max-cond-instances=# - Maximum number of instrumented condition objects. - --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. - --performance-schema-max-mutex-classes=# - Maximum number of mutex instruments. - --performance-schema-max-mutex-instances=# - Maximum number of instrumented MUTEX objects. - --performance-schema-max-rwlock-classes=# - Maximum number of rwlock instruments. - --performance-schema-max-rwlock-instances=# - Maximum number of instrumented RWLOCK objects. - --performance-schema-max-table-handles=# - Maximum number of opened instrumented tables. - --performance-schema-max-table-instances=# - Maximum number of instrumented tables. - --performance-schema-max-thread-classes=# - Maximum number of thread instruments. - --performance-schema-max-thread-instances=# - Maximum number of instrumented threads. - --pid-file=name Pid file used by safe_mysqld - --plugin-dir=name Directory for plugins - --plugin-load=name Semicolon-separated list of plugins to load, where each - plugin is specified as ether a plugin_name=library_file - pair or only a library_file. If the latter case, all - plugins from a given library_file will be loaded. - --plugin-maturity=name - The lowest desirable plugin maturity (unknown, - experimental, alpha, beta, gamma, or stable). Plugins - less mature than that will not be installed or loaded. - -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 - --progress-report-time=# - Seconds between sending progress reports to the client - for time-consuming statements. Set to 0 to disable - progress reporting. - --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-strip-comments - Strip all comments from a query before storing it in the - query cache - --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 - The location and name to use for the file that keeps a - list of the last relay logs - --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-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-annotate-row-events - Tells the slave to write annotate rows events recieved - from the master to its own binary log. Ignored if - log_slave_updates is not set - --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 - --rowid-merge-buff-size=# - The size of the buffers used [NOT] IN evaluation via - partial matching - --rpl-recovery-rank=# - Unused, will be removed - --safe-mode Skip some optimize stages (for testing). - --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 - --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 - --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. - --skip-bdb Deprecated option; Exist only for compatiblity with old - my.cnf files - --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-show-database - Don't allow 'SHOW DATABASE' commands - --skip-slave-start If set, slave is not autostarted. - --skip-thread-priority - Don't give threads different priorities. This option is - deprecated because it has no effect; the implied behavior - is already the default. - --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-net-timeout=# - Number of seconds to wait for more data from a - master/slave connection before aborting the read - --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 - (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 and - ALL_NON_LOSSY to enable non-lossy conversions. 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 - --sql-mode=name Syntax: sql-mode=mode[,mode[,mode...]]. See the manual - for the complete list of valid sql modes - --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). - -s, --symbolic-links - Enable symbolic link support. - --sync-binlog=# Synchronously flush binary log to disk after every #th - event. 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 (default) to disable synchronous flushing - --sync-relay-log=# Synchronously flush relay log to disk after every #th - event. Use 0 (default) to disable synchronous flushing - --sync-relay-log-info=# - Synchronously flush relay log info to disk after every - #th transaction. Use 0 (default) 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-cache=# Deprecated; use --table-open-cache instead. - --table-definition-cache=# - The number of cached table definitions - --table-open-cache=# - The number of cached open tables - --tc-heuristic-recover=name - Decision to use in heuristic recover process. Possible - values are COMMIT or ROLLBACK. - --thread-cache-size=# - How many threads we should keep in a cache for reuse - --thread-stack=# The stack size for each thread - --time-format=name The TIME format (ignored) - --timed-mutexes Specify whether to time mutexes (only InnoDB mutexes are - currently supported) - --tmp-table-size=# If an internal in-memory temporary table exceeds this - 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 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 - --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. - --userstat Enables statistics gathering for USER_STATISTICS, - CLIENT_STATISTICS, INDEX_STATISTICS and TABLE_STATISTICS - tables in the INFORMATION_SCHEMA - -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) -allow-suspicious-udfs FALSE -auto-increment-increment 1 -auto-increment-offset 1 -autocommit TRUE -automatic-sp-privileges TRUE -back-log 50 -big-tables FALSE -bind-address (No default value) -binlog-annotate-row-events FALSE -binlog-cache-size 32768 -binlog-checksum NONE -binlog-direct-non-transactional-updates FALSE -binlog-format STATEMENT -binlog-optimize-thread-scheduling TRUE -binlog-row-event-max-size 1024 -binlog-stmt-cache-size 32768 -bulk-insert-buffer-size 8388608 -character-set-client-handshake TRUE -character-set-filesystem binary -character-set-server latin1 -character-sets-dir MYSQL_CHARSETSDIR/ -chroot (No default value) -collation-server latin1_swedish_ci -completion-type NO_CHAIN -concurrent-insert AUTO -connect-timeout 10 -console FALSE -date-format %Y-%m-%d -datetime-format %Y-%m-%d %H:%i:%s -deadlock-search-depth-long 15 -deadlock-search-depth-short 4 -deadlock-timeout-long 50000000 -deadlock-timeout-short 10000 -default-storage-engine myisam -default-time-zone (No default value) -default-week-format 0 -delay-key-write ON -delayed-insert-limit 100 -delayed-insert-timeout 300 -delayed-queue-size 1000 -div-precision-increment 4 -engine-condition-pushdown FALSE -event-scheduler OFF -expire-logs-days 0 -external-locking FALSE -extra-max-connections 1 -extra-port 0 -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 -group-concat-max-len 1024 -help TRUE -ignore-builtin-innodb FALSE -init-connect -init-file (No default value) -init-rpl-role MASTER -init-slave -interactive-timeout 28800 -join-buffer-size 131072 -join-buffer-space-limit 2097152 -join-cache-level 2 -keep-files-on-create FALSE -key-buffer-size 134217728 -key-cache-age-threshold 300 -key-cache-block-size 1024 -key-cache-division-limit 100 -key-cache-segments 0 -language MYSQL_SHAREDIR/ -lc-messages en_US -lc-messages-dir MYSQL_SHAREDIR/ -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-error -log-isam myisam.log -log-output FILE -log-queries-not-using-indexes FALSE -log-short-format FALSE -log-slave-updates FALSE -log-slow-admin-statements FALSE -log-slow-filter admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk -log-slow-rate-limit 1 -log-slow-slave-statements FALSE -log-slow-verbosity -log-tc tc.log -log-tc-size 24576 -log-warnings 1 -long-query-time 10 -low-priority-updates FALSE -lower-case-table-names 1 -master-info-file master.info -master-retry-count 86400 -master-verify-checksum FALSE -max-allowed-packet 1048576 -max-binlog-cache-size 18446744073709547520 -max-binlog-size 1073741824 -max-binlog-stmt-cache-size 18446744073709547520 -max-connect-errors 10 -max-connections 151 -max-delayed-threads 20 -max-error-count 64 -max-heap-table-size 16777216 -max-join-size 18446744073709551615 -max-length-for-sort-data 1024 -max-long-data-size 1048576 -max-prepared-stmt-count 16382 -max-relay-log-size 0 -max-seeks-for-key 18446744073709551615 -max-sort-length 1024 -max-sp-recursion-depth 0 -max-tmp-tables 32 -max-user-connections 0 -max-write-lock-count 18446744073709551615 -memlock FALSE -metadata-locks-cache-size 1024 -min-examined-row-limit 0 -mrr-buffer-size 262144 -multi-range-count 256 -myisam-block-size 1024 -myisam-data-pointer-size 6 -myisam-max-sort-file-size 9223372036853727232 -myisam-mmap-size 18446744073709551615 -myisam-recover-options DEFAULT -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 -old FALSE -old-alter-table FALSE -old-passwords FALSE -old-style-user-limits FALSE -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,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on -performance-schema FALSE -performance-schema-events-waits-history-long-size 10000 -performance-schema-events-waits-history-size 10 -performance-schema-max-cond-classes 80 -performance-schema-max-cond-instances 1000 -performance-schema-max-file-classes 50 -performance-schema-max-file-handles 32768 -performance-schema-max-file-instances 10000 -performance-schema-max-mutex-classes 200 -performance-schema-max-mutex-instances 1000000 -performance-schema-max-rwlock-classes 30 -performance-schema-max-rwlock-instances 1000000 -performance-schema-max-table-handles 100000 -performance-schema-max-table-instances 50000 -performance-schema-max-thread-classes 50 -performance-schema-max-thread-instances 1000 -plugin-load (No default value) -plugin-maturity unknown -port 3306 -port-open-timeout 0 -preload-buffer-size 32768 -profiling-history-size 15 -progress-report-time 56 -query-alloc-block-size 8192 -query-cache-limit 1048576 -query-cache-min-res-unit 4096 -query-cache-size 0 -query-cache-strip-comments FALSE -query-cache-type ON -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-purge TRUE -relay-log-recovery FALSE -relay-log-space-limit 0 -replicate-annotate-row-events FALSE -replicate-same-server-id FALSE -report-host (No default value) -report-password (No default value) -report-port 3306 -report-user (No default value) -rowid-merge-buff-size 8388608 -rpl-recovery-rank 0 -safe-user-create FALSE -secure-auth FALSE -secure-file-priv (No default value) -server-id 0 -shared-memory FALSE -shared-memory-base-name MYSQL -show-slave-auth-info FALSE -skip-grant-tables TRUE -skip-name-resolve FALSE -skip-networking FALSE -skip-show-database FALSE -skip-slave-start FALSE -slave-compressed-protocol FALSE -slave-exec-mode STRICT -slave-net-timeout 3600 -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-start-timeout 15000 -sort-buffer-size 2097152 -sql-mode -stack-trace TRUE -symbolic-links FALSE -sync-binlog 0 -sync-frm FALSE -sync-master-info 0 -sync-relay-log 0 -sync-relay-log-info 0 -sysdate-is-now FALSE -table-cache 400 -table-definition-cache 400 -table-open-cache 400 -tc-heuristic-recover COMMIT -thread-cache-size 0 -thread-stack 294912 -time-format %H:%i:%s -timed-mutexes FALSE -tmp-table-size 16777216 -transaction-alloc-block-size 8192 -transaction-isolation REPEATABLE-READ -transaction-prealloc-size 4096 -updatable-views-with-limit YES -userstat FALSE -verbose TRUE -wait-timeout 28800 - -To see what values a running MySQL server is using, type -'mysqladmin variables' instead of 'mysqld --verbose --help'. diff --git a/mysql-test/r/mysqld--help-win.result.THIS b/mysql-test/r/mysqld--help-win.result.THIS new file mode 100644 index 00000000000..05cbcda7129 --- /dev/null +++ b/mysql-test/r/mysqld--help-win.result.THIS @@ -0,0 +1,1089 @@ +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. +--defaults-file=# Only read default options from the given file #. +--defaults-extra-file=# Read this file after the global files are read. + + --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'. + --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-annotate-row-events + Tells the master to annotate RBR events with the + statement that caused these events + --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 NONE. + --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-optimize-thread-scheduling + Run fast part of group commit in a single thread, to + optimize kernel thread scheduling. On by default. Disable + to run each transaction in group commit in its own + thread, which can be slower at very high concurrency. + This option is mostly for testing one algorithm versus + the other, and it should not normally be necessary to + change it. + (Defaults to on; use --skip-binlog-optimize-thread-scheduling 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-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 + --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) + --deadlock-search-depth-long=# + Long search depth for the two-step deadlock detection + --deadlock-search-depth-short=# + Short search depth for the two-step deadlock detection + --deadlock-timeout-long=# + Long timeout for the two-step deadlock detection (in + microseconds) + --deadlock-timeout-short=# + Short timeout for the two-step deadlock detection (in + microseconds) + --default-storage-engine=name + The default storage engine for new tables + --default-time-zone=name + Set the default time zone. + --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 + --delayed-insert-timeout=# + How long a INSERT DELAYED thread should wait for INSERT + statements before terminating + --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 + --div-precision-increment=# + Precision of the result of '/' operator will be increased + on that value + --engine-condition-pushdown + Push supported query conditions to the storage engine. + Deprecated, use --optimizer-switch instead. + (Defaults to on; use --skip-engine-condition-pushdown to disable.) + --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) + --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 + --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. + --extra-max-connections=# + The number of connections on extra-port + --extra-port=# Extra port number to use for tcp connections in a + one-thread-per-connection manner. 0 means don't use + another port + --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. Deprecated, use + --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() + -?, --help Display this help and exit. + --ignore-builtin-innodb + Disable initialization of builtin InnoDB plugin + --init-connect=name Command(s) that are executed for each new connection + (unless the user has SUPER privilege) + --init-file=name Read SQL commands from this file at startup + --init-rpl-role=name + Set the replication role. + --init-slave=name Command(s) that are executed by a slave server each time + the SQL thread starts + --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 joins + --join-buffer-space-limit=# + The limit of the space for all join buffers used by a + query + --join-cache-level=# + Controls what join operations can be executed with join + buffers. Odd numbers are used for plain join buffers + while even numbers are used for linked buffers + --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 + --key-cache-segments=# + 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. + --lc-messages=name Set the language used for the error messages. + -L, --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. + -l, --log[=name] Log connections and queries to file (deprecated option, + use --general-log/--general-log-file instead). + --log-basename=name Basename for all log files and the .pid file. This sets + all log file names at once (in 'datadir') and is normally + the only option you need for specifying log files. Sets + names for --log-bin, --log-bin-index, --relay-log, + --relay-log-index, --general-log-file, + --log-slow-query-log-file, --log-error-file, and + --pid-file + --log-bin[=name] Log update queries in binary format. Optional argument + should be name for binary log. If not given + 'datadir'/'log-basename'-bin or 'datadir'/mysql-bin will + be used (the later if --log-basename is not specified). + We strongly recommend to use either --log-basename or + specify a filename to ensure that replication doesn't + stop if the real hostname of the computer changes. + --log-bin-index=name + File that holds the names for last 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-error[=name] Log errors to file (instead of stdout). If file name is + not specified then 'datadir'/'log-basename'.err or the + 'pid-file' path with extension .err is used + --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-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-filter=name + Log only certain types of queries. Multiple flags can be + specified, separated by commas. Valid values are admin, + slave, filesort, filesort_on_disk, full_join, full_scan, + query_cache, query_cache_miss, tmp_table, + tmp_table_on_disk + --log-slow-queries[=name] + Enable logging of slow queries (longer than + --long-query-time) to log file or table. Optional + argument is a file name for the slow log. If not given, + 'log-basename'-slow.log will be used. Use + --log-output=TABLE if you want to have the log in the + table mysql.slow_log. Deprecated option, use + --slow-query-log/--slow-query-log-file instead. + --log-slow-rate-limit=# + Write to slow log every #th slow query. Set to 1 to log + everything. Increase it to reduce the size of the slow or + the performance impact of slow logging + --log-slow-slave-statements + Log slow statements executed by slave thread to the slow + log if it is open. + --log-slow-verbosity=name + log-slow-verbosity=[value[,value ...]] where value is one + of 'innodb', 'query_plan' + --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. + -W, --log-warnings[=#] + Log some not critical warnings to the general log + file.Value can be between 0 and 11. Higher values mean + more verbosity + --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. Defaults to master.info + --master-retry-count=# + The number of tries the slave will make to connect to the + master before giving up. + --master-verify-checksum + Force checksum verification of logged events in the + binary log before sending them to slaves or printing them + in the output of SHOW BINLOG EVENTS + --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-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 + --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-long-data-size=# + The maximum BLOB length to send to server from + mysql_send_long_data API. Deprecated option; use + max_allowed_packet instead. + --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 + --min-examined-row-limit=# + Don't write queries to slow log that examine fewer rows + than that + --mrr-buffer-size=# Size of buffer to use when using MRR with range access + --multi-range-count=# + Ignored. Use mrr_buffer_size instead + --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, BACKUP_ALL, 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 + --old Use compatible behavior + --old-alter-table Use old, non-optimized alter table + --old-passwords Use old password encryption method (needed for 4.0 and + older clients) + --old-style-user-limits + Enable old-style user limits (before 5.0.3, user + resources were counted per each user+host vs. per + account). + --one-thread (Deprecated): Only use one thread (for debugging under + Linux). Use thread-handling=no-threads instead. + --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_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; if set to 63, the + optimizer will switch to the original find_best search. + NOTE: The value 63 and its associated behaviour is + deprecated + --optimizer-switch=name + optimizer_switch=option=val[,option=val...], where option + is one of {derived_merge, derived_with_keys, firstmatch, + in_to_exists, engine_condition_pushdown, + index_condition_pushdown, index_merge, + index_merge_intersection, index_merge_sort_intersection, + index_merge_sort_union, index_merge_union, + join_cache_bka, join_cache_hashed, + join_cache_incremental, loosescan, materialization, mrr, + mrr_cost_based, mrr_sort_keys, optimize_join_buffer_size, + outer_join_with_cache, partial_match_rowid_merge, + partial_match_table_scan, semijoin, semijoin_with_cache, + subquery_cache, table_elimination } and val is one of + {on, off, default} + --performance-schema + Enable the performance schema. + --performance-schema-events-waits-history-long-size=# + Number of rows in EVENTS_WAITS_HISTORY_LONG. + --performance-schema-events-waits-history-size=# + Number of rows per thread in EVENTS_WAITS_HISTORY. + --performance-schema-max-cond-classes=# + Maximum number of condition instruments. + --performance-schema-max-cond-instances=# + Maximum number of instrumented condition objects. + --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. + --performance-schema-max-mutex-classes=# + Maximum number of mutex instruments. + --performance-schema-max-mutex-instances=# + Maximum number of instrumented MUTEX objects. + --performance-schema-max-rwlock-classes=# + Maximum number of rwlock instruments. + --performance-schema-max-rwlock-instances=# + Maximum number of instrumented RWLOCK objects. + --performance-schema-max-table-handles=# + Maximum number of opened instrumented tables. + --performance-schema-max-table-instances=# + Maximum number of instrumented tables. + --performance-schema-max-thread-classes=# + Maximum number of thread instruments. + --performance-schema-max-thread-instances=# + Maximum number of instrumented threads. + --pid-file=name Pid file used by safe_mysqld + --plugin-dir=name Directory for plugins + --plugin-load=name Semicolon-separated list of plugins to load, where each + plugin is specified as ether a plugin_name=library_file + pair or only a library_file. If the latter case, all + plugins from a given library_file will be loaded. + --plugin-maturity=name + The lowest desirable plugin maturity (unknown, + experimental, alpha, beta, gamma, or stable). Plugins + less mature than that will not be installed or loaded. + -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 + --progress-report-time=# + Seconds between sending progress reports to the client + for time-consuming statements. Set to 0 to disable + progress reporting. + --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-strip-comments + Strip all comments from a query before storing it in the + query cache + --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 + The location and name to use for the file that keeps a + list of the last relay logs + --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-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-annotate-row-events + Tells the slave to write annotate rows events recieved + from the master to its own binary log. Ignored if + log_slave_updates is not set + --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 + --rowid-merge-buff-size=# + The size of the buffers used [NOT] IN evaluation via + partial matching + --rpl-recovery-rank=# + Unused, will be removed + --safe-mode Skip some optimize stages (for testing). + --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 + --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 + --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. + --skip-bdb Deprecated option; Exist only for compatiblity with old + my.cnf files + --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-show-database + Don't allow 'SHOW DATABASE' commands + --skip-slave-start If set, slave is not autostarted. + --skip-thread-priority + Don't give threads different priorities. This option is + deprecated because it has no effect; the implied behavior + is already the default. + --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-net-timeout=# + Number of seconds to wait for more data from a + master/slave connection before aborting the read + --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 + (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 and + ALL_NON_LOSSY to enable non-lossy conversions. 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 + --sql-mode=name Syntax: sql-mode=mode[,mode[,mode...]]. See the manual + for the complete list of valid sql modes + --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). + -s, --symbolic-links + Enable symbolic link support. + --sync-binlog=# Synchronously flush binary log to disk after every #th + event. 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 (default) to disable synchronous flushing + --sync-relay-log=# Synchronously flush relay log to disk after every #th + event. Use 0 (default) to disable synchronous flushing + --sync-relay-log-info=# + Synchronously flush relay log info to disk after every + #th transaction. Use 0 (default) 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-cache=# Deprecated; use --table-open-cache instead. + --table-definition-cache=# + The number of cached table definitions + --table-open-cache=# + The number of cached open tables + --tc-heuristic-recover=name + Decision to use in heuristic recover process. Possible + values are COMMIT or ROLLBACK. + --thread-cache-size=# + How many threads we should keep in a cache for reuse + --thread-stack=# The stack size for each thread + --time-format=name The TIME format (ignored) + --timed-mutexes Specify whether to time mutexes (only InnoDB mutexes are + currently supported) + --tmp-table-size=# If an internal in-memory temporary table exceeds this + 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 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 + --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. + --userstat Enables statistics gathering for USER_STATISTICS, + CLIENT_STATISTICS, INDEX_STATISTICS and TABLE_STATISTICS + tables in the INFORMATION_SCHEMA + -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) +allow-suspicious-udfs FALSE +auto-increment-increment 1 +auto-increment-offset 1 +autocommit TRUE +automatic-sp-privileges TRUE +back-log 50 +big-tables FALSE +bind-address (No default value) +binlog-annotate-row-events FALSE +binlog-cache-size 32768 +binlog-checksum NONE +binlog-direct-non-transactional-updates FALSE +binlog-format STATEMENT +binlog-optimize-thread-scheduling TRUE +binlog-row-event-max-size 1024 +binlog-stmt-cache-size 32768 +bulk-insert-buffer-size 8388608 +character-set-client-handshake TRUE +character-set-filesystem binary +character-set-server latin1 +character-sets-dir MYSQL_CHARSETSDIR/ +chroot (No default value) +collation-server latin1_swedish_ci +completion-type NO_CHAIN +concurrent-insert AUTO +connect-timeout 10 +console FALSE +date-format %Y-%m-%d +datetime-format %Y-%m-%d %H:%i:%s +deadlock-search-depth-long 15 +deadlock-search-depth-short 4 +deadlock-timeout-long 50000000 +deadlock-timeout-short 10000 +default-storage-engine myisam +default-time-zone (No default value) +default-week-format 0 +delay-key-write ON +delayed-insert-limit 100 +delayed-insert-timeout 300 +delayed-queue-size 1000 +div-precision-increment 4 +engine-condition-pushdown FALSE +event-scheduler OFF +expire-logs-days 0 +external-locking FALSE +extra-max-connections 1 +extra-port 0 +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 +group-concat-max-len 1024 +help TRUE +ignore-builtin-innodb FALSE +init-connect +init-file (No default value) +init-rpl-role MASTER +init-slave +interactive-timeout 28800 +join-buffer-size 131072 +join-buffer-space-limit 2097152 +join-cache-level 2 +keep-files-on-create FALSE +key-buffer-size 134217728 +key-cache-age-threshold 300 +key-cache-block-size 1024 +key-cache-division-limit 100 +key-cache-segments 0 +language MYSQL_SHAREDIR/ +lc-messages en_US +lc-messages-dir MYSQL_SHAREDIR/ +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-error +log-isam myisam.log +log-output FILE +log-queries-not-using-indexes FALSE +log-short-format FALSE +log-slave-updates FALSE +log-slow-admin-statements FALSE +log-slow-filter admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk +log-slow-rate-limit 1 +log-slow-slave-statements FALSE +log-slow-verbosity +log-tc tc.log +log-tc-size 24576 +log-warnings 1 +long-query-time 10 +low-priority-updates FALSE +lower-case-table-names 1 +master-info-file master.info +master-retry-count 86400 +master-verify-checksum FALSE +max-allowed-packet 1048576 +max-binlog-cache-size 18446744073709547520 +max-binlog-size 1073741824 +max-binlog-stmt-cache-size 18446744073709547520 +max-connect-errors 10 +max-connections 151 +max-delayed-threads 20 +max-error-count 64 +max-heap-table-size 16777216 +max-join-size 18446744073709551615 +max-length-for-sort-data 1024 +max-long-data-size 1048576 +max-prepared-stmt-count 16382 +max-relay-log-size 0 +max-seeks-for-key 18446744073709551615 +max-sort-length 1024 +max-sp-recursion-depth 0 +max-tmp-tables 32 +max-user-connections 0 +max-write-lock-count 18446744073709551615 +memlock FALSE +metadata-locks-cache-size 1024 +min-examined-row-limit 0 +mrr-buffer-size 262144 +multi-range-count 256 +myisam-block-size 1024 +myisam-data-pointer-size 6 +myisam-max-sort-file-size 9223372036853727232 +myisam-mmap-size 18446744073709551615 +myisam-recover-options DEFAULT +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 +old FALSE +old-alter-table FALSE +old-passwords FALSE +old-style-user-limits FALSE +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,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on +performance-schema FALSE +performance-schema-events-waits-history-long-size 10000 +performance-schema-events-waits-history-size 10 +performance-schema-max-cond-classes 80 +performance-schema-max-cond-instances 1000 +performance-schema-max-file-classes 50 +performance-schema-max-file-handles 32768 +performance-schema-max-file-instances 10000 +performance-schema-max-mutex-classes 200 +performance-schema-max-mutex-instances 1000000 +performance-schema-max-rwlock-classes 30 +performance-schema-max-rwlock-instances 1000000 +performance-schema-max-table-handles 100000 +performance-schema-max-table-instances 50000 +performance-schema-max-thread-classes 50 +performance-schema-max-thread-instances 1000 +plugin-load (No default value) +plugin-maturity unknown +port 3306 +port-open-timeout 0 +preload-buffer-size 32768 +profiling-history-size 15 +progress-report-time 56 +query-alloc-block-size 8192 +query-cache-limit 1048576 +query-cache-min-res-unit 4096 +query-cache-size 0 +query-cache-strip-comments FALSE +query-cache-type ON +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-purge TRUE +relay-log-recovery FALSE +relay-log-space-limit 0 +replicate-annotate-row-events FALSE +replicate-same-server-id FALSE +report-host (No default value) +report-password (No default value) +report-port 3306 +report-user (No default value) +rowid-merge-buff-size 8388608 +rpl-recovery-rank 0 +safe-user-create FALSE +secure-auth FALSE +secure-file-priv (No default value) +server-id 0 +shared-memory FALSE +shared-memory-base-name MYSQL +show-slave-auth-info FALSE +skip-grant-tables TRUE +skip-name-resolve FALSE +skip-networking FALSE +skip-show-database FALSE +skip-slave-start FALSE +slave-compressed-protocol FALSE +slave-exec-mode STRICT +slave-net-timeout 3600 +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-start-timeout 15000 +sort-buffer-size 2097152 +sql-mode +stack-trace TRUE +symbolic-links FALSE +sync-binlog 0 +sync-frm FALSE +sync-master-info 0 +sync-relay-log 0 +sync-relay-log-info 0 +sysdate-is-now FALSE +table-cache 400 +table-definition-cache 400 +table-open-cache 400 +tc-heuristic-recover COMMIT +thread-cache-size 0 +thread-stack 294912 +time-format %H:%i:%s +timed-mutexes FALSE +tmp-table-size 16777216 +transaction-alloc-block-size 8192 +transaction-isolation REPEATABLE-READ +transaction-prealloc-size 4096 +updatable-views-with-limit YES +userstat FALSE +verbose TRUE +wait-timeout 28800 + +To see what values a running MySQL server is using, type +'mysqladmin variables' instead of 'mysqld --verbose --help'. diff --git a/mysql-test/r/mysqld--help.result b/mysql-test/r/mysqld--help.result new file mode 100644 index 00000000000..94d7465d39b --- /dev/null +++ b/mysql-test/r/mysqld--help.result @@ -0,0 +1,1078 @@ +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. +--defaults-file=# Only read default options from the given file #. +--defaults-extra-file=# Read this file after the global files are read. + + --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'. + --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-annotate-row-events + Tells the master to annotate RBR events with the + statement that caused these events + --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 NONE. + --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-optimize-thread-scheduling + Run fast part of group commit in a single thread, to + optimize kernel thread scheduling. On by default. Disable + to run each transaction in group commit in its own + thread, which can be slower at very high concurrency. + This option is mostly for testing one algorithm versus + the other, and it should not normally be necessary to + change it. + (Defaults to on; use --skip-binlog-optimize-thread-scheduling 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-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 + --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) + --deadlock-search-depth-long=# + Long search depth for the two-step deadlock detection + --deadlock-search-depth-short=# + Short search depth for the two-step deadlock detection + --deadlock-timeout-long=# + Long timeout for the two-step deadlock detection (in + microseconds) + --deadlock-timeout-short=# + Short timeout for the two-step deadlock detection (in + microseconds) + --default-storage-engine=name + The default storage engine for new tables + --default-time-zone=name + Set the default time zone. + --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 + --delayed-insert-timeout=# + How long a INSERT DELAYED thread should wait for INSERT + statements before terminating + --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 + --div-precision-increment=# + Precision of the result of '/' operator will be increased + on that value + --engine-condition-pushdown + Push supported query conditions to the storage engine. + Deprecated, use --optimizer-switch instead. + (Defaults to on; use --skip-engine-condition-pushdown to disable.) + --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) + --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 + --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. + --extra-max-connections=# + The number of connections on extra-port + --extra-port=# Extra port number to use for tcp connections in a + one-thread-per-connection manner. 0 means don't use + another port + --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. Deprecated, use + --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() + -?, --help Display this help and exit. + --ignore-builtin-innodb + Disable initialization of builtin InnoDB plugin + --init-connect=name Command(s) that are executed for each new connection + (unless the user has SUPER privilege) + --init-file=name Read SQL commands from this file at startup + --init-rpl-role=name + Set the replication role. + --init-slave=name Command(s) that are executed by a slave server each time + the SQL thread starts + --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 joins + --join-buffer-space-limit=# + The limit of the space for all join buffers used by a + query + --join-cache-level=# + Controls what join operations can be executed with join + buffers. Odd numbers are used for plain join buffers + while even numbers are used for linked buffers + --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 + --key-cache-segments=# + 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 + --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. + -l, --log[=name] Log connections and queries to file (deprecated option, + use --general-log/--general-log-file instead). + --log-basename=name Basename for all log files and the .pid file. This sets + all log file names at once (in 'datadir') and is normally + the only option you need for specifying log files. Sets + names for --log-bin, --log-bin-index, --relay-log, + --relay-log-index, --general-log-file, + --log-slow-query-log-file, --log-error-file, and + --pid-file + --log-bin[=name] Log update queries in binary format. Optional argument + should be name for binary log. If not given + 'datadir'/'log-basename'-bin or 'datadir'/mysql-bin will + be used (the later if --log-basename is not specified). + We strongly recommend to use either --log-basename or + specify a filename to ensure that replication doesn't + stop if the real hostname of the computer changes. + --log-bin-index=name + File that holds the names for last 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-error[=name] Log errors to file (instead of stdout). If file name is + not specified then 'datadir'/'log-basename'.err or the + 'pid-file' path with extension .err is used + --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-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-filter=name + Log only certain types of queries. Multiple flags can be + specified, separated by commas. Valid values are admin, + slave, filesort, filesort_on_disk, full_join, full_scan, + query_cache, query_cache_miss, tmp_table, + tmp_table_on_disk + --log-slow-queries[=name] + Enable logging of slow queries (longer than + --long-query-time) to log file or table. Optional + argument is a file name for the slow log. If not given, + 'log-basename'-slow.log will be used. Use + --log-output=TABLE if you want to have the log in the + table mysql.slow_log. Deprecated option, use + --slow-query-log/--slow-query-log-file instead. + --log-slow-rate-limit=# + Write to slow log every #th slow query. Set to 1 to log + everything. Increase it to reduce the size of the slow or + the performance impact of slow logging + --log-slow-slave-statements + Log slow statements executed by slave thread to the slow + log if it is open. + --log-slow-verbosity=name + log-slow-verbosity=[value[,value ...]] where value is one + of 'innodb', 'query_plan' + --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. + -W, --log-warnings[=#] + Log some not critical warnings to the general log + file.Value can be between 0 and 11. Higher values mean + more verbosity + --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. Defaults to master.info + --master-retry-count=# + The number of tries the slave will make to connect to the + master before giving up. + --master-verify-checksum + Force checksum verification of logged events in the + binary log before sending them to slaves or printing them + in the output of SHOW BINLOG EVENTS + --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-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 + --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-long-data-size=# + The maximum BLOB length to send to server from + mysql_send_long_data API. Deprecated option; use + max_allowed_packet instead. + --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 + --min-examined-row-limit=# + Don't write queries to slow log that examine fewer rows + than that + --mrr-buffer-size=# Size of buffer to use when using MRR with range access + --multi-range-count=# + Ignored. Use mrr_buffer_size instead + --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, BACKUP_ALL, 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 + --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 + --old Use compatible behavior + --old-alter-table Use old, non-optimized alter table + --old-passwords Use old password encryption method (needed for 4.0 and + older clients) + --old-style-user-limits + Enable old-style user limits (before 5.0.3, user + resources were counted per each user+host vs. per + account). + --one-thread (Deprecated): Only use one thread (for debugging under + Linux). Use thread-handling=no-threads instead. + --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_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; if set to 63, the + optimizer will switch to the original find_best search. + NOTE: The value 63 and its associated behaviour is + deprecated + --optimizer-switch=name + optimizer_switch=option=val[,option=val...], where option + is one of {derived_merge, derived_with_keys, firstmatch, + in_to_exists, engine_condition_pushdown, + index_condition_pushdown, index_merge, + index_merge_intersection, index_merge_sort_intersection, + index_merge_sort_union, index_merge_union, + join_cache_bka, join_cache_hashed, + join_cache_incremental, loosescan, materialization, mrr, + mrr_cost_based, mrr_sort_keys, optimize_join_buffer_size, + outer_join_with_cache, partial_match_rowid_merge, + partial_match_table_scan, semijoin, semijoin_with_cache, + subquery_cache, table_elimination } and val is one of + {on, off, default} + --performance-schema + Enable the performance schema. + --performance-schema-events-waits-history-long-size=# + Number of rows in EVENTS_WAITS_HISTORY_LONG. + --performance-schema-events-waits-history-size=# + Number of rows per thread in EVENTS_WAITS_HISTORY. + --performance-schema-max-cond-classes=# + Maximum number of condition instruments. + --performance-schema-max-cond-instances=# + Maximum number of instrumented condition objects. + --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. + --performance-schema-max-mutex-classes=# + Maximum number of mutex instruments. + --performance-schema-max-mutex-instances=# + Maximum number of instrumented MUTEX objects. + --performance-schema-max-rwlock-classes=# + Maximum number of rwlock instruments. + --performance-schema-max-rwlock-instances=# + Maximum number of instrumented RWLOCK objects. + --performance-schema-max-table-handles=# + Maximum number of opened instrumented tables. + --performance-schema-max-table-instances=# + Maximum number of instrumented tables. + --performance-schema-max-thread-classes=# + Maximum number of thread instruments. + --performance-schema-max-thread-instances=# + Maximum number of instrumented threads. + --pid-file=name Pid file used by safe_mysqld + --plugin-dir=name Directory for plugins + --plugin-load=name Semicolon-separated list of plugins to load, where each + plugin is specified as ether a plugin_name=library_file + pair or only a library_file. If the latter case, all + plugins from a given library_file will be loaded. + --plugin-maturity=name + The lowest desirable plugin maturity (unknown, + experimental, alpha, beta, gamma, or stable). Plugins + less mature than that will not be installed or loaded. + -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 + --progress-report-time=# + Seconds between sending progress reports to the client + for time-consuming statements. Set to 0 to disable + progress reporting. + --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-strip-comments + Strip all comments from a query before storing it in the + query cache + --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 + The location and name to use for the file that keeps a + list of the last relay logs + --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-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-annotate-row-events + Tells the slave to write annotate rows events recieved + from the master to its own binary log. Ignored if + log_slave_updates is not set + --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 + --rowid-merge-buff-size=# + The size of the buffers used [NOT] IN evaluation via + partial matching + --rpl-recovery-rank=# + Unused, will be removed + --safe-mode Skip some optimize stages (for testing). + --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 + --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 + --show-slave-auth-info + Show user and password in SHOW SLAVE HOSTS on this + master. + --skip-bdb Deprecated option; Exist only for compatiblity with old + my.cnf files + --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-show-database + Don't allow 'SHOW DATABASE' commands + --skip-slave-start If set, slave is not autostarted. + --skip-thread-priority + Don't give threads different priorities. This option is + deprecated because it has no effect; the implied behavior + is already the default. + --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-net-timeout=# + Number of seconds to wait for more data from a + master/slave connection before aborting the read + --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 + (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 and + ALL_NON_LOSSY to enable non-lossy conversions. 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 + --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 + --sql-mode=name Syntax: sql-mode=mode[,mode[,mode...]]. See the manual + for the complete list of valid sql modes + --stack-trace Print a symbolic stack trace on failure + (Defaults to on; use --skip-stack-trace to disable.) + -s, --symbolic-links + Enable symbolic link support. + --sync-binlog=# Synchronously flush binary log to disk after every #th + event. 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 (default) to disable synchronous flushing + --sync-relay-log=# Synchronously flush relay log to disk after every #th + event. Use 0 (default) to disable synchronous flushing + --sync-relay-log-info=# + Synchronously flush relay log info to disk after every + #th transaction. Use 0 (default) 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-cache=# Deprecated; use --table-open-cache instead. + --table-definition-cache=# + The number of cached table definitions + --table-open-cache=# + The number of cached open tables + --tc-heuristic-recover=name + Decision to use in heuristic recover process. Possible + values are COMMIT or ROLLBACK. + --thread-cache-size=# + How many threads we should keep in a cache for reuse + --thread-stack=# The stack size for each thread + --time-format=name The TIME format (ignored) + --timed-mutexes Specify whether to time mutexes (only InnoDB mutexes are + currently supported) + --tmp-table-size=# If an internal in-memory temporary table exceeds this + 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 + --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 + --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. + --userstat Enables statistics gathering for USER_STATISTICS, + CLIENT_STATISTICS, INDEX_STATISTICS and TABLE_STATISTICS + tables in the INFORMATION_SCHEMA + -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) +allow-suspicious-udfs FALSE +auto-increment-increment 1 +auto-increment-offset 1 +autocommit TRUE +automatic-sp-privileges TRUE +back-log 50 +big-tables FALSE +bind-address (No default value) +binlog-annotate-row-events FALSE +binlog-cache-size 32768 +binlog-checksum NONE +binlog-direct-non-transactional-updates FALSE +binlog-format STATEMENT +binlog-optimize-thread-scheduling TRUE +binlog-row-event-max-size 1024 +binlog-stmt-cache-size 32768 +bulk-insert-buffer-size 8388608 +character-set-client-handshake TRUE +character-set-filesystem binary +character-set-server latin1 +character-sets-dir MYSQL_CHARSETSDIR/ +chroot (No default value) +collation-server latin1_swedish_ci +completion-type NO_CHAIN +concurrent-insert AUTO +connect-timeout 10 +console FALSE +date-format %Y-%m-%d +datetime-format %Y-%m-%d %H:%i:%s +deadlock-search-depth-long 15 +deadlock-search-depth-short 4 +deadlock-timeout-long 50000000 +deadlock-timeout-short 10000 +default-storage-engine myisam +default-time-zone (No default value) +default-week-format 0 +delay-key-write ON +delayed-insert-limit 100 +delayed-insert-timeout 300 +delayed-queue-size 1000 +div-precision-increment 4 +engine-condition-pushdown FALSE +event-scheduler OFF +expire-logs-days 0 +external-locking FALSE +extra-max-connections 1 +extra-port 0 +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 +group-concat-max-len 1024 +help TRUE +ignore-builtin-innodb FALSE +init-connect +init-file (No default value) +init-rpl-role MASTER +init-slave +interactive-timeout 28800 +join-buffer-size 131072 +join-buffer-space-limit 2097152 +join-cache-level 2 +keep-files-on-create FALSE +key-buffer-size 134217728 +key-cache-age-threshold 300 +key-cache-block-size 1024 +key-cache-division-limit 100 +key-cache-segments 0 +language MYSQL_SHAREDIR/ +large-pages FALSE +lc-messages en_US +lc-messages-dir MYSQL_SHAREDIR/ +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-error +log-isam myisam.log +log-output FILE +log-queries-not-using-indexes FALSE +log-short-format FALSE +log-slave-updates FALSE +log-slow-admin-statements FALSE +log-slow-filter admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk +log-slow-rate-limit 1 +log-slow-slave-statements FALSE +log-slow-verbosity +log-tc tc.log +log-tc-size 24576 +log-warnings 1 +long-query-time 10 +low-priority-updates FALSE +lower-case-table-names 1 +master-info-file master.info +master-retry-count 86400 +master-verify-checksum FALSE +max-allowed-packet 1048576 +max-binlog-cache-size 18446744073709547520 +max-binlog-size 1073741824 +max-binlog-stmt-cache-size 18446744073709547520 +max-connect-errors 10 +max-connections 151 +max-delayed-threads 20 +max-error-count 64 +max-heap-table-size 16777216 +max-join-size 18446744073709551615 +max-length-for-sort-data 1024 +max-long-data-size 1048576 +max-prepared-stmt-count 16382 +max-relay-log-size 0 +max-seeks-for-key 18446744073709551615 +max-sort-length 1024 +max-sp-recursion-depth 0 +max-tmp-tables 32 +max-user-connections 0 +max-write-lock-count 18446744073709551615 +memlock FALSE +metadata-locks-cache-size 1024 +min-examined-row-limit 0 +mrr-buffer-size 262144 +multi-range-count 256 +myisam-block-size 1024 +myisam-data-pointer-size 6 +myisam-max-sort-file-size 9223372036853727232 +myisam-mmap-size 18446744073709551615 +myisam-recover-options DEFAULT +myisam-repair-threads 1 +myisam-sort-buffer-size 8388608 +myisam-stats-method nulls_unequal +myisam-use-mmap FALSE +net-buffer-length 16384 +net-read-timeout 30 +net-retry-count 10 +net-write-timeout 60 +old FALSE +old-alter-table FALSE +old-passwords FALSE +old-style-user-limits FALSE +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,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on +performance-schema FALSE +performance-schema-events-waits-history-long-size 10000 +performance-schema-events-waits-history-size 10 +performance-schema-max-cond-classes 80 +performance-schema-max-cond-instances 1000 +performance-schema-max-file-classes 50 +performance-schema-max-file-handles 32768 +performance-schema-max-file-instances 10000 +performance-schema-max-mutex-classes 200 +performance-schema-max-mutex-instances 1000000 +performance-schema-max-rwlock-classes 30 +performance-schema-max-rwlock-instances 1000000 +performance-schema-max-table-handles 100000 +performance-schema-max-table-instances 50000 +performance-schema-max-thread-classes 50 +performance-schema-max-thread-instances 1000 +plugin-load (No default value) +plugin-maturity unknown +port 3306 +port-open-timeout 0 +preload-buffer-size 32768 +profiling-history-size 15 +progress-report-time 56 +query-alloc-block-size 8192 +query-cache-limit 1048576 +query-cache-min-res-unit 4096 +query-cache-size 0 +query-cache-strip-comments FALSE +query-cache-type ON +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-purge TRUE +relay-log-recovery FALSE +relay-log-space-limit 0 +replicate-annotate-row-events FALSE +replicate-same-server-id FALSE +report-host (No default value) +report-password (No default value) +report-port 3306 +report-user (No default value) +rowid-merge-buff-size 8388608 +rpl-recovery-rank 0 +safe-user-create FALSE +secure-auth FALSE +secure-file-priv (No default value) +server-id 0 +show-slave-auth-info FALSE +skip-grant-tables TRUE +skip-name-resolve FALSE +skip-networking FALSE +skip-show-database FALSE +skip-slave-start FALSE +slave-compressed-protocol FALSE +slave-exec-mode STRICT +slave-net-timeout 3600 +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 +sort-buffer-size 2097152 +sql-mode +stack-trace TRUE +symbolic-links FALSE +sync-binlog 0 +sync-frm FALSE +sync-master-info 0 +sync-relay-log 0 +sync-relay-log-info 0 +sysdate-is-now FALSE +table-cache 400 +table-definition-cache 400 +table-open-cache 400 +tc-heuristic-recover COMMIT +thread-cache-size 0 +thread-stack 294912 +time-format %H:%i:%s +timed-mutexes FALSE +tmp-table-size 16777216 +transaction-alloc-block-size 8192 +transaction-isolation REPEATABLE-READ +transaction-prealloc-size 4096 +updatable-views-with-limit YES +userstat FALSE +verbose TRUE +wait-timeout 28800 + +To see what values a running MySQL server is using, type +'mysqladmin variables' instead of 'mysqld --verbose --help'. diff --git a/mysql-test/suite.pm b/mysql-test/suite.pm index 9db2c96a7c5..7c234afffb1 100644 --- a/mysql-test/suite.pm +++ b/mysql-test/suite.pm @@ -1,4 +1,5 @@ package My::Suite::Main; +use My::Platform; @ISA = qw(My::Suite); @@ -13,6 +14,9 @@ sub skip_combinations { my %skip = ( 'include/have_innodb.combinations' => [ @combinations ], 'include/have_xtradb.combinations' => [ @combinations ]); + # don't run tests for the wrong platform + $skip{'include/platform.combinations'} = [ (IS_WINDOWS) ? 'unix' : 'win' ]; + # as a special case, disable certain include files as a whole $skip{'include/not_embedded.inc'} = 'Not run for embedded server' if $::opt_embedded_server; diff --git a/mysql-test/suite/funcs_1/t/is_columns_is.test b/mysql-test/suite/funcs_1/t/is_columns_is.test index 54527e6e080..29d387857c9 100644 --- a/mysql-test/suite/funcs_1/t/is_columns_is.test +++ b/mysql-test/suite/funcs_1/t/is_columns_is.test @@ -16,7 +16,6 @@ # --source include/not_embedded.inc -# This test depends on having the PBXT information_schema stuff. --source include/have_xtradb.inc let $my_where = WHERE table_schema = 'information_schema' diff --git a/mysql-test/t/mysqld--help-notwin.test b/mysql-test/t/mysqld--help-notwin.test deleted file mode 100644 index 7cc490c0615..00000000000 --- a/mysql-test/t/mysqld--help-notwin.test +++ /dev/null @@ -1,9 +0,0 @@ -# -# mysqld --help -# ---source include/not_embedded.inc ---source include/not_windows.inc ---source include/have_perfschema.inc - ---source include/mysqld--help.inc - diff --git a/mysql-test/t/mysqld--help-win.test b/mysql-test/t/mysqld--help-win.test deleted file mode 100644 index fca329bfbe6..00000000000 --- a/mysql-test/t/mysqld--help-win.test +++ /dev/null @@ -1,9 +0,0 @@ -# -# mysqld --help -# ---source include/not_embedded.inc ---source include/windows.inc ---source include/have_perfschema.inc - ---source include/mysqld--help.inc - diff --git a/mysql-test/t/mysqld--help.test b/mysql-test/t/mysqld--help.test new file mode 100644 index 00000000000..806e6f7f8d1 --- /dev/null +++ b/mysql-test/t/mysqld--help.test @@ -0,0 +1,60 @@ +# +# mysqld --help +# +--source include/not_embedded.inc +--source include/have_perfschema.inc +--source include/platform.inc + +# +# force lower-case-table-names=1 (linux/macosx have different defaults) +# force symbolic-links=0 (valgrind build has a different default) +# + +exec $MYSQLD_BOOTSTRAP_CMD --symbolic-links=0 --lower-case-table-names=1 --help --verbose > $MYSQL_TMP_DIR/mysqld--help.txt 2>&1; + +# The inline perl code below will copy $MYSQL_TMP_DIR/mysqld--help.txt +# to output, but filter away some variable stuff (e.g. paths). + +perl; + # Variables which we don't want to display in the result file since + # their paths may vary: + @skipvars=qw/basedir open-files-limit general-log-file log plugin-dir + log-slow-queries pid-file slow-query-log-file log-basename + datadir slave-load-tmpdir tmpdir socket/; + + # Plugins which may or may not be there: + @plugins=qw/innodb ndb archive blackhole federated partition ndbcluster feedback debug temp-pool ssl des-key-file + xtradb thread-concurrency super-large-pages mutex-deadlock-detector null-audit maria aria pbxt oqgraph sphinx thread-handling thread-pool/; + + # And substitute the content some environment variables with their + # names: + @env=qw/MYSQLTEST_VARDIR MYSQL_TEST_DIR MYSQL_CHARSETSDIR MYSQL_SHAREDIR/; + + $re1=join('|', @skipvars, @plugins); + $re2=join('|', @plugins); + $skip=0; + open(F, '<', "$ENV{MYSQL_TMP_DIR}/mysqld--help.txt") or die; + while () { + next if 1../The following groups are read/; + # formatting, skip line consisting entirely of dashes and blanks + next if /^[\- ]+\s?$/; + next if /Value \(after reading options\)/; # skip table header + next if /^($re1) /; + next if /^($re2)-/; + $skip=0 if /^ -/ or /^$/; + $skip=1 if / --($re2)\b/; + y!\\!/!; + s/[ ]+/ /; # squeeze spaces to remove table formatting + # fixes for 32-bit + s/\b4294967295\b/18446744073709551615/; + s/\b2146435072\b/9223372036853727232/; + s/\b196608\b/262144/; + s/\b4294963200\b/18446744073709547520/; + foreach $var (@env) { s/$ENV{$var}/$var/ } + next if /use --skip-(use-)?symbolic-links to disable/; # for valgrind, again + next if $skip; + print; + } + close F; +EOF + -- cgit v1.2.1