SQL Error Log System Variables and Options
You are viewing an old version of this article. View
the current version here.
Contents
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.
Options
sql_error_log
- Description: 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 mysql.plugins table.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.
- Valid values are:
- Commandline:
--sql-error-log=value
- Data Type:
enumerated
- Default Value:
ON
- Valid Values:
OFF
,ON
,FORCE
,FORCE_PLUS_PERMANENT
System Variables
sql_error_log_filename
- Description: 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 data directory. - Commandline:
--sql-error-log-filename=value
- Scope: Global
- Dynamic: No
- Data Type:
string
- Default Value:
sql_errors.log
sql_error_log_rate
- Description: 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. - Commandline:
--sql-error-log-rate=#
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
1
sql_error_log_rotate
- Description: Setting to #1
forces log rotation.
- Commandline:
--sql-error-log-rate[={0|1}]
- Scope: Global
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
sql_error_log_rotations
- Description: 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.
- Commandline:
--sql-error-log-rotations=#
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
9
- Range:
1
to999
sql_error_log_size_limit
- Description: The log file size limit in bytes. After reaching this size, the log file is rotated.
- Commandline:
--sql-error-log-size-limit=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
1000000
- Range:
100
to9223372036854775807
sql_error_log_warnings
- Description: If set, log warnings in addition to errors.
- Commandline:
--sql-error-log-warnings={0,1}
- Scope: Global
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
OFF
- Introduced: MariaDB 10.11.6
with_db_and_thread_info
- Description: If enabled, it prints the database name and the thread ID in the log in addition to already existing columns.
- Commandline:
--with-db-and-thread-info=value
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
OFF
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.