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