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