62
94
--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.
96
.. _drizzled_kernel_options:
74
.. option:: --auto-increment-increment arg (=1)
101
.. option:: --auto-increment-increment ARG
104
:Variable: ``auto_increment_increment``
76
106
Auto-increment columns are incremented by this
78
.. option:: --auto-increment-offset arg (=1)
108
.. option:: --auto-increment-offset ARG
111
:Variable: ``auto_increment_offset``
80
113
Offset added to Auto-increment columns.
81
114
Used when auto-increment-increment != 1
83
.. option:: --basedir, -b arg
116
.. option:: --back-log ARG
119
:Variable: ``back_log``
121
The number of outstanding connection requests Drizzle can have. This comes
122
into play when the main Drizzle thread gets very many connection requests in
125
.. option:: --basedir, -b ARG
128
:Variable: ``basedir``
85
130
Path to installation directory.
86
131
All paths are usually resolved relative to this.
88
.. option:: --chroot, -r arg
133
.. option:: --bulk-insert-buffer-size SIZE
136
:Variable: ``bulk_insert_buffer_size``
138
Size of tree cache used in bulk insert optimization. Note that this is a
141
.. option:: --chroot, -r ARG
90
146
Chroot drizzled daemon during startup.
92
.. option:: --collation-server arg
148
.. option:: --collation-server ARG
151
:Variable: ``collation_server``
94
153
Set the default collation.
96
.. option:: --completion-type arg (=0)
98
Default completion type.
155
.. option:: --completion-type ARG
158
:Variable: ``completion_type``
100
162
.. option:: --core-file
102
167
Write core on errors.
104
.. option:: --datadir arg
169
.. option:: --datadir ARG
172
:Variable: ``datadir``
106
174
Path to the database root.
108
.. option:: --default-storage-engine arg
176
.. option:: --default-storage-engine ARG
179
:Variable: ``storage_engine``
110
181
Set the default storage engine for tables.
112
.. option:: --default-time-zone arg
183
.. option:: --default-time-zone ARG
114
188
Set the default time zone.
190
.. option:: --disable-optimizer-prune
193
:Variable: ``optimizer_prune_level``
195
Do not apply any heuristic(s) during query optimization to prune, thus
196
perform an exhaustive search from the optimizer search space.
198
.. option:: --div-precision-increment ARG
201
:Variable: ``div_precision_increment``
203
Precision of the result of '/' operator will be increased on that value.
116
205
.. We should really remove --exit-info as an option
117
.. option:: --exit-info, -T arg
206
.. option:: --exit-info, -T ARG
119
211
Used for debugging; Use at your own risk!
121
213
.. option:: --gdb
123
Set up signals usable for debugging
125
.. option:: --lc-time-name arg
218
Set up signals usable for debugging.
220
.. option:: --group-concat-max-len ARG
223
:Variable: ``group_concat_max_len``
225
The maximum length of the result of function group_concat.
227
.. option:: --join-buffer-constraint ARG
232
A global constraint for join-buffer-size for all clients, cannot be set lower
233
than :option:`--join-buffer-size`. Setting to 0 means unlimited.
235
.. option:: --join-buffer-size SIZE
238
:Variable: ``join_buffer_size``
240
The size of the buffer that is used for full joins.
242
.. option:: --lc-time-name ARG
245
:Variable: ``lc_time_names``
127
247
Set the language used for the month names and the days of the week.
129
.. option:: --log-warnings, -W arg
249
.. option:: --log-warnings, -W ARG
131
254
Log some not critical warnings to the log file.
133
.. Why is this a core argument?
134
.. option:: --port-open-timeout arg (=0)
136
Maximum time in seconds to wait for the port to become free.
137
A value of 0 means not to wait.
139
.. option:: --secure-file-priv arg
141
Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to files within
144
.. Why is this still here?
145
.. option:: --server-id arg (=0)
147
Uniquely identifies the server instance in the community of replication
150
.. option:: --skip-stack-trace
152
Don't print a stack trace on failure.
154
.. option:: --symbolic-links, -s
156
Enable symbolic link support.
158
.. option:: --timed-mutexes
160
Specify whether to time mutexes (only InnoDB mutexes are currently supported)
162
.. option:: --tmpdir, -t arg
164
Path for temporary files.
166
.. option:: --transaction-isolation arg
168
Default transaction isolation level.
170
.. option:: --user, -u arg
172
Run drizzled daemon as user.
174
.. option:: --version, -V
176
Output version information and exit.
178
.. option:: --back-log arg (=50)
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
184
.. option:: --bulk-insert-buffer-size arg (=8388608)
186
Size of tree cache used in bulk insert optimization. Note that this is a
189
.. option:: --div-precision-increment arg (=4)
191
Precision of the result of '/' operator will be increased on that value.
193
.. option:: --group-concat-max-len arg (=1024)
195
The maximum length of the result of function group_concat.
197
.. option:: --join-buffer-size arg (=131072)
199
The size of the buffer that is used for full joins.
201
.. option:: --join-buffer-constraint arg (=0)
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.
206
.. Why is this a core arg?
207
.. option:: --max-allowed-packet arg (=64M)
256
.. Why is this a core ARG?
257
.. option:: --max-allowed-packet SIZE
260
:Variable: ``max_allowed_packet``
209
262
Max packetlength to send/receive from to server.
211
.. option:: --max-connect-errors arg (=10)
264
.. option:: --max-connect-errors ARG
213
269
If there is more than this number of interrupted connections from a host
214
270
this host will be blocked from further connections.
216
.. option:: --max-error-count arg (=64)
272
.. option:: --max-error-count ARG
275
:Variable: ``max_error_count``
218
277
Max number of errors/warnings to store for a statement.
220
.. option:: --max-heap-table-size arg (=16M)
279
.. option:: --max-heap-table-size SIZE
282
:Variable: ``max_heap_table_size``
222
284
Don't allow creation of heap tables bigger than this.
224
.. option:: --max-join-size arg (=2147483647)
286
.. option:: --max-join-size SIZE
289
:Variable: ``max_join_size``
226
291
Joins that are probably going to read more than max_join_size records return
229
.. option:: --max-length-for-sort-data arg (=1024)
294
.. option:: --max-length-for-sort-data SIZE
297
:Variable: ``max_length_for_sort_data``
231
299
Max number of bytes in sorted records.
233
.. option:: --max-seeks-for-key arg (=18446744073709551615)
235
Limit assumed max number of seeks when looking up rows based on a key
237
.. option:: --max-sort-length arg (=1024)
301
.. option:: --max-seeks-for-key ARG
304
:Variable: ``max_seeks_for_key``
306
Limit assumed max number of seeks when looking up rows based on a key.
307
Set to -1 to disable.
309
.. option:: --max-sort-length SIZE
312
:Variable: ``max_sort_length``
239
314
The number of bytes to use when sorting BLOB or TEXT values (only the first
240
315
max_sort_length bytes of each value are used; the rest are ignored).
242
.. option:: --max-write-lock-count arg (=18446744073709551615)
317
.. option:: --max-write-lock-count ARG
320
:Variable: ``max_write_lock_count``
244
322
After this many write locks, allow some read locks to run in between.
246
.. option:: --min-examined-row-limit arg (=0)
323
Set to -1 to disable.
325
.. option:: --min-examined-row-limit ARG
328
:Variable: ``min_examined_row_limit``
248
330
Don't log queries which examine less than min_examined_row_limit rows to
251
.. option:: --disable-optimizer-prune
253
Do not apply any heuristic(s) during query optimization to prune, thus
254
perform an exhaustive search from the optimizer search space.
256
.. option:: --optimizer-search-depth arg (=0)
333
.. option:: --optimizer-search-depth ARG
336
:Variable: ``optimizer_search_depth``
258
338
Maximum depth of search performed by the query optimizer. Values larger than
259
339
the number of relations in a query result in better query plans, but take
263
343
MAX_TABLES+2, the optimizer will switch to the original find_best (used for
264
344
testing/comparison).
266
.. option:: --preload-buffer-size arg (=32768)
268
The size of the buffer that is allocated when preloading indexes
270
.. option:: --query-alloc-block-size arg (=8192)
272
Allocation block size for query parsing and execution
274
.. option:: --query-prealloc-size arg (=8192)
276
Persistent buffer for query parsing and execution
278
.. option:: --range-alloc-block-size arg (=4096)
280
Allocation block size for storing ranges during optimization
282
.. option:: --read-buffer-size arg (=131072)
346
.. option:: --pid-file FILE
349
:Variable: ``pid_file``
351
PID file used by :program:`drizzled`.
353
.. Why is this a core argument?
354
.. option:: --port-open-timeout ARG
359
Maximum time in seconds to wait for the port to become free.
360
A value of 0 means not to wait.
362
.. option:: --preload-buffer-size SIZE
365
:Variable: ``preload_buffer_size``
367
The size of the buffer that is allocated when preloading indexes.
369
.. option:: --query-alloc-block-size SIZE
372
:Variable: ``query_alloc_block_size``
374
Allocation block size for query parsing and execution.
376
.. option:: --query-prealloc-size SIZE
379
:Variable: ``query_prealloc_size``
381
Persistent buffer for query parsing and execution.
383
.. option:: --range-alloc-block-size SIZE
386
:Variable: ``range_alloc_block_size``
388
Allocation block size for storing ranges during optimization.
390
.. option:: --read-buffer-constraint ARG
395
A global constraint for read-buffer-size for all clients, cannot be set lower
396
than --read-buffer-size. Setting to 0 means unlimited.
398
.. option:: --read-buffer-size SIZE
401
:Variable: ``read_buffer_size``
284
403
Each thread that does a sequential scan allocates a buffer of this size for
285
404
each table it scans. If you do many sequential scans, you may want to
286
405
increase this value. Note that this only affect MyISAM.
288
.. option:: --read-buffer-constraint arg (=0)
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.
293
.. option:: --read-rnd-buffer-size arg (=262144)
407
.. option:: --read-rnd-buffer-size SIZE
410
:Variable: ``read_rnd_buffer_size``
295
412
When reading rows in sorted order after a sort, the rows are read through
296
413
this buffer to avoid a disk seeks. If not set, then it's set to the value of
299
.. option:: --read-rnd-constraint arg (=0)
416
.. option:: --read-rnd-constraint ARG
301
421
A global constraint for read-rnd-buffer-size for all clients, cannot be set
302
422
lower than --read-rnd-buffer-size. Setting to 0 means unlimited.
304
.. option:: --scheduler arg (=multi-thread)
424
.. option:: --replicate-query
427
:Variable: ``replicate_query``
429
Include the SQL query in replicated protobuf messages.
431
.. option:: --scheduler ARG
433
:Default: multi-thread
434
:Variable: ``scheduler``
306
436
Select scheduler to be used.
308
.. option:: --sort-buffer-size arg (=2097144)
310
Each thread that needs to do a sort allocates a buffer of this size.
312
.. option:: --sort-buffer-constraint arg (=0)
438
.. option:: --secure-file-priv ARG
441
:Variable: ``secure_file_priv``
443
Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to files within
446
.. Why is this still here?
447
.. option:: --server-id ARG
450
:Variable: ``server_id``
452
Uniquely identifies the server instance in the community of replication
455
.. option:: --skip-stack-trace
460
Don't print a stack trace on failure.
462
.. option:: --sort-buffer-constraint ARG
314
467
A global constraint for sort-buffer-size for all clients, cannot be set lower
315
468
than --sort-buffer-size. Setting to 0 means unlimited.
317
.. option:: --table-definition-cache arg (=128)
470
.. option:: --sort-buffer-size SIZE
473
:Variable: ``sort_buffer_size``
475
Each thread that needs to do a sort allocates a buffer of this size.
477
.. option:: --symbolic-links, -s
482
Enable symbolic link support.
484
.. option:: --table-definition-cache ARG
487
:Variable: ``table_definition_cache``
319
489
The number of cached table definitions.
321
.. option:: --table-open-cache arg (=1024)
323
The number of cached open tables.
325
.. option:: --table-lock-wait-timeout arg (=50)
491
.. option:: --table-lock-wait-timeout ARG
494
:Variable: ``table_lock_wait_timeout``
327
496
Timeout in seconds to wait for a table level lock before returning an error.
328
497
Used only if the connection has active cursors.
330
.. option:: --thread-stack arg (=0)
499
.. option:: --table-open-cache ARG
502
:Variable: ``table_open_cache``
504
The number of cached open tables.
506
.. option:: --thread-stack ARG
509
:Variable: ``thread_stack``
332
511
The stack size for each thread. 0 means use OS default.
334
.. option:: --tmp-table-size arg (=16M)
513
.. option:: --timed-mutexes
516
:Variable: ``timed_mutexes``
518
Specify whether to time mutexes (only InnoDB mutexes are currently supported).
520
.. option:: --tmp-table-size SIZE
523
:Variable: ``tmp_table_size``
336
525
If an internal in-memory temporary table exceeds this size, Drizzle will
337
526
automatically convert it to an on-disk MyISAM table.
528
.. option:: --tmpdir, -t DIR
531
:Variable: ``tmpdir``
533
Path for temporary files.
535
.. option:: --transaction-isolation ARG
537
:Default: REPEATABLE-READ
538
:Variable: ``tx_isolation``
540
Default transaction isolation level.
542
.. option:: --transaction-message-threshold
545
:Variable: ``transaction_message_threshold``
547
Max message size written to transaction log, valid values 131072 - 1048576 bytes.
549
.. option:: --user, -u ARG
554
Run drizzled daemon as user.
556
.. option:: --version, -V
559
:Variable: ``version``
561
Output version information and exit.
563
.. _drizzled_variables:
568
.. _drizzled_auto_increment_increment:
570
* ``auto_increment_increment``
574
:Option: :option:`--auto-increment-increment`
576
.. _drizzled_auto_increment_offset:
578
* ``auto_increment_offset``
582
:Option: :option:`--auto-increment-offset`
584
.. _drizzled_autocommit:
592
If statements are auto-committed.
594
.. _drizzled_back_log:
600
:Option: :option:`--back-log`
602
.. _drizzled_basedir:
608
:Option: :option:`--basedir`
610
.. _drizzled_bulk_insert_buffer_size:
612
* ``bulk_insert_buffer_size``
616
:Option: :option:`--bulk-insert-buffer-size`
618
.. _drizzled_collation_server:
620
* ``collation_server``
624
:Option: :option:`--collation-server`
626
.. _drizzled_completion_type:
628
* ``completion_type``
632
:Option: :option:`--completion-type`
634
.. _drizzled_datadir:
640
:Option: :option:`--datadir`
642
.. _drizzled_div_precision_increment:
644
* ``div_precision_increment``
648
:Option: :option:`--div-precision-increment`
650
.. _drizzled_error_count:
660
.. _drizzled_foreign_key_checks:
662
* ``foreign_key_checks``
668
If foreign key checks are enabled.
670
.. _drizzled_group_concat_max_len:
672
* ``group_concat_max_len``
676
:Option: :option:`--group-concat-max-len`
678
.. _drizzled_hostname:
686
Hostname of the server.
688
.. _drizzled_identity:
698
.. _drizzled_join_buffer_size:
700
* ``join_buffer_size``
704
:Option: :option:`--join-buffer-size`
706
.. _drizzled_last_insert_id:
714
Last auto-increment insert ID value.
716
.. _drizzled_lc_time_names:
726
.. _drizzled_max_allowed_packet:
728
* ``max_allowed_packet``
732
:Option: :option:`--max-allowed-packet`
734
.. _drizzled_max_error_count:
736
* ``max_error_count``
740
:Option: :option:`--max-error-count`
742
.. _drizzled_max_heap_table_size:
744
* ``max_heap_table_size``
748
:Option: :option:`--max-heap-table-size`
750
.. _drizzled_max_join_size:
756
:Option: :option:`--max-join-size`
758
.. _drizzled_max_length_for_sort_data:
760
* ``max_length_for_sort_data``
764
:Option: :option:`--max-length-for-sort-data`
766
.. _drizzled_max_seeks_for_key:
768
* ``max_seeks_for_key``
772
:Option: :option:`--max-seeks-for-key`
774
.. _drizzled_max_sort_length:
776
* ``max_sort_length``
780
:Option: :option:`--max-sort-length`
782
.. _drizzled_max_write_lock_count:
784
* ``max_write_lock_count``
788
:Option: :option:`--max-write-lock-count`
790
.. _drizzled_min_examined_row_limit:
792
* ``min_examined_row_limit``
796
:Option: :option:`--min-examined-row-limit`
798
.. _drizzled_optimizer_prune_level:
800
* ``optimizer_prune_level``
804
:Option: :option:`--disable-optimizer-prune`
806
Optimizer prune level.
808
.. _drizzled_optimizer_search_depth:
810
* ``optimizer_search_depth``
814
:Option: :option:`--optimizer-search-depth`
816
.. _drizzled_pid_file:
822
:Option: :option:`--pid-file`
824
.. _drizzled_plugin_dir:
830
:Option: :option:`--plugin-dir`
832
.. _drizzled_preload_buffer_size:
834
* ``preload_buffer_size``
838
:Option: :option:`--preload-buffer-size`
840
.. _drizzled_pseudo_thread_id:
842
* ``pseudo_thread_id``
850
.. _drizzled_query_alloc_block_size:
852
* ``query_alloc_block_size``
856
:Option: :option:`--query-alloc-block-size`
858
.. _drizzled_query_prealloc_size:
860
* ``query_prealloc_size``
864
:Option: :option:`--query-prealloc-size`
866
.. _drizzled_range_alloc_block_size:
868
* ``range_alloc_block_size``
872
:Option: :option:`--range-alloc-block-size`
874
.. _drizzled_read_buffer_size:
876
* ``read_buffer_size``
880
:Option: :option:`--read-buffer-size`
882
.. _drizzled_read_rnd_buffer_size:
884
* ``read_rnd_buffer_size``
888
:Option: :option:`--read-rnd-buffer-size`
890
.. _drizzled_replicate_query:
892
* ``replicate_query``
896
:Option: :option:`--replicate-query`
898
.. _drizzled_scheduler:
904
:Option: :option:`--scheduler`
906
.. _drizzled_secure_file_priv:
908
* ``secure_file_priv``
912
:Option: :option:`--secure-file-priv`
914
.. _drizzled_server_id:
920
:Option: :option:`--server-id`
922
.. _drizzled_server_uuid:
932
.. _drizzled_sort_buffer_size:
934
* ``sort_buffer_size``
938
:Option: :option:`--sort-buffer-size`
940
.. _drizzled_sql_big_selects:
942
* ``sql_big_selects``
950
.. _drizzled_sql_buffer_result:
952
* ``sql_buffer_result``
960
.. _drizzled_sql_notes:
970
.. _drizzled_sql_select_limit:
972
* ``sql_select_limit``
980
.. _drizzled_sql_warnings:
990
.. _drizzled_storage_engine:
996
:Option: :option:`--default-storage-engine`
998
.. _drizzled_table_definition_cache:
1000
* ``table_definition_cache``
1004
:Option: :option:`--table-definition-cache`
1006
.. _drizzled_table_lock_wait_timeout:
1008
* ``table_lock_wait_timeout``
1012
:Option: :option:`--table-lock-wait-timeout`
1014
.. _drizzled_table_open_cache:
1016
* ``table_open_cache``
1020
:Option: :option:`--table-open-cache`
1022
.. _drizzled_thread_stack:
1028
:Option: :option:`--thread-stack`
1030
.. _drizzled_timed_mutexes:
1036
:Option: :option:`--timed-mutexes`
1038
.. _drizzled_timestamp:
1046
Current UNIX timestamp.
1048
.. _drizzled_tmp_table_size:
1050
* ``tmp_table_size``
1054
:Option: :option:`--tmp-table-size`
1056
.. _drizzled_tmpdir:
1062
:Option: :option:`--tmpdir`
1064
.. _drizzled_transaction_message_threshold:
1066
* ``transaction_message_threshold``
1070
:Option: :option:`--transaction-message-threshold`
1072
.. _drizzled_tx_isolation:
1078
:Option: :option:`--transactions-isolation`
1080
.. _drizzled_unique_checks:
1088
Check UNIQUE indexes for uniqueness.
1090
.. _drizzled_vc_branch:
1098
Version control (Bazaar) branch.
1100
.. _drizzled_vc_release_id:
1108
Version control (Bazaar) release id.
1110
.. _drizzled_vc_revid:
1118
Version control (Bazaar) revision id.
1120
.. _drizzled_vc_revno:
1128
Version control (Bazaar) revision number.
1130
.. _drizzled_version:
1136
:Option: :option:`--version`
1140
.. _drizzled_version_comment:
1142
* ``version_comment``
1150
.. _drizzled_version_compile_machine:
1152
* ``version_compile_machine``
1158
Version compile for machine type.
1160
.. _drizzled_version_compile_os:
1162
* ``version_compile_os``
1168
Version compile for OS.
1170
.. _drizzled_version_compile_vendor:
1172
* ``version_compile_vendor``
1178
Version compile for OS vendor.
1180
.. _drizzled_warning_count:
added
removed
docs/configuration/drizzled.rst
