5.5.3 Error Log Components

Table des matières

This section describes the characteristics of individual error log components. For general information about configuring error logging, see Section 5.4.2, “The Error Log”.

A log component can be a filter or a sink:

A filter processes log events, to add, remove, or modify event fields, or to delete events entirely. The resulting events pass to the next log component named in the log_error_services system variable value.
A sink is a destination (writer) for log events. Typically, a sink processes log events into log messages that have a particular format and writes these messages to its associated output, such as a file or the system log.

The server executes filters and sinks in the log_error_services value in the order they are named. The rightmost component should therefore be a sink. If the rightmost component is a filter, any changes it has on events have no effect on output.

The following sections describe individual log components, grouped by component type:

Component descriptions include these types of information:

The component name and intended purpose.
Whether the component is built in or must be loaded. For a loadable component, the description specifies the URN to use to load and unload the component with the INSTALL COMPONENT and UNINSTALL COMPONENT statements.
Whether the component can be listed multiple times in the log_error_services value.
For a sink component, the destination to which the component writes output.

Error Log Filter Components

Error log filter components implement filtering of error log events:

If no filter component is enabled, no filtering occurs.
Any enabled filter component affects log events only for components listed later in the log_error_services value. In particular, for any log sink component listed in log_error_services earlier than any filter component, no log event filtering occurs.

Table des matières Haut

The log_filter_internal Component

Purpose: Implements filtering based on the log_error_verbosity system variable setting. See Section 5.4.2.5, “Error Log Filtering”.
URN: This component is built in and need not be loaded with INSTALL COMPONENT before use.
Multiple uses permitted: No.

Because log_error_verbosity affects the log_filter_internal component, log_error_verbosity has no effect on logging if log_filter_internal is not enabled.

Table des matières Haut

The log_filter_dragnet Component

Purpose: Implements filtering based on the rules defined by the dragnet.log_error_filter_rules system variable setting. See Section 5.4.2.5, “Error Log Filtering”.
URN: file://component_log_filter_dragnet
Multiple uses permitted: No.

Table des matières Haut

Error Log Sink Components

Error log sink components are writers that implement error log output. If no sink component is enabled, no log output occurs.

Some sink component descriptions refer to the default error log destination. This is the console or a file and is indicated by the fault of the log_error system variable, determined as described in Section 5.4.2.2, “Default Error Log Destination Configuration”.

Table des matières Haut

The log_sink_internal Component

Purpose: Implements traditional error log message output format.
URN: This component is built in and need not be loaded with INSTALL COMPONENT before use.
Multiple uses permitted: No.
Output destination: Writes to the default error log destination.

Table des matières Haut

The log_sink_json Component

Purpose: Implements JSON-format error logging.
URN: file://component_log_sink_json
Multiple uses permitted: Yes.
Output destination: The JSON log writer determines its output destination based on the default error log destination, which is given by the log_error system variable:
- If log_error names a file, the JSON writer bases output file naming on that file name, plus a numbered .NN.json suffix, with NN starting at 00. For example, if log_error is file_name, successive instances of log_sink_json named in the log_error_services value write to file_name.00.json, file_name.01.json, and so forth.
- If log_error is stderr, the JSON writer writes to the console. If log_json_writer is named multiple times in the log_error_services value, they all write to the console, which is likely not useful.

Table des matières Haut

The log_sink_syseventlog Component

Purpose: Implements error logging to the system log. This is the Event Log on Windows, and syslog on Unix and Unix-like systems.
URN: file://component_log_sink_syseventlog
Multiple uses permitted: No.
Output destination: Writes to the system log. Does not use the default error log destination.

Table des matières Haut

The log_sink_test Component

Purpose: Intended for internal use in writing test cases. Not intended for production use.
URN: file://component_log_sink_test
Multiple uses permitted: Yes.
Output destination: Writes to the default error log destination.

Rechercher dans le manuel MySQL

Traduction non disponible

Le manuel MySQL n'est pas encore traduit en français sur l'infobrol. Seule la version anglaise est disponible pour l'instant.

Document créé le 26/06/2006, dernière modification le 26/10/2018
Source du document imprimé : https://www.gaudry.be/mysql-rf-error-log-components.html

L'infobrol est un site personnel dont le contenu n'engage que moi. Le texte est mis à disposition sous licence CreativeCommons(BY-NC-SA). Plus d'info sur les conditions d'utilisation et sur l'auteur.

Références

Manuel MySQL : https://dev.mysql.com/

Ces références et liens indiquent des documents consultés lors de la rédaction de cette page, ou qui peuvent apporter un complément d'information, mais les auteurs de ces sources ne peuvent être tenus responsables du contenu de cette page.
L'auteur de ce site est seul responsable de la manière dont sont présentés ici les différents concepts, et des libertés qui sont prises avec les ouvrages de référence. N'oubliez pas que vous devez croiser les informations de sources multiples afin de diminuer les risques d'erreurs.

Table des matières Haut