5
4
There are many different options one can use to configure Drizzle.
9
.. option:: --help-extended
10
Display this help and exit after initializing plugins.
13
Display this help and exit.
15
.. option:: --no-defaults
16
Configuration file defaults are not used if no-defaults is set
18
.. option:: --defaults-file arg
19
Configuration file to use
21
.. option:: --config-dir arg (=/etc/drizzle)
22
Base location for config files
24
.. option:: --plugin-dir arg
27
.. option:: --pid-file arg
29
Pid file used by drizzled.
31
Plugin Loading Options
32
----------------------
34
.. option:: --plugin-add arg
35
Optional comma separated list of plugins to load at startup in addition
36
to the default list of plugins.
38
for example: --plugin_add=crc32,console,pbxt
40
.. option:: --plugin-remove arg
41
Optional comma separated list of plugins to not load at startup.
42
Effectively removes a plugin from the list of plugins to be loaded.
44
for example: --plugin_remove=syslog,md5
46
.. option:: --plugin-load arg (=version,uuid_function,user_function,transaction_log,syslog,substr_functions,sleep,show_schema_proto,rot13,reverse_function,rand_function,multi_thread,md5,logging_stats,length,hex_functions,hello_world,filtered_replicator,errmsg_stderr,default_replicator,database_function,crc32,connection_id,compression,charlength,benchmark,ascii,)
48
Optional comma separated list of plugins to load at starup instead of
49
the default plugin load list. This completely replaces the whole list.
54
.. option:: --auto-increment-increment arg (=1)
56
Auto-increment columns are incremented by this
58
.. option:: --auto-increment-offset arg (=1)
60
Offset added to Auto-increment columns.
61
Used when auto-increment-increment != 1
63
.. option:: -b,--basedir arg
65
Path to installation directory.
66
All paths are usually resolved relative to this.
68
.. option:: -r,--chroot arg
70
Chroot drizzled daemon during startup.
72
.. option:: --collation-server arg
74
Set the default collation.
76
.. option:: --completion-type arg (=0)
78
Default completion type.
80
.. option:: --core-file
84
.. option:: --datadir arg
86
Path to the database root.
88
.. option:: --default-storage-engine arg
90
Set the default storage engine for tables.
92
.. option:: --default-time-zone arg
94
Set the default time zone.
96
.. We should really remove --exit-info as an option
97
.. option:: -T,--exit-info arg
99
Used for debugging; Use at your own risk!
103
Set up signals usable for debugging
105
.. option:: --lc-time-name arg
107
Set the language used for the month names and the days of the week.
109
.. option:: -W [ --log-warnings ] arg
111
Log some not critical warnings to the log file.
113
.. Why is this a core argument?
114
.. option:: --port-open-timeout arg (=0)
116
Maximum time in seconds to wait for the port to become free.
117
A value of 0 means not to wait.
119
.. option:: --secure-file-priv arg
121
Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to files within
124
.. Why is this still here?
125
.. option:: --server-id arg (=0)
127
Uniquely identifies the server instance in the community of replication
130
.. option:: --skip-stack-trace
132
Don't print a stack trace on failure.
134
.. option:: -s,--symbolic-links
136
Enable symbolic link support.
138
.. option:: --timed-mutexes
140
Specify whether to time mutexes (only InnoDB mutexes are currently supported)
142
.. option:: -t,--tmpdir arg
144
Path for temporary files.
146
.. option:: --transaction-isolation arg
148
Default transaction isolation level.
150
.. option:: -u,--user arg
152
Run drizzled daemon as user.
154
.. option:: -V,--version
156
Output version information and exit.
158
.. option:: --back-log arg (=50)
160
The number of outstanding connection requests Drizzle can have. This comes
161
into play when the main Drizzle thread gets very many connection requests in
164
.. option:: --bulk-insert-buffer-size arg (=8388608)
166
Size of tree cache used in bulk insert optimization. Note that this is a limit
169
.. option:: --div-precision-increment arg (=4)
171
Precision of the result of '/' operator will be increased on that value.
173
.. option:: --group-concat-max-len arg (=1024)
175
The maximum length of the result of function group_concat.
177
.. option:: --join-buffer-size arg (=131072)
179
The size of the buffer that is used for full joins.
181
.. Why is this a core arg?
182
.. option:: --max-allowed-packet arg (=1M)
184
Max packetlength to send/receive from to server.
186
.. option:: --max-connect-errors arg (=10)
188
If there is more than this number of interrupted connections from a host
189
this host will be blocked from further connections.
191
.. option:: --max-error-count arg (=64)
193
Max number of errors/warnings to store for a statement.
195
.. option:: --max-heap-table-size arg (=16M)
197
Don't allow creation of heap tables bigger than this.
199
.. option:: --max-join-size arg (=2147483647)
201
Joins that are probably going to read more than max_join_size records return
204
.. option:: --max-length-for-sort-data arg (=1024)
206
Max number of bytes in sorted records.
208
.. option:: --max-seeks-for-key arg (=18446744073709551615)
210
Limit assumed max number of seeks when looking up rows based on a key
212
.. option:: --max-sort-length arg (=1024)
214
The number of bytes to use when sorting BLOB or TEXT values (only the first
215
max_sort_length bytes of each value are used; the rest are ignored).
217
.. option:: --max-write-lock-count arg (=18446744073709551615)
219
After this many write locks, allow some read locks to run in between.
221
.. option:: --min-examined-row-limit arg (=0)
223
Don't log queries which examine less than min_examined_row_limit rows to file.
225
.. option:: --disable-optimizer-prune
227
Do not apply any heuristic(s) during query optimization to prune, thus
228
perform an exhaustive search from the optimizer search space.
230
.. option:: --optimizer-search-depth arg (=0)
232
Maximum depth of search performed by the query optimizer. Values larger than
233
the number of relations in a query result in better query plans, but take
234
longer to compile a query. Smaller values than the number of tables in a
235
relation result in faster optimization, but may produce very bad query plans.
236
If set to 0, the system will automatically pick a reasonable value; if set to
237
MAX_TABLES+2, the optimizer will switch to the original find_best (used for
240
.. option:: --preload-buffer-size arg (=32768)
242
The size of the buffer that is allocated when preloading indexes
244
.. option:: --query-alloc-block-size arg (=8192)
246
Allocation block size for query parsing and execution
248
.. option:: --query-prealloc-size arg (=8192)
250
Persistent buffer for query parsing and execution
252
.. option:: --range-alloc-block-size arg (=4096)
254
Allocation block size for storing ranges during optimization
256
.. option:: --read-buffer-size arg (=131072)
258
Each thread that does a sequential scan allocates a buffer of this size for
259
each table it scans. If you do many sequential scans, you may want to
262
.. option:: --read-rnd-buffer-size arg (=262144)
264
When reading rows in sorted order after a sort, the rows are read through
265
this buffer to avoid a disk seeks. If not set, then it's set to the value of
268
.. option:: --scheduler arg (=multi-thread)
270
Select scheduler to be used.
272
.. option:: --sort-buffer-size arg (=2097144)
274
Each thread that needs to do a sort allocates a buffer of this size.
276
.. option:: --table-definition-cache arg (=128)
278
The number of cached table definitions.
280
.. option:: --table-open-cache arg (=1024)
282
The number of cached open tables.
284
.. option:: --table-lock-wait-timeout arg (=50)
286
Timeout in seconds to wait for a table level lock before returning an error.
287
Used only if the connection has active cursors.
289
.. option:: --thread-stack arg (=0)
291
The stack size for each thread. 0 means use OS default.
293
.. option:: --tmp-table-size arg (=16M)
295
If an internal in-memory temporary table exceeds this size, Drizzle will
296
automatically convert it to an on-disk MyISAM table.
added
removed
docs/options.rst
