Drizzled Options

There are many different options one can use to configure Drizzle.

Config File Options

--help-extended

Display this help and exit after initializing plugins.

--help

Display this help and exit.

--no-defaults

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

--defaults-file arg

Configuration file to use

--config-dir arg (=/etc/drizzle)

Base location for config files

--plugin-dir arg

Directory for plugins

--pid-file arg

Pid file used by drizzled.

Plugin Loading Options

--plugin-add arg

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

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

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

Kernel Options

--auto-increment-increment arg (=1)

Auto-increment columns are incremented by this

--auto-increment-offset arg (=1)

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

--basedir, -b arg

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

--chroot, -r arg

Chroot drizzled daemon during startup.

--collation-server arg

Set the default collation.

--completion-type arg (=0)

Default completion type.

--core-file

Write core on errors.

--datadir arg

Path to the database root.

--default-storage-engine arg

Set the default storage engine for tables.

--default-time-zone arg

Set the default time zone.

--exit-info, -T arg

Used for debugging; Use at your own risk!

--gdb

Set up signals usable for debugging

--lc-time-name arg

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

--log-warnings, -W arg

Log some not critical warnings to the log file.

--port-open-timeout arg (=0)

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

--secure-file-priv arg

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

--server-id arg (=0)

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

--skip-stack-trace

Don’t print a stack trace on failure.

Enable symbolic link support.

--timed-mutexes

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

--tmpdir, -t arg

Path for temporary files.

--transaction-isolation arg

Default transaction isolation level.

--user, -u arg

Run drizzled daemon as user.

--version, -V

Output version information and exit.

--back-log arg (=50)

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.

--bulk-insert-buffer-size arg (=8388608)

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

--div-precision-increment arg (=4)

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

--group-concat-max-len arg (=1024)

The maximum length of the result of function group_concat.

--join-buffer-size arg (=131072)

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

--join-buffer-constraint arg (=0)

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

--max-allowed-packet arg (=64M)

Max packetlength to send/receive from to server.

--max-connect-errors arg (=10)

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 (=64)

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

--max-heap-table-size arg (=16M)

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

--max-join-size arg (=2147483647)

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

--max-length-for-sort-data arg (=1024)

Max number of bytes in sorted records.

--max-seeks-for-key arg (=18446744073709551615)

Limit assumed max number of seeks when looking up rows based on a key

--max-sort-length arg (=1024)

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 (=18446744073709551615)

After this many write locks, allow some read locks to run in between.

--min-examined-row-limit arg (=0)

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

--disable-optimizer-prune

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

--optimizer-search-depth arg (=0)

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

--preload-buffer-size arg (=32768)

The size of the buffer that is allocated when preloading indexes

--query-alloc-block-size arg (=8192)

Allocation block size for query parsing and execution

--query-prealloc-size arg (=8192)

Persistent buffer for query parsing and execution

--range-alloc-block-size arg (=4096)

Allocation block size for storing ranges during optimization

--read-buffer-size arg (=131072)

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-buffer-constraint arg (=0)

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

--read-rnd-buffer-size arg (=262144)

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 (=0)

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 (=multi-thread)

Select scheduler to be used.

--sort-buffer-size arg (=2097144)

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

--sort-buffer-constraint arg (=0)

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

--table-definition-cache arg (=128)

The number of cached table definitions.

--table-open-cache arg (=1024)

The number of cached open tables.

--table-lock-wait-timeout arg (=50)

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

--thread-stack arg (=0)

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

--tmp-table-size arg (=16M)

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

Table Of Contents

Previous topic

Configuration

Next topic

Plugin Documentation

This Page