94
62
--plugin_remove=syslog,md5
96
.. _drizzled_kernel_options:
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.
101
.. option:: --auto-increment-increment ARG
104
:Variable: ``auto_increment_increment``
74
.. option:: --auto-increment-increment arg (=1)
106
76
Auto-increment columns are incremented by this
108
.. option:: --auto-increment-offset ARG
111
:Variable: ``auto_increment_offset``
78
.. option:: --auto-increment-offset arg (=1)
113
80
Offset added to Auto-increment columns.
114
81
Used when auto-increment-increment != 1
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``
83
.. option:: --basedir, -b arg
130
85
Path to installation directory.
131
86
All paths are usually resolved relative to this.
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
88
.. option:: --chroot, -r arg
146
90
Chroot drizzled daemon during startup.
148
.. option:: --collation-server ARG
151
:Variable: ``collation_server``
92
.. option:: --collation-server arg
153
94
Set the default collation.
155
.. option:: --completion-type ARG
158
:Variable: ``completion_type``
96
.. option:: --completion-type arg (=0)
98
Default completion type.
162
100
.. option:: --core-file
167
102
Write core on errors.
169
.. option:: --datadir ARG
172
:Variable: ``datadir``
104
.. option:: --datadir arg
174
106
Path to the database root.
176
.. option:: --default-storage-engine ARG
179
:Variable: ``storage_engine``
108
.. option:: --default-storage-engine arg
181
110
Set the default storage engine for tables.
183
.. option:: --default-time-zone ARG
112
.. option:: --default-time-zone arg
188
114
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.
205
116
.. We should really remove --exit-info as an option
206
.. option:: --exit-info, -T ARG
117
.. option:: --exit-info, -T arg
211
119
Used for debugging; Use at your own risk!
213
121
.. option:: --gdb
218
Set up signals usable for debugging.
220
.. option:: --group-concat-max-len ARG
223
:Variable: ``group_concat_max_len``
123
Set up signals usable for debugging
125
.. option:: --lc-time-name arg
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.
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)
225
195
The maximum length of the result of function group_concat.
227
.. option:: --join-buffer-constraint ARG
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)
232
203
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``
247
Set the language used for the month names and the days of the week.
249
.. option:: --log-warnings, -W ARG
254
Log some not critical warnings to the log file.
256
.. Why is this a core ARG?
257
.. option:: --max-allowed-packet SIZE
260
:Variable: ``max_allowed_packet``
204
than --join-buffer-size. Setting to 0 means unlimited.
206
.. Why is this a core arg?
207
.. option:: --max-allowed-packet arg (=64M)
262
209
Max packetlength to send/receive from to server.
264
.. option:: --max-connect-errors ARG
211
.. option:: --max-connect-errors arg (=10)
269
213
If there is more than this number of interrupted connections from a host
270
214
this host will be blocked from further connections.
272
.. option:: --max-error-count ARG
275
:Variable: ``max_error_count``
216
.. option:: --max-error-count arg (=64)
277
218
Max number of errors/warnings to store for a statement.
279
.. option:: --max-heap-table-size SIZE
282
:Variable: ``max_heap_table_size``
220
.. option:: --max-heap-table-size arg (=16M)
284
222
Don't allow creation of heap tables bigger than this.
286
.. option:: --max-join-size SIZE
289
:Variable: ``max_join_size``
224
.. option:: --max-join-size arg (=2147483647)
291
226
Joins that are probably going to read more than max_join_size records return
294
.. option:: --max-length-for-sort-data SIZE
297
:Variable: ``max_length_for_sort_data``
229
.. option:: --max-length-for-sort-data arg (=1024)
299
231
Max number of bytes in sorted records.
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``
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)
314
239
The number of bytes to use when sorting BLOB or TEXT values (only the first
315
240
max_sort_length bytes of each value are used; the rest are ignored).
317
.. option:: --max-write-lock-count ARG
320
:Variable: ``max_write_lock_count``
242
.. option:: --max-write-lock-count arg (=18446744073709551615)
322
244
After this many write locks, allow some read locks to run in between.
323
Set to -1 to disable.
325
.. option:: --min-examined-row-limit ARG
328
:Variable: ``min_examined_row_limit``
246
.. option:: --min-examined-row-limit arg (=0)
330
248
Don't log queries which examine less than min_examined_row_limit rows to
333
.. option:: --optimizer-search-depth ARG
336
:Variable: ``optimizer_search_depth``
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)
338
258
Maximum depth of search performed by the query optimizer. Values larger than
339
259
the number of relations in a query result in better query plans, but take
343
263
MAX_TABLES+2, the optimizer will switch to the original find_best (used for
344
264
testing/comparison).
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``
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)
403
284
Each thread that does a sequential scan allocates a buffer of this size for
404
285
each table it scans. If you do many sequential scans, you may want to
405
286
increase this value. Note that this only affect MyISAM.
407
.. option:: --read-rnd-buffer-size SIZE
410
:Variable: ``read_rnd_buffer_size``
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)
412
295
When reading rows in sorted order after a sort, the rows are read through
413
296
this buffer to avoid a disk seeks. If not set, then it's set to the value of
416
.. option:: --read-rnd-constraint ARG
299
.. option:: --read-rnd-constraint arg (=0)
421
301
A global constraint for read-rnd-buffer-size for all clients, cannot be set
422
302
lower than --read-rnd-buffer-size. Setting to 0 means unlimited.
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``
304
.. option:: --scheduler arg (=multi-thread)
436
306
Select scheduler to be used.
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
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)
467
314
A global constraint for sort-buffer-size for all clients, cannot be set lower
468
315
than --sort-buffer-size. Setting to 0 means unlimited.
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``
317
.. option:: --table-definition-cache arg (=128)
489
319
The number of cached table definitions.
491
.. option:: --table-lock-wait-timeout ARG
494
:Variable: ``table_lock_wait_timeout``
321
.. option:: --table-open-cache arg (=1024)
323
The number of cached open tables.
325
.. option:: --table-lock-wait-timeout arg (=50)
496
327
Timeout in seconds to wait for a table level lock before returning an error.
497
328
Used only if the connection has active cursors.
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``
330
.. option:: --thread-stack arg (=0)
511
332
The stack size for each thread. 0 means use OS default.
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``
334
.. option:: --tmp-table-size arg (=16M)
525
336
If an internal in-memory temporary table exceeds this size, Drizzle will
526
337
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/options.rst
