"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/configuration/drizzled.rst" (6 May 2012, 21624 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

drizzled

drizzled Configuration

Options

General Options

--daemon, -d

Run drizzled as a daemon.

--help, -?

Display this help and exit.

--help-extended

Display this help and exit after initializing plugins.

--user, -u ARG

Default
Variable

Run drizzled daemon as user.

--version, -V

Default
Variable

version

Print the version of Drizzle and exit.

Config File Options

--config-dir DIR

Default

/etc/drizzle

Variable

Base location for config files.

--defaults-file FILE

Default
Variable

Configuration file to use.

--no-defaults

Default
Variable

Configuration file defaults are not used if no-defaults is set.

Plugin Options

--plugin-add LIST

Default
Variable

Optional comma separated list of plugins to load at startup in addition to the default list of plugins.

For example:

--plugin_add=crc32,console,pbxt

--plugin-dir DIR

Default
Variable

Directory for plugins.

--plugin-load LIST

Default

See default_plugins

Variable

Optional comma separated list of plugins to load at starup instead of the default plugin load list. This completely replaces the whole list.

--plugin-remove LIST

Default
Variable

Optional comma separated list of plugins to not load at startup. Effectively removes a plugin from the list of plugins to be loaded.

For example:

--plugin_remove=syslog,md5

Replication Options

--replicate-query

Default
Variable

replicate_query

Include the SQL query in replicated protobuf messages.

--transaction-message-threshold

Default

1048576

Variable

transaction_message_threshold

Max message size written to transaction log, valid values 131072 - 1048576 bytes.

Kernel Options

--auto-increment-increment ARG

Default

1

Variable

auto_increment_increment

Auto-increment columns are incremented by this

--auto-increment-offset ARG

Default

1

Variable

auto_increment_offset

Offset added to Auto-increment columns. Used when auto-increment-increment != 1

--back-log ARG

Default

50

Variable

back_log

The number of outstanding connection requests Drizzle can have. This comes into play when the main Drizzle thread gets very many connection requests in a very short time.

--basedir, -b ARG

Default
Variable

basedir

Path to installation directory. All paths are usually resolved relative to this.

--bulk-insert-buffer-size SIZE

Default

8388608

Variable

bulk_insert_buffer_size

Size of tree cache used in bulk insert optimization. Note that this is a limit per thread!

--chroot, -r ARG

Default
Variable

Chroot drizzled daemon during startup.

--collation-server ARG

Default
Variable

collation_server

Set the default collation.

--completion-type ARG

Default

0

Variable

completion_type

Unknown.

--core-file

Default
Variable

Write core on errors.

--datadir ARG

Default
Variable

datadir

Path to the database root.

--default-storage-engine ARG

Default

InnoDB

Variable

storage_engine

Set the default storage engine for tables.

--default-time-zone ARG

Default
Variable

Set the default time zone.

--disable-optimizer-prune

Default
Variable

optimizer_prune_level

Do not apply any heuristic(s) during query optimization to prune, thus perform an exhaustive search from the optimizer search space.

--div-precision-increment ARG

Default

4

Variable

div_precision_increment

Precision of the result of '/' operator will be increased on that value.

--exit-info, -T ARG

Default
Variable

Used for debugging; Use at your own risk!

--gdb

Default
Variable

Set up signals usable for debugging.

--group-concat-max-len ARG

Default

1024

Variable

group_concat_max_len

The maximum length of the result of function group_concat.

--join-buffer-constraint ARG

Default

0

Variable

A global constraint for join-buffer-size for all clients, cannot be set lower than --join-buffer-size. Setting to 0 means unlimited.

--join-buffer-size SIZE

Default

131072

Variable

join_buffer_size

The size of the buffer that is used for full joins.

--lc-time-name ARG

Default
Variable

lc_time_names

Set the language used for the month names and the days of the week.

--log-warnings, -W ARG

Default
Variable

Log some not critical warnings to the log file.

--max-allowed-packet SIZE

Default

64M

Variable

max_allowed_packet

Max packetlength to send/receive from to server.

--max-connect-errors ARG

Default

10

Variable

If there is more than this number of interrupted connections from a host this host will be blocked from further connections.

--max-error-count ARG

Default

64

Variable

max_error_count

Max number of errors/warnings to store for a statement.

--max-heap-table-size SIZE

Default

16M

Variable

max_heap_table_size

Don't allow creation of heap tables bigger than this.

--max-join-size SIZE

Default

2147483647

Variable

max_join_size

Joins that are probably going to read more than max_join_size records return an error.

--max-length-for-sort-data SIZE

Default

1024

Variable

max_length_for_sort_data

Max number of bytes in sorted records.

--max-seeks-for-key ARG

Default

-1

Variable

max_seeks_for_key

Limit assumed max number of seeks when looking up rows based on a key. Set to -1 to disable.

--max-sort-length SIZE

Default

1024

Variable

max_sort_length

The number of bytes to use when sorting BLOB or TEXT values (only the first max_sort_length bytes of each value are used; the rest are ignored).

--max-write-lock-count ARG

Default

-1

Variable

max_write_lock_count

After this many write locks, allow some read locks to run in between. Set to -1 to disable.

--min-examined-row-limit ARG

Default

0

Variable

min_examined_row_limit

Don't log queries which examine less than min_examined_row_limit rows to file.

--optimizer-search-depth ARG

Default

0

Variable

optimizer_search_depth

Maximum depth of search performed by the query optimizer. Values larger than the number of relations in a query result in better query plans, but take longer to compile a query. Smaller values than the number of tables in a relation result in faster optimization, but may produce very bad query plans. If set to 0, the system will automatically pick a reasonable value; if set to MAX_TABLES+2, the optimizer will switch to the original find_best (used for testing/comparison).

--pid-file FILE

Default
Variable

pid_file

PID file used by drizzled.

--port-open-timeout ARG

Default

0

Variable

Maximum time in seconds to wait for the port to become free. A value of 0 means not to wait.

--preload-buffer-size SIZE

Default

32768

Variable

preload_buffer_size

The size of the buffer that is allocated when preloading indexes.

--query-alloc-block-size SIZE

Default

8192

Variable

query_alloc_block_size

Allocation block size for query parsing and execution.

--query-prealloc-size SIZE

Default

8192

Variable

query_prealloc_size

Persistent buffer for query parsing and execution.

--range-alloc-block-size SIZE

Default

4096

Variable

range_alloc_block_size

Allocation block size for storing ranges during optimization.

--read-buffer-constraint ARG

Default

0

Variable

A global constraint for read-buffer-size for all clients, cannot be set lower than --read-buffer-size. Setting to 0 means unlimited.

--read-buffer-size SIZE

Default

131072

Variable

read_buffer_size

Each thread that does a sequential scan allocates a buffer of this size for each table it scans. If you do many sequential scans, you may want to increase this value. Note that this only affect MyISAM.

--read-rnd-buffer-size SIZE

Default

262144

Variable

read_rnd_buffer_size

When reading rows in sorted order after a sort, the rows are read through this buffer to avoid a disk seeks. If not set, then it's set to the value of record_buffer.

--read-rnd-constraint ARG

Default

0

Variable

A global constraint for read-rnd-buffer-size for all clients, cannot be set lower than --read-rnd-buffer-size. Setting to 0 means unlimited.

--scheduler ARG

Default

multi-thread

Variable

scheduler

Select scheduler to be used.

--secure-file-priv ARG

Default
Variable

secure_file_priv

Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to files within specified directory.

--server-id ARG

Default

0

Variable

server_id

Uniquely identifies the server instance in the community of replication partners.

--skip-stack-trace

Default
Variable

Don't print a stack trace on failure.

--sort-buffer-constraint ARG

Default

0

Variable

A global constraint for sort-buffer-size for all clients, cannot be set lower than --sort-buffer-size. Setting to 0 means unlimited.

--sort-buffer-size SIZE

Default

2097144

Variable

sort_buffer_size

Each thread that needs to do a sort allocates a buffer of this size.

--symbolic-links, -s

Default
Variable

Enable symbolic link support.

--table-definition-cache ARG

Default

128

Variable

table_definition_cache

The number of cached table definitions.

--table-lock-wait-timeout ARG

Default

50

Variable

table_lock_wait_timeout

Timeout in seconds to wait for a table level lock before returning an error. Used only if the connection has active cursors.

--table-open-cache ARG

Default

1024

Variable

table_open_cache

The number of cached open tables.

--thread-stack ARG

Default

0

Variable

thread_stack

The stack size for each thread. 0 means use OS default.

--timed-mutexes

Default
Variable

timed_mutexes

Specify whether to time mutexes (only InnoDB mutexes are currently supported).

--tmp-table-size SIZE

Default

16M

Variable

tmp_table_size

If an internal in-memory temporary table exceeds this size, Drizzle will automatically convert it to an on-disk MyISAM table.

--tmpdir, -t DIR

Default
Variable

tmpdir

Path for temporary files.

--transaction-isolation ARG

Default

REPEATABLE-READ

Variable

tx_isolation

Default transaction isolation level.

Variables