67
94
--plugin_remove=syslog,md5
69
.. 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)
71
Optional comma separated list of plugins to load at starup instead of
72
the default plugin load list. This completely replaces the whole list.
74
96
.. _drizzled_kernel_options:
79
.. option:: --auto-increment-increment arg (=1)
101
.. option:: --auto-increment-increment ARG
104
:Variable: ``auto_increment_increment``
81
106
Auto-increment columns are incremented by this
83
.. option:: --auto-increment-offset arg (=1)
108
.. option:: --auto-increment-offset ARG
111
:Variable: ``auto_increment_offset``
85
113
Offset added to Auto-increment columns.
86
114
Used when auto-increment-increment != 1
88
.. 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``
90
130
Path to installation directory.
91
131
All paths are usually resolved relative to this.
93
.. 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
95
146
Chroot drizzled daemon during startup.
97
.. option:: --collation-server arg
148
.. option:: --collation-server ARG
151
:Variable: ``collation_server``
99
153
Set the default collation.
101
.. option:: --completion-type arg (=0)
103
Default completion type.
155
.. option:: --completion-type ARG
158
:Variable: ``completion_type``
105
162
.. option:: --core-file
107
167
Write core on errors.
109
.. option:: --datadir arg
169
.. option:: --datadir ARG
172
:Variable: ``datadir``
111
174
Path to the database root.
113
.. option:: --default-storage-engine arg
176
.. option:: --default-storage-engine ARG
179
:Variable: ``storage_engine``
115
181
Set the default storage engine for tables.
117
.. option:: --default-time-zone arg
183
.. option:: --default-time-zone ARG
119
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.
121
205
.. We should really remove --exit-info as an option
122
.. option:: --exit-info, -T arg
206
.. option:: --exit-info, -T ARG
124
211
Used for debugging; Use at your own risk!
126
213
.. option:: --gdb
128
Set up signals usable for debugging
130
.. 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``
132
247
Set the language used for the month names and the days of the week.
134
.. option:: --log-warnings, -W arg
249
.. option:: --log-warnings, -W ARG
136
254
Log some not critical warnings to the log file.
138
.. Why is this a core argument?
139
.. option:: --port-open-timeout arg (=0)
141
Maximum time in seconds to wait for the port to become free.
142
A value of 0 means not to wait.
144
.. option:: --secure-file-priv arg
146
Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to files within
149
.. Why is this still here?
150
.. option:: --server-id arg (=0)
152
Uniquely identifies the server instance in the community of replication
155
.. option:: --skip-stack-trace
157
Don't print a stack trace on failure.
159
.. option:: --symbolic-links, -s
161
Enable symbolic link support.
163
.. option:: --timed-mutexes
165
Specify whether to time mutexes (only InnoDB mutexes are currently supported)
167
.. option:: --tmpdir, -t arg
169
Path for temporary files.
171
.. option:: --transaction-isolation arg
173
Default transaction isolation level.
175
.. option:: --user, -u arg
177
Run drizzled daemon as user.
179
.. option:: --version, -V
181
Output version information and exit.
183
.. option:: --back-log arg (=50)
185
The number of outstanding connection requests Drizzle can have. This comes
186
into play when the main Drizzle thread gets very many connection requests in
189
.. option:: --bulk-insert-buffer-size arg (=8388608)
191
Size of tree cache used in bulk insert optimization. Note that this is a
194
.. option:: --div-precision-increment arg (=4)
196
Precision of the result of '/' operator will be increased on that value.
198
.. option:: --group-concat-max-len arg (=1024)
200
The maximum length of the result of function group_concat.
202
.. option:: --join-buffer-size arg (=131072)
204
The size of the buffer that is used for full joins.
206
.. option:: --join-buffer-constraint arg (=0)
208
A global constraint for join-buffer-size for all clients, cannot be set lower
209
than --join-buffer-size. Setting to 0 means unlimited.
211
.. Why is this a core arg?
212
.. option:: --max-allowed-packet arg (=64M)
256
.. Why is this a core ARG?
257
.. option:: --max-allowed-packet SIZE
260
:Variable: ``max_allowed_packet``
214
262
Max packetlength to send/receive from to server.
216
.. option:: --max-connect-errors arg (=10)
264
.. option:: --max-connect-errors ARG
218
269
If there is more than this number of interrupted connections from a host
219
270
this host will be blocked from further connections.
221
.. option:: --max-error-count arg (=64)
272
.. option:: --max-error-count ARG
275
:Variable: ``max_error_count``
223
277
Max number of errors/warnings to store for a statement.
225
.. option:: --max-heap-table-size arg (=16M)
279
.. option:: --max-heap-table-size SIZE
282
:Variable: ``max_heap_table_size``
227
284
Don't allow creation of heap tables bigger than this.
229
.. option:: --max-join-size arg (=2147483647)
286
.. option:: --max-join-size SIZE
289
:Variable: ``max_join_size``
231
291
Joins that are probably going to read more than max_join_size records return
234
.. option:: --max-length-for-sort-data arg (=1024)
294
.. option:: --max-length-for-sort-data SIZE
297
:Variable: ``max_length_for_sort_data``
236
299
Max number of bytes in sorted records.
238
.. option:: --max-seeks-for-key arg (=18446744073709551615)
240
Limit assumed max number of seeks when looking up rows based on a key
242
.. 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``
244
314
The number of bytes to use when sorting BLOB or TEXT values (only the first
245
315
max_sort_length bytes of each value are used; the rest are ignored).
247
.. option:: --max-write-lock-count arg (=18446744073709551615)
317
.. option:: --max-write-lock-count ARG
320
:Variable: ``max_write_lock_count``
249
322
After this many write locks, allow some read locks to run in between.
251
.. 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``
253
330
Don't log queries which examine less than min_examined_row_limit rows to
256
.. option:: --disable-optimizer-prune
258
Do not apply any heuristic(s) during query optimization to prune, thus
259
perform an exhaustive search from the optimizer search space.
261
.. option:: --optimizer-search-depth arg (=0)
333
.. option:: --optimizer-search-depth ARG
336
:Variable: ``optimizer_search_depth``
263
338
Maximum depth of search performed by the query optimizer. Values larger than
264
339
the number of relations in a query result in better query plans, but take
268
343
MAX_TABLES+2, the optimizer will switch to the original find_best (used for
269
344
testing/comparison).
271
.. option:: --preload-buffer-size arg (=32768)
273
The size of the buffer that is allocated when preloading indexes
275
.. option:: --query-alloc-block-size arg (=8192)
277
Allocation block size for query parsing and execution
279
.. option:: --query-prealloc-size arg (=8192)
281
Persistent buffer for query parsing and execution
283
.. option:: --range-alloc-block-size arg (=4096)
285
Allocation block size for storing ranges during optimization
287
.. 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``
289
403
Each thread that does a sequential scan allocates a buffer of this size for
290
404
each table it scans. If you do many sequential scans, you may want to
291
405
increase this value. Note that this only affect MyISAM.
293
.. option:: --read-buffer-constraint arg (=0)
295
A global constraint for read-buffer-size for all clients, cannot be set lower
296
than --read-buffer-size. Setting to 0 means unlimited.
298
.. option:: --read-rnd-buffer-size arg (=262144)
407
.. option:: --read-rnd-buffer-size SIZE
410
:Variable: ``read_rnd_buffer_size``
300
412
When reading rows in sorted order after a sort, the rows are read through
301
413
this buffer to avoid a disk seeks. If not set, then it's set to the value of
304
.. option:: --read-rnd-constraint arg (=0)
416
.. option:: --read-rnd-constraint ARG
306
421
A global constraint for read-rnd-buffer-size for all clients, cannot be set
307
422
lower than --read-rnd-buffer-size. Setting to 0 means unlimited.
309
.. 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``
311
436
Select scheduler to be used.
313
.. option:: --sort-buffer-size arg (=2097144)
315
Each thread that needs to do a sort allocates a buffer of this size.
317
.. 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
319
467
A global constraint for sort-buffer-size for all clients, cannot be set lower
320
468
than --sort-buffer-size. Setting to 0 means unlimited.
322
.. 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``
324
489
The number of cached table definitions.
326
.. option:: --table-open-cache arg (=1024)
328
The number of cached open tables.
330
.. option:: --table-lock-wait-timeout arg (=50)
491
.. option:: --table-lock-wait-timeout ARG
494
:Variable: ``table_lock_wait_timeout``
332
496
Timeout in seconds to wait for a table level lock before returning an error.
333
497
Used only if the connection has active cursors.
335
.. 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``
337
511
The stack size for each thread. 0 means use OS default.
339
.. 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``
341
525
If an internal in-memory temporary table exceeds this size, Drizzle will
342
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: