1
/usr/libexec/mysqld Ver 5.0.45-log for redhat-linux-gnu on x86_64 (Source distribution)
2
Copyright (C) 2000 MySQL AB, by Monty and others
3
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
4
and you are welcome to modify and redistribute it under the GPL license
6
Starts the MySQL database server
8
Usage: /usr/libexec/mysqld [OPTIONS]
10
Default options are read from the following files in the given order:
11
/etc/my.cnf ~/.my.cnf /etc/my.cnf
12
The following groups are read: mysqld server mysqld-5.0
13
The following options may be given as the first argument:
14
--print-defaults Print the program argument list and exit
15
--no-defaults Don't read default options from any options file
16
--defaults-file=# Only read default options from the given file #
17
--defaults-extra-file=# Read this file after the global files are read
19
-?, --help Display this help and exit.
20
--abort-slave-event-count=#
21
Option used by mysql-test for debugging and testing of
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
-b, --basedir=name Path to installation directory. All paths are usually
39
resolved relative to this.
40
--bdb Enable Berkeley DB (if this version of MySQL supports
41
it). Disable with --skip-bdb (will save memory).
42
--bdb-home=name Berkeley home directory.
43
--bdb-lock-detect=name
44
Berkeley lock detect (DEFAULT, OLDEST, RANDOM or
46
--bdb-logdir=name Berkeley DB log file directory.
47
--bdb-no-recover Don't try to recover Berkeley DB tables on start.
48
--bdb-no-sync This option is deprecated, use --skip-sync-bdb-logs
50
--bdb-shared-data Start Berkeley DB in multi-process mode.
51
--bdb-tmpdir=name Berkeley DB tempfile name.
52
--big-tables Allow big result sets by saving all temporary sets on
53
file (Solves most 'table full' errors).
54
--bind-address=name IP address to bind to.
55
--binlog-do-db=name Tells the master it should log updates for the specified
56
database, and exclude all others not explicitly
58
--binlog-ignore-db=name
59
Tells the master that updates to the given database
60
should not be logged tothe binary log.
61
--bootstrap Used by mysql installation scripts.
62
--character-set-client-handshake
63
Don't ignore client side character set value sent during
65
--character-set-filesystem=name
66
Set the filesystem character set.
67
-C, --character-set-server=name
68
Set the default character set.
69
--character-sets-dir=name
70
Directory where character sets are.
71
-r, --chroot=name Chroot mysqld daemon during startup.
72
--collation-server=name
73
Set the default collation.
74
--completion-type=# Default completion type.
75
--concurrent-insert[=#]
76
Use concurrent insert with MyISAM. Disable with
78
--console Write error output on screen; Don't remove the console
80
--core-file Write core on errors.
81
-h, --datadir=name Path to the database root.
82
-C, --default-character-set=name
83
Set the default character set (deprecated option, use
84
--character-set-server instead).
85
--default-collation=name
86
Set the default collation (deprecated option, use
87
--collation-server instead).
88
--default-storage-engine=name
89
Set the default storage engine (table type) for tables.
90
--default-table-type=name
91
(deprecated) Use --default-storage-engine.
92
--default-time-zone=name
93
Set the default time zone.
94
--delay-key-write[=name]
95
Type of DELAY_KEY_WRITE.
96
--delay-key-write-for-all-tables
97
Don't flush key buffers between writes for any MyISAM
98
table (Deprecated option, use --delay-key-write=all
100
--des-key-file=name Load keys for des_encrypt() and des_encrypt from given
102
--disconnect-slave-event-count=#
103
Option used by mysql-test for debugging and testing of
105
--enable-locking Deprecated option, use --external-locking instead.
106
--enable-pstack Print a symbolic stack trace on failure.
107
--engine-condition-pushdown
108
Push supported query conditions to the storage engine.
109
-T, --exit-info[=#] Used for debugging; Use at your own risk!
110
--external-locking Use system (external) locking (disabled by default). With
111
this option enabled you can run myisamchk to test (not
112
repair) tables while the MySQL server is running. Disable
113
with --skip-external-locking.
114
--flush Flush tables to disk between SQL commands.
115
--gdb Set up signals usable for debugging
116
--large-pages Enable support for large pages. Disable with
118
--init-connect=name Command(s) that are executed for each new connection
119
--init-file=name Read SQL commands from this file at startup.
121
Set the replication role.
122
--init-slave=name Command(s) that are executed when a slave connects to
124
--innodb Enable InnoDB (if this version of MySQL supports it).
125
Disable with --skip-innodb (will save memory).
126
--innodb_checksums Enable InnoDB checksums validation (enabled by default).
127
Disable with --skip-innodb-checksums.
128
--innodb_data_file_path=name
129
Path to individual files and their sizes.
130
--innodb_data_home_dir=name
131
The common part for InnoDB table spaces.
133
Enable InnoDB doublewrite buffer (enabled by default).
134
Disable with --skip-innodb-doublewrite.
135
--innodb_fast_shutdown[=#]
136
Speeds up the shutdown process of the InnoDB storage
137
engine. Possible values are 0, 1 (faster) or 2 (fastest -
139
--innodb_file_per_table
140
Stores each InnoDB table to an .ibd file in the database
142
--innodb_flush_log_at_trx_commit[=#]
143
Set to 0 (write and flush once per second), 1 (write and
144
flush at each commit) or 2 (write at commit, flush once
146
--innodb_flush_method=name
147
With which method to flush data.
148
--innodb_locks_unsafe_for_binlog
149
Force InnoDB not to use next-key locking. Instead use
150
only row-level locking
151
--innodb_log_arch_dir=name
152
Where full logs should be archived.
153
--innodb_log_archive[=#]
154
Set to 1 if you want to have logs archived.
155
--innodb_log_group_home_dir=name
156
Path to InnoDB log files.
157
--innodb_max_dirty_pages_pct=#
158
Percentage of dirty pages allowed in bufferpool.
159
--innodb_max_purge_lag=#
160
Desired maximum length of the purge queue (0 = no limit)
161
--innodb_rollback_on_timeout
162
Roll back the complete transaction on lock wait timeout,
163
for 4.x compatibility (disabled by default)
165
Enable SHOW INNODB STATUS output in the
166
innodb_status.<pid> file
167
--innodb_support_xa Enable InnoDB support for the XA two-phase commit
169
Enable InnoDB locking in LOCK TABLES
170
--isam Obsolete. ISAM storage engine is no longer supported.
171
-L, --language=name Client error messages in given language. May be given as
174
Set the language used for the month names and the days of
176
--local-infile Enable/disable LOAD DATA LOCAL INFILE (takes values 1|0).
177
-l, --log[=name] Log connections and queries to file.
178
--log-bin[=name] Log update queries in binary format. Optional (but
179
strongly recommended to avoid replication problems if
180
server's hostname changes) argument should be the chosen
181
location for the binary log files.
183
File that holds the names for last binary log files.
184
--log-bin-trust-function-creators
185
If equal to 0 (the default), then when --log-bin is used,
186
creation of a stored function is allowed only to users
187
having the SUPER privilege and only if this function may
188
not break binary logging.
189
--log-bin-trust-routine-creators
190
(deprecated) Use log-bin-trust-function-creators.
191
--log-error[=name] Error log file.
192
--log-isam[=name] Log all MyISAM changes to file.
193
-0, --log-long-format
194
Log some extra information to update log. Please note
195
that this option is deprecated; see --log-short-format
197
--log-queries-not-using-indexes
198
Log queries that are executed without benefit of any
199
index to the slow log if it is open.
200
--log-short-format Don't log extra information to update and slow-query
202
--log-slave-updates Tells the slave to log the updates from the slave thread
203
to the binary log. You will need to turn it on if you
204
plan to daisy-chain the slaves.
205
--log-slow-admin-statements
206
Log slow OPTIMIZE, ANALYZE, ALTER and other
207
administrative statements to the slow log if it is open.
208
--log-slow-queries[=name]
209
Log slow queries to this log file. Defaults logging to
210
hostname-slow.log file. Must be enabled to activate other
212
--log-tc=name Path to transaction coordinator log (used for
213
transactions that affect more than one storage engine,
214
when binary log is disabled)
215
--log-tc-size=# Size of transaction coordinator log.
216
--log-update[=name] The update log is deprecated since version 5.0, is
217
replaced by the binary log and this option justs turns on
219
-W, --log-warnings[=#]
220
Log some not critical warnings to the log file.
221
--low-priority-updates
222
INSERT/DELETE/UPDATE has lower priority than selects.
223
--master-connect-retry=#
224
The number of seconds the slave thread will sleep before
225
retrying to connect to the master in case the master goes
226
down or the connection is lost.
227
--master-host=name Master hostname or IP address for replication. If not
228
set, the slave thread will not be started. Note that the
229
setting of master-host will be ignored if there exists a
230
valid master.info file.
231
--master-info-file=name
232
The location and name of the file that remembers the
233
master and where the I/O replication thread is in the
235
--master-password=name
236
The password the slave thread will authenticate with when
237
connecting to the master. If not set, an empty password
238
is assumed.The value in master.info will take precedence
240
--master-port=# The port the master is listening on. If not set, the
241
compiled setting of MYSQL_PORT is assumed. If you have
242
not tinkered with configure options, this should be 3306.
243
The value in master.info will take precedence if it can
245
--master-retry-count=#
246
The number of tries the slave will make to connect to the
247
master before giving up.
248
--master-ssl Enable the slave to connect to the master using SSL.
249
--master-ssl-ca[=name]
250
Master SSL CA file. Only applies if you have enabled
252
--master-ssl-capath[=name]
253
Master SSL CA path. Only applies if you have enabled
255
--master-ssl-cert[=name]
256
Master SSL certificate file name. Only applies if you
257
have enabled master-ssl
258
--master-ssl-cipher[=name]
259
Master SSL cipher. Only applies if you have enabled
261
--master-ssl-key[=name]
262
Master SSL keyfile name. Only applies if you have enabled
264
--master-user=name The username the slave thread will use for authentication
265
when connecting to the master. The user must have FILE
266
privilege. If the master user is not set, user test is
267
assumed. The value in master.info will take precedence if
269
--max-binlog-dump-events=#
270
Option used by mysql-test for debugging and testing of
272
--memlock Lock mysqld in memory.
273
--merge Enable Merge storage engine. Disable with --skip-merge.
274
--myisam-recover[=name]
275
Syntax: myisam-recover[=option[,option...]], where option
276
can be DEFAULT, BACKUP, FORCE or QUICK.
277
--ndbcluster Enable NDB Cluster (if this version of MySQL supports
278
it). Disable with --skip-ndbcluster (will save memory).
279
-n, --new Use very new possible 'unsafe' functions.
280
--old-passwords Use old password encryption method (needed for 4.0 and
282
--old-style-user-limits
283
Enable old-style user limits (before 5.0.3 user resources
284
were counted per each user+host vs. per account)
285
--pid-file=name Pid file used by safe_mysqld.
286
-P, --port=# Port number to use for connection.
287
--port-open-timeout=#
288
Maximum time in seconds to wait for the port to become
289
free. (Default: no wait)
290
--profiling_history_size=#
291
Limit of query profiling memory
292
--relay-log=name The location and name to use for relay logs.
293
--relay-log-index=name
294
The location and name to use for the file that keeps a
295
list of the last relay logs.
296
--relay-log-info-file=name
297
The location and name of the file that remembers where
298
the SQL replication thread is in the relay logs.
299
--replicate-do-db=name
300
Tells the slave thread to restrict replication to the
301
specified database. To specify more than one database,
302
use the directive multiple times, once for each database.
303
Note that this will only work if you do not use
304
cross-database queries such as UPDATE some_db.some_table
305
SET foo='bar' while having selected a different or no
306
database. If you need cross database updates to work,
307
make sure you have 3.23.28 or later, and use
308
replicate-wild-do-table=db_name.%.
309
--replicate-do-table=name
310
Tells the slave thread to restrict replication to the
311
specified table. To specify more than one table, use the
312
directive multiple times, once for each table. This will
313
work for cross-database updates, in contrast to
315
--replicate-ignore-db=name
316
Tells the slave thread to not replicate to the specified
317
database. To specify more than one database to ignore,
318
use the directive multiple times, once for each database.
319
This option will not work if you use cross database
320
updates. If you need cross database updates to work, make
321
sure you have 3.23.28 or later, and use
322
replicate-wild-ignore-table=db_name.%.
323
--replicate-ignore-table=name
324
Tells the slave thread to not replicate to the specified
325
table. To specify more than one table to ignore, use the
326
directive multiple times, once for each table. This will
327
work for cross-datbase updates, in contrast to
329
--replicate-rewrite-db=name
330
Updates to a database with a different name than the
332
replicate-rewrite-db=master_db_name->slave_db_name.
333
--replicate-same-server-id
334
In replication, if set to 1, do not skip events having
335
our server id. Default value is 0 (to break infinite
336
loops in circular replication). Can't be set to 1 if
337
--log-slave-updates is used.
338
--replicate-wild-do-table=name
339
Tells the slave thread to restrict replication to the
340
tables that match the specified wildcard pattern. To
341
specify more than one table, use the directive multiple
342
times, once for each table. This will work for
343
cross-database updates. Example:
344
replicate-wild-do-table=foo%.bar% will replicate only
345
updates to tables in all databases that start with foo
346
and whose table names start with bar.
347
--replicate-wild-ignore-table=name
348
Tells the slave thread to not replicate to the tables
349
that match the given wildcard pattern. To specify more
350
than one table to ignore, use the directive multiple
351
times, once for each table. This will work for
352
cross-database updates. Example:
353
replicate-wild-ignore-table=foo%.bar% will not do updates
354
to tables in databases that start with foo and whose
355
table names start with bar.
356
--report-host=name Hostname or IP of the slave to be reported to to the
357
master during slave registration. Will appear in the
358
output of SHOW SLAVE HOSTS. Leave unset if you do not
359
want the slave to register itself with the master. Note
360
that it is not sufficient for the master to simply read
361
the IP of the slave off the socket once the slave
362
connects. Due to NAT and other routing issues, that IP
363
may not be valid for connecting to the slave from the
364
master or other hosts.
365
--report-password=name
367
--report-port=# Port for connecting to slave reported to the master
368
during slave registration. Set it only if the slave is
369
listening on a non-default port or if you have a special
370
tunnel from the master or other clients to the slave. If
371
not sure, leave this option unset.
372
--report-user=name Undocumented.
373
--rpl-recovery-rank=#
375
--safe-mode Skip some optimize stages (for testing).
377
Deprecated option; use GRANT SHOW DATABASES instead...
378
--safe-user-create Don't allow new user creation by the user who has no
379
write privileges to the mysql.user table.
380
--safemalloc-mem-limit=#
381
Simulate memory shortage when compiled with the
382
--with-debug=full option.
383
--secure-auth Disallow authentication for accounts that have old
385
--secure-file-priv=name
386
Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to
387
files within specified directory
388
--server-id=# Uniquely identifies the server instance in the community
389
of replication partners.
390
-O, --set-variable=name
391
Change the value of a variable. Please note that this
392
option is deprecated;you can set variables directly with
393
--variable-name=value.
394
--show-slave-auth-info
395
Show user and password in SHOW SLAVE HOSTS on this master
396
--skip-grant-tables Start without grant tables. This gives all users FULL
397
ACCESS to all tables!
398
--skip-host-cache Don't cache host names.
399
--skip-locking Deprecated option, use --skip-external-locking instead.
400
--skip-name-resolve Don't resolve hostnames. All hostnames are IP's or
402
--skip-networking Don't allow connection with TCP/IP.
403
--skip-new Don't use new, possible wrong routines.
405
Don't allow 'SHOW DATABASE' commands.
406
--skip-slave-start If set, slave is not autostarted.
407
--skip-stack-trace Don't print a stack trace on failure.
408
--skip-symlink Don't allow symlinking of tables. Deprecated option. Use
409
--skip-symbolic-links instead.
410
--skip-thread-priority
411
Don't give threads different priorities.
412
--slave-load-tmpdir=name
413
The location where the slave should put its temporary
414
files when replicating a LOAD DATA INFILE command.
415
--slave-skip-errors=name
416
Tells the slave thread to continue replication when a
417
query returns an error from the provided list.
418
--socket=name Socket file to use for connection.
419
--sporadic-binlog-dump-fail
420
Option used by mysql-test for debugging and testing of
422
--sql-bin-update-same=#
423
The update log is deprecated since version 5.0, is
424
replaced by the binary log and this option does nothing
426
--sql-mode=name Syntax: sql-mode=option[,option[,option...]] where option
427
can be one of: REAL_AS_FLOAT, PIPES_AS_CONCAT,
428
ANSI_QUOTES, IGNORE_SPACE, ONLY_FULL_GROUP_BY,
429
NO_UNSIGNED_SUBTRACTION.
430
--ssl Enable SSL for connection (automatically enabled with
431
other flags). Disable with --skip-ssl.
432
--ssl-ca=name CA file in PEM format (check OpenSSL docs, implies
434
--ssl-capath=name CA directory (check OpenSSL docs, implies --ssl).
435
--ssl-cert=name X509 cert in PEM format (implies --ssl).
436
--ssl-cipher=name SSL cipher to use (implies --ssl).
437
--ssl-key=name X509 key in PEM format (implies --ssl).
439
Enable symbolic link support.
440
--sysdate-is-now Non-default option to alias SYSDATE() to NOW() to make it
441
safe-replicable. Since 5.0, SYSDATE() returns a `dynamic'
442
value different for different invocations, even within
444
--tc-heuristic-recover=name
445
Decision to use in heuristic recover process. Possible
446
values are COMMIT or ROLLBACK.
447
--temp-pool Using this option will cause most temporary files created
448
to use a small set of names, rather than a unique name
450
--timed_mutexes Specify whether to time mutexes (only InnoDB mutexes are
452
-t, --tmpdir=name Path for temporary files. Several paths may be specified,
453
separated by a colon (:), in this case they are used in a
455
--transaction-isolation=name
456
Default transaction isolation level.
457
-s, --use-symbolic-links
458
Enable symbolic link support. Deprecated option; use
459
--symbolic-links instead.
460
-u, --user=name Run mysqld daemon as user.
461
-v, --verbose Used with --help option for detailed help
462
-V, --version Output version information and exit.
463
-W, --warnings[=#] Deprecated; use --log-warnings instead.
464
--back_log=# The number of outstanding connection requests MySQL can
465
have. This comes into play when the main MySQL thread
466
gets very many connection requests in a very short time.
467
--bdb_cache_size=# The buffer that is allocated to cache index and rows for
469
--bdb_lock_max=# Synonym for bdb_max_lock.
470
--bdb_log_buffer_size=#
471
The buffer that is allocated to cache index and rows for
473
--bdb_max_lock=# The maximum number of locks you can have active on a BDB
475
--binlog_cache_size=#
476
The size of the cache to hold the SQL statements for the
477
binary log during a transaction. If you often use big,
478
multi-statement transactions you can increase this to get
480
--bulk_insert_buffer_size=#
481
Size of tree cache used in bulk insert optimisation. Note
482
that this is a limit per thread!
483
--connect_timeout=# The number of seconds the mysqld server is waiting for a
484
connect packet before responding with 'Bad handshake'.
485
--date_format=name The DATE format (For future).
486
--datetime_format=name
487
The DATETIME/TIMESTAMP format (for future).
488
--default_week_format=#
489
The default week format used by WEEK() functions.
490
--delayed_insert_limit=#
491
After inserting delayed_insert_limit rows, the INSERT
492
DELAYED handler will check if there are any SELECT
493
statements pending. If so, it allows these to execute
495
--delayed_insert_timeout=#
496
How long a INSERT DELAYED thread should wait for INSERT
497
statements before terminating.
498
--delayed_queue_size=#
499
What size queue (in rows) should be allocated for
500
handling INSERT DELAYED. If the queue becomes full, any
501
client that does INSERT DELAYED will wait until there is
502
room in the queue again.
503
--div_precision_increment=#
504
Precision of the result of '/' operator will be increased
507
If non-zero, binary logs will be purged after
508
expire_logs_days days; possible purges happen at startup
509
and at binary log rotation.
510
--flush_time=# A dedicated thread is created to flush all tables at the
512
--ft_boolean_syntax=name
513
List of operators for MATCH ... AGAINST ( ... IN BOOLEAN
515
--ft_max_word_len=# The maximum length of the word to be included in a
516
FULLTEXT index. Note: FULLTEXT indexes must be rebuilt
517
after changing this variable.
518
--ft_min_word_len=# The minimum length of the word to be included in a
519
FULLTEXT index. Note: FULLTEXT indexes must be rebuilt
520
after changing this variable.
521
--ft_query_expansion_limit=#
522
Number of best matches to use for query expansion
523
--ft_stopword_file=name
524
Use stopwords from this file instead of built-in list.
525
--group_concat_max_len=#
526
The maximum length of the result of function
528
--innodb_additional_mem_pool_size=#
529
Size of a memory pool InnoDB uses to store data
530
dictionary information and other internal data
532
--innodb_autoextend_increment=#
533
Data file autoextend increment in megabytes
534
--innodb_buffer_pool_awe_mem_mb=#
535
If Windows AWE is used, the size of InnoDB buffer pool
536
allocated from the AWE memory.
537
--innodb_buffer_pool_size=#
538
The size of the memory buffer InnoDB uses to cache data
539
and indexes of its tables.
540
--innodb_commit_concurrency=#
541
Helps in performance tuning in heavily concurrent
543
--innodb_concurrency_tickets=#
544
Number of times a thread is allowed to enter InnoDB
545
within the same SQL query after it has once got the
547
--innodb_file_io_threads=#
548
Number of file I/O threads in InnoDB.
549
--innodb_force_recovery=#
550
Helps to save your data in case the disk image of the
551
database becomes corrupt.
552
--innodb_lock_wait_timeout=#
553
Timeout in seconds an InnoDB transaction may wait for a
554
lock before being rolled back.
555
--innodb_log_buffer_size=#
556
The size of the buffer which InnoDB uses to write log to
557
the log files on disk.
558
--innodb_log_file_size=#
559
Size of each log file in a log group.
560
--innodb_log_files_in_group=#
561
Number of log files in the log group. InnoDB writes to
562
the files in a circular fashion. Value 3 is recommended
564
--innodb_mirrored_log_groups=#
565
Number of identical copies of log groups we keep for the
566
database. Currently this should be set to 1.
567
--innodb_open_files=#
568
How many files at the maximum InnoDB keeps open at the
570
--innodb_sync_spin_loops=#
571
Count of spin-loop rounds in InnoDB mutexes
572
--innodb_thread_concurrency=#
573
Helps in performance tuning in heavily concurrent
574
environments. Sets the maximum number of threads allowed
575
inside InnoDB. Value 0 will disable the thread
577
--innodb_thread_sleep_delay=#
578
Time of innodb thread sleeping before joining InnoDB
579
queue (usec). Value 0 disable a sleep
580
--interactive_timeout=#
581
The number of seconds the server waits for activity on an
582
interactive connection before closing it.
584
The size of the buffer that is used for full joins.
585
--key_buffer_size=# The size of the buffer used for index blocks for MyISAM
586
tables. Increase this to get better index handling (for
587
all reads and multiple writes) to as much as you can
588
afford; 64M on a 256M machine that mainly runs MySQL is
590
--key_cache_age_threshold=#
591
This characterizes the number of hits a hot block has to
592
be untouched until it is considered aged enough to be
593
downgraded to a warm block. This specifies the percentage
594
ratio of that number of hits to the total number of
596
--key_cache_block_size=#
597
The default size of key cache blocks
598
--key_cache_division_limit=#
599
The minimum percentage of warm blocks in key cache
600
--long_query_time=# Log all queries that have taken more than long_query_time
601
seconds to execute to file.
602
--lower_case_table_names[=#]
603
If set to 1 table names are stored in lowercase on disk
604
and table names will be case-insensitive. Should be set
605
to 2 if you are using a case insensitive file system
606
--max_allowed_packet=#
607
Max packetlength to send/receive from to server.
608
--max_binlog_cache_size=#
609
Can be used to restrict the total size used to cache a
610
multi-transaction query.
611
--max_binlog_size=# Binary log will be rotated automatically when the size
612
exceeds this value. Will also apply to relay logs if
613
max_relay_log_size is 0. The minimum value for this
615
--max_connect_errors=#
616
If there is more than this number of interrupted
617
connections from a host this host will be blocked from
619
--max_connections=# The number of simultaneous clients allowed.
620
--max_delayed_threads=#
621
Don't start more than this number of threads to handle
622
INSERT DELAYED statements. If set to zero, which means
623
INSERT DELAYED is not used.
624
--max_error_count=# Max number of errors/warnings to store for a statement.
625
--max_heap_table_size=#
626
Don't allow creation of heap tables bigger than this.
627
--max_join_size=# Joins that are probably going to read more than
628
max_join_size records return an error.
629
--max_length_for_sort_data=#
630
Max number of bytes in sorted records.
631
--max_prepared_stmt_count=#
632
Maximum number of prepared statements in the server.
633
--max_relay_log_size=#
634
If non-zero: relay log will be rotated automatically when
635
the size exceeds this value; if zero (the default): when
636
the size exceeds max_binlog_size. 0 excepted, the minimum
637
value for this variable is 4096.
638
--max_seeks_for_key=#
639
Limit assumed max number of seeks when looking up rows
641
--max_sort_length=# The number of bytes to use when sorting BLOB or TEXT
642
values (only the first max_sort_length bytes of each
643
value are used; the rest are ignored).
644
--max_sp_recursion_depth[=#]
645
Maximum stored procedure recursion depth. (discussed with
647
--max_tmp_tables=# Maximum number of temporary tables a client can keep open
649
--max_user_connections=#
650
The maximum number of active connections for a single
652
--max_write_lock_count=#
653
After this many write locks, allow some read locks to run
655
--multi_range_count=#
656
Number of key ranges to request at once.
657
--myisam_block_size=#
658
Block size to be used for MyISAM index pages.
659
--myisam_data_pointer_size=#
660
Default pointer size to be used for MyISAM tables.
661
--myisam_max_extra_sort_file_size=#
663
--myisam_max_sort_file_size=#
664
Don't use the fast sort index method to created index if
665
the temporary file would get bigger than this.
666
--myisam_repair_threads=#
667
Number of threads to use when repairing MyISAM tables.
668
The value of 1 disables parallel repair.
669
--myisam_sort_buffer_size=#
670
The buffer that is allocated when sorting the index when
671
doing a REPAIR or when creating indexes with CREATE INDEX
673
--myisam_stats_method=name
674
Specifies how MyISAM index statistics collection code
675
should threat NULLs. Possible values of name are
676
"nulls_unequal" (default behavior for 4.1/5.0),
677
"nulls_equal" (emulate 4.0 behavior), and
679
--net_buffer_length=#
680
Buffer length for TCP/IP and socket communication.
682
Number of seconds to wait for more data from a connection
683
before aborting the read.
684
--net_retry_count=# If a read on a communication port is interrupted, retry
685
this many times before giving up.
686
--net_write_timeout=#
687
Number of seconds to wait for a block to be written to a
688
connection before aborting the write.
690
If this is not 0, then mysqld will use this value to
691
reserve file descriptors to use with setrlimit(). If this
692
value is 0 then mysqld will reserve max_connections*5 or
693
max_connections + table_cache*2 (whichever is larger)
695
--optimizer_prune_level[=#]
696
Controls the heuristic(s) applied during query
697
optimization to prune less-promising partial plans from
698
the optimizer search space. Meaning: 0 - do not apply any
699
heuristic, thus perform exhaustive search; 1 - prune
700
plans based on number of retrieved rows.
701
--optimizer_search_depth[=#]
702
Maximum depth of search performed by the query optimizer.
703
Values larger than the number of relations in a query
704
result in better query plans, but take longer to compile
705
a query. Smaller values than the number of tables in a
706
relation result in faster optimization, but may produce
707
very bad query plans. If set to 0, the system will
708
automatically pick a reasonable value; if set to
709
MAX_TABLES+2, the optimizer will switch to the original
710
find_best (used for testing/comparison).
711
--preload_buffer_size=#
712
The size of the buffer that is allocated when preloading
714
--query_alloc_block_size=#
715
Allocation block size for query parsing and execution
716
--query_cache_limit=#
717
Don't cache results that are bigger than this.
718
--query_cache_min_res_unit=#
719
minimal size of unit in wich space for results is
720
allocated (last unit will be trimed after writing all
723
The memory allocated to store results from old queries.
725
0 = OFF = Don't cache or retrieve results. 1 = ON = Cache
726
all results except SELECT SQL_NO_CACHE ... queries. 2 =
727
DEMAND = Cache only SELECT SQL_CACHE ... queries.
728
--query_cache_wlock_invalidate
729
Invalidate queries in query cache on LOCK for write
730
--query_prealloc_size=#
731
Persistent buffer for query parsing and execution
732
--range_alloc_block_size=#
733
Allocation block size for storing ranges during
736
Each thread that does a sequential scan allocates a
737
buffer of this size for each table it scans. If you do
738
many sequential scans, you may want to increase this
740
--read_only Make all non-temporary tables read-only, with the
741
exception for replication (slave) threads and users with
743
--read_rnd_buffer_size=#
744
When reading rows in sorted order after a sort, the rows
745
are read through this buffer to avoid a disk seeks. If
746
not set, then it's set to the value of record_buffer.
747
--record_buffer=# Alias for read_buffer_size
748
--relay_log_purge 0 = do not purge relay logs. 1 = purge them as soon as
749
they are no more needed.
750
--relay_log_space_limit=#
751
Maximum space to use for all relay logs.
752
--slave_compressed_protocol
753
Use compression on master/slave protocol.
754
--slave_net_timeout=#
755
Number of seconds to wait for more data from a
756
master/slave connection before aborting the read.
757
--slave_transaction_retries=#
758
Number of times the slave SQL thread will retry a
759
transaction in case it failed with a deadlock or elapsed
760
lock wait timeout, before giving up and stopping.
762
If creating the thread takes longer than this value (in
763
seconds), the Slow_launch_threads counter will be
766
Each thread that needs to do a sort allocates a buffer of
768
--sync-bdb-logs Synchronously flush Berkeley DB logs. Enabled by default
769
--sync-binlog=# Synchronously flush binary log to disk after every #th
770
event. Use 0 (default) to disable synchronous flushing.
771
--sync-frm Sync .frm to disk on create. Enabled by default.
772
--table_cache=# The number of open tables for all threads.
773
--table_lock_wait_timeout=#
774
Timeout in seconds to wait for a table level lock before
775
returning an error. Used only if the connection has
777
--thread_cache_size=#
778
How many threads we should keep in a cache for reuse.
779
--thread_concurrency=#
780
Permits the application to give the threads system a hint
781
for the desired number of threads that should be run at
783
--thread_stack=# The stack size for each thread.
784
--time_format=name The TIME format (for future).
785
--tmp_table_size=# If an in-memory temporary table exceeds this size, MySQL
786
will automatically convert it to an on-disk MyISAM table.
787
--transaction_alloc_block_size=#
788
Allocation block size for various transaction-related
790
--transaction_prealloc_size=#
791
Persistent buffer for various transaction-related
793
--updatable_views_with_limit=#
794
1 = YES = Don't issue an error message (warning only) if
795
a VIEW without presence of a key of the underlying table
796
is used in queries with a LIMIT clause for updating. 0 =
797
NO = Prohibit update of a VIEW, which does not contain a
798
key of the underlying table and the query uses a LIMIT
799
clause (usually get from GUI tools).
800
--wait_timeout=# The number of seconds the server waits for activity on a
801
connection before closing it.
803
Variables (--variable-name=value)
804
and boolean options {FALSE|TRUE} Value (after reading options)
805
--------------------------------- -----------------------------
807
abort-slave-event-count 0
808
allow-suspicious-udfs FALSE
809
auto-increment-increment 1
810
auto-increment-offset 1
811
automatic-sp-privileges TRUE
814
bdb-home (No default value)
815
bdb-logdir (No default value)
816
bdb-tmpdir (No default value)
817
bind-address (No default value)
818
character-set-client-handshake TRUE
819
character-set-filesystem binary
820
character-set-server latin1
821
character-sets-dir /usr/share/mysql/charsets/
822
chroot (No default value)
823
collation-server latin1_swedish_ci
827
datadir /mnt/data/mysql/
828
default-character-set latin1
829
default-collation latin1_swedish_ci
830
default-time-zone (No default value)
831
des-key-file (No default value)
832
disconnect-slave-event-count 0
835
engine-condition-pushdown FALSE
836
external-locking FALSE
839
init-connect (No default value)
840
init-file (No default value)
841
init-slave (No default value)
843
innodb_checksums TRUE
844
innodb_data_home_dir (No default value)
845
innodb_doublewrite TRUE
846
innodb_fast_shutdown 1
847
innodb_file_per_table TRUE
848
innodb_flush_log_at_trx_commit 2
849
innodb_flush_method O_DIRECT
850
innodb_locks_unsafe_for_binlog FALSE
851
innodb_log_arch_dir (No default value)
852
innodb_log_group_home_dir (No default value)
853
innodb_max_dirty_pages_pct 90
854
innodb_max_purge_lag 0
855
innodb_rollback_on_timeout FALSE
856
innodb_status_file FALSE
857
innodb_support_xa TRUE
858
innodb_table_locks TRUE
860
language /usr/share/mysql/english/
863
log (No default value)
865
log-bin-index (No default value)
866
log-bin-trust-function-creators FALSE
867
log-bin-trust-routine-creators FALSE
870
log-queries-not-using-indexes FALSE
871
log-short-format FALSE
872
log-slave-updates FALSE
873
log-slow-admin-statements FALSE
874
log-slow-queries (No default value)
877
log-update (No default value)
879
low-priority-updates FALSE
880
master-connect-retry 60
881
master-host (No default value)
882
master-info-file master.info
883
master-password (No default value)
885
master-retry-count 86400
887
master-ssl-ca (No default value)
888
master-ssl-capath (No default value)
889
master-ssl-cert (No default value)
890
master-ssl-cipher (No default value)
891
master-ssl-key (No default value)
893
max-binlog-dump-events 0
900
old-style-user-limits FALSE
901
pid-file /mnt/data/mysql/sl1.pid
904
profiling_history_size 15
905
relay-log (No default value)
906
relay-log-index (No default value)
907
relay-log-info-file relay-log.info
908
replicate-same-server-id FALSE
909
report-host (No default value)
910
report-password (No default value)
912
report-user (No default value)
914
safe-user-create FALSE
916
secure-file-priv (No default value)
918
show-slave-auth-info FALSE
919
skip-grant-tables FALSE
920
skip-slave-start FALSE
921
slave-load-tmpdir /tmp/
922
socket /mnt/data/mysql/mysql.sock
923
sporadic-binlog-dump-fail FALSE
926
ssl-ca /opt/mysql.pdns/.cert/ca-cert.pem
927
ssl-capath (No default value)
928
ssl-cert /opt/mysql.pdns/.cert/server-cert.pem
929
ssl-cipher (No default value)
930
ssl-key /opt/mysql.pdns/.cert/server-key.pem
933
tc-heuristic-recover (No default value)
936
tmpdir (No default value)
937
use-symbolic-links TRUE
941
bdb_cache_size 8388600
943
bdb_log_buffer_size 0
945
binlog_cache_size 32768
946
bulk_insert_buffer_size 8388608
948
date_format (No default value)
949
datetime_format (No default value)
950
default_week_format 0
951
delayed_insert_limit 100
952
delayed_insert_timeout 300
953
delayed_queue_size 1000
954
div_precision_increment 4
959
ft_query_expansion_limit 20
960
ft_stopword_file (No default value)
961
group_concat_max_len 1024
962
innodb_additional_mem_pool_size 1048576
963
innodb_autoextend_increment 8
964
innodb_buffer_pool_awe_mem_mb 0
965
innodb_buffer_pool_size 16777216
966
innodb_commit_concurrency 0
967
innodb_concurrency_tickets 500
968
innodb_file_io_threads 4
969
innodb_force_recovery 0
970
innodb_lock_wait_timeout 3
971
innodb_log_buffer_size 1048576
972
innodb_log_file_size 67108864
973
innodb_log_files_in_group 2
974
innodb_mirrored_log_groups 1
975
innodb_open_files 300
976
innodb_sync_spin_loops 20
977
innodb_thread_concurrency 8
978
innodb_thread_sleep_delay 10000
979
interactive_timeout 28800
980
join_buffer_size 131072
981
key_buffer_size 8388600
982
key_cache_age_threshold 300
983
key_cache_block_size 1024
984
key_cache_division_limit 100
986
lower_case_table_names 0
987
max_allowed_packet 1048576
988
max_binlog_cache_size 18446744073709551615
989
max_binlog_size 1073741824
990
max_connect_errors 10
992
max_delayed_threads 20
994
max_heap_table_size 16777216
995
max_join_size 18446744073709551615
996
max_length_for_sort_data 1024
997
max_prepared_stmt_count 16382
999
max_seeks_for_key 18446744073709551615
1000
max_sort_length 1024
1001
max_sp_recursion_depth 0
1003
max_user_connections 0
1004
max_write_lock_count 18446744073709551615
1005
multi_range_count 256
1006
myisam_block_size 1024
1007
myisam_data_pointer_size 6
1008
myisam_max_extra_sort_file_size 2147483648
1009
myisam_max_sort_file_size 9223372036854775807
1010
myisam_repair_threads 1
1011
myisam_sort_buffer_size 8388608
1012
myisam_stats_method nulls_unequal
1013
net_buffer_length 16384
1016
net_write_timeout 60
1018
optimizer_prune_level 1
1019
optimizer_search_depth 62
1020
preload_buffer_size 32768
1021
query_alloc_block_size 8192
1022
query_cache_limit 1048576
1023
query_cache_min_res_unit 4096
1026
query_cache_wlock_invalidate FALSE
1027
query_prealloc_size 8192
1028
range_alloc_block_size 2048
1029
read_buffer_size 131072
1031
read_rnd_buffer_size 262144
1032
record_buffer 131072
1033
relay_log_purge TRUE
1034
relay_log_space_limit 0
1035
slave_compressed_protocol FALSE
1036
slave_net_timeout 3600
1037
slave_transaction_retries 10
1039
sort_buffer_size 2097144
1044
table_lock_wait_timeout 50
1046
thread_concurrency 10
1048
time_format (No default value)
1049
tmp_table_size 33554432
1050
transaction_alloc_block_size 8192
1051
transaction_prealloc_size 4096
1052
updatable_views_with_limit 1
1055
To see what values a running MySQL server is using, type
1056
'mysqladmin variables' instead of 'mysqld --verbose --help'.