1The following options may be given as the first argument: 2--print-defaults Print the program argument list and exit. 3--no-defaults Don't read default options from any option file, 4 except for login file. 5--defaults-file=# Only read default options from the given file #. 6--defaults-extra-file=# Read this file after the global files are read. 7--defaults-group-suffix=# 8 Also read groups with concat(group, suffix) 9--login-path=# Read this path from the login file. 10 11 --abort-slave-event-count=# 12 Option used by mysql-test for debugging and testing of 13 replication. 14 --allow-suspicious-udfs 15 Allows use of UDFs consisting of only one symbol xxx() 16 without corresponding xxx_init() or xxx_deinit(). That 17 also means that one can load any function from any 18 library, for example exit() from libc.so 19 -a, --ansi Use ANSI SQL syntax instead of MySQL syntax. This mode 20 will also set transaction isolation level 'serializable'. 21 --auto-increment-increment[=#] 22 Auto-increment columns are incremented by this 23 --auto-increment-offset[=#] 24 Offset added to Auto-increment columns. Used when 25 auto-increment-increment != 1 26 --autocommit Set default value for autocommit (0 or 1) 27 (Defaults to on; use --skip-autocommit to disable.) 28 --automatic-sp-privileges 29 Creating and dropping stored procedures alters ACLs 30 (Defaults to on; use --skip-automatic-sp-privileges to disable.) 31 --avoid-temporal-upgrade 32 When this option is enabled, the pre-5.6.4 temporal types 33 are not upgraded to the new format for ALTER TABLE 34 requests ADD/CHANGE/MODIFY COLUMN, ADD INDEX or FORCE 35 operation. This variable is deprecated and will be 36 removed in a future release. 37 --back-log=# The number of outstanding connection requests MySQL can 38 have. This comes into play when the main MySQL thread 39 gets very many connection requests in a very short time 40 -b, --basedir=name Path to installation directory. All paths are usually 41 resolved relative to this 42 --big-tables Allow big result sets by saving all temporary sets on 43 file (Solves most 'table full' errors) 44 --bind-address=name IP address to bind to. 45 --binlog-cache-size=# 46 The size of the transactional cache for updates to 47 transactional engines for the binary log. If you often 48 use transactions containing many statements, you can 49 increase this to get more performance 50 --binlog-checksum=name 51 Type of BINLOG_CHECKSUM_ALG. Include checksum for log 52 events in the binary log. Possible values are NONE and 53 CRC32; default is CRC32. 54 --binlog-direct-non-transactional-updates 55 Causes updates to non-transactional engines using 56 statement format to be written directly to binary log. 57 Before using this option make sure that there are no 58 dependencies between transactional and non-transactional 59 tables such as in the statement INSERT INTO t_myisam 60 SELECT * FROM t_innodb; otherwise, slaves may diverge 61 from the master. 62 --binlog-do-db=name Tells the master it should log updates for the specified 63 database, and exclude all others not explicitly 64 mentioned. 65 --binlog-error-action=name 66 When statements cannot be written to the binary log due 67 to a fatal error, the server can either ignore the error 68 and let the master continue, or abort. 69 --binlog-format=name 70 What form of binary logging the master will use: either 71 ROW for row-based binary logging, STATEMENT for 72 statement-based binary logging, or MIXED. MIXED is 73 statement-based binary logging except for those 74 statements where only row-based is correct: those which 75 involve user-defined functions (i.e. UDFs) or the UUID() 76 function; for those, row-based binary logging is 77 automatically used. If NDBCLUSTER is enabled and 78 binlog-format is MIXED, the format switches to row-based 79 and back implicitly per each query accessing an 80 NDBCLUSTER table 81 --binlog-group-commit-sync-delay=# 82 The number of microseconds the server waits for the 83 binary log group commit sync queue to fill before 84 continuing. Default: 0. Min: 0. Max: 1000000. 85 --binlog-group-commit-sync-no-delay-count=# 86 If there are this many transactions in the commit sync 87 queue and the server is waiting for more transactions to 88 be enqueued (as set using 89 --binlog-group-commit-sync-delay), the commit procedure 90 resumes. 91 --binlog-gtid-simple-recovery 92 If this option is enabled, the server does not open more 93 than two binary logs when initializing GTID_PURGED and 94 GTID_EXECUTED, either during server restart or when 95 binary logs are being purged. Enabling this option is 96 useful when the server has already generated many binary 97 logs without GTID events (e.g., having GTID_MODE = OFF). 98 Note: If this option is enabled, GLOBAL.GTID_EXECUTED and 99 GLOBAL.GTID_PURGED may be initialized wrongly in two 100 cases: (1) All binary logs were generated by MySQL 5.7.5 101 or older, and GTID_MODE was ON for some binary logs but 102 OFF for the newest binary log. (2) The oldest existing 103 binary log was generated by MySQL 5.7.5 or older, and SET 104 GTID_PURGED was issued after the oldest binary log was 105 generated. If a wrong set is computed in one of case (1) 106 or case (2), it will remain wrong even if the server is 107 later restarted with this option disabled. 108 (Defaults to on; use --skip-binlog-gtid-simple-recovery to disable.) 109 --binlog-ignore-db=name 110 Tells the master that updates to the given database 111 should not be logged to the binary log. 112 --binlog-max-flush-queue-time=# 113 The maximum time that the binary log group commit will 114 keep reading transactions before it flush the 115 transactions to the binary log (and optionally sync, 116 depending on the value of sync_binlog). 117 --binlog-order-commits 118 Issue internal commit calls in the same order as 119 transactions are written to the binary log. Default is to 120 order commits. 121 (Defaults to on; use --skip-binlog-order-commits to disable.) 122 --binlog-row-event-max-size=# 123 The maximum size of a row-based binary log event in 124 bytes. Rows will be grouped into events smaller than this 125 size if possible. The value has to be a multiple of 256. 126 --binlog-row-image=name 127 Controls whether rows should be logged in 'FULL', 128 'NOBLOB' or 'MINIMAL' formats. 'FULL', means that all 129 columns in the before and after image are logged. 130 'NOBLOB', means that mysqld avoids logging blob columns 131 whenever possible (eg, blob column was not changed or is 132 not part of primary key). 'MINIMAL', means that a PK 133 equivalent (PK columns or full row if there is no PK in 134 the table) is logged in the before image, and only 135 changed columns are logged in the after image. (Default: 136 FULL). 137 --binlog-rows-query-log-events 138 Allow writing of Rows_query_log events into binary log. 139 --binlog-stmt-cache-size=# 140 The size of the statement cache for updates to 141 non-transactional engines for the binary log. If you 142 often use statements updating a great number of rows, you 143 can increase this to get more performance 144 --binlog-transaction-dependency-history-size=# 145 Maximum number of rows to keep in the writeset history. 146 --binlog-transaction-dependency-tracking=name 147 Selects the source of dependency information from which 148 to assess which transactions can be executed in parallel 149 by the slave's multi-threaded applier. Possible values 150 are COMMIT_ORDER, WRITESET and WRITESET_SESSION. 151 --block-encryption-mode=name 152 mode for AES_ENCRYPT/AES_DECRYPT 153 --bootstrap Used by mysql installation scripts. 154 --bulk-insert-buffer-size=# 155 Size of tree cache used in bulk insert optimisation. Note 156 that this is a limit per thread! 157 --character-set-client-handshake 158 Don't ignore client side character set value sent during 159 handshake. 160 (Defaults to on; use --skip-character-set-client-handshake to disable.) 161 --character-set-filesystem=name 162 Set the filesystem character set. 163 -C, --character-set-server=name 164 Set the default character set. 165 --character-sets-dir=name 166 Directory where character sets are 167 --check-proxy-users If set to FALSE (the default), then proxy user identity 168 will not be mapped for authentication plugins which 169 support mapping from grant tables. When set to TRUE, 170 users associated with authentication plugins which signal 171 proxy user mapping should be done according to GRANT 172 PROXY privilege definition. 173 -r, --chroot=name Chroot mysqld daemon during startup. 174 --collation-server=name 175 Set the default collation. 176 --completion-type=name 177 The transaction completion type, one of NO_CHAIN, CHAIN, 178 RELEASE 179 --concurrent-insert[=name] 180 Use concurrent insert with MyISAM. Possible values are 181 NEVER, AUTO, ALWAYS 182 --connect-timeout=# The number of seconds the mysqld server is waiting for a 183 connect packet before responding with 'Bad handshake' 184 --console Write error output on screen; don't remove the console 185 window on windows. 186 --core-file Write core on errors. 187 --daemonize Run mysqld as sysv daemon 188 -h, --datadir=name Path to the database root directory 189 --date-format=name The DATE format (ignored) 190 --datetime-format=name 191 The DATETIME format (ignored) 192 --default-authentication-plugin=name 193 The default authentication plugin used by the server to 194 hash the password. 195 --default-password-lifetime=# 196 The number of days after which the password will expire. 197 --default-storage-engine=name 198 The default storage engine for new tables 199 --default-time-zone=name 200 Set the default time zone. 201 --default-tmp-storage-engine=name 202 The default storage engine for new explict temporary 203 tables 204 --default-week-format=# 205 The default week format used by WEEK() functions 206 --delay-key-write[=name] 207 Type of DELAY_KEY_WRITE 208 --delayed-insert-limit=# 209 After inserting delayed_insert_limit rows, the INSERT 210 DELAYED handler will check if there are any SELECT 211 statements pending. If so, it allows these to execute 212 before continuing. This variable is deprecated along with 213 INSERT DELAYED. 214 --delayed-insert-timeout=# 215 How long a INSERT DELAYED thread should wait for INSERT 216 statements before terminating. This variable is 217 deprecated along with INSERT DELAYED. 218 --delayed-queue-size=# 219 What size queue (in rows) should be allocated for 220 handling INSERT DELAYED. If the queue becomes full, any 221 client that does INSERT DELAYED will wait until there is 222 room in the queue again. This variable is deprecated 223 along with INSERT DELAYED. 224 --disable-partition-engine-check 225 Skip the check for non-natively partitioned tables during 226 bootstrap. This option is deprecated along with the 227 partition engine. 228 (Defaults to on; use --skip-disable-partition-engine-check to disable.) 229 --disabled-storage-engines=name 230 Limit CREATE TABLE for the storage engines listed 231 --disconnect-on-expired-password 232 Give clients that don't signal password expiration 233 support execution time error(s) instead of connection 234 error 235 (Defaults to on; use --skip-disconnect-on-expired-password to disable.) 236 --disconnect-slave-event-count=# 237 Option used by mysql-test for debugging and testing of 238 replication. 239 --div-precision-increment=# 240 Precision of the result of '/' operator will be increased 241 on that value 242 --early-plugin-load=name 243 Optional semicolon-separated list of plugins to load 244 before storage engine initialization, where each plugin 245 is identified as name=library, where name is the plugin 246 name and library is the plugin library in plugin_dir. 247 --end-markers-in-json 248 In JSON output ("EXPLAIN FORMAT=JSON" and optimizer 249 trace), if variable is set to 1, repeats the structure's 250 key (if it has one) near the closing bracket 251 --enforce-gtid-consistency[=name] 252 Prevents execution of statements that would be impossible 253 to log in a transactionally safe manner. Currently, the 254 disallowed statements include CREATE TEMPORARY TABLE 255 inside transactions, all updates to non-transactional 256 tables, and CREATE TABLE ... SELECT. 257 --eq-range-index-dive-limit=# 258 The optimizer will use existing index statistics instead 259 of doing index dives for equality ranges if the number of 260 equality ranges for the index is larger than or equal to 261 this number. If set to 0, index dives are always used. 262 --event-scheduler[=name] 263 Enable the event scheduler. Possible values are ON, OFF, 264 and DISABLED (keep the event scheduler completely 265 deactivated, it cannot be activated run-time) 266 -T, --exit-info[=#] Used for debugging. Use at your own risk. 267 --expire-logs-days=# 268 If non-zero, binary logs will be purged after 269 expire_logs_days days; possible purges happen at startup 270 and at binary log rotation 271 --explicit-defaults-for-timestamp 272 This option causes CREATE TABLE to create all TIMESTAMP 273 columns as NULL with DEFAULT NULL attribute, Without this 274 option, TIMESTAMP columns are NOT NULL and have implicit 275 DEFAULT clauses. The old behavior is deprecated. The 276 variable can only be set by users having the SUPER 277 privilege. 278 --external-locking Use system (external) locking (disabled by default). 279 With this option enabled you can run myisamchk to test 280 (not repair) tables while the MySQL server is running. 281 Disable with --skip-external-locking. 282 --flush Flush MyISAM tables to disk between SQL commands 283 --flush-time=# A dedicated thread is created to flush all tables at the 284 given interval 285 --ft-boolean-syntax=name 286 List of operators for MATCH ... AGAINST ( ... IN BOOLEAN 287 MODE) 288 --ft-max-word-len=# The maximum length of the word to be included in a 289 FULLTEXT index. Note: FULLTEXT indexes must be rebuilt 290 after changing this variable 291 --ft-min-word-len=# The minimum length of the word to be included in a 292 FULLTEXT index. Note: FULLTEXT indexes must be rebuilt 293 after changing this variable 294 --ft-query-expansion-limit=# 295 Number of best matches to use for query expansion 296 --ft-stopword-file=name 297 Use stopwords from this file instead of built-in list 298 --gdb Set up signals usable for debugging. 299 --general-log Log connections and queries to a table or log file. 300 Defaults to logging to a file hostname.log, or if 301 --log-output=TABLE is used, to a table mysql.general_log. 302 --general-log-file=name 303 Log connections and queries to given file 304 --group-concat-max-len=# 305 The maximum length of the result of function 306 GROUP_CONCAT() 307 --gtid-executed-compression-period[=#] 308 When binlog is disabled, a background thread wakes up to 309 compress the gtid_executed table every 310 gtid_executed_compression_period transactions, as a 311 special case, if variable is 0, the thread never wakes up 312 to compress the gtid_executed table. 313 --gtid-mode=name Controls whether Global Transaction Identifiers (GTIDs) 314 are enabled. Can be OFF, OFF_PERMISSIVE, ON_PERMISSIVE, 315 or ON. OFF means that no transaction has a GTID. 316 OFF_PERMISSIVE means that new transactions (committed in 317 a client session using GTID_NEXT='AUTOMATIC') are not 318 assigned any GTID, and replicated transactions are 319 allowed to have or not have a GTID. ON_PERMISSIVE means 320 that new transactions are assigned a GTID, and replicated 321 transactions are allowed to have or not have a GTID. ON 322 means that all transactions have a GTID. ON is required 323 on a master before any slave can use 324 MASTER_AUTO_POSITION=1. To safely switch from OFF to ON, 325 first set all servers to OFF_PERMISSIVE, then set all 326 servers to ON_PERMISSIVE, then wait for all transactions 327 without a GTID to be replicated and executed on all 328 servers, and finally set all servers to GTID_MODE = ON. 329 -?, --help Display this help and exit. 330 --host-cache-size=# How many host names should be cached to avoid resolving. 331 --ignore-builtin-innodb 332 IGNORED. This option will be removed in future releases. 333 Disable initialization of builtin InnoDB plugin 334 --ignore-db-dir=name 335 Specifies a directory to add to the ignore list when 336 collecting database names from the datadir. Put a blank 337 argument to reset the list accumulated so far. 338 --init-connect=name Command(s) that are executed for each new connection 339 --init-file=name Read SQL commands from this file at startup 340 --init-slave=name Command(s) that are executed by a slave server each time 341 the SQL thread starts 342 --initialize Create the default database and exit. Create a super user 343 with a random expired password and store it into the log. 344 --initialize-insecure 345 Create the default database and exit. Create a super user 346 with empty password. 347 --interactive-timeout=# 348 The number of seconds the server waits for activity on an 349 interactive connection before closing it 350 --internal-tmp-disk-storage-engine[=name] 351 The default storage engine for on-disk internal tmp table 352 --join-buffer-size=# 353 The size of the buffer that is used for full joins 354 --keep-files-on-create 355 Don't overwrite stale .MYD and .MYI even if no directory 356 is specified 357 --key-buffer-size=# The size of the buffer used for index blocks for MyISAM 358 tables. Increase this to get better index handling (for 359 all reads and multiple writes) to as much as you can 360 afford 361 --key-cache-age-threshold=# 362 This characterizes the number of hits a hot block has to 363 be untouched until it is considered aged enough to be 364 downgraded to a warm block. This specifies the percentage 365 ratio of that number of hits to the total number of 366 blocks in key cache 367 --key-cache-block-size=# 368 The default size of key cache blocks 369 --key-cache-division-limit=# 370 The minimum percentage of warm blocks in key cache 371 --keyring-migration-destination=name 372 Keyring plugin to which the keys are migrated to. This 373 option must be specified along with 374 --keyring-migration-source. 375 --keyring-migration-host=name 376 Connect to host. 377 --keyring-migration-password[=name] 378 Password to use when connecting to server during keyring 379 migration. If password value is not specified then it 380 will be asked from the tty. 381 --keyring-migration-port=# 382 Port number to use for connection. 383 --keyring-migration-socket=name 384 The socket file to use for connection. 385 --keyring-migration-source=name 386 Keyring plugin from where the keys needs to be migrated 387 to. This option must be specified along with 388 --keyring-migration-destination. 389 --keyring-migration-user=name 390 User to login to server. 391 -L, --language=name Client error messages in given language. May be given as 392 a full path. Deprecated. Use --lc-messages-dir instead. 393 --large-pages Enable support for large pages 394 --lc-messages=name Set the language used for the error messages. 395 --lc-messages-dir=name 396 Directory where error messages are 397 --lc-time-names=name 398 Set the language used for the month names and the days of 399 the week. 400 --local-infile Enable LOAD DATA LOCAL INFILE 401 (Defaults to on; use --skip-local-infile to disable.) 402 --lock-wait-timeout=# 403 Timeout in seconds to wait for a lock before returning an 404 error. 405 --log-bin[=name] Log update queries in binary format. Optional (but 406 strongly recommended to avoid replication problems if 407 server's hostname changes) argument should be the chosen 408 location for the binary log files. 409 --log-bin-index=name 410 File that holds the names for binary log files. 411 --log-bin-trust-function-creators 412 If set to FALSE (the default), then when --log-bin is 413 used, creation of a stored function (or trigger) is 414 allowed only to users having the SUPER privilege and only 415 if this stored function (trigger) may not break binary 416 logging. Note that if ALL connections to this server 417 ALWAYS use row-based binary logging, the security issues 418 do not exist and the binary logging cannot break, so you 419 can safely set this to TRUE 420 --log-bin-use-v1-row-events 421 If equal to 1 then version 1 row events are written to a 422 row based binary log. If equal to 0, then the latest 423 version of events are written. This option is useful 424 during some upgrades. 425 --log-builtin-as-identified-by-password 426 Controls logging of CREATE/ALTER/GRANT and SET PASSWORD 427 user statements in replication binlogs, general query 428 logs and audit logs. 429 --log-error[=name] Error log file 430 --log-error-verbosity=# 431 How detailed the error log should be. 1, log errors only. 432 2, log errors and warnings. 3, log errors, warnings, and 433 notes. Messages sent to the client are unaffected by this 434 setting. 435 --log-isam[=name] Log all MyISAM changes to file. 436 --log-output=name Syntax: log-output=value[,value...], where "value" could 437 be TABLE, FILE or NONE 438 --log-queries-not-using-indexes 439 Log queries that are executed without benefit of any 440 index to the slow log if it is open 441 --log-raw Log to general log before any rewriting of the query. For 442 use in debugging, not production as sensitive information 443 may be logged. 444 --log-short-format Don't log extra information to update and slow-query 445 logs. 446 --log-slave-updates Tells the slave to log the updates from the slave thread 447 to the binary log. You will need to turn it on if you 448 plan to daisy-chain the slaves 449 --log-slow-admin-statements 450 Log slow OPTIMIZE, ANALYZE, ALTER and other 451 administrative statements to the slow log if it is open. 452 --log-slow-slave-statements 453 Log slow statements executed by slave thread to the slow 454 log if it is open. 455 --log-statements-unsafe-for-binlog 456 Log statements considered unsafe when using statement 457 based binary logging. 458 (Defaults to on; use --skip-log-statements-unsafe-for-binlog to disable.) 459 --log-syslog Errors, warnings, and similar issues eligible for MySQL's 460 error log file may additionally be sent to the host 461 operating system's system log ("syslog"). 462 --log-syslog-facility=name 463 When logging issues using the host operating system's 464 syslog, identify as a facility of the given type (to aid 465 in log filtering). 466 --log-syslog-include-pid 467 When logging issues using the host operating system's 468 syslog, include this MySQL server's process ID (PID). 469 This setting does not affect MySQL's own error log file. 470 (Defaults to on; use --skip-log-syslog-include-pid to disable.) 471 --log-syslog-tag=name 472 When logging issues using the host operating system's 473 syslog, tag the entries from this particular MySQL server 474 with this ident. This will help distinguish entries from 475 MySQL servers co-existing on the same host machine. A 476 non-empty tag will be appended to the default ident of 477 'mysqld', connected by a hyphen. 478 --log-tc=name Path to transaction coordinator log (used for 479 transactions that affect more than one storage engine, 480 when binary log is disabled). 481 --log-tc-size=# Size of transaction coordinator log. 482 --log-throttle-queries-not-using-indexes=# 483 Log at most this many 'not using index' warnings per 484 minute to the slow log. Any further warnings will be 485 condensed into a single summary line. A value of 0 486 disables throttling. Option has no effect unless 487 --log_queries_not_using_indexes is set. 488 --log-timestamps=name 489 UTC to timestamp log files in zulu time, for more concise 490 timestamps and easier correlation of logs from servers 491 from multiple time zones, or SYSTEM to use the system's 492 local time. This affects only log files, not log tables, 493 as the timestamp columns of the latter can be converted 494 at will. 495 -W, --log-warnings[=#] 496 Log some not critical warnings to the log file 497 --long-query-time=# Log all queries that have taken more than long_query_time 498 seconds to execute to file. The argument will be treated 499 as a decimal value with microsecond precision 500 --low-priority-updates 501 INSERT/DELETE/UPDATE has lower priority than selects 502 --lower-case-table-names[=#] 503 If set to 1 table names are stored in lowercase on disk 504 and table names will be case-insensitive. Should be set 505 to 2 if you are using a case insensitive file system 506 --master-info-file=name 507 The location and name of the file that remembers the 508 master and where the I/O replication thread is in the 509 master's binlogs. 510 --master-info-repository=name 511 Defines the type of the repository for the master 512 information. 513 --master-retry-count=# 514 The number of tries the slave will make to connect to the 515 master before giving up. Deprecated option, use 'CHANGE 516 MASTER TO master_retry_count = <num>' instead. 517 --master-verify-checksum 518 Force checksum verification of logged events in binary 519 log before sending them to slaves or printing them in 520 output of SHOW BINLOG EVENTS. Disabled by default. 521 --max-allowed-packet=# 522 Max packet length to send to or receive from the server 523 --max-binlog-cache-size=# 524 Sets the total size of the transactional cache 525 --max-binlog-dump-events=# 526 Option used by mysql-test for debugging and testing of 527 replication. 528 --max-binlog-size=# Binary log will be rotated automatically when the size 529 exceeds this value. Will also apply to relay logs if 530 max_relay_log_size is 0 531 --max-binlog-stmt-cache-size=# 532 Sets the total size of the statement cache 533 --max-connect-errors=# 534 If there is more than this number of interrupted 535 connections from a host this host will be blocked from 536 further connections 537 --max-connections=# The number of simultaneous clients allowed 538 --max-delayed-threads=# 539 Don't start more than this number of threads to handle 540 INSERT DELAYED statements. If set to zero INSERT DELAYED 541 will be not used. This variable is deprecated along with 542 INSERT DELAYED. 543 --max-digest-length=# 544 Maximum length considered for digest text. 545 --max-error-count=# Max number of errors/warnings to store for a statement 546 --max-execution-time=# 547 Kill SELECT statement that takes over the specified 548 number of milliseconds 549 --max-heap-table-size=# 550 Don't allow creation of heap tables bigger than this 551 --max-join-size=# Joins that are probably going to read more than 552 max_join_size records return an error 553 --max-length-for-sort-data=# 554 Max number of bytes in sorted records 555 --max-points-in-geometry[=#] 556 Maximum number of points in a geometry 557 --max-prepared-stmt-count=# 558 Maximum number of prepared statements in the server 559 --max-relay-log-size=# 560 If non-zero: relay log will be rotated automatically when 561 the size exceeds this value; if zero: when the size 562 exceeds max_binlog_size 563 --max-seeks-for-key=# 564 Limit assumed max number of seeks when looking up rows 565 based on a key 566 --max-sort-length=# The number of bytes to use when sorting BLOB or TEXT 567 values (only the first max_sort_length bytes of each 568 value are used; the rest are ignored) 569 --max-sp-recursion-depth[=#] 570 Maximum stored procedure recursion depth 571 --max-tmp-tables=# Maximum number of temporary tables a client can keep open 572 at a time 573 --max-user-connections=# 574 The maximum number of active connections for a single 575 user (0 = no limit) 576 --max-write-lock-count=# 577 After this many write locks, allow some read locks to run 578 in between 579 --memlock Lock mysqld in memory. 580 --metadata-locks-cache-size=# 581 Has no effect, deprecated 582 --metadata-locks-hash-instances=# 583 Has no effect, deprecated 584 --min-examined-row-limit=# 585 Don't write queries to slow log that examine fewer rows 586 than that 587 --multi-range-count=# 588 Number of key ranges to request at once. This variable 589 has no effect, and is deprecated. It will be removed in a 590 future release. 591 --myisam-block-size=# 592 Block size to be used for MyISAM index pages 593 --myisam-data-pointer-size=# 594 Default pointer size to be used for MyISAM tables 595 --myisam-max-sort-file-size=# 596 Don't use the fast sort index method to created index if 597 the temporary file would get bigger than this 598 --myisam-mmap-size=# 599 Restricts the total memory used for memory mapping of 600 MySQL tables 601 --myisam-recover-options[=name] 602 Syntax: myisam-recover-options[=option[,option...]], 603 where option can be DEFAULT, BACKUP, FORCE, QUICK, or OFF 604 --myisam-repair-threads=# 605 If larger than 1, when repairing a MyISAM table all 606 indexes will be created in parallel, with one thread per 607 index. The value of 1 disables parallel repair 608 --myisam-sort-buffer-size=# 609 The buffer that is allocated when sorting the index when 610 doing a REPAIR or when creating indexes with CREATE INDEX 611 or ALTER TABLE 612 --myisam-stats-method=name 613 Specifies how MyISAM index statistics collection code 614 should treat NULLs. Possible values of name are 615 NULLS_UNEQUAL (default behavior for 4.1 and later), 616 NULLS_EQUAL (emulate 4.0 behavior), and NULLS_IGNORED 617 --myisam-use-mmap Use memory mapping for reading and writing MyISAM tables 618 --mysql-native-password-proxy-users 619 If set to FALSE (the default), then the 620 mysql_native_password plugin will not signal for 621 authenticated users to be checked for mapping to proxy 622 users. When set to TRUE, the plugin will flag associated 623 authenticated accounts to be mapped to proxy users when 624 the server option check_proxy_users is enabled. 625 --net-buffer-length=# 626 Buffer length for TCP/IP and socket communication 627 --net-read-timeout=# 628 Number of seconds to wait for more data from a connection 629 before aborting the read 630 --net-retry-count=# If a read on a communication port is interrupted, retry 631 this many times before giving up 632 --net-write-timeout=# 633 Number of seconds to wait for a block to be written to a 634 connection before aborting the write 635 -n, --new Use very new possible "unsafe" functions 636 --offline-mode Make the server into offline mode 637 --old Use compatible behavior 638 --old-alter-table Use old, non-optimized alter table 639 --old-passwords=# Determine which hash algorithm to use when generating 640 passwords using the PASSWORD() function 641 --old-style-user-limits 642 Enable old-style user limits (before 5.0.3, user 643 resources were counted per each user+host vs. per 644 account). 645 --open-files-limit=# 646 If this is not 0, then mysqld will use this value to 647 reserve file descriptors to use with setrlimit(). If this 648 value is 0 then mysqld will reserve max_connections*5 or 649 max_connections + table_open_cache*2 (whichever is 650 larger) number of file descriptors 651 --optimizer-prune-level=# 652 Controls the heuristic(s) applied during query 653 optimization to prune less-promising partial plans from 654 the optimizer search space. Meaning: 0 - do not apply any 655 heuristic, thus perform exhaustive search; 1 - prune 656 plans based on number of retrieved rows 657 --optimizer-search-depth=# 658 Maximum depth of search performed by the query optimizer. 659 Values larger than the number of relations in a query 660 result in better query plans, but take longer to compile 661 a query. Values smaller than the number of tables in a 662 relation result in faster optimization, but may produce 663 very bad query plans. If set to 0, the system will 664 automatically pick a reasonable value 665 --optimizer-switch=name 666 optimizer_switch=option=val[,option=val...], where option 667 is one of {index_merge, index_merge_union, 668 index_merge_sort_union, index_merge_intersection, 669 engine_condition_pushdown, index_condition_pushdown, mrr, 670 mrr_cost_based, materialization, semijoin, loosescan, 671 firstmatch, duplicateweedout, 672 subquery_materialization_cost_based, block_nested_loop, 673 batched_key_access, use_index_extensions, 674 condition_fanout_filter, derived_merge, 675 prefer_ordering_index} and val is one of {on, off, 676 default} 677 --optimizer-trace=name 678 Controls tracing of the Optimizer: 679 optimizer_trace=option=val[,option=val...], where option 680 is one of {enabled, one_line} and val is one of {on, 681 default} 682 --optimizer-trace-features=name 683 Enables/disables tracing of selected features of the 684 Optimizer: 685 optimizer_trace_features=option=val[,option=val...], 686 where option is one of {greedy_search, range_optimizer, 687 dynamic_range, repeated_subselect} and val is one of {on, 688 off, default} 689 --optimizer-trace-limit=# 690 Maximum number of shown optimizer traces 691 --optimizer-trace-max-mem-size=# 692 Maximum allowed cumulated size of stored optimizer traces 693 --optimizer-trace-offset=# 694 Offset of first optimizer trace to show; see manual 695 --parser-max-mem-size=# 696 Maximum amount of memory available to the parser 697 --performance-schema 698 Enable the performance schema. 699 (Defaults to on; use --skip-performance-schema to disable.) 700 --performance-schema-accounts-size=# 701 Maximum number of instrumented user@host accounts. Use 0 702 to disable, -1 for automated scaling. 703 --performance-schema-consumer-events-stages-current 704 Default startup value for the events_stages_current 705 consumer. 706 --performance-schema-consumer-events-stages-history 707 Default startup value for the events_stages_history 708 consumer. 709 --performance-schema-consumer-events-stages-history-long 710 Default startup value for the events_stages_history_long 711 consumer. 712 --performance-schema-consumer-events-statements-current 713 Default startup value for the events_statements_current 714 consumer. 715 (Defaults to on; use --skip-performance-schema-consumer-events-statements-current to disable.) 716 --performance-schema-consumer-events-statements-history 717 Default startup value for the events_statements_history 718 consumer. 719 (Defaults to on; use --skip-performance-schema-consumer-events-statements-history to disable.) 720 --performance-schema-consumer-events-statements-history-long 721 Default startup value for the 722 events_statements_history_long consumer. 723 --performance-schema-consumer-events-transactions-current 724 Default startup value for the events_transactions_current 725 consumer. 726 --performance-schema-consumer-events-transactions-history 727 Default startup value for the events_transactions_history 728 consumer. 729 --performance-schema-consumer-events-transactions-history-long 730 Default startup value for the 731 events_transactions_history_long consumer. 732 --performance-schema-consumer-events-waits-current 733 Default startup value for the events_waits_current 734 consumer. 735 --performance-schema-consumer-events-waits-history 736 Default startup value for the events_waits_history 737 consumer. 738 --performance-schema-consumer-events-waits-history-long 739 Default startup value for the events_waits_history_long 740 consumer. 741 --performance-schema-consumer-global-instrumentation 742 Default startup value for the global_instrumentation 743 consumer. 744 (Defaults to on; use --skip-performance-schema-consumer-global-instrumentation to disable.) 745 --performance-schema-consumer-statements-digest 746 Default startup value for the statements_digest consumer. 747 (Defaults to on; use --skip-performance-schema-consumer-statements-digest to disable.) 748 --performance-schema-consumer-thread-instrumentation 749 Default startup value for the thread_instrumentation 750 consumer. 751 (Defaults to on; use --skip-performance-schema-consumer-thread-instrumentation to disable.) 752 --performance-schema-digests-size=# 753 Size of the statement digest. Use 0 to disable, -1 for 754 automated sizing. 755 --performance-schema-events-stages-history-long-size=# 756 Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to 757 disable, -1 for automated sizing. 758 --performance-schema-events-stages-history-size=# 759 Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0 760 to disable, -1 for automated sizing. 761 --performance-schema-events-statements-history-long-size=# 762 Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. Use 0 763 to disable, -1 for automated sizing. 764 --performance-schema-events-statements-history-size=# 765 Number of rows per thread in EVENTS_STATEMENTS_HISTORY. 766 Use 0 to disable, -1 for automated sizing. 767 --performance-schema-events-transactions-history-long-size=# 768 Number of rows in EVENTS_TRANSACTIONS_HISTORY_LONG. Use 0 769 to disable, -1 for automated sizing. 770 --performance-schema-events-transactions-history-size=# 771 Number of rows per thread in EVENTS_TRANSACTIONS_HISTORY. 772 Use 0 to disable, -1 for automated sizing. 773 --performance-schema-events-waits-history-long-size=# 774 Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to 775 disable, -1 for automated sizing. 776 --performance-schema-events-waits-history-size=# 777 Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0 778 to disable, -1 for automated sizing. 779 --performance-schema-hosts-size=# 780 Maximum number of instrumented hosts. Use 0 to disable, 781 -1 for automated scaling. 782 --performance-schema-instrument[=name] 783 Default startup value for a performance schema 784 instrument. 785 --performance-schema-max-cond-classes=# 786 Maximum number of condition instruments. 787 --performance-schema-max-cond-instances=# 788 Maximum number of instrumented condition objects. Use 0 789 to disable, -1 for automated scaling. 790 --performance-schema-max-digest-length=# 791 Maximum length considered for digest text, when stored in 792 performance_schema tables. 793 --performance-schema-max-file-classes=# 794 Maximum number of file instruments. 795 --performance-schema-max-file-handles=# 796 Maximum number of opened instrumented files. 797 --performance-schema-max-file-instances=# 798 Maximum number of instrumented files. Use 0 to disable, 799 -1 for automated scaling. 800 --performance-schema-max-index-stat=# 801 Maximum number of index statistics for instrumented 802 tables. Use 0 to disable, -1 for automated scaling. 803 --performance-schema-max-memory-classes=# 804 Maximum number of memory pool instruments. 805 --performance-schema-max-metadata-locks=# 806 Maximum number of metadata locks. Use 0 to disable, -1 807 for automated scaling. 808 --performance-schema-max-mutex-classes=# 809 Maximum number of mutex instruments. 810 --performance-schema-max-mutex-instances=# 811 Maximum number of instrumented MUTEX objects. Use 0 to 812 disable, -1 for automated scaling. 813 --performance-schema-max-prepared-statements-instances=# 814 Maximum number of instrumented prepared statements. Use 0 815 to disable, -1 for automated scaling. 816 --performance-schema-max-program-instances=# 817 Maximum number of instrumented programs. Use 0 to 818 disable, -1 for automated scaling. 819 --performance-schema-max-rwlock-classes=# 820 Maximum number of rwlock instruments. 821 --performance-schema-max-rwlock-instances=# 822 Maximum number of instrumented RWLOCK objects. Use 0 to 823 disable, -1 for automated scaling. 824 --performance-schema-max-socket-classes=# 825 Maximum number of socket instruments. 826 --performance-schema-max-socket-instances=# 827 Maximum number of opened instrumented sockets. Use 0 to 828 disable, -1 for automated scaling. 829 --performance-schema-max-sql-text-length=# 830 Maximum length of displayed sql text. 831 --performance-schema-max-stage-classes=# 832 Maximum number of stage instruments. 833 --performance-schema-max-statement-classes=# 834 Maximum number of statement instruments. 835 --performance-schema-max-statement-stack=# 836 Number of rows per thread in EVENTS_STATEMENTS_CURRENT. 837 --performance-schema-max-table-handles=# 838 Maximum number of opened instrumented tables. Use 0 to 839 disable, -1 for automated scaling. 840 --performance-schema-max-table-instances=# 841 Maximum number of instrumented tables. Use 0 to disable, 842 -1 for automated scaling. 843 --performance-schema-max-table-lock-stat=# 844 Maximum number of lock statistics for instrumented 845 tables. Use 0 to disable, -1 for automated scaling. 846 --performance-schema-max-thread-classes=# 847 Maximum number of thread instruments. 848 --performance-schema-max-thread-instances=# 849 Maximum number of instrumented threads. Use 0 to disable, 850 -1 for automated scaling. 851 --performance-schema-session-connect-attrs-size=# 852 Size of session attribute string buffer per thread. Use 0 853 to disable, -1 for automated sizing. 854 --performance-schema-setup-actors-size=# 855 Maximum number of rows in SETUP_ACTORS. Use 0 to disable, 856 -1 for automated scaling. 857 --performance-schema-setup-objects-size=# 858 Maximum number of rows in SETUP_OBJECTS. Use 0 to 859 disable, -1 for automated scaling. 860 --performance-schema-users-size=# 861 Maximum number of instrumented users. Use 0 to disable, 862 -1 for automated scaling. 863 --pid-file=name Pid file used by safe_mysqld 864 --plugin-dir=name Directory for plugins 865 --plugin-load=name Optional semicolon-separated list of plugins to load, 866 where each plugin is identified as name=library, where 867 name is the plugin name and library is the plugin library 868 in plugin_dir. 869 --plugin-load-add=name 870 Optional semicolon-separated list of plugins to load, 871 where each plugin is identified as name=library, where 872 name is the plugin name and library is the plugin library 873 in plugin_dir. This option adds to the list specified by 874 --plugin-load in an incremental way. Multiple 875 --plugin-load-add are supported. 876 -P, --port=# Port number to use for connection or 0 to default to, 877 my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default 878 (3306), whatever comes first 879 --port-open-timeout=# 880 Maximum time in seconds to wait for the port to become 881 free. (Default: No wait). 882 --preload-buffer-size=# 883 The size of the buffer that is allocated when preloading 884 indexes 885 --profiling-history-size=# 886 Limit of query profiling memory 887 --query-alloc-block-size=# 888 Allocation block size for query parsing and execution 889 --query-cache-limit=# 890 Don't cache results that are bigger than this. This 891 variable is deprecated and will be removed in a future 892 release. 893 --query-cache-min-res-unit=# 894 The minimum size for blocks allocated by the query cache. 895 This variable is deprecated and will be removed in a 896 future release. 897 --query-cache-size=# 898 The memory allocated to store results from old queries. 899 This variable is deprecated and will be removed in a 900 future release. 901 --query-cache-type=name 902 OFF = Don't cache or retrieve results. ON = Cache all 903 results except SELECT SQL_NO_CACHE ... queries. DEMAND = 904 Cache only SELECT SQL_CACHE ... queries. This variable is 905 deprecated and will be removed in a future release. 906 --query-cache-wlock-invalidate 907 Invalidate queries in query cache on LOCK for write. This 908 variable is deprecated and will be removed in a future 909 release. 910 --query-prealloc-size=# 911 Persistent buffer for query parsing and execution 912 --range-alloc-block-size=# 913 Allocation block size for storing ranges during 914 optimization 915 --range-optimizer-max-mem-size=# 916 Maximum amount of memory used by the range optimizer to 917 allocate predicates during range analysis. The larger the 918 number, more memory may be consumed during range 919 analysis. If the value is too low to completed range 920 optimization of a query, index range scan will not be 921 considered for this query. A value of 0 means range 922 optimizer does not have any cap on memory. 923 --read-buffer-size=# 924 Each thread that does a sequential scan allocates a 925 buffer of this size for each table it scans. If you do 926 many sequential scans, you may want to increase this 927 value 928 --read-only Make all non-temporary tables read-only, with the 929 exception for replication (slave) threads and users with 930 the SUPER privilege 931 --read-rnd-buffer-size=# 932 When reading rows in sorted order after a sort, the rows 933 are read through this buffer to avoid a disk seeks 934 --relay-log=name The location and name to use for relay logs 935 --relay-log-index=name 936 File that holds the names for relay log files. 937 --relay-log-info-file=name 938 The location and name of the file that remembers where 939 the SQL replication thread is in the relay logs 940 --relay-log-info-repository=name 941 Defines the type of the repository for the relay log 942 information and associated workers. 943 --relay-log-purge if disabled - do not purge relay logs. if enabled - purge 944 them as soon as they are no more needed 945 (Defaults to on; use --skip-relay-log-purge to disable.) 946 --relay-log-recovery 947 Enables automatic relay log recovery right after the 948 database startup, which means that the IO Thread starts 949 re-fetching from the master right after the last 950 transaction processed 951 --relay-log-space-limit=# 952 Maximum space to use for all relay logs 953 --replicate-do-db=name 954 Tells the slave thread to restrict replication to the 955 specified database. To specify more than one database, 956 use the directive multiple times, once for each database. 957 Note that this will only work if you do not use 958 cross-database queries such as UPDATE some_db.some_table 959 SET foo='bar' while having selected a different or no 960 database. If you need cross database updates to work, 961 make sure you have 3.23.28 or later, and use 962 replicate-wild-do-table=db_name.%. 963 --replicate-do-table=name 964 Tells the slave thread to restrict replication to the 965 specified table. To specify more than one table, use the 966 directive multiple times, once for each table. This will 967 work for cross-database updates, in contrast to 968 replicate-do-db. 969 --replicate-ignore-db=name 970 Tells the slave thread to not replicate to the specified 971 database. To specify more than one database to ignore, 972 use the directive multiple times, once for each database. 973 This option will not work if you use cross database 974 updates. If you need cross database updates to work, make 975 sure you have 3.23.28 or later, and use 976 replicate-wild-ignore-table=db_name.%. 977 --replicate-ignore-table=name 978 Tells the slave thread to not replicate to the specified 979 table. To specify more than one table to ignore, use the 980 directive multiple times, once for each table. This will 981 work for cross-database updates, in contrast to 982 replicate-ignore-db. 983 --replicate-rewrite-db=name 984 Updates to a database with a different name than the 985 original. Example: 986 replicate-rewrite-db=master_db_name->slave_db_name. 987 --replicate-same-server-id 988 In replication, if set to 1, do not skip events having 989 our server id. Default value is 0 (to break infinite 990 loops in circular replication). Can't be set to 1 if 991 --log-slave-updates is used. 992 --replicate-wild-do-table=name 993 Tells the slave thread to restrict replication to the 994 tables that match the specified wildcard pattern. To 995 specify more than one table, use the directive multiple 996 times, once for each table. This will work for 997 cross-database updates. Example: 998 replicate-wild-do-table=foo%.bar% will replicate only 999 updates to tables in all databases that start with foo 1000 and whose table names start with bar. 1001 --replicate-wild-ignore-table=name 1002 Tells the slave thread to not replicate to the tables 1003 that match the given wildcard pattern. To specify more 1004 than one table to ignore, use the directive multiple 1005 times, once for each table. This will work for 1006 cross-database updates. Example: 1007 replicate-wild-ignore-table=foo%.bar% will not do updates 1008 to tables in databases that start with foo and whose 1009 table names start with bar. 1010 --replication-optimize-for-static-plugin-config 1011 Optional flag that blocks plugin install/uninstall and 1012 allows skipping the acquisition of the lock to read from 1013 the plugin list and the usage of read-optimized 1014 spin-locks. Use only when plugin hook callback needs 1015 optimization (a lot of semi-sync slaves, for instance). 1016 --replication-sender-observe-commit-only 1017 Optional flag that allows for only calling back observer 1018 hooks at commit. 1019 --report-host=name Hostname or IP of the slave to be reported to the master 1020 during slave registration. Will appear in the output of 1021 SHOW SLAVE HOSTS. Leave unset if you do not want the 1022 slave to register itself with the master. Note that it is 1023 not sufficient for the master to simply read the IP of 1024 the slave off the socket once the slave connects. Due to 1025 NAT and other routing issues, that IP may not be valid 1026 for connecting to the slave from the master or other 1027 hosts 1028 --report-password=name 1029 The account password of the slave to be reported to the 1030 master during slave registration 1031 --report-port=# Port for connecting to slave reported to the master 1032 during slave registration. Set it only if the slave is 1033 listening on a non-default port or if you have a special 1034 tunnel from the master or other clients to the slave. If 1035 not sure, leave this option unset 1036 --report-user=name The account user name of the slave to be reported to the 1037 master during slave registration 1038 --require-secure-transport 1039 When this option is enabled, connections attempted using 1040 insecure transport will be rejected. Secure transports 1041 are SSL/TLS, Unix socket or Shared Memory (on Windows). 1042 --rpl-stop-slave-timeout=# 1043 Timeout in seconds to wait for slave to stop before 1044 returning a warning. 1045 --safe-user-create Don't allow new user creation by the user who has no 1046 write privileges to the mysql.user table. 1047 --secure-auth Disallow authentication for accounts that have old 1048 (pre-4.1) passwords. Deprecated. Always TRUE. 1049 (Defaults to on; use --skip-secure-auth to disable.) 1050 --secure-file-priv=name 1051 Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to 1052 files within specified directory 1053 --server-id=# Uniquely identifies the server instance in the community 1054 of replication partners 1055 --server-id-bits=# Set number of significant bits in server-id 1056 --session-track-gtids=name 1057 Controls the amount of global transaction ids to be 1058 included in the response packet sent by the 1059 server.(Default: OFF). 1060 --session-track-schema 1061 Track changes to the 'default schema'. 1062 (Defaults to on; use --skip-session-track-schema to disable.) 1063 --session-track-state-change 1064 Track changes to the 'session state'. 1065 --session-track-system-variables=name 1066 Track changes in registered system variables. 1067 --session-track-transaction-info=name 1068 Track changes to the transaction attributes. OFF to 1069 disable; STATE to track just transaction state (Is there 1070 an active transaction? Does it have any data? etc.); 1071 CHARACTERISTICS to track transaction state and report all 1072 statements needed to start a transaction with the same 1073 characteristics (isolation level, read only/read write, 1074 snapshot - but not any work done / data modified within 1075 the transaction). 1076 --sha256-password-proxy-users 1077 If set to FALSE (the default), then the sha256_password 1078 authentication plugin will not signal for authenticated 1079 users to be checked for mapping to proxy users. When set 1080 to TRUE, the plugin will flag associated authenticated 1081 accounts to be mapped to proxy users when the server 1082 option check_proxy_users is enabled. 1083 --show-compatibility-56 1084 SHOW commands / INFORMATION_SCHEMA tables compatible with 1085 MySQL 5.6 1086 --show-create-table-verbosity 1087 When this option is enabled, it increases the verbosity 1088 of 'SHOW CREATE TABLE'. 1089 --show-old-temporals 1090 When this option is enabled, the pre-5.6.4 temporal types 1091 will be marked in the 'SHOW CREATE TABLE' and 1092 'INFORMATION_SCHEMA.COLUMNS' table as a comment in 1093 COLUMN_TYPE field. This variable is deprecated and will 1094 be removed in a future release. 1095 --show-slave-auth-info 1096 Show user and password in SHOW SLAVE HOSTS on this 1097 master. 1098 --skip-grant-tables Start without grant tables. This gives all users FULL 1099 ACCESS to all tables. 1100 --skip-host-cache Don't cache host names. 1101 --skip-name-resolve Don't resolve hostnames. All hostnames are IP's or 1102 'localhost'. 1103 --skip-networking Don't allow connection with TCP/IP 1104 --skip-new Don't use new, possibly wrong routines. 1105 --skip-show-database 1106 Don't allow 'SHOW DATABASE' commands 1107 --skip-slave-start If set, slave is not autostarted. 1108 --skip-stack-trace Don't print a stack trace on failure. 1109 --slave-allow-batching 1110 Allow slave to batch requests 1111 --slave-checkpoint-group=# 1112 Maximum number of processed transactions by 1113 Multi-threaded slave before a checkpoint operation is 1114 called to update progress status. 1115 --slave-checkpoint-period=# 1116 Gather workers' activities to Update progress status of 1117 Multi-threaded slave and flush the relay log info to disk 1118 after every #th milli-seconds. 1119 --slave-compressed-protocol 1120 Use compression on master/slave protocol 1121 --slave-exec-mode=name 1122 Modes for how replication events should be executed. 1123 Legal values are STRICT (default) and IDEMPOTENT. In 1124 IDEMPOTENT mode, replication will not stop for operations 1125 that are idempotent. In STRICT mode, replication will 1126 stop on any unexpected difference between the master and 1127 the slave 1128 --slave-load-tmpdir=name 1129 The location where the slave should put its temporary 1130 files when replicating a LOAD DATA INFILE command 1131 --slave-max-allowed-packet=# 1132 The maximum packet length to sent successfully from the 1133 master to slave. 1134 --slave-net-timeout=# 1135 Number of seconds to wait for more data from a 1136 master/slave connection before aborting the read 1137 --slave-parallel-type=name 1138 Specifies if the slave will use database partitioning or 1139 information from master to parallelize 1140 transactions.(Default: DATABASE). 1141 --slave-parallel-workers=# 1142 Number of worker threads for executing events in parallel 1143 --slave-pending-jobs-size-max=# 1144 Max size of Slave Worker queues holding yet not applied 1145 events.The least possible value must be not less than the 1146 master side max_allowed_packet. 1147 --slave-preserve-commit-order 1148 Force slave workers to make commits in the same order as 1149 on the master. Disabled by default. 1150 --slave-rows-search-algorithms=name 1151 Set of searching algorithms that the slave will use while 1152 searching for records from the storage engine to either 1153 updated or deleted them. Possible values are: INDEX_SCAN, 1154 TABLE_SCAN and HASH_SCAN. Any combination is allowed, and 1155 the slave will always pick the most suitable algorithm 1156 for any given scenario. (Default: INDEX_SCAN, 1157 TABLE_SCAN). 1158 --slave-skip-errors=name 1159 Tells the slave thread to continue replication when a 1160 query event returns an error from the provided list 1161 --slave-sql-verify-checksum 1162 Force checksum verification of replication events after 1163 reading them from relay log. Note: Events are always 1164 checksum-verified by slave on receiving them from the 1165 network before writing them to the relay log. Enabled by 1166 default. 1167 (Defaults to on; use --skip-slave-sql-verify-checksum to disable.) 1168 --slave-transaction-retries=# 1169 Number of times the slave SQL thread will retry a 1170 transaction in case it failed with a deadlock or elapsed 1171 lock wait timeout, before giving up and stopping 1172 --slave-type-conversions=name 1173 Set of slave type conversions that are enabled. Legal 1174 values are: ALL_LOSSY to enable lossy conversions, 1175 ALL_NON_LOSSY to enable non-lossy conversions, 1176 ALL_UNSIGNED to treat all integer column type data to be 1177 unsigned values, and ALL_SIGNED to treat all integer 1178 column type data to be signed values. Default treatment 1179 is ALL_SIGNED. If ALL_SIGNED and ALL_UNSIGNED both are 1180 specified, ALL_SIGNED will take higher priority than 1181 ALL_UNSIGNED. If the variable is assigned the empty set, 1182 no conversions are allowed and it is expected that the 1183 types match exactly. 1184 --slow-launch-time=# 1185 If creating the thread takes longer than this value (in 1186 seconds), the Slow_launch_threads counter will be 1187 incremented 1188 --slow-query-log Log slow queries to a table or log file. Defaults logging 1189 to a file hostname-slow.log or a table mysql.slow_log if 1190 --log-output=TABLE is used. Must be enabled to activate 1191 other slow log options 1192 --slow-query-log-file=name 1193 Log slow queries to given log file. Defaults logging to 1194 hostname-slow.log. Must be enabled to activate other slow 1195 log options 1196 --socket=name Socket file to use for connection 1197 --sort-buffer-size=# 1198 Each thread that needs to do a sort allocates a buffer of 1199 this size 1200 --sporadic-binlog-dump-fail 1201 Option used by mysql-test for debugging and testing of 1202 replication. 1203 --sql-mode=name Syntax: sql-mode=mode[,mode[,mode...]]. See the manual 1204 for the complete list of valid sql modes 1205 --stored-program-cache=# 1206 The soft upper limit for number of cached stored routines 1207 for one connection. 1208 --super-read-only Make all non-temporary tables read-only, with the 1209 exception for replication (slave) threads. Users with 1210 the SUPER privilege are affected, unlike read_only. 1211 Setting super_read_only to ON also sets read_only to ON. 1212 -s, --symbolic-links 1213 Enable symbolic link support. 1214 --sync-binlog=# Synchronously flush binary log to disk after every #th 1215 write to the file. Use 0 to disable synchronous flushing 1216 --sync-frm Sync .frm files to disk on creation 1217 (Defaults to on; use --skip-sync-frm to disable.) 1218 --sync-master-info=# 1219 Synchronously flush master info to disk after every #th 1220 event. Use 0 to disable synchronous flushing 1221 --sync-relay-log=# Synchronously flush relay log to disk after every #th 1222 event. Use 0 to disable synchronous flushing 1223 --sync-relay-log-info=# 1224 Synchronously flush relay log info to disk after every 1225 #th transaction. Use 0 to disable synchronous flushing 1226 --sysdate-is-now Non-default option to alias SYSDATE() to NOW() to make it 1227 safe-replicable. Since 5.0, SYSDATE() returns a `dynamic' 1228 value different for different invocations, even within 1229 the same statement. 1230 --table-definition-cache=# 1231 The number of cached table definitions 1232 --table-open-cache=# 1233 The number of cached open tables (total for all table 1234 cache instances) 1235 --table-open-cache-instances=# 1236 The number of table cache instances 1237 --tc-heuristic-recover=name 1238 Decision to use in heuristic recover process. Possible 1239 values are OFF, COMMIT or ROLLBACK. 1240 --thread-cache-size=# 1241 How many threads we should keep in a cache for reuse 1242 --thread-handling=name 1243 Define threads usage for handling queries, one of 1244 one-thread-per-connection, no-threads, loaded-dynamically 1245 --thread-stack=# The stack size for each thread 1246 --time-format=name The TIME format (ignored) 1247 --tls-version=name TLS version, permitted values are TLSv1, TLSv1.1, 1248 TLSv1.2(Only for openssl) 1249 --tmp-table-size=# If an internal in-memory temporary table exceeds this 1250 size, MySQL will automatically convert it to an on-disk 1251 MyISAM table 1252 -t, --tmpdir=name Path for temporary files. Several paths may be specified, 1253 separated by a colon (:), in this case they are used in a 1254 round-robin fashion 1255 --transaction-alloc-block-size=# 1256 Allocation block size for transactions to be stored in 1257 binary log 1258 --transaction-isolation=name 1259 Default transaction isolation level. 1260 --transaction-prealloc-size=# 1261 Persistent buffer for transactions to be stored in binary 1262 log 1263 --transaction-read-only 1264 Default transaction access mode. True if transactions are 1265 read-only. 1266 --transaction-write-set-extraction[=name] 1267 This option is used to let the server know when to 1268 extract the write set which will be used for various 1269 purposes. 1270 --updatable-views-with-limit=name 1271 YES = Don't issue an error message (warning only) if a 1272 VIEW without presence of a key of the underlying table is 1273 used in queries with a LIMIT clause for updating. NO = 1274 Prohibit update of a VIEW, which does not contain a key 1275 of the underlying table and the query uses a LIMIT clause 1276 (usually get from GUI tools) 1277 -u, --user=name Run mysqld daemon as user. 1278 --validate-user-plugins 1279 Turns on additional validation of authentication plugins 1280 assigned to user accounts. 1281 (Defaults to on; use --skip-validate-user-plugins to disable.) 1282 -v, --verbose Used with --help option for detailed help. 1283 -V, --version Output version information and exit. 1284 --wait-timeout=# The number of seconds the server waits for activity on a 1285 connection before closing it 1286 1287Variables (--variable-name=value) 1288abort-slave-event-count 0 1289allow-suspicious-udfs FALSE 1290auto-increment-increment 1 1291auto-increment-offset 1 1292autocommit TRUE 1293automatic-sp-privileges TRUE 1294avoid-temporal-upgrade FALSE 1295back-log 80 1296big-tables FALSE 1297bind-address * 1298binlog-cache-size 32768 1299binlog-checksum CRC32 1300binlog-direct-non-transactional-updates FALSE 1301binlog-error-action ABORT_SERVER 1302binlog-format ROW 1303binlog-group-commit-sync-delay 0 1304binlog-group-commit-sync-no-delay-count 0 1305binlog-gtid-simple-recovery TRUE 1306binlog-max-flush-queue-time 0 1307binlog-order-commits TRUE 1308binlog-row-event-max-size 8192 1309binlog-row-image FULL 1310binlog-rows-query-log-events FALSE 1311binlog-stmt-cache-size 32768 1312binlog-transaction-dependency-history-size 25000 1313binlog-transaction-dependency-tracking COMMIT_ORDER 1314block-encryption-mode aes-128-ecb 1315bulk-insert-buffer-size 8388608 1316character-set-client-handshake TRUE 1317character-set-filesystem binary 1318character-set-server latin1 1319character-sets-dir MYSQL_CHARSETSDIR/ 1320check-proxy-users FALSE 1321chroot (No default value) 1322collation-server latin1_swedish_ci 1323completion-type NO_CHAIN 1324concurrent-insert AUTO 1325connect-timeout 10 1326console FALSE 1327daemonize FALSE 1328date-format %Y-%m-%d 1329datetime-format %Y-%m-%d %H:%i:%s 1330default-authentication-plugin mysql_native_password 1331default-password-lifetime 0 1332default-storage-engine InnoDB 1333default-time-zone (No default value) 1334default-tmp-storage-engine InnoDB 1335default-week-format 0 1336delay-key-write ON 1337delayed-insert-limit 100 1338delayed-insert-timeout 300 1339delayed-queue-size 1000 1340disable-partition-engine-check TRUE 1341disabled-storage-engines 1342disconnect-on-expired-password TRUE 1343disconnect-slave-event-count 0 1344div-precision-increment 4 1345end-markers-in-json FALSE 1346enforce-gtid-consistency FALSE 1347eq-range-index-dive-limit 200 1348event-scheduler OFF 1349expire-logs-days 0 1350explicit-defaults-for-timestamp FALSE 1351external-locking FALSE 1352flush FALSE 1353flush-time 0 1354ft-boolean-syntax + -><()~*:""&| 1355ft-max-word-len 84 1356ft-min-word-len 4 1357ft-query-expansion-limit 20 1358ft-stopword-file (No default value) 1359gdb FALSE 1360general-log FALSE 1361group-concat-max-len 1024 1362gtid-executed-compression-period 1000 1363gtid-mode OFF 1364help TRUE 1365host-cache-size 279 1366ignore-builtin-innodb FALSE 1367init-connect 1368init-file (No default value) 1369init-slave 1370initialize FALSE 1371initialize-insecure FALSE 1372interactive-timeout 28800 1373internal-tmp-disk-storage-engine InnoDB 1374join-buffer-size 262144 1375keep-files-on-create FALSE 1376key-buffer-size 8388608 1377key-cache-age-threshold 300 1378key-cache-block-size 1024 1379key-cache-division-limit 100 1380keyring-migration-destination (No default value) 1381keyring-migration-host (No default value) 1382keyring-migration-port 0 1383keyring-migration-socket (No default value) 1384keyring-migration-source (No default value) 1385keyring-migration-user (No default value) 1386language MYSQL_SHAREDIR/ 1387large-pages FALSE 1388lc-messages en_US 1389lc-messages-dir MYSQL_SHAREDIR/ 1390lc-time-names en_US 1391local-infile TRUE 1392lock-wait-timeout 31536000 1393log-bin (No default value) 1394log-bin-index (No default value) 1395log-bin-trust-function-creators FALSE 1396log-bin-use-v1-row-events FALSE 1397log-builtin-as-identified-by-password FALSE 1398log-error stderr 1399log-error-verbosity 1 1400log-isam myisam.log 1401log-output FILE 1402log-queries-not-using-indexes FALSE 1403log-raw FALSE 1404log-short-format FALSE 1405log-slave-updates FALSE 1406log-slow-admin-statements FALSE 1407log-slow-slave-statements FALSE 1408log-statements-unsafe-for-binlog TRUE 1409log-syslog FALSE 1410log-syslog-facility daemon 1411log-syslog-include-pid TRUE 1412log-syslog-tag 1413log-tc tc.log 1414log-tc-size ##### 1415log-throttle-queries-not-using-indexes 0 1416log-timestamps UTC 1417log-warnings 0 1418long-query-time 10 1419low-priority-updates FALSE 1420lower-case-table-names 1 1421master-info-file master.info 1422master-info-repository FILE 1423master-retry-count 86400 1424master-verify-checksum FALSE 1425max-allowed-packet 4194304 1426max-binlog-cache-size 18446744073709547520 1427max-binlog-dump-events 0 1428max-binlog-size 1073741824 1429max-binlog-stmt-cache-size 18446744073709547520 1430max-connect-errors 100 1431max-connections 151 1432max-delayed-threads 20 1433max-digest-length 1024 1434max-error-count 64 1435max-execution-time 0 1436max-heap-table-size 16777216 1437max-join-size 18446744073709551615 1438max-length-for-sort-data 1024 1439max-points-in-geometry 65536 1440max-prepared-stmt-count 16382 1441max-relay-log-size 0 1442max-seeks-for-key 18446744073709551615 1443max-sort-length 1024 1444max-sp-recursion-depth 0 1445max-tmp-tables 32 1446max-user-connections 0 1447max-write-lock-count 18446744073709551615 1448memlock FALSE 1449metadata-locks-cache-size 1024 1450metadata-locks-hash-instances 8 1451min-examined-row-limit 0 1452multi-range-count 256 1453myisam-block-size 1024 1454myisam-data-pointer-size 6 1455myisam-max-sort-file-size 9223372036853727232 1456myisam-mmap-size 18446744073709551615 1457myisam-recover-options OFF 1458myisam-repair-threads 1 1459myisam-sort-buffer-size 8388608 1460myisam-stats-method nulls_unequal 1461myisam-use-mmap FALSE 1462mysql-native-password-proxy-users FALSE 1463net-buffer-length 16384 1464net-read-timeout 30 1465net-retry-count 10 1466net-write-timeout 60 1467new FALSE 1468offline-mode FALSE 1469old FALSE 1470old-alter-table FALSE 1471old-passwords 0 1472old-style-user-limits FALSE 1473optimizer-prune-level 1 1474optimizer-search-depth 62 1475optimizer-switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,prefer_ordering_index=on 1476optimizer-trace 1477optimizer-trace-features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on 1478optimizer-trace-limit 1 1479optimizer-trace-max-mem-size 16384 1480optimizer-trace-offset -1 1481parser-max-mem-size 18446744073709551615 1482performance-schema TRUE 1483performance-schema-accounts-size -1 1484performance-schema-consumer-events-stages-current FALSE 1485performance-schema-consumer-events-stages-history FALSE 1486performance-schema-consumer-events-stages-history-long FALSE 1487performance-schema-consumer-events-statements-current TRUE 1488performance-schema-consumer-events-statements-history TRUE 1489performance-schema-consumer-events-statements-history-long FALSE 1490performance-schema-consumer-events-transactions-current FALSE 1491performance-schema-consumer-events-transactions-history FALSE 1492performance-schema-consumer-events-transactions-history-long FALSE 1493performance-schema-consumer-events-waits-current FALSE 1494performance-schema-consumer-events-waits-history FALSE 1495performance-schema-consumer-events-waits-history-long FALSE 1496performance-schema-consumer-global-instrumentation TRUE 1497performance-schema-consumer-statements-digest TRUE 1498performance-schema-consumer-thread-instrumentation TRUE 1499performance-schema-digests-size -1 1500performance-schema-events-stages-history-long-size -1 1501performance-schema-events-stages-history-size -1 1502performance-schema-events-statements-history-long-size -1 1503performance-schema-events-statements-history-size -1 1504performance-schema-events-transactions-history-long-size -1 1505performance-schema-events-transactions-history-size -1 1506performance-schema-events-waits-history-long-size -1 1507performance-schema-events-waits-history-size -1 1508performance-schema-hosts-size -1 1509performance-schema-instrument 1510performance-schema-max-cond-classes 80 1511performance-schema-max-cond-instances -1 1512performance-schema-max-digest-length 1024 1513performance-schema-max-file-classes 80 1514performance-schema-max-file-handles 32768 1515performance-schema-max-file-instances -1 1516performance-schema-max-index-stat -1 1517performance-schema-max-memory-classes 320 1518performance-schema-max-metadata-locks -1 1519performance-schema-max-mutex-classes 210 1520performance-schema-max-mutex-instances -1 1521performance-schema-max-prepared-statements-instances -1 1522performance-schema-max-program-instances -1 1523performance-schema-max-rwlock-classes 50 1524performance-schema-max-rwlock-instances -1 1525performance-schema-max-socket-classes 10 1526performance-schema-max-socket-instances -1 1527performance-schema-max-sql-text-length 1024 1528performance-schema-max-stage-classes 150 1529performance-schema-max-statement-classes 193 1530performance-schema-max-statement-stack 10 1531performance-schema-max-table-handles -1 1532performance-schema-max-table-instances -1 1533performance-schema-max-table-lock-stat -1 1534performance-schema-max-thread-classes 50 1535performance-schema-max-thread-instances -1 1536performance-schema-session-connect-attrs-size -1 1537performance-schema-setup-actors-size -1 1538performance-schema-setup-objects-size -1 1539performance-schema-users-size -1 1540port #### 1541port-open-timeout 0 1542preload-buffer-size 32768 1543profiling-history-size 15 1544query-alloc-block-size 8192 1545query-cache-limit 1048576 1546query-cache-min-res-unit 4096 1547query-cache-size 1048576 1548query-cache-type OFF 1549query-cache-wlock-invalidate FALSE 1550query-prealloc-size 8192 1551range-alloc-block-size 4096 1552range-optimizer-max-mem-size 8388608 1553read-buffer-size 131072 1554read-only FALSE 1555read-rnd-buffer-size 262144 1556relay-log (No default value) 1557relay-log-index (No default value) 1558relay-log-info-file relay-log.info 1559relay-log-info-repository FILE 1560relay-log-purge TRUE 1561relay-log-recovery FALSE 1562relay-log-space-limit 0 1563replicate-same-server-id FALSE 1564replication-optimize-for-static-plugin-config FALSE 1565replication-sender-observe-commit-only FALSE 1566report-host (No default value) 1567report-password (No default value) 1568report-port 0 1569report-user (No default value) 1570require-secure-transport FALSE 1571rpl-stop-slave-timeout 31536000 1572safe-user-create FALSE 1573secure-auth TRUE 1574server-id 0 1575server-id-bits 32 1576session-track-gtids OFF 1577session-track-schema TRUE 1578session-track-state-change FALSE 1579session-track-system-variables time_zone,autocommit,character_set_client,character_set_results,character_set_connection 1580session-track-transaction-info OFF 1581sha256-password-proxy-users FALSE 1582show-compatibility-56 FALSE 1583show-create-table-verbosity FALSE 1584show-old-temporals FALSE 1585show-slave-auth-info FALSE 1586skip-grant-tables TRUE 1587skip-name-resolve FALSE 1588skip-networking FALSE 1589skip-show-database FALSE 1590skip-slave-start FALSE 1591slave-allow-batching FALSE 1592slave-checkpoint-group 512 1593slave-checkpoint-period 300 1594slave-compressed-protocol FALSE 1595slave-exec-mode STRICT 1596slave-max-allowed-packet 1073741824 1597slave-net-timeout 60 1598slave-parallel-type DATABASE 1599slave-parallel-workers 0 1600slave-pending-jobs-size-max 16777216 1601slave-preserve-commit-order FALSE 1602slave-rows-search-algorithms TABLE_SCAN,INDEX_SCAN 1603slave-skip-errors (No default value) 1604slave-sql-verify-checksum TRUE 1605slave-transaction-retries 10 1606slave-type-conversions 1607slow-launch-time 2 1608slow-query-log FALSE 1609sort-buffer-size 262144 1610sporadic-binlog-dump-fail FALSE 1611sql-mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION 1612stored-program-cache 256 1613super-read-only FALSE 1614symbolic-links FALSE 1615sync-binlog 1 1616sync-frm TRUE 1617sync-master-info 10000 1618sync-relay-log 10000 1619sync-relay-log-info 10000 1620sysdate-is-now FALSE 1621table-open-cache-instances 16 1622tc-heuristic-recover OFF 1623thread-cache-size 9 1624thread-handling one-thread-per-connection 1625thread-stack 262144 1626time-format %H:%i:%s 1627tmp-table-size 16777216 1628transaction-alloc-block-size 8192 1629transaction-isolation REPEATABLE-READ 1630transaction-prealloc-size 4096 1631transaction-read-only FALSE 1632transaction-write-set-extraction OFF 1633updatable-views-with-limit YES 1634validate-user-plugins TRUE 1635verbose TRUE 1636wait-timeout 28800 1637 1638To see what values a running MySQL server is using, type 1639'mysqladmin variables' instead of 'mysqld --verbose --help'. 1640