mysqld--help.result 57.9 KB
Newer Older
1
The following options may be given as the first argument:
2 3 4 5
--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.
6

7 8 9 10 11 12 13 14 15 16 17 18
 --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
19
 --autocommit        Set default value for autocommit (0 or 1)
20
 (Defaults to on; use --skip-autocommit to disable.)
21 22 23 24 25 26 27 28 29 30 31
 --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.
Sergei Golubchik's avatar
Sergei Golubchik committed
32
 --binlog-annotate-row-events 
Sergei Golubchik's avatar
Sergei Golubchik committed
33 34
 Tells the master to annotate RBR events with the
 statement that caused these events
35
 --binlog-cache-size=# 
36 37 38 39
 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
Sergei Golubchik's avatar
Sergei Golubchik committed
40 41
 --binlog-checksum=name 
 Type of BINLOG_CHECKSUM_ALG. Include checksum for log
42
 events in the binary log. One of: NONE, CRC32
43 44 45 46 47 48 49 50 51 52 53
 --binlog-commit-wait-count=# 
 If non-zero, binlog write will wait at most
 binlog_commit_wait_usec microseconds for at least this
 many commits to queue up for group commit to the binlog.
 This can reduce I/O on the binlog and provide increased
 opportunity for parallel apply on the slave, but too high
 a value will decrease commit throughput.
 --binlog-commit-wait-usec=# 
 Maximum time, in microseconds, to wait for more commits
 to queue up for binlog group commit. Only takes effect if
 the value of binlog_commit_wait_count is non-zero.
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
54 55 56 57 58 59 60 61
 --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.
62 63 64 65 66 67 68 69 70 71 72
 --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
73
 automatically used.
74 75
 --binlog-ignore-db=name 
 Tells the master that updates to the given database
76
 should not be logged to the binary log.
Sergei Golubchik's avatar
Sergei Golubchik committed
77 78 79 80 81 82 83 84 85
 --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.)
86 87 88 89
 --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.
90 91 92 93 94
 --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
95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
 --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 
113
 The transaction completion type. One of: NO_CHAIN, CHAIN,
114 115
 RELEASE
 --concurrent-insert[=name] 
116 117
 Use concurrent insert with MyISAM. One of: NEVER, AUTO, 
 ALWAYS
118
 --console           Write error output on screen; don't remove the console
119 120 121 122 123 124
 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)
125 126 127 128 129 130 131 132 133 134
 --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)
135
 --default-regex-flags=name 
136 137
 Default flags for the regex library. Any combination of: 
 DOTALL, DUPNAMES, EXTENDED, EXTRA, MULTILINE, UNGREEDY
138 139 140 141
 --default-storage-engine=name 
 The default storage engine for new tables
 --default-time-zone=name 
 Set the default time zone.
142 143 144
 --default-tmp-storage-engine=name 
 The default storage engine for user-created temporary
 tables
145 146 147
 --default-week-format=# 
 The default week format used by WEEK() functions
 --delay-key-write[=name] 
148
 Type of DELAY_KEY_WRITE. One of: OFF, ON, ALL
149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164
 --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
Monty's avatar
Monty committed
165 166 167 168 169 170 171
 --encrypt-tmp-disk-tables 
 Encrypt tmp disk tables (created as part of query
 execution)
 --encryption-algorithm=name 
 Which encryption algorithm to use for table encryption.
 aes_cbc is the recommended one.. One of: none, aes_ecb, 
 aes_cbc, aes_ctr
172 173 174 175
 --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)
176 177 178 179
 --expensive-subquery-limit=# 
 The maximum number of rows a subquery may examine in
 order to be executed during optimization and used for
 constant optimization
180 181 182 183 184 185 186 187
 --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.
188 189 190 191 192
 --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
193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208
 --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
Sergei Golubchik's avatar
Sergei Golubchik committed
209
 --gdb               Set up signals usable for debugging. Deprecated, use
210
 --general-log       Log connections and queries to a table or log file.
211
 Defaults logging to a file 'hostname'.log or a table
212 213 214
 mysql.general_logif --log-output=TABLE is used
 --general-log-file=name 
 Log connections and queries to given file
215 216 217 218
 --getopt-prefix-matching 
 Recognize command-line options by their unambiguos
 prefixes.
 (Defaults to on; use --skip-getopt-prefix-matching to disable.)
219 220 221
 --group-concat-max-len=# 
 The maximum length of the result of function 
 GROUP_CONCAT()
unknown's avatar
unknown committed
222 223 224 225 226 227
 --gtid-domain-id=#  Used with global transaction ID to identify logically
 independent replication streams. When events can
 propagate through multiple parallel paths (for example
 multiple masters), each independent source server must
 use a distinct domain_id. For simple tree-shaped
 replication topologies, it can be left at its default, 0.
228 229 230 231 232 233 234 235 236 237
 --gtid-ignore-duplicates 
 When set, different master connections in multi-source
 replication are allowed to receive and process event
 groups with the same GTID (when using GTID mode). Only
 one will be applied, any others will be ignored. Within a
 given replication domain, just the sequence number will
 be used to decide whether a given GTID has been already
 applied; this means it is the responsibility of the user
 to ensure that GTID sequence numbers are strictly
 increasing.
238 239 240 241
 --gtid-strict-mode  Enforce strict seq_no ordering of events in the binary
 log. Slave stops with an error if it encounters an event
 that would cause it to generate an out-of-order binlog if
 executed.
242
 -?, --help          Display this help and exit.
243 244
 --histogram-size=#  Number of bytes used for a histogram. If set to 0, no
 histograms are created by ANALYZE.
245 246 247 248 249
 --histogram-type=name 
 Specifies type of the histograms created by ANALYZE.
 Possible values are: SINGLE_PREC_HB - single precision
 height-balanced, DOUBLE_PREC_HB - double precision
 height-balanced.
250
 --host-cache-size=# How many host names should be cached to avoid resolving.
251 252
 --ignore-builtin-innodb 
 Disable initialization of builtin InnoDB plugin
Sergei Golubchik's avatar
Sergei Golubchik committed
253 254 255 256
 --ignore-db-dirs=name 
 Specifies a directory to add to the ignore list when
 collecting database names from the datadir. Put a blank
 argument to reset the list accumulated so far.
257
 --init-connect=name Command(s) that are executed for each new connection
Sergei Golubchik's avatar
Sergei Golubchik committed
258
 (unless the user has SUPER privilege)
259 260
 --init-file=name    Read SQL commands from this file at startup
 --init-rpl-role=name 
261
 Set the replication role. One of: MASTER, SLAVE
262 263 264 265 266 267
 --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=# 
Sergei Golubchik's avatar
Sergei Golubchik committed
268 269 270 271
 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
272 273 274 275
 --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
276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292
 --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
293 294 295 296 297
 --key-cache-file-hash-size=# 
 Number of hash buckets for open and changed files.  If
 you have a lot of MyISAM files open you should increase
 this for faster flush of changes. A good value is
 probably 1/10 of number of possible open MyISAM files.
298 299
 --key-cache-segments=# 
 The number of segments in a key cache
300 301 302 303 304 305 306 307 308 309 310
 -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.)
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
311 312 313
 --lock-wait-timeout=# 
 Timeout in seconds to wait for a lock before returning an
 error.
Sergei Golubchik's avatar
Sergei Golubchik committed
314 315
 --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
316 317
 the only option you need for specifying log files. Sets
 names for --log-bin, --log-bin-index, --relay-log,
Sergei Golubchik's avatar
Sergei Golubchik committed
318
 --relay-log-index, --general-log-file,
319
 --log-slow-query-log-file, --log-error-file, and
Sergei Golubchik's avatar
Sergei Golubchik committed
320 321 322
 --pid-file
 --log-bin[=name]    Log update queries in binary format. Optional argument
 should be name for binary log. If not given
323 324 325
 '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
Sergei Golubchik's avatar
Sergei Golubchik committed
326
 specify a filename to ensure that replication doesn't
327
 stop if the real hostname of the computer changes.
328 329 330 331 332 333 334 335 336 337 338
 --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
Sergei Golubchik's avatar
Sergei Golubchik committed
339 340
 --log-error[=name]  Log errors to file (instead of stdout).  If file name is
 not specified then 'datadir'/'log-basename'.err or the
341
 'pid-file' path with extension .err is used
342
 --log-isam[=name]   Log all MyISAM changes to file.
343 344
 --log-output=name   How logs should be written. Any combination of: NONE, 
 FILE, TABLE
345 346 347 348 349 350 351 352 353 354 355
 --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.
356
 --log-slow-filter=name 
357 358 359
 Log only certain types of queries. Any combination of: 
 admin, filesort, filesort_on_disk, full_join, full_scan, 
 query_cache, query_cache_miss, tmp_table, 
360 361 362 363 364
 tmp_table_on_disk
 --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
365 366 367
 --log-slow-slave-statements 
 Log slow statements executed by slave thread to the slow
 log if it is open.
368
 --log-slow-verbosity=name 
369 370
 Verbosity level for the slow log. Any combination of: 
 innodb, query_plan, explain
371 372
 --log-tc=name       Path to transaction coordinator log (used for
 transactions that affect more than one storage engine,
373
 when binary log is disabled).
374 375
 --log-tc-size=#     Size of transaction coordinator log.
 -W, --log-warnings[=#] 
Sergei Golubchik's avatar
Sergei Golubchik committed
376 377 378
 Log some not critical warnings to the general log
 file.Value can be between 0 and 11. Higher values mean
 more verbosity
379 380 381 382 383 384 385 386 387 388 389 390
 --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
Sergei Golubchik's avatar
Sergei Golubchik committed
391
 master's binlogs. Defaults to master.info
392 393 394
 --master-retry-count=# 
 The number of tries the slave will make to connect to the
 master before giving up.
Sergei Golubchik's avatar
Sergei Golubchik committed
395 396 397 398
 --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
399 400 401
 --max-allowed-packet=# 
 Max packet length to send to or receive from the server
 --max-binlog-cache-size=# 
402
 Sets the total size of the transactional cache
403
 --max-binlog-size=# Binary log will be rotated automatically when the size
404
 exceeds this value.
405 406
 --max-binlog-stmt-cache-size=# 
 Sets the total size of the statement cache
407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422
 --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
423 424 425 426
 --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.
427 428 429
 --max-prepared-stmt-count=# 
 Maximum number of prepared statements in the server
 --max-relay-log-size=# 
430
 relay log will be rotated automatically when the size
Sergei Golubchik's avatar
Sergei Golubchik committed
431
 exceeds this value.  If 0 at startup, it's set to
432
 max_binlog_size
433 434 435 436 437 438 439 440
 --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
Monty's avatar
Monty committed
441 442 443 444 445
 --max-statement-time=# 
 A SELECT query that have taken more than
 max_statement_time seconds will be aborted. The argument
 will be treated as a decimal value with microsecond
 precision.  A value of 0 (default) means no timeout
446
 --max-tmp-tables=#  Unused, will be removed.
447 448 449 450 451 452 453
 --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.
454
 --metadata-locks-cache-size=# 
455
 Unused
456 457
 --metadata-locks-hash-instances=# 
 Number of metadata locks hash instances
458 459 460
 --min-examined-row-limit=# 
 Don't write queries to slow log that examine fewer rows
 than that
461
 --mrr-buffer-size=# Size of buffer to use when using MRR with range access
Sergei Golubchik's avatar
Sergei Golubchik committed
462 463
 --multi-range-count=# 
 Ignored. Use mrr_buffer_size instead
464 465 466 467 468 469 470 471 472 473 474
 --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] 
475 476 477
 Specifies how corrupted tables should be automatically
 repaired. Any combination of: DEFAULT, BACKUP, FORCE, 
 QUICK, BACKUP_ALL, OFF
478 479 480 481 482 483 484 485 486 487 488 489 490 491
 --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
492 493 494 495
 --mysql56-temporal-format 
 Use MySQL-5.6 (instead of MariaDB-5.3) format for TIME,
 DATETIME, TIMESTAMP columns.
 (Defaults to on; use --skip-mysql56-temporal-format to disable.)
496 497 498 499 500 501 502 503 504 505
 --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
506 507
 --old               Use compatible behavior from previous MariaDB version.
 See also --old-mode
508
 --old-alter-table   Use old, non-optimized alter table
509
 --old-mode=name     Used to emulate old behavior from earlier MariaDB or
510 511 512
 MySQL versions. Any combination of: 
 NO_DUP_KEY_WARNINGS_WITH_IGNORE, NO_PROGRESS_INFO, 
 ZERO_DATE_TIME_CAST
513 514 515
 --old-passwords     Use old password encryption method (needed for 4.0 and
 older clients)
 --old-style-user-limits 
516 517 518
 Enable old-style user limits (before 5.0.3, user
 resources were counted per each user+host vs. per
 account).
519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538
 --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
539 540 541
 optimizer will switch to the original find_best search.
 NOTE: The value 63 and its associated behaviour is
 deprecated
unknown's avatar
unknown committed
542 543 544
 --optimizer-selectivity-sampling-limit=# 
 Controls number of record samples to check condition
 selectivity
545
 --optimizer-switch=name 
546 547 548 549 550 551 552 553 554 555 556 557 558 559
 Fine-tune the optimizer behavior. Takes a comma-separated
 list of option=value pairs, where value is on, off, or
 default, and options are: index_merge, index_merge_union,
 index_merge_sort_union, index_merge_intersection, 
 index_merge_sort_intersection, engine_condition_pushdown,
 index_condition_pushdown, derived_merge, 
 derived_with_keys, firstmatch, loosescan, materialization,
 in_to_exists, semijoin, partial_match_rowid_merge, 
 partial_match_table_scan, subquery_cache, mrr, 
 mrr_cost_based, mrr_sort_keys, outer_join_with_cache, 
 semijoin_with_cache, join_cache_incremental, 
 join_cache_hashed, join_cache_bka, 
 optimize_join_buffer_size, table_elimination, 
 extended_keys, exists_to_in
Igor Babaev's avatar
Igor Babaev committed
560 561 562 563 564
 --optimizer-use-condition-selectivity=# 
 Controls selectivity of which conditions the optimizer
 takes into account to calculate cardinality of a partial
 join when it searches for the best execution plan
 Meaning: 1 - use selectivity of index backed range
565
 conditions to calculate the cardinality of a partial join
Igor Babaev's avatar
Igor Babaev committed
566
 if the last joined table is accessed by full table scan
567 568 569 570 571 572 573
 or an index scan, 2 - use selectivity of index backed
 range conditions to calculate the cardinality of a
 partial join in any case, 3 - additionally always use
 selectivity of range conditions that are not backed by
 any index to calculate the cardinality of a partial join,
 4 - use histograms to calculate selectivity of range
 conditions that are not backed by any index to calculate
unknown's avatar
unknown committed
574 575 576
 the cardinality of a partial join.5 - additionally use
 selectivity of certain non-range predicates calculated on
 record samples
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
577 578
 --performance-schema 
 Enable the performance schema.
Michael Widenius's avatar
Michael Widenius committed
579
 --performance-schema-accounts-size=# 
580 581
 Maximum number of instrumented user@host accounts. Use 0
 to disable, -1 for automated sizing.
Michael Widenius's avatar
Michael Widenius committed
582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621
 --performance-schema-consumer-events-stages-current 
 Default startup value for the events_stages_current
 consumer.
 --performance-schema-consumer-events-stages-history 
 Default startup value for the events_stages_history
 consumer.
 --performance-schema-consumer-events-stages-history-long 
 Default startup value for the events_stages_history_long
 consumer.
 --performance-schema-consumer-events-statements-current 
 Default startup value for the events_statements_current
 consumer.
 (Defaults to on; use --skip-performance-schema-consumer-events-statements-current to disable.)
 --performance-schema-consumer-events-statements-history 
 Default startup value for the events_statements_history
 consumer.
 --performance-schema-consumer-events-statements-history-long 
 Default startup value for the
 events_statements_history_long consumer.
 --performance-schema-consumer-events-waits-current 
 Default startup value for the events_waits_current
 consumer.
 --performance-schema-consumer-events-waits-history 
 Default startup value for the events_waits_history
 consumer.
 --performance-schema-consumer-events-waits-history-long 
 Default startup value for the events_waits_history_long
 consumer.
 --performance-schema-consumer-global-instrumentation 
 Default startup value for the global_instrumentation
 consumer.
 (Defaults to on; use --skip-performance-schema-consumer-global-instrumentation to disable.)
 --performance-schema-consumer-statements-digest 
 Default startup value for the statements_digest consumer.
 (Defaults to on; use --skip-performance-schema-consumer-statements-digest to disable.)
 --performance-schema-consumer-thread-instrumentation 
 Default startup value for the thread_instrumentation
 consumer.
 (Defaults to on; use --skip-performance-schema-consumer-thread-instrumentation to disable.)
 --performance-schema-digests-size=# 
622 623
 Size of the statement digest. Use 0 to disable, -1 for
 automated sizing.
Michael Widenius's avatar
Michael Widenius committed
624
 --performance-schema-events-stages-history-long-size=# 
625 626
 Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to
 disable, -1 for automated sizing.
Michael Widenius's avatar
Michael Widenius committed
627
 --performance-schema-events-stages-history-size=# 
628 629
 Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0
 to disable, -1 for automated sizing.
Michael Widenius's avatar
Michael Widenius committed
630
 --performance-schema-events-statements-history-long-size=# 
631 632
 Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. Use 0
 to disable, -1 for automated sizing.
Michael Widenius's avatar
Michael Widenius committed
633 634
 --performance-schema-events-statements-history-size=# 
 Number of rows per thread in EVENTS_STATEMENTS_HISTORY.
635
 Use 0 to disable, -1 for automated sizing.
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
636
 --performance-schema-events-waits-history-long-size=# 
637 638
 Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to
 disable, -1 for automated sizing.
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
639
 --performance-schema-events-waits-history-size=# 
640 641
 Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0
 to disable, -1 for automated sizing.
Michael Widenius's avatar
Michael Widenius committed
642
 --performance-schema-hosts-size=# 
643 644
 Maximum number of instrumented hosts. Use 0 to disable,
 -1 for automated sizing.
Michael Widenius's avatar
Michael Widenius committed
645 646 647
 --performance-schema-instrument[=name] 
 Default startup value for a performance schema
 instrument.
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
648 649 650
 --performance-schema-max-cond-classes=# 
 Maximum number of condition instruments.
 --performance-schema-max-cond-instances=# 
651 652
 Maximum number of instrumented condition objects. Use 0
 to disable, -1 for automated sizing.
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
653 654 655 656 657
 --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=# 
658 659
 Maximum number of instrumented files. Use 0 to disable,
 -1 for automated sizing.
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
660 661 662
 --performance-schema-max-mutex-classes=# 
 Maximum number of mutex instruments.
 --performance-schema-max-mutex-instances=# 
663 664
 Maximum number of instrumented MUTEX objects. Use 0 to
 disable, -1 for automated sizing.
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
665 666 667
 --performance-schema-max-rwlock-classes=# 
 Maximum number of rwlock instruments.
 --performance-schema-max-rwlock-instances=# 
668 669
 Maximum number of instrumented RWLOCK objects. Use 0 to
 disable, -1 for automated sizing.
Michael Widenius's avatar
Michael Widenius committed
670 671 672
 --performance-schema-max-socket-classes=# 
 Maximum number of socket instruments.
 --performance-schema-max-socket-instances=# 
673 674
 Maximum number of opened instrumented sockets. Use 0 to
 disable, -1 for automated sizing.
Michael Widenius's avatar
Michael Widenius committed
675 676 677 678
 --performance-schema-max-stage-classes=# 
 Maximum number of stage instruments.
 --performance-schema-max-statement-classes=# 
 Maximum number of statement instruments.
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
679
 --performance-schema-max-table-handles=# 
680 681
 Maximum number of opened instrumented tables. Use 0 to
 disable, -1 for automated sizing.
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
682
 --performance-schema-max-table-instances=# 
683 684
 Maximum number of instrumented tables. Use 0 to disable,
 -1 for automated sizing.
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
685 686 687
 --performance-schema-max-thread-classes=# 
 Maximum number of thread instruments.
 --performance-schema-max-thread-instances=# 
688 689 690 691 692
 Maximum number of instrumented threads. Use 0 to disable,
 -1 for automated sizing.
 --performance-schema-session-connect-attrs-size=# 
 Size of session attribute string buffer per thread. Use 0
 to disable, -1 for automated sizing.
Michael Widenius's avatar
Michael Widenius committed
693 694 695 696 697
 --performance-schema-setup-actors-size=# 
 Maximum number of rows in SETUP_ACTORS.
 --performance-schema-setup-objects-size=# 
 Maximum number of rows in SETUP_OBJECTS.
 --performance-schema-users-size=# 
698 699
 Maximum number of instrumented users. Use 0 to disable,
 -1 for automated sizing.
700 701
 --pid-file=name     Pid file used by safe_mysqld
 --plugin-dir=name   Directory for plugins
702 703 704 705
 --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.
706 707
 --plugin-load-add=name 
 Optional semicolon-separated list of plugins to load.
708
 This option adds to the list specified by --plugin-load
709 710
 in an incremental way. It can be specified many times,
 adding more plugins every time.
711
 --plugin-maturity=name 
712 713 714
 The lowest desirable plugin maturity. Plugins less mature
 than that will not be installed or loaded. One of: 
 unknown, experimental, alpha, beta, gamma, stable
715 716 717 718 719
 -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
720
 free. (Default: No wait).
721 722 723 724 725
 --preload-buffer-size=# 
 The size of the buffer that is allocated when preloading
 indexes
 --profiling-history-size=# 
 Limit of query profiling memory
Sergei Golubchik's avatar
Sergei Golubchik committed
726 727 728 729
 --progress-report-time=# 
 Seconds between sending progress reports to the client
 for time-consuming statements. Set to 0 to disable
 progress reporting.
730 731 732 733 734 735 736 737
 --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
Sergei Golubchik's avatar
Sergei Golubchik committed
738 739 740
 --query-cache-strip-comments 
 Strip all comments from a query before storing it in the
 query cache
741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761
 --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
762
 are read through this buffer to avoid a disk seeks
763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779
 --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
Sergei Golubchik's avatar
Sergei Golubchik committed
780
 --replicate-annotate-row-events 
781
 Tells the slave to write annotate rows events received
Sergei Golubchik's avatar
Sergei Golubchik committed
782 783
 from the master to its own binary log. Ignored if
 log_slave_updates is not set
784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799
 --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.
800 801 802 803 804 805 806 807
 --replicate-events-marked-for-skip=name 
 Whether the slave should replicate events that were
 created with @@skip_replication=1 on the master. Default
 REPLICATE (no events are skipped). Other values are
 FILTER_ON_SLAVE (events will be sent by the master but
 ignored by the slave) and FILTER_ON_MASTER (events marked
 with @@skip_replication=1 will be filtered on the master
 and never be sent to the slave).
808 809 810 811 812 813 814 815 816 817 818 819
 --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
820
 work for cross-database updates, in contrast to
821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867
 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
868 869 870
 --rowid-merge-buff-size=# 
 The size of the buffers used [NOT] IN evaluation via
 partial matching
871
 --safe-mode         Skip some optimize stages (for testing). Deprecated.
872 873 874 875 876 877 878 879 880 881
 --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 
882 883
 Show user and password in SHOW SLAVE HOSTS on this
 master.
884 885
 --skip-bdb          Deprecated option; Exist only for compatiblity with old
 my.cnf files
886
 --skip-grant-tables Start without grant tables. This gives all users FULL
887
 ACCESS to all tables.
888 889 890 891 892 893 894 895 896
 --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.
 --slave-compressed-protocol 
 Use compression on master/slave protocol
897
 --slave-ddl-exec-mode=name 
898 899 900 901 902 903
 How replication events should be executed. Legal values
 are STRICT and IDEMPOTENT (default). In IDEMPOTENT mode,
 replication will not stop for DDL operations that are
 idempotent. This means that CREATE TABLE is treated as
 CREATE TABLE OR REPLACE and DROP TABLE is treated as DROP
 TABLE IF EXISTS.
unknown's avatar
unknown committed
904 905 906 907 908 909 910 911
 --slave-domain-parallel-threads=# 
 Maximum number of parallel threads to use on slave for
 events in a single replication domain. When using
 multiple domains, this can be used to limit a single
 domain from grabbing all threads and thus stalling other
 domains. The default of 0 means to allow a domain to grab
 as many threads as it wants, up to the value of
 slave_parallel_threads.
912
 --slave-exec-mode=name 
913 914 915 916 917 918 919
 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. For example, in row based replication
 attempts to delete rows that doesn't exist will be
 ignored. In STRICT mode, replication will stop on any
 unexpected difference between the master and the slave
920 921 922
 --slave-load-tmpdir=name 
 The location where the slave should put its temporary
 files when replicating a LOAD DATA INFILE command
923 924 925
 --slave-max-allowed-packet=# 
 The maximum packet length to sent successfully from the
 master to slave.
926
 --slave-net-timeout=# 
927
 Number of seconds to wait for more data from any
928
 master/slave connection before aborting the read
unknown's avatar
unknown committed
929 930 931 932 933
 --slave-parallel-max-queued=# 
 Limit on how much memory SQL threads should use per
 parallel replication thread when reading ahead in the
 relay log looking for opportunities for parallel
 replication. Only used when --slave-parallel-threads > 0.
934 935
 --slave-parallel-mode=name 
 Controls what transactions are applied in parallel when
936 937 938 939 940 941 942 943
 using --slave-parallel-threads. Possible values:
 "optimistic" tries to apply most transactional DML in
 parallel, and handles any conflicts with rollback and
 retry. "conservative" limits parallelism in an effort to
 avoid any conflicts. "aggressive" tries to maximise the
 parallelism, possibly at the cost of increased conflict
 rate. "minimal" only parallelizes the commit steps of
 transactions. "none" disables parallel apply completely.
944
 --slave-parallel-threads=# 
945 946 947 948 949 950
 If non-zero, number of threads to spawn to apply in
 parallel events on the slave that were group-committed on
 the master or were logged with GTID in different
 replication domains. Note that these threads are in
 addition to the IO and SQL threads, which are always
 created by a replication slave
951 952 953 954 955 956 957 958 959
 --slave-run-triggers-for-rbr=name 
 Modes for how triggers in row-base replication on slave
 side will be executed. Legal values are NO (default), YES
 and LOGGING. NO means that trigger for RBR will not be
 running on slave. YES and LOGGING means that triggers
 will be running on slave, if there was not triggers
 running on the master for the statement. LOGGING also
 means results of that the executed triggers work will be
 written to the binlog.
960 961 962
 --slave-skip-errors=name 
 Tells the slave thread to continue replication when a
 query event returns an error from the provided list
Sergei Golubchik's avatar
Sergei Golubchik committed
963 964 965 966 967 968
 --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.)
969 970 971 972
 --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
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
973
 --slave-type-conversions=name 
974 975 976 977
 Set of slave type conversions that are enabled. If the
 variable is empty, no conversions are allowed and it is
 expected that the types match exactly. Any combination
 of: ALL_LOSSY, ALL_NON_LOSSY
978 979 980 981 982
 --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
983 984 985
 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
986 987
 --slow-query-log-file=name 
 Log slow queries to given log file. Defaults logging to
988 989
 'hostname'-slow.log. Must be enabled to activate other
 slow log options
990 991 992 993
 --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
994 995 996 997 998 999 1000 1001 1002 1003 1004 1005
 --sql-mode=name     Sets the sql mode. Any combination of: REAL_AS_FLOAT, 
 PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, 
 IGNORE_BAD_TABLE_OPTIONS, ONLY_FULL_GROUP_BY, 
 NO_UNSIGNED_SUBTRACTION, NO_DIR_IN_CREATE, POSTGRESQL, 
 ORACLE, MSSQL, DB2, MAXDB, NO_KEY_OPTIONS, 
 NO_TABLE_OPTIONS, NO_FIELD_OPTIONS, MYSQL323, MYSQL40, 
 ANSI, NO_AUTO_VALUE_ON_ZERO, NO_BACKSLASH_ESCAPES, 
 STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, 
 NO_ZERO_DATE, ALLOW_INVALID_DATES, 
 ERROR_FOR_DIVISION_BY_ZERO, TRADITIONAL, 
 NO_AUTO_CREATE_USER, HIGH_NOT_PRECEDENCE, 
 NO_ENGINE_SUBSTITUTION, PAD_CHAR_TO_FULL_LENGTH
Sergei Golubchik's avatar
Sergei Golubchik committed
1006 1007
 --stack-trace       Print a symbolic stack trace on failure
 (Defaults to on; use --skip-stack-trace to disable.)
1008 1009 1010
 --stored-program-cache=# 
 The soft upper limit for number of cached stored routines
 for one connection.
1011 1012 1013 1014 1015
 --strict-password-validation 
 When password validation plugins are enabled, reject
 passwords that cannot be validated (passwords specified
 as a hash)
 (Defaults to on; use --skip-strict-password-validation to disable.)
1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040
 -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 
1041 1042
 Decision to use in heuristic recover process. One of: 
 COMMIT, ROLLBACK
1043 1044
 --thread-cache-size=# 
 How many threads we should keep in a cache for reuse
1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063
 --thread-pool-idle-timeout=# 
 Timeout in seconds for an idle thread in the thread
 pool.Worker thread will be shut down after timeout
 --thread-pool-max-threads=# 
 Maximum allowed number of worker threads in the thread
 pool
 --thread-pool-oversubscribe=# 
 How many additional active worker threads in a group are
 allowed.
 --thread-pool-size=# 
 Number of thread groups in the pool. This parameter is
 roughly equivalent to maximum number of concurrently
 executing threads (threads in a waiting state do not
 count as executing).
 --thread-pool-stall-limit=# 
 Maximum query execution time in milliseconds,before an
 executing non-yielding thread is considered stalled.If a
 worker thread is stalled, additional worker thread may be
 created to handle remaining clients.
1064 1065
 --thread-stack=#    The stack size for each thread
 --time-format=name  The TIME format (ignored)
1066 1067
 --timed-mutexes     Specify whether to time mutexes. Deprecated, has no
 effect.
1068 1069
 --tmp-table-size=#  If an internal in-memory temporary table exceeds this
 size, MySQL will automatically convert it to an on-disk
1070
 MyISAM or Aria table
1071 1072 1073 1074 1075 1076 1077
 -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 
1078 1079 1080
 Default transaction isolation level. One of: 
 READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, 
 SERIALIZABLE
1081 1082 1083
 --transaction-prealloc-size=# 
 Persistent buffer for transactions to be stored in binary
 log
Michael Widenius's avatar
Michael Widenius committed
1084 1085 1086
 --transaction-read-only 
 Default transaction access mode. True if transactions are
 read-only.
1087 1088 1089 1090 1091 1092 1093
 --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)
1094
 --use-stat-tables=name 
1095 1096
 Specifies how to use system statistics tables. One of: 
 NEVER, COMPLEMENTARY, PREFERABLY
1097
 -u, --user=name     Run mysqld daemon as user.
1098 1099 1100
 --userstat          Enables statistics gathering for USER_STATISTICS,
 CLIENT_STATISTICS, INDEX_STATISTICS and TABLE_STATISTICS
 tables in the INFORMATION_SCHEMA
1101
 -v, --verbose       Used with --help option for detailed help.
1102 1103 1104
 -V, --version       Output version information and exit.
 --wait-timeout=#    The number of seconds the server waits for activity on a
 connection before closing it
1105 1106

Variables (--variable-name=value)
1107 1108 1109
allow-suspicious-udfs FALSE
auto-increment-increment 1
auto-increment-offset 1
1110
autocommit TRUE
1111
automatic-sp-privileges TRUE
1112
back-log 150
1113 1114
big-tables FALSE
bind-address (No default value)
Sergei Golubchik's avatar
Sergei Golubchik committed
1115
binlog-annotate-row-events FALSE
1116
binlog-cache-size 32768
Sergei Golubchik's avatar
Sergei Golubchik committed
1117
binlog-checksum NONE
1118 1119
binlog-commit-wait-count 0
binlog-commit-wait-usec 100000
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
1120
binlog-direct-non-transactional-updates FALSE
1121
binlog-format STATEMENT
Sergei Golubchik's avatar
Sergei Golubchik committed
1122
binlog-optimize-thread-scheduling TRUE
1123
binlog-row-event-max-size 1024
1124
binlog-stmt-cache-size 32768
1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136
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
console FALSE
date-format %Y-%m-%d
datetime-format %Y-%m-%d %H:%i:%s
1137 1138 1139 1140
deadlock-search-depth-long 15
deadlock-search-depth-short 4
deadlock-timeout-long 50000000
deadlock-timeout-short 10000
1141
default-regex-flags 
1142
default-storage-engine myisam
1143
default-time-zone (No default value)
1144
default-tmp-storage-engine (No default value)
1145 1146 1147 1148 1149 1150
default-week-format 0
delay-key-write ON
delayed-insert-limit 100
delayed-insert-timeout 300
delayed-queue-size 1000
div-precision-increment 4
Monty's avatar
Monty committed
1151 1152
encrypt-tmp-disk-tables FALSE
encryption-algorithm none
1153
event-scheduler OFF
1154
expensive-subquery-limit 100
1155 1156
expire-logs-days 0
external-locking FALSE
1157 1158
extra-max-connections 1
extra-port 0
1159 1160 1161 1162 1163 1164 1165 1166 1167
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
1168
getopt-prefix-matching TRUE
1169
group-concat-max-len 1024
unknown's avatar
unknown committed
1170
gtid-domain-id 0
1171
gtid-ignore-duplicates FALSE
1172
gtid-strict-mode FALSE
1173
help TRUE
1174
histogram-size 0
1175
histogram-type SINGLE_PREC_HB
1176
host-cache-size 128
1177
ignore-builtin-innodb FALSE
Sergei Golubchik's avatar
Sergei Golubchik committed
1178
ignore-db-dirs 
1179 1180 1181 1182 1183 1184
init-connect 
init-file (No default value)
init-rpl-role MASTER
init-slave 
interactive-timeout 28800
join-buffer-size 131072
Sergei Golubchik's avatar
Sergei Golubchik committed
1185
join-buffer-space-limit 2097152
Sergei Golubchik's avatar
Sergei Golubchik committed
1186
join-cache-level 2
1187
keep-files-on-create FALSE
1188
key-buffer-size 134217728
1189 1190 1191
key-cache-age-threshold 300
key-cache-block-size 1024
key-cache-division-limit 100
1192
key-cache-file-hash-size 512
1193
key-cache-segments 0
1194 1195 1196 1197 1198
large-pages FALSE
lc-messages en_US
lc-messages-dir MYSQL_SHAREDIR/
lc-time-names en_US
local-infile TRUE
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
1199
lock-wait-timeout 31536000
1200 1201 1202 1203 1204 1205 1206 1207 1208 1209
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
1210 1211
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
1212
log-slow-slave-statements FALSE
1213
log-slow-verbosity 
1214 1215 1216 1217 1218 1219 1220
log-tc tc.log
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
Sergei Golubchik's avatar
Sergei Golubchik committed
1221
master-verify-checksum FALSE
1222
max-allowed-packet 1048576
1223 1224
max-binlog-cache-size 18446744073709547520
max-binlog-size 1073741824
1225
max-binlog-stmt-cache-size 18446744073709547520
1226
max-connect-errors 100
1227 1228 1229 1230 1231 1232
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
1233
max-long-data-size 1048576
1234
max-prepared-stmt-count 16382
1235
max-relay-log-size 1073741824
1236 1237 1238
max-seeks-for-key 18446744073709551615
max-sort-length 1024
max-sp-recursion-depth 0
Monty's avatar
Monty committed
1239
max-statement-time 0
1240 1241 1242 1243
max-tmp-tables 32
max-user-connections 0
max-write-lock-count 18446744073709551615
memlock FALSE
1244
metadata-locks-cache-size 1024
1245
metadata-locks-hash-instances 8
1246
min-examined-row-limit 0
1247
mrr-buffer-size 262144
Sergei Golubchik's avatar
Sergei Golubchik committed
1248
multi-range-count 256
1249 1250 1251 1252
myisam-block-size 1024
myisam-data-pointer-size 6
myisam-max-sort-file-size 9223372036853727232
myisam-mmap-size 18446744073709551615
1253
myisam-recover-options DEFAULT
1254
myisam-repair-threads 1
1255
myisam-sort-buffer-size 134216704
1256
myisam-stats-method NULLS_UNEQUAL
1257
myisam-use-mmap FALSE
1258
mysql56-temporal-format TRUE
1259 1260 1261 1262 1263 1264
net-buffer-length 16384
net-read-timeout 30
net-retry-count 10
net-write-timeout 60
old FALSE
old-alter-table FALSE
1265
old-mode 
1266 1267 1268 1269
old-passwords FALSE
old-style-user-limits FALSE
optimizer-prune-level 1
optimizer-search-depth 62
Igor Babaev's avatar
Igor Babaev committed
1270
optimizer-selectivity-sampling-limit 100
1271
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,extended_keys=on,exists_to_in=on
Igor Babaev's avatar
Igor Babaev committed
1272
optimizer-use-condition-selectivity 1
1273 1274
performance-schema FALSE
performance-schema-accounts-size -1
Michael Widenius's avatar
Michael Widenius committed
1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286
performance-schema-consumer-events-stages-current FALSE
performance-schema-consumer-events-stages-history FALSE
performance-schema-consumer-events-stages-history-long FALSE
performance-schema-consumer-events-statements-current TRUE
performance-schema-consumer-events-statements-history FALSE
performance-schema-consumer-events-statements-history-long FALSE
performance-schema-consumer-events-waits-current FALSE
performance-schema-consumer-events-waits-history FALSE
performance-schema-consumer-events-waits-history-long FALSE
performance-schema-consumer-global-instrumentation TRUE
performance-schema-consumer-statements-digest TRUE
performance-schema-consumer-thread-instrumentation TRUE
1287 1288 1289 1290 1291 1292 1293 1294
performance-schema-digests-size -1
performance-schema-events-stages-history-long-size -1
performance-schema-events-stages-history-size -1
performance-schema-events-statements-history-long-size -1
performance-schema-events-statements-history-size -1
performance-schema-events-waits-history-long-size -1
performance-schema-events-waits-history-size -1
performance-schema-hosts-size -1
Michael Widenius's avatar
Michael Widenius committed
1295
performance-schema-instrument 
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
1296
performance-schema-max-cond-classes 80
1297
performance-schema-max-cond-instances -1
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
1298 1299
performance-schema-max-file-classes 50
performance-schema-max-file-handles 32768
1300
performance-schema-max-file-instances -1
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
1301
performance-schema-max-mutex-classes 200
1302
performance-schema-max-mutex-instances -1
1303
performance-schema-max-rwlock-classes 40
1304
performance-schema-max-rwlock-instances -1
Michael Widenius's avatar
Michael Widenius committed
1305
performance-schema-max-socket-classes 10
1306
performance-schema-max-socket-instances -1
Michael Widenius's avatar
Michael Widenius committed
1307
performance-schema-max-stage-classes 150
1308
performance-schema-max-statement-classes 178
1309 1310
performance-schema-max-table-handles -1
performance-schema-max-table-instances -1
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
1311
performance-schema-max-thread-classes 50
1312 1313
performance-schema-max-thread-instances -1
performance-schema-session-connect-attrs-size -1
Michael Widenius's avatar
Michael Widenius committed
1314 1315
performance-schema-setup-actors-size 100
performance-schema-setup-objects-size 100
1316
performance-schema-users-size -1
1317
plugin-maturity unknown
1318 1319 1320 1321
port 3306
port-open-timeout 0
preload-buffer-size 32768
profiling-history-size 15
1322
progress-report-time 5
1323
protocol-version 10
1324
query-alloc-block-size 16384
1325 1326 1327
query-cache-limit 1048576
query-cache-min-res-unit 4096
query-cache-size 0
Sergei Golubchik's avatar
Sergei Golubchik committed
1328
query-cache-strip-comments FALSE
1329 1330
query-cache-type ON
query-cache-wlock-invalidate FALSE
1331
query-prealloc-size 24576
1332 1333 1334 1335 1336 1337 1338 1339 1340 1341
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
Sergei Golubchik's avatar
Sergei Golubchik committed
1342
replicate-annotate-row-events FALSE
1343
replicate-events-marked-for-skip REPLICATE
1344 1345 1346
replicate-same-server-id FALSE
report-host (No default value)
report-password (No default value)
1347
report-port 0
1348
report-user (No default value)
1349
rowid-merge-buff-size 8388608
1350 1351 1352 1353 1354 1355
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
1356
skip-name-resolve FALSE
1357 1358 1359 1360
skip-networking FALSE
skip-show-database FALSE
skip-slave-start FALSE
slave-compressed-protocol FALSE
1361
slave-ddl-exec-mode IDEMPOTENT
unknown's avatar
unknown committed
1362
slave-domain-parallel-threads 0
1363
slave-exec-mode STRICT
1364
slave-max-allowed-packet 1073741824
1365
slave-net-timeout 3600
unknown's avatar
unknown committed
1366
slave-parallel-max-queued 131072
1367
slave-parallel-mode conservative
1368
slave-parallel-threads 0
1369
slave-run-triggers-for-rbr NO
1370
slave-skip-errors (No default value)
Sergei Golubchik's avatar
Sergei Golubchik committed
1371
slave-sql-verify-checksum TRUE
1372
slave-transaction-retries 10
Vladislav Vaintroub's avatar
merge  
Vladislav Vaintroub committed
1373
slave-type-conversions 
1374 1375 1376 1377
slow-launch-time 2
slow-query-log FALSE
sort-buffer-size 2097152
sql-mode 
Sergei Golubchik's avatar
Sergei Golubchik committed
1378
stack-trace TRUE
1379
stored-program-cache 256
1380
strict-password-validation TRUE
1381 1382
symbolic-links FALSE
sync-binlog 0
1383
sync-frm FALSE
1384 1385 1386 1387 1388 1389 1390 1391 1392
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
1393
thread-pool-idle-timeout 60
1394
thread-pool-max-threads 1000
1395 1396
thread-pool-oversubscribe 3
thread-pool-stall-limit 500
1397
thread-stack 294912
1398 1399 1400 1401 1402 1403
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
Michael Widenius's avatar
Michael Widenius committed
1404
transaction-read-only FALSE
1405
updatable-views-with-limit YES
1406
use-stat-tables NEVER
1407
userstat FALSE
1408 1409
verbose TRUE
wait-timeout 28800
1410 1411 1412

To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --verbose --help'.