This page documents system variables related to the Mroonga storage engine. See Server System Variables for instructions on setting them.
See also the Full list of MariaDB options, system and status variables.
mroonga_action_on_fulltext_query_errorDescription: Action to take when encountering a Mroonga fulltext error.
ERROR: Report an error without logging.
ERROR_AND_LOG: Report an error with logging (the default)
IGNORE: No logging or reporting - the error is ignored.
Command line: --mroonga-action-on-fulltext-query-error=value
Scope: Global, Session
Dynamic: Yes
Data Type: enum
Default Value: ERROR_AND_LOG
mroonga_boolean_mode_syntax_flagsDescription: Flags to customize syntax in BOOLEAN MODE searches. Available flags:
DEFAULT: (=SYNTAX_QUERY,ALLOW_LEADING_NOT)
ALLOW_COLUMN: Allows COLUMN:... syntax in query syntax, an incompatible change to the regular BOOLEAN MODE syntax. Permits multiple indexes in one MATCH () AGAINST ()
mroonga_database_path_prefixDescription: The database path prefix.
Command line: --mroonga-database-path-prefix=value
Scope: Global
Dynamic: Yes
mroonga_default_parserDescription: The fulltext default parser, for example TokenBigramSplitSymbolAlphaDigit or TokenBigram (the default). See the list of options at . Deprecated since Mroonga 5.04, use instead.
Command line: --mroonga-default-parser=value
Scope: Global
mroonga_default_tokenizerDescription: The fulltext default parser, for example TokenBigramSplitSymbolAlphaDigit or TokenBigram (the default). See the list of options at .
Command line: --mroonga-default-tokenizer=value
Scope: Global, Session
mroonga_default_wrapper_engineDescription: The default engine for wrapper mode.
Command line: --mroonga-default-wrapper-engine=value
Scope: Global
Dynamic: No
mroonga_dry_writeDescription: If set to on, (off is default), data is not actually written to the Groonga database. Only really useful to change for benchmarking.
Command line: --mroonga-dry-write[={0|1}]
Scope: Global, Session
mroonga_enable_operations_recordingDescription: Whether recording operations for recovery to the Groonga database is enabled (default) or not. Requires reopening the database with after changing the variable.
Command line: --mroonga-enable-operations-recording={0|1}
Scope: Global
Dynamic: Yes
mroonga_enable_optimizationDescription: If set to on (the default), optimization is enabled. Only really useful to change for benchmarking.
Command line: --mroonga-enable-optimization={0|1}
Scope: Global, Session
Dynamic: Yes
mroonga_libgroonga_embeddedDescription: Whether libgroonga is embedded or not.
Command line: None
Scope: Global
Dynamic: No
mroonga_libgroonga_support_lz4Description: Whether libgroonga supports lz4 or not.
Command line: None
Scope: Global
Dynamic: No
mroonga_libgroonga_support_zlibDescription: Whether libgroonga supports zlib or not.
Command line: None
Scope: Global
Dynamic: No
mroonga_libgroonga_support_zstdDescription: Whether libgroonga supports Zstandard or not.
Command line: None
Scope: Global
Dynamic: No
mroonga_libgroonga_versionDescription: Groonga library version.
Command line: None
Scope: Global
Dynamic: No
mroonga_lock_timeoutDescription: Lock timeout used in Groonga.
Command line: --mroonga-lock-timeout=#
Scope: Global
Dynamic: Yes
mroonga_log_fileDescription: Name and path of the Mroonga log file.
Command line: --mroonga-log-file=value
Scope: Global
Dynamic: Yes
mroonga_log_levelDescription: Mroonga log file output level, which determines what is logged. Valid levels include:
NONE No output.
EMERG: Only emergency error messages, such as database corruption.
mroonga_match_escalation_thresholdDescription: The threshold to determine whether the match method is escalated. -1 means never escalate.
Command line: --mroonga-match-escalation-threshold=#
Scope: Global, Session
Dynamic: Yes
mroonga_max_n_records_for_estimateDescription: The max number of records to estimate the number of matched records
Command line: --mroonga-max-n-records-for-estimate=#
Scope: Global, Session
Dynamic: Yes
mroonga_query_log_fileDescription: Query log file for Mroonga.
Command line: --mroonga-query-log-file=filename
Scope: Global
Dynamic: Yes
mroonga_vector_column_delimiterDescription: Delimiter to use when outputting a vector column. The default is a white space.
Command line: --mroonga-vector-column-delimiter=value
Scope: Global
Dynamic: Yes
mroonga_versionDescription: Mroonga version
Command line: None
Scope: Global
Dynamic: No
This page is licensed: CC BY-SA / Gnu FDL
IGNORE_AND_LOGALLOW_LEADING_NOT Permits using the NOT_INCLUDED_KEYWORD syntax in the query syntax.
ALLOW_UPDATE: Permits updating values with the COLUMN:=NEW_VALUE syntax in the query syntax.
SYNTAX_QUERY: Mroonga will use Groonga's query syntax, compatible with MariaDB's BOOLEAN MODE syntax. Unless SYNTAX_SCRIPT is specified, this mode is always in use.
SYNTAX_SCRIPT: Mroonga will use Groonga's script syntax, a JavaScript-like syntax. If both SYNTAX_QUERY and SYNTAX_SCRIPT are specified, SYNTAX_SCRIPT will take precedence..
Command line: --mroonga-boolean-mode-syntax-flags=value
Scope: Global, Session
Dynamic: Yes
Data Type: enum
Default Value: DEFAULT
Data Type: string
Default Value: (Empty)
Dynamic: Yes
Data Type: string
Default Value: TokenBigram
Deprecated: , Mroonga 5.0.4
Dynamic: Yes
Data Type: string
Default Value: TokenBigram
Introduced: , Mroonga 5.0.4
Data Type: string
Default Value: (Empty)
Data Type: boolean
Default Value: off
Data Type: boolean
Default Value: ON
Introduced: ,
Data Type: boolean
Default Value: on
booleanDefault Value: ON
Introduced:
booleanDefault Value: OFF
booleanDefault Value: ON
booleanDefault Value: OFF
Introduced: ,
stringData Type: numeric
Default Value: 900000
Range: -1 to 2147483647
Data Type: string
Default Value: groonga.log
ALERT: Alert messages, such as internal errors.CRIT: Critical error messages, such as deadlocks.
ERROR: Errors, such as API errors.
WARNING: Warnings, such as invalid arguments.
NOTICE: Notices, such as a change in configuration or a status change.
INFO: Information messages, such as file system operations.
DEBUG: Debug messages, suggested for developers or testers.
DUMP: Dump messages.
Command line: --mroonga-log-level=value
Scope: Global
Dynamic: Yes
Data Type: enum
Default Value: NOTICE
Data Type: numeric
Default Value: 0
Range: -1 to 9223372036854775807
Data Type: numeric
Default Value: 1000
Range: -1 to 2147483647
Data Type: string
Default Value: (Empty string)
Introduced:
Data Type: string
Default Value: `` (white space)
string