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.

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

  • 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:Global
    Dynamic:No
    Option:

    Error count.

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

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

  • 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:Global
    Dynamic:No
    Option:

    Unknown.

Table Of Contents

Previous topic

Values

Next topic

Administering Drizzle

This Page