· 9 years ago · Aug 13, 2017, 11:26 PM
1mysqld Ver 5.1.41-3ubuntu12.10 for debian-linux-gnu on x86_64 ((Ubuntu))
2Copyright (C) 2000-2008 MySQL AB, by Monty and others
3Copyright (C) 2008 Sun Microsystems, Inc.
4This software comes with ABSOLUTELY NO WARRANTY. This is free software,
5and you are welcome to modify and redistribute it under the GPL license
6
7Starts the MySQL database server
8
9Usage: mysqld [OPTIONS]
10
11Default options are read from the following files in the given order:
12/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
13The following groups are read: mysqld server mysqld-5.1
14The following options may be given as the first argument:
15--print-defaults Print the program argument list and exit
16--no-defaults Don't read default options from any options file
17--defaults-file=# Only read default options from the given file #
18--defaults-extra-file=# Read this file after the global files are read
19
20 --abort-slave-event-count=#
21 Option used by mysql-test for debugging and testing of
22 replication.
23 --allow-suspicious-udfs
24 Allows use of UDFs consisting of only one symbol xxx()
25 without corresponding xxx_init() or xxx_deinit(). That
26 also means that one can load any function from any
27 library, for example exit() from libc.so
28 -a, --ansi Use ANSI SQL syntax instead of MySQL syntax. This mode
29 will also set transaction isolation level 'serializable'.
30 --auto-increment-increment[=#]
31 Auto-increment columns are incremented by this
32 --auto-increment-offset[=#]
33 Offset added to Auto-increment columns. Used when
34 auto-increment-increment != 1
35 --automatic-sp-privileges
36 Creating and dropping stored procedures alters ACLs.
37 Disable with --skip-automatic-sp-privileges.
38 --back_log=# The number of outstanding connection requests MySQL can
39 have. This comes into play when the main MySQL thread
40 gets very many connection requests in a very short time.
41 -b, --basedir=name Path to installation directory. All paths are usually
42 resolved relative to this.
43 --big-tables Allow big result sets by saving all temporary sets on
44 file (Solves most 'table full' errors).
45 --bind-address=name IP address to bind to.
46 --binlog-do-db=name Tells the master it should log updates for the specified
47 database, and exclude all others not explicitly
48 mentioned.
49 --binlog-ignore-db=name
50 Tells the master that updates to the given database
51 should not be logged tothe binary log.
52 --binlog-row-event-max-size=#
53 The maximum size of a row-based binary log event in
54 bytes. Rows will be grouped into events smaller than this
55 size if possible. The value has to be a multiple of 256.
56 --binlog_cache_size=#
57 The size of the cache to hold the SQL statements for the
58 binary log during a transaction. If you often use big,
59 multi-statement transactions you can increase this to get
60 more performance.
61 --binlog_format=name
62 Does not have any effect without '--log-bin'. Tell the
63 master the form of binary logging to use: either 'row'
64 for row-based binary logging, or 'statement' for
65 statement-based binary logging, or 'mixed'. 'mixed' is
66 statement-based binary logging except for those
67 statements where only row-based is correct: those which
68 involve user-defined functions (i.e. UDFs) or the UUID()
69 function; for those, row-based binary logging is
70 automatically used.
71 --bootstrap Used by mysql installation scripts.
72 --bulk_insert_buffer_size=#
73 Size of tree cache used in bulk insert optimisation. Note
74 that this is a limit per thread!
75 --character-set-client-handshake
76 Don't ignore client side character set value sent during
77 handshake.
78 --character-set-filesystem=name
79 Set the filesystem character set.
80 -C, --character-set-server=name
81 Set the default character set.
82 --character-sets-dir=name
83 Directory where character sets are.
84 -r, --chroot=name Chroot mysqld daemon during startup.
85 --collation-server=name
86 Set the default collation.
87 --completion-type=# Default completion type.
88 --concurrent-insert[=#]
89 Use concurrent insert with MyISAM. Disable with
90 --concurrent-insert=0
91 --connect_timeout=# The number of seconds the mysqld server is waiting for a
92 connect packet before responding with 'Bad handshake'.
93 --console Write error output on screen; Don't remove the console
94 window on windows.
95 --core-file Write core on errors.
96 -h, --datadir=name Path to the database root.
97 --datetime_format=name
98 The DATETIME/TIMESTAMP format (for future).
99 --date_format=name The DATE format (For future).
100 -C, --default-character-set=name
101 Set the default character set (deprecated option, use
102 --character-set-server instead).
103 --default-collation=name
104 Set the default collation (deprecated option, use
105 --collation-server instead).
106 --default-storage-engine=name
107 Set the default storage engine (table type) for tables.
108 --default-table-type=name
109 (deprecated) Use --default-storage-engine.
110 --default-time-zone=name
111 Set the default time zone.
112 --default_week_format=#
113 The default week format used by WEEK() functions.
114 --delay-key-write[=name]
115 Type of DELAY_KEY_WRITE.
116 --delay-key-write-for-all-tables
117 Don't flush key buffers between writes for any MyISAM
118 table (Deprecated option, use --delay-key-write=all
119 instead).
120 --delayed_insert_limit=#
121 After inserting delayed_insert_limit rows, the INSERT
122 DELAYED handler will check if there are any SELECT
123 statements pending. If so, it allows these to execute
124 before continuing.
125 --delayed_insert_timeout=#
126 How long a INSERT DELAYED thread should wait for INSERT
127 statements before terminating.
128 --delayed_queue_size=#
129 What size queue (in rows) should be allocated for
130 handling INSERT DELAYED. If the queue becomes full, any
131 client that does INSERT DELAYED will wait until there is
132 room in the queue again.
133 --des-key-file=name Load keys for des_encrypt() and des_encrypt from given
134 file.
135 --disconnect-slave-event-count=#
136 Option used by mysql-test for debugging and testing of
137 replication.
138 --div_precision_increment=#
139 Precision of the result of '/' operator will be increased
140 on that value.
141 --enable-locking Deprecated option, use --external-locking instead.
142 --engine-condition-pushdown
143 Push supported query conditions to the storage engine.
144 --event-scheduler[=name]
145 Enable/disable the event scheduler.
146 -T, --exit-info[=#] Used for debugging; Use at your own risk!
147 --expire_logs_days=#
148 If non-zero, binary logs will be purged after
149 expire_logs_days days; possible purges happen at startup
150 and at binary log rotation.
151 --external-locking Use system (external) locking (disabled by default).
152 With this option enabled you can run myisamchk to test
153 (not repair) tables while the MySQL server is running.
154 Disable with --skip-external-locking.
155 --flush Flush tables to disk between SQL commands.
156 --flush_time=# A dedicated thread is created to flush all tables at the
157 given interval.
158 --ft_boolean_syntax=name
159 List of operators for MATCH ... AGAINST ( ... IN BOOLEAN
160 MODE)
161 --ft_max_word_len=# The maximum length of the word to be included in a
162 FULLTEXT index. Note: FULLTEXT indexes must be rebuilt
163 after changing this variable.
164 --ft_min_word_len=# The minimum length of the word to be included in a
165 FULLTEXT index. Note: FULLTEXT indexes must be rebuilt
166 after changing this variable.
167 --ft_query_expansion_limit=#
168 Number of best matches to use for query expansion
169 --ft_stopword_file=name
170 Use stopwords from this file instead of built-in list.
171 --gdb Set up signals usable for debugging
172 --general_log Enable|disable general log
173 --general_log_file=name
174 Log connections and queries to given file.
175 --group_concat_max_len=#
176 The maximum length of the result of function
177 group_concat.
178 -?, --help Display this help and exit.
179 --ignore-builtin-innodb
180 Disable initialization of builtin InnoDB plugin
181 --init-connect=name Command(s) that are executed for each new connection
182 --init-file=name Read SQL commands from this file at startup.
183 --init-rpl-role=name
184 Set the replication role.
185 --init-slave=name Command(s) that are executed when a slave connects to
186 this master
187 --innodb[=#] Enable or disable InnoDB plugin. Possible values are ON,
188 OFF, FORCE (don't start if the plugin fails to load).
189 --innodb-adaptive-hash-index
190 Enable InnoDB adaptive hash index (enabled by default).
191 Disable with --skip-innodb-adaptive-hash-index.
192 --innodb-additional-mem-pool-size=#
193 Size of a memory pool InnoDB uses to store data
194 dictionary information and other internal data
195 structures.
196 --innodb-autoextend-increment=#
197 Data file autoextend increment in megabytes
198 --innodb-autoinc-lock-mode=#
199 The AUTOINC lock modes supported by InnoDB:
200 0 => Old style AUTOINC locking (for backward
201 compatibility)
202 1 => New style AUTOINC locking
203 2 => No AUTOINC locking (unsafe for SBR)
204 --innodb-buffer-pool-size=#
205 The size of the memory buffer InnoDB uses to cache data
206 and indexes of its tables.
207 --innodb-checksums Enable InnoDB checksums validation (enabled by default).
208 Disable with --skip-innodb-checksums.
209 --innodb-commit-concurrency=#
210 Helps in performance tuning in heavily concurrent
211 environments.
212 --innodb-concurrency-tickets=#
213 Number of times a thread is allowed to enter InnoDB
214 within the same SQL query after it has once got the
215 ticket
216 --innodb-data-file-path=name
217 Path to individual files and their sizes.
218 --innodb-data-home-dir=name
219 The common part for InnoDB table spaces.
220 --innodb-doublewrite
221 Enable InnoDB doublewrite buffer (enabled by default).
222 Disable with --skip-innodb-doublewrite.
223 --innodb-fast-shutdown[=#]
224 Speeds up the shutdown process of the InnoDB storage
225 engine. Possible values are 0, 1 (faster) or 2 (fastest -
226 crash-like).
227 --innodb-file-io-threads=#
228 Number of file I/O threads in InnoDB.
229 --innodb-file-per-table
230 Stores each InnoDB table to an .ibd file in the database
231 dir.
232 --innodb-flush-log-at-trx-commit[=#]
233 Set to 0 (write and flush once per second), 1 (write and
234 flush at each commit) or 2 (write at commit, flush once
235 per second).
236 --innodb-flush-method=name
237 With which method to flush data.
238 --innodb-force-recovery=#
239 Helps to save your data in case the disk image of the
240 database becomes corrupt.
241 --innodb-lock-wait-timeout=#
242 Timeout in seconds an InnoDB transaction may wait for a
243 lock before being rolled back.
244 --innodb-locks-unsafe-for-binlog
245 Force InnoDB to not use next-key locking, to use only
246 row-level locking.
247 --innodb-log-buffer-size=#
248 The size of the buffer which InnoDB uses to write log to
249 the log files on disk.
250 --innodb-log-file-size=#
251 Size of each log file in a log group.
252 --innodb-log-files-in-group=#
253 Number of log files in the log group. InnoDB writes to
254 the files in a circular fashion. Value 3 is recommended
255 here.
256 --innodb-log-group-home-dir=name
257 Path to InnoDB log files.
258 --innodb-max-dirty-pages-pct=#
259 Percentage of dirty pages allowed in bufferpool.
260 --innodb-max-purge-lag=#
261 Desired maximum length of the purge queue (0 = no limit)
262 --innodb-mirrored-log-groups=#
263 Number of identical copies of log groups we keep for the
264 database. Currently this should be set to 1.
265 --innodb-open-files=#
266 How many files at the maximum InnoDB keeps open at the
267 same time.
268 --innodb-rollback-on-timeout
269 Roll back the complete transaction on lock wait timeout,
270 for 4.x compatibility (disabled by default)
271 --innodb-stats-on-metadata
272 Enable statistics gathering for metadata commands such as
273 SHOW TABLE STATUS (on by default)
274 --innodb-status-file
275 Enable SHOW INNODB STATUS output in the
276 innodb_status.<pid> file
277 --innodb-support-xa Enable InnoDB support for the XA two-phase commit
278 --innodb-sync-spin-loops=#
279 Count of spin-loop rounds in InnoDB mutexes
280 --innodb-table-locks
281 Enable InnoDB locking in LOCK TABLES
282 --innodb-thread-concurrency=#
283 Helps in performance tuning in heavily concurrent
284 environments. Sets the maximum number of threads allowed
285 inside InnoDB. Value 0 will disable the thread
286 throttling.
287 --innodb-thread-sleep-delay=#
288 Time of innodb thread sleeping before joining InnoDB
289 queue (usec). Value 0 disable a sleep
290 --innodb-use-legacy-cardinality-algorithm
291 Use legacy algorithm for picking random pages during
292 index cardinality estimation. Disable this to use a
293 better algorithm, but note that your query plans may
294 change (enabled by default).
295 --interactive_timeout=#
296 The number of seconds the server waits for activity on an
297 interactive connection before closing it.
298 --join_buffer_size=#
299 The size of the buffer that is used for full joins.
300 --keep_files_on_create
301 Don't overwrite stale .MYD and .MYI even if no directory
302 is specified.
303 --key_buffer_size=# The size of the buffer used for index blocks for MyISAM
304 tables. Increase this to get better index handling (for
305 all reads and multiple writes) to as much as you can
306 afford; 64M on a 256M machine that mainly runs MySQL is
307 quite common.
308 --key_cache_age_threshold=#
309 This characterizes the number of hits a hot block has to
310 be untouched until it is considered aged enough to be
311 downgraded to a warm block. This specifies the percentage
312 ratio of that number of hits to the total number of
313 blocks in key cache
314 --key_cache_block_size=#
315 The default size of key cache blocks
316 --key_cache_division_limit=#
317 The minimum percentage of warm blocks in key cache
318 -L, --language=name Client error messages in given language. May be given as
319 a full path.
320 --large-pages Enable support for large pages. Disable with
321 --skip-large-pages.
322 --lc-time-names=name
323 Set the language used for the month names and the days of
324 the week.
325 --local-infile Enable/disable LOAD DATA LOCAL INFILE (takes values 1|0).
326 -l, --log[=name] Log connections and queries to file (deprecated option,
327 use --general_log/--general_log_file instead).
328 --log-bin[=name] Log update queries in binary format. Optional (but
329 strongly recommended to avoid replication problems if
330 server's hostname changes) argument should be the chosen
331 location for the binary log files.
332 --log-bin-index=name
333 File that holds the names for last binary log files.
334 --log-bin-trust-function-creators
335 If equal to 0 (the default), then when --log-bin is used,
336 creation of a stored function (or trigger) is allowed
337 only to users having the SUPER privilege and only if this
338 stored function (trigger) may not break binary
339 logging.Note that if ALL connections to this server
340 ALWAYS use row-based binary logging, the security issues
341 do not exist and the binary logging cannot break, so you
342 can safely set this to 1.
343 --log-bin-trust-routine-creators
344 (deprecated) Use log-bin-trust-function-creators.
345 --log-error[=name] Error log file.
346 --log-isam[=name] Log all MyISAM changes to file.
347 -0, --log-long-format
348 Log some extra information to update log. Please note
349 that this option is deprecated; see --log-short-format
350 option.
351 --log-output[=name] Syntax: log-output[=value[,value...]], where "value"
352 could be TABLE, FILE or NONE.
353 --log-queries-not-using-indexes
354 Log queries that are executed without benefit of any
355 index to the slow log if it is open.
356 --log-short-format Don't log extra information to update and slow-query
357 logs.
358 --log-slave-updates Tells the slave to log the updates from the slave thread
359 to the binary log. You will need to turn it on if you
360 plan to daisy-chain the slaves.
361 --log-slow-admin-statements
362 Log slow OPTIMIZE, ANALYZE, ALTER and other
363 administrative statements to the slow log if it is open.
364 --log-slow-slave-statements
365 Log slow statements executed by slave thread to the slow
366 log if it is open.
367 --log-tc=name Path to transaction coordinator log (used for
368 transactions that affect more than one storage engine,
369 when binary log is disabled)
370 --log-tc-size=# Size of transaction coordinator log.
371 --log-update[=name] The update log is deprecated since version 5.0, is
372 replaced by the binary log and this option justs turns on
373 --log-bin instead.
374 -W, --log-warnings[=#]
375 Log some not critical warnings to the log file.
376 --log_slow_queries[=name]
377 Log slow queries to a table or log file. Defaults logging
378 to table mysql.slow_log or hostname-slow.log if
379 --log-output=file is used. Must be enabled to activate
380 other slow log options. (deprecated option, use
381 --slow_query_log/--slow_query_log_file instead)
382 --long_query_time=# Log all queries that have taken more than long_query_time
383 seconds to execute to file. The argument will be treated
384 as a decimal value with microsecond precission.
385 --low-priority-updates
386 INSERT/DELETE/UPDATE has lower priority than selects.
387 --lower_case_table_names[=#]
388 If set to 1 table names are stored in lowercase on disk
389 and table names will be case-insensitive. Should be set
390 to 2 if you are using a case insensitive file system
391 --master-connect-retry=#
392 The number of seconds the slave thread will sleep before
393 retrying to connect to the master in case the master goes
394 down or the connection is lost.
395 --master-host=name Master hostname or IP address for replication. If not
396 set, the slave thread will not be started. Note that the
397 setting of master-host will be ignored if there exists a
398 valid master.info file.
399 --master-info-file=name
400 The location and name of the file that remembers the
401 master and where the I/O replication thread is in the
402 master's binlogs.
403 --master-password=name
404 The password the slave thread will authenticate with when
405 connecting to the master. If not set, an empty password
406 is assumed.The value in master.info will take precedence
407 if it can be read.
408 --master-port=# The port the master is listening on. If not set, the
409 compiled setting of MYSQL_PORT is assumed. If you have
410 not tinkered with configure options, this should be 3306.
411 The value in master.info will take precedence if it can
412 be read.
413 --master-retry-count=#
414 The number of tries the slave will make to connect to the
415 master before giving up.
416 --master-ssl Enable the slave to connect to the master using SSL.
417 --master-ssl-ca[=name]
418 Master SSL CA file. Only applies if you have enabled
419 master-ssl.
420 --master-ssl-capath[=name]
421 Master SSL CA path. Only applies if you have enabled
422 master-ssl.
423 --master-ssl-cert[=name]
424 Master SSL certificate file name. Only applies if you
425 have enabled master-ssl
426 --master-ssl-cipher[=name]
427 Master SSL cipher. Only applies if you have enabled
428 master-ssl.
429 --master-ssl-key[=name]
430 Master SSL keyfile name. Only applies if you have enabled
431 master-ssl.
432 --master-user=name The username the slave thread will use for authentication
433 when connecting to the master. The user must have FILE
434 privilege. If the master user is not set, user test is
435 assumed. The value in master.info will take precedence if
436 it can be read.
437 --max-binlog-dump-events=#
438 Option used by mysql-test for debugging and testing of
439 replication.
440 --max_allowed_packet=#
441 Max packetlength to send/receive from to server.
442 --max_binlog_cache_size=#
443 Can be used to restrict the total size used to cache a
444 multi-transaction query.
445 --max_binlog_size=# Binary log will be rotated automatically when the size
446 exceeds this value. Will also apply to relay logs if
447 max_relay_log_size is 0. The minimum value for this
448 variable is 4096.
449 --max_connections=# The number of simultaneous clients allowed.
450 --max_connect_errors=#
451 If there is more than this number of interrupted
452 connections from a host this host will be blocked from
453 further connections.
454 --max_delayed_threads=#
455 Don't start more than this number of threads to handle
456 INSERT DELAYED statements. If set to zero, which means
457 INSERT DELAYED is not used.
458 --max_error_count=# Max number of errors/warnings to store for a statement.
459 --max_heap_table_size=#
460 Don't allow creation of heap tables bigger than this.
461 --max_join_size=# Joins that are probably going to read more than
462 max_join_size records return an error.
463 --max_length_for_sort_data=#
464 Max number of bytes in sorted records.
465 --max_prepared_stmt_count=#
466 Maximum number of prepared statements in the server.
467 --max_relay_log_size=#
468 If non-zero: relay log will be rotated automatically when
469 the size exceeds this value; if zero (the default): when
470 the size exceeds max_binlog_size. 0 excepted, the minimum
471 value for this variable is 4096.
472 --max_seeks_for_key=#
473 Limit assumed max number of seeks when looking up rows
474 based on a key
475 --max_sort_length=# The number of bytes to use when sorting BLOB or TEXT
476 values (only the first max_sort_length bytes of each
477 value are used; the rest are ignored).
478 --max_sp_recursion_depth[=#]
479 Maximum stored procedure recursion depth. (discussed with
480 docs).
481 --max_tmp_tables=# Maximum number of temporary tables a client can keep open
482 at a time.
483 --max_user_connections=#
484 The maximum number of active connections for a single
485 user (0 = no limit).
486 --max_write_lock_count=#
487 After this many write locks, allow some read locks to run
488 in between.
489 --memlock Lock mysqld in memory.
490 --min_examined_row_limit=#
491 Don't log queries which examine less than
492 min_examined_row_limit rows to file.
493 --multi_range_count=#
494 Number of key ranges to request at once.
495 --myisam-recover[=name]
496 Syntax: myisam-recover[=option[,option...]], where option
497 can be DEFAULT, BACKUP, FORCE or QUICK.
498 --myisam_block_size=#
499 Block size to be used for MyISAM index pages.
500 --myisam_data_pointer_size=#
501 Default pointer size to be used for MyISAM tables.
502 --myisam_max_extra_sort_file_size=#
503 Deprecated option
504 --myisam_max_sort_file_size=#
505 Don't use the fast sort index method to created index if
506 the temporary file would get bigger than this.
507 --myisam_repair_threads=#
508 Number of threads to use when repairing MyISAM tables.
509 The value of 1 disables parallel repair.
510 --myisam_sort_buffer_size=#
511 The buffer that is allocated when sorting the index when
512 doing a REPAIR or when creating indexes with CREATE INDEX
513 or ALTER TABLE.
514 --myisam_stats_method=name
515 Specifies how MyISAM index statistics collection code
516 should threat NULLs. Possible values of name are
517 "nulls_unequal" (default behavior for 4.1/5.0),
518 "nulls_equal" (emulate 4.0 behavior), and
519 "nulls_ignored".
520 --myisam_use_mmap Use memory mapping for reading and writing MyISAM tables
521 --ndb-use-copying-alter-table
522 Force ndbcluster to always copy tables at alter table
523 (should only be used if on-line alter table fails).
524 --net_buffer_length=#
525 Buffer length for TCP/IP and socket communication.
526 --net_read_timeout=#
527 Number of seconds to wait for more data from a connection
528 before aborting the read.
529 --net_retry_count=# If a read on a communication port is interrupted, retry
530 this many times before giving up.
531 --net_write_timeout=#
532 Number of seconds to wait for a block to be written to a
533 connection before aborting the write.
534 -n, --new Use very new possible 'unsafe' functions.
535 --old Use compatible behavior.
536 --old-alter-table Use old, non-optimized alter table.
537 --old-passwords Use old password encryption method (needed for 4.0 and
538 older clients).
539 --old-style-user-limits
540 Enable old-style user limits (before 5.0.3 user resources
541 were counted per each user+host vs. per account)
542 --one-thread (deprecated): Only use one thread (for debugging under
543 Linux). Use thread-handling=no-threads instead
544 --open_files_limit=#
545 If this is not 0, then mysqld will use this value to
546 reserve file descriptors to use with setrlimit(). If this
547 value is 0 then mysqld will reserve max_connections*5 or
548 max_connections + table_cache*2 (whichever is larger)
549 number of files.
550 --optimizer_prune_level[=#]
551 Controls the heuristic(s) applied during query
552 optimization to prune less-promising partial plans from
553 the optimizer search space. Meaning: 0 - do not apply any
554 heuristic, thus perform exhaustive search; 1 - prune
555 plans based on number of retrieved rows.
556 --optimizer_search_depth[=#]
557 Maximum depth of search performed by the query optimizer.
558 Values larger than the number of relations in a query
559 result in better query plans, but take longer to compile
560 a query. Smaller values than the number of tables in a
561 relation result in faster optimization, but may produce
562 very bad query plans. If set to 0, the system will
563 automatically pick a reasonable value; if set to
564 MAX_TABLES+2, the optimizer will switch to the original
565 find_best (used for testing/comparison).
566 --optimizer_switch=name
567 optimizer_switch=option=val[,option=val...], where
568 option={index_merge, index_merge_union,
569 index_merge_sort_union, index_merge_intersection} and
570 val={on, off, default}.
571 --pid-file=name Pid file used by safe_mysqld.
572 --plugin-load=name Optional semicolon-separated list of plugins to load,
573 where each plugin is identified as name=library, where
574 name is the plugin name and library is the plugin library
575 in plugin_dir.
576 --plugin_dir=name Directory for plugins.
577 -P, --port=# Port number to use for connection or 0 for default to, in
578 order of preference, my.cnf, $MYSQL_TCP_PORT,
579 /etc/services, built-in default (3306).
580 --port-open-timeout=#
581 Maximum time in seconds to wait for the port to become
582 free. (Default: no wait)
583 --preload_buffer_size=#
584 The size of the buffer that is allocated when preloading
585 indexes
586 --profiling_history_size=#
587 Limit of query profiling memory
588 --query_alloc_block_size=#
589 Allocation block size for query parsing and execution
590 --query_cache_limit=#
591 Don't cache results that are bigger than this.
592 --query_cache_min_res_unit=#
593 minimal size of unit in wich space for results is
594 allocated (last unit will be trimed after writing all
595 result data.
596 --query_cache_size=#
597 The memory allocated to store results from old queries.
598 --query_cache_type=#
599 0 = OFF = Don't cache or retrieve results. 1 = ON = Cache
600 all results except SELECT SQL_NO_CACHE ... queries. 2 =
601 DEMAND = Cache only SELECT SQL_CACHE ... queries.
602 --query_cache_wlock_invalidate
603 Invalidate queries in query cache on LOCK for write
604 --query_prealloc_size=#
605 Persistent buffer for query parsing and execution
606 --range_alloc_block_size=#
607 Allocation block size for storing ranges during
608 optimization
609 --read_buffer_size=#
610 Each thread that does a sequential scan allocates a
611 buffer of this size for each table it scans. If you do
612 many sequential scans, you may want to increase this
613 value.
614 --read_only Make all non-temporary tables read-only, with the
615 exception for replication (slave) threads and users with
616 the SUPER privilege
617 --read_rnd_buffer_size=#
618 When reading rows in sorted order after a sort, the rows
619 are read through this buffer to avoid a disk seeks. If
620 not set, then it's set to the value of record_buffer.
621 --record_buffer=# Alias for read_buffer_size
622 --relay-log=name The location and name to use for relay logs.
623 --relay-log-index=name
624 The location and name to use for the file that keeps a
625 list of the last relay logs.
626 --relay-log-info-file=name
627 The location and name of the file that remembers where
628 the SQL replication thread is in the relay logs.
629 --relay_log_purge 0 = do not purge relay logs. 1 = purge them as soon as
630 they are no more needed.
631 --relay_log_space_limit=#
632 Maximum space to use for all relay logs.
633 --replicate-do-db=name
634 Tells the slave thread to restrict replication to the
635 specified database. To specify more than one database,
636 use the directive multiple times, once for each database.
637 Note that this will only work if you do not use
638 cross-database queries such as UPDATE some_db.some_table
639 SET foo='bar' while having selected a different or no
640 database. If you need cross database updates to work,
641 make sure you have 3.23.28 or later, and use
642 replicate-wild-do-table=db_name.%.
643 --replicate-do-table=name
644 Tells the slave thread to restrict replication to the
645 specified table. To specify more than one table, use the
646 directive multiple times, once for each table. This will
647 work for cross-database updates, in contrast to
648 replicate-do-db.
649 --replicate-ignore-db=name
650 Tells the slave thread to not replicate to the specified
651 database. To specify more than one database to ignore,
652 use the directive multiple times, once for each database.
653 This option will not work if you use cross database
654 updates. If you need cross database updates to work, make
655 sure you have 3.23.28 or later, and use
656 replicate-wild-ignore-table=db_name.%.
657 --replicate-ignore-table=name
658 Tells the slave thread to not replicate to the specified
659 table. To specify more than one table to ignore, use the
660 directive multiple times, once for each table. This will
661 work for cross-datbase updates, in contrast to
662 replicate-ignore-db.
663 --replicate-rewrite-db=name
664 Updates to a database with a different name than the
665 original. Example:
666 replicate-rewrite-db=master_db_name->slave_db_name.
667 --replicate-same-server-id
668 In replication, if set to 1, do not skip events having
669 our server id. Default value is 0 (to break infinite
670 loops in circular replication). Can't be set to 1 if
671 --log-slave-updates is used.
672 --replicate-wild-do-table=name
673 Tells the slave thread to restrict replication to the
674 tables that match the specified wildcard pattern. To
675 specify more than one table, use the directive multiple
676 times, once for each table. This will work for
677 cross-database updates. Example:
678 replicate-wild-do-table=foo%.bar% will replicate only
679 updates to tables in all databases that start with foo
680 and whose table names start with bar.
681 --replicate-wild-ignore-table=name
682 Tells the slave thread to not replicate to the tables
683 that match the given wildcard pattern. To specify more
684 than one table to ignore, use the directive multiple
685 times, once for each table. This will work for
686 cross-database updates. Example:
687 replicate-wild-ignore-table=foo%.bar% will not do updates
688 to tables in databases that start with foo and whose
689 table names start with bar.
690 --report-host=name Hostname or IP of the slave to be reported to to the
691 master during slave registration. Will appear in the
692 output of SHOW SLAVE HOSTS. Leave unset if you do not
693 want the slave to register itself with the master. Note
694 that it is not sufficient for the master to simply read
695 the IP of the slave off the socket once the slave
696 connects. Due to NAT and other routing issues, that IP
697 may not be valid for connecting to the slave from the
698 master or other hosts.
699 --report-password=name
700 Undocumented.
701 --report-port=# Port for connecting to slave reported to the master
702 during slave registration. Set it only if the slave is
703 listening on a non-default port or if you have a special
704 tunnel from the master or other clients to the slave. If
705 not sure, leave this option unset.
706 --report-user=name Undocumented.
707 --rpl-recovery-rank=#
708 Undocumented.
709 --safe-mode Skip some optimize stages (for testing).
710 --safe-show-database
711 Deprecated option; use GRANT SHOW DATABASES instead...
712 --safe-user-create Don't allow new user creation by the user who has no
713 write privileges to the mysql.user table.
714 --safemalloc-mem-limit=#
715 Simulate memory shortage when compiled with the
716 --with-debug=full option.
717 --secure-auth Disallow authentication for accounts that have old
718 (pre-4.1) passwords.
719 --secure-file-priv=name
720 Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to
721 files within specified directory
722 --server-id=# Uniquely identifies the server instance in the community
723 of replication partners.
724 -O, --set-variable=name
725 Change the value of a variable. Please note that this
726 option is deprecated;you can set variables directly with
727 --variable-name=value.
728 --show-slave-auth-info
729 Show user and password in SHOW SLAVE HOSTS on this master
730 --skip-grant-tables Start without grant tables. This gives all users FULL
731 ACCESS to all tables!
732 --skip-host-cache Don't cache host names.
733 --skip-locking Deprecated option, use --skip-external-locking instead.
734 --skip-name-resolve Don't resolve hostnames. All hostnames are IP's or
735 'localhost'.
736 --skip-networking Don't allow connection with TCP/IP.
737 --skip-new Don't use new, possible wrong routines.
738 --skip-show-database
739 Don't allow 'SHOW DATABASE' commands.
740 --skip-slave-start If set, slave is not autostarted.
741 --skip-stack-trace Don't print a stack trace on failure.
742 --skip-symlink Don't allow symlinking of tables. Deprecated option. Use
743 --skip-symbolic-links instead.
744 --skip-thread-priority
745 Don't give threads different priorities. Deprecated
746 option.
747 --slave-exec-mode=name
748 Modes for how replication events should be executed.
749 Legal values are STRICT (default) and IDEMPOTENT. In
750 IDEMPOTENT mode, replication will not stop for operations
751 that are idempotent. In STRICT mode, replication will
752 stop on any unexpected difference between the master and
753 the slave.
754 --slave-load-tmpdir=name
755 The location where the slave should put its temporary
756 files when replicating a LOAD DATA INFILE command.
757 --slave-skip-errors=name
758 Tells the slave thread to continue replication when a
759 query event returns an error from the provided list.
760 --slave_compressed_protocol
761 Use compression on master/slave protocol.
762 --slave_net_timeout=#
763 Number of seconds to wait for more data from a
764 master/slave connection before aborting the read.
765 --slave_transaction_retries=#
766 Number of times the slave SQL thread will retry a
767 transaction in case it failed with a deadlock or elapsed
768 lock wait timeout, before giving up and stopping.
769 --slow-query-log Enable|disable slow query log
770 --slow_launch_time=#
771 If creating the thread takes longer than this value (in
772 seconds), the Slow_launch_threads counter will be
773 incremented.
774 --slow_query_log_file=name
775 Log slow queries to given log file. Defaults logging to
776 hostname-slow.log. Must be enabled to activate other slow
777 log options.
778 --socket=name Socket file to use for connection.
779 --sort_buffer_size=#
780 Each thread that needs to do a sort allocates a buffer of
781 this size.
782 --sporadic-binlog-dump-fail
783 Option used by mysql-test for debugging and testing of
784 replication.
785 --sql-bin-update-same=#
786 The update log is deprecated since version 5.0, is
787 replaced by the binary log and this option does nothing
788 anymore.
789 --sql-mode=name Syntax: sql-mode=option[,option[,option...]] where option
790 can be one of: REAL_AS_FLOAT, PIPES_AS_CONCAT,
791 ANSI_QUOTES, IGNORE_SPACE, ONLY_FULL_GROUP_BY,
792 NO_UNSIGNED_SUBTRACTION.
793 --ssl Enable SSL for connection (automatically enabled with
794 other flags). Disable with --skip-ssl.
795 --ssl-ca=name CA file in PEM format (check OpenSSL docs, implies
796 --ssl).
797 --ssl-capath=name CA directory (check OpenSSL docs, implies --ssl).
798 --ssl-cert=name X509 cert in PEM format (implies --ssl).
799 --ssl-cipher=name SSL cipher to use (implies --ssl).
800 --ssl-key=name X509 key in PEM format (implies --ssl).
801 -s, --symbolic-links
802 Enable symbolic link support.
803 --sync-binlog=# Synchronously flush binary log to disk after every #th
804 event. Use 0 (default) to disable synchronous flushing.
805 --sync-frm Sync .frm to disk on create. Enabled by default.
806 --sysdate-is-now Non-default option to alias SYSDATE() to NOW() to make it
807 safe-replicable. Since 5.0, SYSDATE() returns a `dynamic'
808 value different for different invocations, even within
809 the same statement.
810 --table_cache=# Deprecated; use --table_open_cache instead.
811 --table_definition_cache=#
812 The number of cached table definitions.
813 --table_lock_wait_timeout=#
814 Timeout in seconds to wait for a table level lock before
815 returning an error. Used only if the connection has
816 active cursors.
817 --table_open_cache=#
818 The number of cached open tables.
819 --tc-heuristic-recover=name
820 Decision to use in heuristic recover process. Possible
821 values are COMMIT or ROLLBACK.
822 --temp-pool Using this option will cause most temporary files created
823 to use a small set of names, rather than a unique name
824 for each new file.
825 --thread_cache_size=#
826 How many threads we should keep in a cache for reuse.
827 --thread_concurrency=#
828 Permits the application to give the threads system a hint
829 for the desired number of threads that should be run at
830 the same time.
831 --thread_handling=name
832 Define threads usage for handling queries:
833 one-thread-per-connection or no-threads
834 --thread_stack=# The stack size for each thread.
835 --timed_mutexes Specify whether to time mutexes (only InnoDB mutexes are
836 currently supported)
837 --time_format=name The TIME format (for future).
838 -t, --tmpdir=name Path for temporary files. Several paths may be specified,
839 separated by a colon (:), in this case they are used in a
840 round-robin fashion.
841 --tmp_table_size=# If an internal in-memory temporary table exceeds this
842 size, MySQL will automatically convert it to an on-disk
843 MyISAM table.
844 --transaction-isolation=name
845 Default transaction isolation level.
846 --transaction_alloc_block_size=#
847 Allocation block size for transactions to be stored in
848 binary log
849 --transaction_prealloc_size=#
850 Persistent buffer for transactions to be stored in binary
851 log
852 --updatable_views_with_limit=#
853 1 = YES = Don't issue an error message (warning only) if
854 a VIEW without presence of a key of the underlying table
855 is used in queries with a LIMIT clause for updating. 0 =
856 NO = Prohibit update of a VIEW, which does not contain a
857 key of the underlying table and the query uses a LIMIT
858 clause (usually get from GUI tools).
859 -s, --use-symbolic-links
860 Enable symbolic link support. Deprecated option; use
861 --symbolic-links instead.
862 -u, --user=name Run mysqld daemon as user.
863 -v, --verbose Used with --help option for detailed help
864 -V, --version Output version information and exit.
865 --wait_timeout=# The number of seconds the server waits for activity on a
866 connection before closing it.
867 -W, --warnings[=#] Deprecated; use --log-warnings instead.
868
869Variables (--variable-name=value)
870and boolean options {FALSE|TRUE} Value (after reading options)
871--------------------------------- -----------------------------
872abort-slave-event-count 0
873allow-suspicious-udfs FALSE
874auto-increment-increment 1
875auto-increment-offset 1
876automatic-sp-privileges TRUE
877back_log 50
878basedir /usr
879bind-address (No default value)
880binlog-row-event-max-size 1024
881binlog_cache_size 32768
882binlog_format (No default value)
883bulk_insert_buffer_size 8388608
884character-set-client-handshake TRUE
885character-set-filesystem binary
886character-set-server latin1
887character-sets-dir /usr/share/mysql/charsets/
888chroot (No default value)
889collation-server latin1_swedish_ci
890completion-type 0
891concurrent-insert 1
892connect_timeout 10
893console FALSE
894datadir .
895datetime_format %Y-%m-%d %H:%i:%s
896date_format %Y-%m-%d
897default-character-set latin1
898default-collation latin1_swedish_ci
899default-storage-engine MyISAM
900default-table-type MyISAM
901default-time-zone (No default value)
902default_week_format 0
903delayed_insert_limit 100
904delayed_insert_timeout 300
905delayed_queue_size 1000
906des-key-file (No default value)
907disconnect-slave-event-count 0
908div_precision_increment 4
909enable-locking FALSE
910engine-condition-pushdown TRUE
911expire_logs_days 10
912external-locking FALSE
913flush_time 0
914ft_max_word_len 84
915ft_min_word_len 4
916ft_query_expansion_limit 20
917ft_stopword_file (No default value)
918gdb FALSE
919general_log FALSE
920general_log_file (No default value)
921group_concat_max_len 1024
922help TRUE
923init-connect (No default value)
924init-file (No default value)
925init-slave (No default value)
926innodb ON
927innodb-adaptive-hash-index TRUE
928innodb-additional-mem-pool-size 1048576
929innodb-autoextend-increment 8
930innodb-autoinc-lock-mode 1
931innodb-buffer-pool-size 8388608
932innodb-checksums TRUE
933innodb-commit-concurrency 0
934innodb-concurrency-tickets 500
935innodb-data-file-path (No default value)
936innodb-data-home-dir (No default value)
937innodb-doublewrite TRUE
938innodb-fast-shutdown 1
939innodb-file-io-threads 4
940innodb-file-per-table FALSE
941innodb-flush-log-at-trx-commit 1
942innodb-flush-method (No default value)
943innodb-force-recovery 0
944innodb-lock-wait-timeout 50
945innodb-locks-unsafe-for-binlog FALSE
946innodb-log-buffer-size 1048576
947innodb-log-file-size 5242880
948innodb-log-files-in-group 2
949innodb-log-group-home-dir (No default value)
950innodb-max-dirty-pages-pct 90
951innodb-max-purge-lag 0
952innodb-mirrored-log-groups 1
953innodb-open-files 300
954innodb-rollback-on-timeout FALSE
955innodb-stats-on-metadata TRUE
956innodb-status-file FALSE
957innodb-support-xa TRUE
958innodb-sync-spin-loops 20
959innodb-table-locks TRUE
960innodb-thread-concurrency 8
961innodb-thread-sleep-delay 10000
962innodb-use-legacy-cardinality-algorithm TRUE
963interactive_timeout 28800
964join_buffer_size 131072
965keep_files_on_create FALSE
966key_buffer_size 16777216
967key_cache_age_threshold 300
968key_cache_block_size 1024
969key_cache_division_limit 100
970language /usr/share/mysql/english/
971large-pages FALSE
972lc-time-names en_US
973local-infile TRUE
974log (No default value)
975log-bin (No default value)
976log-bin-index (No default value)
977log-bin-trust-function-creators FALSE
978log-bin-trust-routine-creators FALSE
979log-error /var/log/mysql/error.log
980log-isam myisam.log
981log-output FILE
982log-queries-not-using-indexes FALSE
983log-short-format FALSE
984log-slave-updates FALSE
985log-slow-admin-statements FALSE
986log-slow-slave-statements FALSE
987log-tc tc.log
988log-tc-size 24576
989log-update (No default value)
990log-warnings 1
991log_slow_queries (No default value)
992long_query_time 10
993low-priority-updates FALSE
994lower_case_table_names 0
995master-connect-retry 60
996master-host (No default value)
997master-info-file master.info
998master-password (No default value)
999master-port 3306
1000master-retry-count 86400
1001master-ssl FALSE
1002master-ssl-ca (No default value)
1003master-ssl-capath (No default value)
1004master-ssl-cert (No default value)
1005master-ssl-cipher (No default value)
1006master-ssl-key (No default value)
1007master-user test
1008max-binlog-dump-events 0
1009max_allowed_packet 16777216
1010max_binlog_cache_size 18446744073709547520
1011max_binlog_size 104857600
1012max_connections 151
1013max_connect_errors 10
1014max_delayed_threads 20
1015max_error_count 64
1016max_heap_table_size 16777216
1017max_join_size 18446744073709551615
1018max_length_for_sort_data 1024
1019max_prepared_stmt_count 16382
1020max_relay_log_size 0
1021max_seeks_for_key 18446744073709551615
1022max_sort_length 1024
1023max_sp_recursion_depth 0
1024max_tmp_tables 32
1025max_user_connections 0
1026max_write_lock_count 18446744073709551615
1027memlock FALSE
1028min_examined_row_limit 0
1029multi_range_count 256
1030myisam-recover BACKUP
1031myisam_block_size 1024
1032myisam_data_pointer_size 6
1033myisam_max_extra_sort_file_size 2147483648
1034myisam_max_sort_file_size 9223372036853727232
1035myisam_repair_threads 1
1036myisam_sort_buffer_size 8388608
1037myisam_stats_method nulls_unequal
1038myisam_use_mmap FALSE
1039ndb-use-copying-alter-table FALSE
1040net_buffer_length 16384
1041net_read_timeout 30
1042net_retry_count 10
1043net_write_timeout 60
1044new FALSE
1045old FALSE
1046old-alter-table FALSE
1047old-passwords FALSE
1048old-style-user-limits FALSE
1049open_files_limit 1024
1050optimizer_prune_level 1
1051optimizer_search_depth 62
1052optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on
1053pid-file /var/lib/mysql/athena.pid
1054plugin-load (No default value)
1055plugin_dir /usr/lib/mysql/plugin
1056port 3306
1057port-open-timeout 0
1058preload_buffer_size 32768
1059profiling_history_size 15
1060query_alloc_block_size 8192
1061query_cache_limit 1048576
1062query_cache_min_res_unit 4096
1063query_cache_size 16777216
1064query_cache_type 1
1065query_cache_wlock_invalidate FALSE
1066query_prealloc_size 8192
1067range_alloc_block_size 4096
1068read_buffer_size 131072
1069read_only FALSE
1070read_rnd_buffer_size 262144
1071record_buffer 131072
1072relay-log (No default value)
1073relay-log-index (No default value)
1074relay-log-info-file relay-log.info
1075relay_log_purge TRUE
1076relay_log_space_limit 0
1077replicate-same-server-id FALSE
1078report-host (No default value)
1079report-password (No default value)
1080report-port 3306
1081report-user (No default value)
1082rpl-recovery-rank 0
1083safe-user-create FALSE
1084secure-auth FALSE
1085secure-file-priv (No default value)
1086server-id 0
1087show-slave-auth-info FALSE
1088skip-grant-tables FALSE
1089skip-slave-start FALSE
1090slave-exec-mode STRICT
1091slave-load-tmpdir /tmp
1092slave_compressed_protocol FALSE
1093slave_net_timeout 3600
1094slave_transaction_retries 10
1095slow-query-log FALSE
1096slow_launch_time 2
1097slow_query_log_file (No default value)
1098socket /var/run/mysqld/mysqld.sock
1099sort_buffer_size 2097144
1100sporadic-binlog-dump-fail FALSE
1101sql-mode OFF
1102ssl FALSE
1103ssl-ca (No default value)
1104ssl-capath (No default value)
1105ssl-cert (No default value)
1106ssl-cipher (No default value)
1107ssl-key (No default value)
1108symbolic-links TRUE
1109sync-binlog 0
1110sync-frm TRUE
1111sysdate-is-now FALSE
1112table_cache 64
1113table_definition_cache 256
1114table_lock_wait_timeout 50
1115table_open_cache 64
1116tc-heuristic-recover (No default value)
1117temp-pool TRUE
1118thread_cache_size 8
1119thread_concurrency 10
1120thread_stack 196608
1121timed_mutexes FALSE
1122time_format %H:%i:%s
1123tmpdir /tmp
1124tmp_table_size 16777216
1125transaction_alloc_block_size 8192
1126transaction_prealloc_size 4096
1127updatable_views_with_limit 1
1128use-symbolic-links TRUE
1129verbose TRUE
1130wait_timeout 28800
1131warnings 1
1132
1133To see what values a running MySQL server is using, type
1134'mysqladmin variables' instead of 'mysqld --verbose --help'.