drizzled Configuration

Options

General Options

--daemon, -d

Run drizzled as a daemon.

--help, -?

Display this help and exit.

--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:

false

Variable:

replicate_query

Include the SQL query in replicated protobuf messages. This can be useful for tracking back what SQL query caused what row operations to occur at the expense of increased size of the replication log (possibly even doubling it for some operations).

--transaction-message-threshold
Default:

1048576

Variable:

transaction_message_threshold

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

If a transaction produres more than transaction-message-threshold bytes of data for replication, the transaction is segmented in the replication stream. if transaction-message-threshold is met and in the event of ROLLBACK, the slave will have to do slightly more work as it may have already started applying the transaction and will also have to execute ROLLBACK.

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.

--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.

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.

--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

  • autocommit

    Scope:

    Global

    Dynamic:

    No

    Option:

    If statements are auto-committed.

  • back_log

    Scope:

    Global

    Dynamic:

    No

    Option:

    --back-log

  • basedir

    Scope:

    Global

    Dynamic:

    No

    Option:

    --basedir

  • datadir

    Scope:

    Global

    Dynamic:

    No

    Option:

    --datadir

  • error_count

    Scope:

    Session

    Dynamic:

    No

    Option:

    This variable contains a count of the number of errors from the previous statement executed in the current session. It is reset with each query, which includes any SHOW VARIABLES query, so only a SELECT @@error_count will get the previous warning count.

    Similar to the error_count variable, but for errors.

  • foreign_key_checks

    Scope:

    Global

    Dynamic:

    No

    Option:

    If foreign key checks are enabled.

  • hostname

    Scope:

    Global

    Dynamic:

    No

    Option:

    Hostname of the server.

  • identity

    Scope:

    Global

    Dynamic:

    No

    Option:

    Unknown.

  • last_insert_id

    Scope:

    Global

    Dynamic:

    No

    Option:

    Last auto-increment insert ID value.

  • lc_time_names

    Scope:

    Global

    Dynamic:

    No

    Option:

    Unknown.

  • pid_file

    Scope:

    Global

    Dynamic:

    No

    Option:

    --pid-file

  • pseudo_thread_id

    Scope:

    Global

    Dynamic:

    No

    Option:

    Unknown.

  • scheduler

    Scope:

    Global

    Dynamic:

    No

    Option:

    --scheduler

  • server_id

    Scope:

    Global

    Dynamic:

    No

    Option:

    --server-id

  • server_uuid

    Scope:

    Global

    Dynamic:

    No

    Option:

    Server UUID.

  • sql_big_selects

    Scope:

    Global

    Dynamic:

    No

    Option:

    Unknown.

  • sql_buffer_result

    Scope:

    Global

    Dynamic:

    No

    Option:

    Unknown.

  • sql_notes

    Scope:

    Global

    Dynamic:

    No

    Option:

    Unknown.

  • sql_select_limit

    Scope:

    Global

    Dynamic:

    No

    Option:

    Unknown.

  • sql_warnings

    Scope:

    Global

    Dynamic:

    No

    Option:

    Unknown.

  • timed_mutexes

    Scope:

    Global

    Dynamic:

    No

    Option:

    --timed-mutexes

  • timestamp

    Scope:

    Global

    Dynamic:

    No

    Option:

    Current UNIX timestamp.

  • tmpdir

    Scope:

    Global

    Dynamic:

    No

    Option:

    --tmpdir

  • unique_checks

    Scope:

    Global

    Dynamic:

    No

    Option:

    Check UNIQUE indexes for uniqueness.

  • vc_branch

    Scope:

    Global

    Dynamic:

    No

    Option:

    Version control (Bazaar) branch.

  • vc_release_id

    Scope:

    Global

    Dynamic:

    No

    Option:

    Version control (Bazaar) release id.

  • vc_revid

    Scope:

    Global

    Dynamic:

    No

    Option:

    Version control (Bazaar) revision id.

  • vc_revno

    Scope:

    Global

    Dynamic:

    No

    Option:

    Version control (Bazaar) revision number.

  • version

    Scope:

    Global

    Dynamic:

    No

    Option:

    --version

    Drizzle version.

  • version_comment

    Scope:

    Global

    Dynamic:

    No

    Option:

    Version comment.

  • version_compile_machine

    Scope:

    Global

    Dynamic:

    No

    Option:

    Version compile for machine type.

  • version_compile_os

    Scope:

    Global

    Dynamic:

    No

    Option:

    Version compile for OS.

  • version_compile_vendor

    Scope:

    Global

    Dynamic:

    No

    Option:

    Version compile for OS vendor.

  • warning_count

    Scope:

    Session

    Dynamic:

    No

    Option:

    This variable contains a count of the number of warnings from the previous statement executed in the current session. It is reset with each query, which includes any SHOW VARIABLES query, so only a SELECT @@warning_count will get the previous warning count.

    Similar to the error_count variable, but for warnings.