SQL_ERROR_LOG Plugin System Variables

You are viewing an old version of this article. View the current version here.

This page documents system variables 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_log_filename

  • Description: The name of the logfile containing the errors. Rotation will use a naming convention such as sql_error_log_filename.001.
  • 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: string
  • 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

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.