This page documents system variables and options related to the SQL_Error_Log Plugin. See Server System Variables for a complete list of system variables and instructions on setting them.
See also the Full list of MariaDB options, system and status variables.
sql_error_logDescription: Controls how the server should treat the plugin when the server starts up.
Valid values are:
OFF - Disables the plugin without removing it from the table.
sql_error_log_filenameDescription: The name (and optionally path) of the logfile containing the errors. Rotation will use a naming convention such as sql_error_log_filename.001. If no path is specified, the log file will be written to the .
Command line: --sql-error-log-filename=value
Scope: Global
sql_error_log_rateDescription: The logging sampling rate. Setting to 10, for example, means that one in ten errors will be logged. If set to zero, logging is disabled. The default, 1, logs every error.
Command line: --sql-error-log-rate=#
Scope: Global
sql_error_log_rotateDescription: Setting to #1forces log rotation.
Command line: --sql-error-log-rate[={0|1}]
Scope: Global
Dynamic: Yes
sql_error_log_rotationsDescription: Number of rotations before the log is removed. When rotated, the current log file is stored and a new, empty, log is created. Any rotations older than this setting are removed.
Command line: --sql-error-log-rotations=#
Scope: Global
Dynamic: Yes
sql_error_log_size_limitDescription: The log file size limit in bytes. After reaching this size, the log file is rotated.
Command line: --sql-error-log-size-limit=#
Scope: Global
Dynamic: No
sql_error_log_warningsDescription: If set, log warnings in addition to errors.
Command line: --sql-error-log-warnings={0,1}
Scope: Global
Dynamic: Yes
sql_error_log_with_db_and_thread_infoDescription: If enabled, it prints the database name and the thread ID in the log in addition to already existing columns.
Command line: --sql-error-log-with-db-and-thread-info=value
Scope: Global
Dynamic: No
This page is licensed: CC BY-SA / Gnu FDL
ON - Enables the plugin. If the plugin cannot be initialized, then the server will still continue starting up, but the plugin will be disabled.FORCE - Enables the plugin. If the plugin cannot be initialized, then the server will fail to start with an error.
FORCE_PLUS_PERMANENT - Enables the plugin. If the plugin cannot be initialized, then the server will fail to start with an error. In addition, the plugin cannot be uninstalled with UNINSTALL SONAME or UNINSTALL PLUGIN while the server is running.
See Plugin Overview: Configuring Plugin Activation at Server Startup for more information.
Command line: --sql-error-log=value
Data Type: enumerated
Default Value: ON
Valid Values: OFF, ON, FORCE, FORCE_PLUS_PERMANENT
Data Type: string
Default Value: sql_errors.log
Dynamic: Yes
Data Type: numeric
Default Value: 1
Data Type: boolean
Default Value: OFF
Data Type: numeric
Default Value: 9
Range: 1 to 999
Data Type: numeric
Default Value: 1000000
Range: 100 to 9223372036854775807
Data Type: boolean
Default Value: ON
Introduced:
Data Type: boolean
Default Value: OFF
Introduced: , , , ,