9
13
.. option:: --help-extended
10
Display this help and exit after initializing plugins.
13
Display this help and exit.
15
Display this help and exit after initializing plugins.
17
.. option:: --help, -?
19
Display this help and exit.
15
21
.. option:: --no-defaults
16
Configuration file defaults are not used if no-defaults is set
23
Configuration file defaults are not used if no-defaults is set
18
25
.. option:: --defaults-file arg
19
Configuration file to use
27
Configuration file to use
21
29
.. option:: --config-dir arg (=/etc/drizzle)
22
Base location for config files
31
Base location for config files
24
33
.. option:: --plugin-dir arg
27
37
.. option:: --pid-file arg
29
Pid file used by drizzled.
39
Pid file used by drizzled.
31
41
Plugin Loading Options
32
42
----------------------
34
46
.. option:: --plugin-add arg
35
Optional comma separated list of plugins to load at startup in addition
36
to the default list of plugins.
48
Optional comma separated list of plugins to load at startup in addition
49
to the default list of plugins.
38
for example: --plugin_add=crc32,console,pbxt
53
--plugin_add=crc32,console,pbxt
40
55
.. 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.
57
Optional comma separated list of plugins to not load at startup.
58
Effectively removes a plugin from the list of plugins to be loaded.
62
--plugin_remove=syslog,md5
64
.. 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)
66
Optional comma separated list of plugins to load at starup instead of
67
the default plugin load list. This completely replaces the whole list.
54
74
.. option:: --auto-increment-increment arg (=1)
56
Auto-increment columns are incremented by this
76
Auto-increment columns are incremented by this
58
78
.. 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.
80
Offset added to Auto-increment columns.
81
Used when auto-increment-increment != 1
83
.. option:: --basedir, -b arg
85
Path to installation directory.
86
All paths are usually resolved relative to this.
88
.. option:: --chroot, -r arg
90
Chroot drizzled daemon during startup.
72
92
.. option:: --collation-server arg
74
Set the default collation.
94
Set the default collation.
76
96
.. option:: --completion-type arg (=0)
78
Default completion type.
98
Default completion type.
80
100
.. option:: --core-file
102
Write core on errors.
84
104
.. option:: --datadir arg
86
Path to the database root.
106
Path to the database root.
88
108
.. option:: --default-storage-engine arg
90
Set the default storage engine for tables.
110
Set the default storage engine for tables.
92
112
.. option:: --default-time-zone arg
94
Set the default time zone.
114
Set the default time zone.
96
116
.. We should really remove --exit-info as an option
97
.. option:: -T,--exit-info arg
117
.. option:: --exit-info, -T arg
99
Used for debugging; Use at your own risk!
119
Used for debugging; Use at your own risk!
101
121
.. option:: --gdb
103
Set up signals usable for debugging
123
Set up signals usable for debugging
105
125
.. 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.
127
Set the language used for the month names and the days of the week.
129
.. option:: --log-warnings, -W arg
131
Log some not critical warnings to the log file.
113
133
.. Why is this a core argument?
114
134
.. 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.
136
Maximum time in seconds to wait for the port to become free.
137
A value of 0 means not to wait.
119
139
.. option:: --secure-file-priv arg
121
Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to files within
141
Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to files within
124
144
.. Why is this still here?
125
145
.. option:: --server-id arg (=0)
127
Uniquely identifies the server instance in the community of replication
147
Uniquely identifies the server instance in the community of replication
130
150
.. option:: --skip-stack-trace
132
Don't print a stack trace on failure.
134
.. option:: -s,--symbolic-links
136
Enable symbolic link support.
152
Don't print a stack trace on failure.
154
.. option:: --symbolic-links, -s
156
Enable symbolic link support.
138
158
.. 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.
160
Specify whether to time mutexes (only InnoDB mutexes are currently supported)
162
.. option:: --tmpdir, -t arg
164
Path for temporary files.
146
166
.. option:: --transaction-isolation arg
148
Default transaction isolation level.
150
.. option:: -u,--user arg
152
Run drizzled daemon as user.
168
Default transaction isolation level.
170
.. option:: --user, -u arg
172
Run drizzled daemon as user.
154
.. option:: -V,--version
174
.. option:: --version, -V
156
Output version information and exit.
176
Output version information and exit.
158
178
.. 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
180
The number of outstanding connection requests Drizzle can have. This comes
181
into play when the main Drizzle thread gets very many connection requests in
164
184
.. option:: --bulk-insert-buffer-size arg (=8388608)
166
Size of tree cache used in bulk insert optimization. Note that this is a limit
186
Size of tree cache used in bulk insert optimization. Note that this is a
169
189
.. option:: --div-precision-increment arg (=4)
171
Precision of the result of '/' operator will be increased on that value.
191
Precision of the result of '/' operator will be increased on that value.
173
193
.. option:: --group-concat-max-len arg (=1024)
175
The maximum length of the result of function group_concat.
195
The maximum length of the result of function group_concat.
177
197
.. option:: --join-buffer-size arg (=131072)
179
The size of the buffer that is used for full joins.
199
The size of the buffer that is used for full joins.
181
201
.. option:: --join-buffer-constraint arg (=0)
183
A global constraint for join-buffer-size for all clients, cannot be set lower
184
than --join-buffer-size. Setting to 0 means unlimited.
203
A global constraint for join-buffer-size for all clients, cannot be set lower
204
than --join-buffer-size. Setting to 0 means unlimited.
186
206
.. Why is this a core arg?
187
207
.. option:: --max-allowed-packet arg (=64M)
189
Max packetlength to send/receive from to server.
209
Max packetlength to send/receive from to server.
191
211
.. option:: --max-connect-errors arg (=10)
193
If there is more than this number of interrupted connections from a host
194
this host will be blocked from further connections.
213
If there is more than this number of interrupted connections from a host
214
this host will be blocked from further connections.
196
216
.. option:: --max-error-count arg (=64)
198
Max number of errors/warnings to store for a statement.
218
Max number of errors/warnings to store for a statement.
200
220
.. option:: --max-heap-table-size arg (=16M)
202
Don't allow creation of heap tables bigger than this.
222
Don't allow creation of heap tables bigger than this.
204
224
.. option:: --max-join-size arg (=2147483647)
206
Joins that are probably going to read more than max_join_size records return
226
Joins that are probably going to read more than max_join_size records return
209
229
.. option:: --max-length-for-sort-data arg (=1024)
211
Max number of bytes in sorted records.
231
Max number of bytes in sorted records.
213
233
.. option:: --max-seeks-for-key arg (=18446744073709551615)
215
Limit assumed max number of seeks when looking up rows based on a key
235
Limit assumed max number of seeks when looking up rows based on a key
217
237
.. option:: --max-sort-length arg (=1024)
219
The number of bytes to use when sorting BLOB or TEXT values (only the first
220
max_sort_length bytes of each value are used; the rest are ignored).
239
The number of bytes to use when sorting BLOB or TEXT values (only the first
240
max_sort_length bytes of each value are used; the rest are ignored).
222
242
.. option:: --max-write-lock-count arg (=18446744073709551615)
224
After this many write locks, allow some read locks to run in between.
244
After this many write locks, allow some read locks to run in between.
226
246
.. option:: --min-examined-row-limit arg (=0)
228
Don't log queries which examine less than min_examined_row_limit rows to file.
248
Don't log queries which examine less than min_examined_row_limit rows to
230
251
.. option:: --disable-optimizer-prune
232
Do not apply any heuristic(s) during query optimization to prune, thus
233
perform an exhaustive search from the optimizer search space.
253
Do not apply any heuristic(s) during query optimization to prune, thus
254
perform an exhaustive search from the optimizer search space.
235
256
.. option:: --optimizer-search-depth arg (=0)
237
Maximum depth of search performed by the query optimizer. Values larger than
238
the number of relations in a query result in better query plans, but take
239
longer to compile a query. Smaller values than the number of tables in a
240
relation result in faster optimization, but may produce very bad query plans.
241
If set to 0, the system will automatically pick a reasonable value; if set to
242
MAX_TABLES+2, the optimizer will switch to the original find_best (used for
258
Maximum depth of search performed by the query optimizer. Values larger than
259
the number of relations in a query result in better query plans, but take
260
longer to compile a query. Smaller values than the number of tables in a
261
relation result in faster optimization, but may produce very bad query plans.
262
If set to 0, the system will automatically pick a reasonable value; if set to
263
MAX_TABLES+2, the optimizer will switch to the original find_best (used for
245
266
.. option:: --preload-buffer-size arg (=32768)
247
The size of the buffer that is allocated when preloading indexes
268
The size of the buffer that is allocated when preloading indexes
249
270
.. option:: --query-alloc-block-size arg (=8192)
251
Allocation block size for query parsing and execution
272
Allocation block size for query parsing and execution
253
274
.. option:: --query-prealloc-size arg (=8192)
255
Persistent buffer for query parsing and execution
276
Persistent buffer for query parsing and execution
257
278
.. option:: --range-alloc-block-size arg (=4096)
259
Allocation block size for storing ranges during optimization
280
Allocation block size for storing ranges during optimization
261
282
.. option:: --read-buffer-size arg (=131072)
263
Each thread that does a sequential scan allocates a buffer of this size for
264
each table it scans. If you do many sequential scans, you may want to
265
increase this value. Note that this only affect MyISAM.
284
Each thread that does a sequential scan allocates a buffer of this size for
285
each table it scans. If you do many sequential scans, you may want to
286
increase this value. Note that this only affect MyISAM.
267
288
.. option:: --read-buffer-constraint arg (=0)
269
A global constraint for read-buffer-size for all clients, cannot be set lower
270
than --read-buffer-size. Setting to 0 means unlimited.
290
A global constraint for read-buffer-size for all clients, cannot be set lower
291
than --read-buffer-size. Setting to 0 means unlimited.
272
293
.. option:: --read-rnd-buffer-size arg (=262144)
274
When reading rows in sorted order after a sort, the rows are read through
275
this buffer to avoid a disk seeks. If not set, then it's set to the value of
295
When reading rows in sorted order after a sort, the rows are read through
296
this buffer to avoid a disk seeks. If not set, then it's set to the value of
278
299
.. option:: --read-rnd-constraint arg (=0)
280
A global constraint for read-rnd-buffer-size for all clients, cannot be set
281
lower than --read-rnd-buffer-size. Setting to 0 means unlimited.
301
A global constraint for read-rnd-buffer-size for all clients, cannot be set
302
lower than --read-rnd-buffer-size. Setting to 0 means unlimited.
283
304
.. option:: --scheduler arg (=multi-thread)
285
Select scheduler to be used.
306
Select scheduler to be used.
287
308
.. option:: --sort-buffer-size arg (=2097144)
289
Each thread that needs to do a sort allocates a buffer of this size.
310
Each thread that needs to do a sort allocates a buffer of this size.
291
312
.. option:: --sort-buffer-constraint arg (=0)
293
A global constraint for sort-buffer-size for all clients, cannot be set lower
294
than --sort-buffer-size. Setting to 0 means unlimited.
314
A global constraint for sort-buffer-size for all clients, cannot be set lower
315
than --sort-buffer-size. Setting to 0 means unlimited.
296
317
.. option:: --table-definition-cache arg (=128)
298
The number of cached table definitions.
319
The number of cached table definitions.
300
321
.. option:: --table-open-cache arg (=1024)
302
The number of cached open tables.
323
The number of cached open tables.
304
325
.. option:: --table-lock-wait-timeout arg (=50)
306
Timeout in seconds to wait for a table level lock before returning an error.
307
Used only if the connection has active cursors.
327
Timeout in seconds to wait for a table level lock before returning an error.
328
Used only if the connection has active cursors.
309
330
.. option:: --thread-stack arg (=0)
311
The stack size for each thread. 0 means use OS default.
332
The stack size for each thread. 0 means use OS default.
313
334
.. option:: --tmp-table-size arg (=16M)
315
If an internal in-memory temporary table exceeds this size, Drizzle will
316
automatically convert it to an on-disk MyISAM table.
336
If an internal in-memory temporary table exceeds this size, Drizzle will
337
automatically convert it to an on-disk MyISAM table.
added
removed
docs/options.rst
