Run drizzled as a daemon.
Display this help and exit.
Display this help and exit after initializing plugins.
Default: | |
---|---|
Variable: |
Run drizzled daemon as user.
Default: | |
---|---|
Variable: | version |
Print the version of Drizzle and exit.
Default: | /etc/drizzle |
---|---|
Variable: |
Base location for config files.
Default: | |
---|---|
Variable: |
Configuration file to use.
Default: | |
---|---|
Variable: |
Configuration file defaults are not used if no-defaults is set.
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
Default: | |
---|---|
Variable: |
Directory for plugins.
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.
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
Default: | |
---|---|
Variable: | replicate_query |
Include the SQL query in replicated protobuf messages.
Default: | 1048576 |
---|---|
Variable: | transaction_message_threshold |
Max message size written to transaction log, valid values 131072 - 1048576 bytes.
Default: | 1 |
---|---|
Variable: | auto_increment_increment |
Auto-increment columns are incremented by this
Default: | 1 |
---|---|
Variable: | auto_increment_offset |
Offset added to Auto-increment columns. Used when auto-increment-increment != 1
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.
Default: | |
---|---|
Variable: | basedir |
Path to installation directory. All paths are usually resolved relative to this.
Default: | 8388608 |
---|---|
Variable: | bulk_insert_buffer_size |
Size of tree cache used in bulk insert optimization. Note that this is a limit per thread!
Default: | |
---|---|
Variable: |
Chroot drizzled daemon during startup.
Default: | |
---|---|
Variable: | collation_server |
Set the default collation.
Default: | 0 |
---|---|
Variable: | completion_type |
Unknown.
Default: | |
---|---|
Variable: |
Write core on errors.
Default: | |
---|---|
Variable: | datadir |
Path to the database root.
Default: | InnoDB |
---|---|
Variable: | storage_engine |
Set the default storage engine for tables.
Default: | |
---|---|
Variable: |
Set the default time zone.
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.
Default: | 4 |
---|---|
Variable: | div_precision_increment |
Precision of the result of ‘/’ operator will be increased on that value.
Default: | |
---|---|
Variable: |
Used for debugging; Use at your own risk!
Default: | |
---|---|
Variable: |
Set up signals usable for debugging.
Default: | 1024 |
---|---|
Variable: | group_concat_max_len |
The maximum length of the result of function group_concat.
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.
Default: | 131072 |
---|---|
Variable: | join_buffer_size |
The size of the buffer that is used for full joins.
Default: | |
---|---|
Variable: | lc_time_names |
Set the language used for the month names and the days of the week.
Default: | |
---|---|
Variable: |
Log some not critical warnings to the log file.
Default: | 64M |
---|---|
Variable: | max_allowed_packet |
Max packetlength to send/receive from to server.
Default: | 10 |
---|---|
Variable: |
If there is more than this number of interrupted connections from a host this host will be blocked from further connections.
Default: | 64 |
---|---|
Variable: | max_error_count |
Max number of errors/warnings to store for a statement.
Default: | 16M |
---|---|
Variable: | max_heap_table_size |
Don’t allow creation of heap tables bigger than this.
Default: | 2147483647 |
---|---|
Variable: | max_join_size |
Joins that are probably going to read more than max_join_size records return an error.
Default: | 1024 |
---|---|
Variable: | max_length_for_sort_data |
Max number of bytes in sorted records.
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.
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).
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.
Default: | 0 |
---|---|
Variable: | min_examined_row_limit |
Don’t log queries which examine less than min_examined_row_limit rows to file.
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).
Default: | |
---|---|
Variable: | pid_file |
PID file used by drizzled.
Default: | 0 |
---|---|
Variable: |
Maximum time in seconds to wait for the port to become free. A value of 0 means not to wait.
Default: | 32768 |
---|---|
Variable: | preload_buffer_size |
The size of the buffer that is allocated when preloading indexes.
Default: | 8192 |
---|---|
Variable: | query_alloc_block_size |
Allocation block size for query parsing and execution.
Default: | 8192 |
---|---|
Variable: | query_prealloc_size |
Persistent buffer for query parsing and execution.
Default: | 4096 |
---|---|
Variable: | range_alloc_block_size |
Allocation block size for storing ranges during optimization.
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.
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.
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.
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.
Default: | multi-thread |
---|---|
Variable: | scheduler |
Select scheduler to be used.
Default: | |
---|---|
Variable: | secure_file_priv |
Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to files within specified directory.
Default: | 0 |
---|---|
Variable: | server_id |
Uniquely identifies the server instance in the community of replication partners.
Default: | |
---|---|
Variable: |
Don’t print a stack trace on failure.
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.
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.
Default: | 128 |
---|---|
Variable: | table_definition_cache |
The number of cached table definitions.
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.
Default: | 1024 |
---|---|
Variable: | table_open_cache |
The number of cached open tables.
Default: | 0 |
---|---|
Variable: | thread_stack |
The stack size for each thread. 0 means use OS default.
Default: | |
---|---|
Variable: | timed_mutexes |
Specify whether to time mutexes (only InnoDB mutexes are currently supported).
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.
Default: | |
---|---|
Variable: | tmpdir |
Path for temporary files.
Default: | REPEATABLE-READ |
---|---|
Variable: | tx_isolation |
Default transaction isolation level.
auto_increment_increment
Scope: Global Dynamic: No Option: --auto-increment-increment
auto_increment_offset
Scope: Global Dynamic: No Option: --auto-increment-offset
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
bulk_insert_buffer_size
Scope: Global Dynamic: No Option: --bulk-insert-buffer-size
collation_server
Scope: Global Dynamic: No Option: --collation-server
completion_type
Scope: Global Dynamic: No Option: --completion-type
datadir
Scope: Global Dynamic: No Option: --datadir
div_precision_increment
Scope: Global Dynamic: No Option: --div-precision-increment
error_count
Scope: Global Dynamic: No Option: Error count.
foreign_key_checks
Scope: Global Dynamic: No Option: If foreign key checks are enabled.
group_concat_max_len
Scope: Global Dynamic: No Option: --group-concat-max-len
hostname
Scope: Global Dynamic: No Option: Hostname of the server.
identity
Scope: Global Dynamic: No Option: Unknown.
join_buffer_size
Scope: Global Dynamic: No Option: --join-buffer-size
last_insert_id
Scope: Global Dynamic: No Option: Last auto-increment insert ID value.
lc_time_names
Scope: Global Dynamic: No Option: Unknown.
max_allowed_packet
Scope: Global Dynamic: No Option: --max-allowed-packet
max_error_count
Scope: Global Dynamic: No Option: --max-error-count
max_heap_table_size
Scope: Global Dynamic: No Option: --max-heap-table-size
max_join_size
Scope: Global Dynamic: No Option: --max-join-size
max_length_for_sort_data
Scope: Global Dynamic: No Option: --max-length-for-sort-data
max_seeks_for_key
Scope: Global Dynamic: No Option: --max-seeks-for-key
max_sort_length
Scope: Global Dynamic: No Option: --max-sort-length
max_write_lock_count
Scope: Global Dynamic: No Option: --max-write-lock-count
min_examined_row_limit
Scope: Global Dynamic: No Option: --min-examined-row-limit
optimizer_prune_level
Scope: Global Dynamic: No Option: --disable-optimizer-prune Optimizer prune level.
optimizer_search_depth
Scope: Global Dynamic: No Option: --optimizer-search-depth
pid_file
Scope: Global Dynamic: No Option: --pid-file
plugin_dir
Scope: Global Dynamic: No Option: --plugin-dir
preload_buffer_size
Scope: Global Dynamic: No Option: --preload-buffer-size
pseudo_thread_id
Scope: Global Dynamic: No Option: Unknown.
query_alloc_block_size
Scope: Global Dynamic: No Option: --query-alloc-block-size
query_prealloc_size
Scope: Global Dynamic: No Option: --query-prealloc-size
range_alloc_block_size
Scope: Global Dynamic: No Option: --range-alloc-block-size
read_buffer_size
Scope: Global Dynamic: No Option: --read-buffer-size
read_rnd_buffer_size
Scope: Global Dynamic: No Option: --read-rnd-buffer-size
replicate_query
Scope: Global Dynamic: No Option: --replicate-query
scheduler
Scope: Global Dynamic: No Option: --scheduler
secure_file_priv
Scope: Global Dynamic: No Option: --secure-file-priv
server_id
Scope: Global Dynamic: No Option: --server-id
server_uuid
Scope: Global Dynamic: No Option: Server UUID.
sort_buffer_size
Scope: Global Dynamic: No Option: --sort-buffer-size
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.
storage_engine
Scope: Global Dynamic: No Option: --default-storage-engine
table_definition_cache
Scope: Global Dynamic: No Option: --table-definition-cache
table_lock_wait_timeout
Scope: Global Dynamic: No Option: --table-lock-wait-timeout
table_open_cache
Scope: Global Dynamic: No Option: --table-open-cache
thread_stack
Scope: Global Dynamic: No Option: --thread-stack
timed_mutexes
Scope: Global Dynamic: No Option: --timed-mutexes
timestamp
Scope: Global Dynamic: No Option: Current UNIX timestamp.
tmp_table_size
Scope: Global Dynamic: No Option: --tmp-table-size
tmpdir
Scope: Global Dynamic: No Option: --tmpdir
transaction_message_threshold
Scope: Global Dynamic: No Option: --transaction-message-threshold
tx_isolation
Scope: Global Dynamic: No Option: --transaction-isolation
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.