Rechercher dans le manuel MySQL
5.4.2.2 Default Error Log Destination Configuration
This section discusses which server options configure the default error log destination, which can be the console or a named file. It also indicates which log writer components base their own output destination on the default destination.
In this discussion, “console” means
stderr
, the standard error output. This is
your terminal or console window unless the standard error output
has been redirected to a different destination.
The server interprets options that determine the default error log destination somewhat differently for Windows and Unix systems. Be sure to configure the destination using the information appropriate to your platform:
For Windows, see Default Error Log Destination on Windows.
For Unix and Unix-like systems, see Default Error Log Destination on Unix and Unix-Like Systems.
After the server interprets the default error log destination
options, it sets the log_error
system variable to indicate the default destination, which
affects where several log writer components write error
messages. See
How the Default Error Log Destination Affects Log Writers.
Default Error Log Destination on Windows
On Windows, mysqld uses the
--log-error
,
--pid-file
, and
--console
options to determine
whether the default error log destination is the console or a
file, and, if a file, the file name:
If
--console
is given, the default destination is the console. (--console
takes precedence over--log-error
if both are given, and the following items regarding--log-error
do not apply.)If
--log-error
is not given, or is given without naming a file, the default destination is a file named
in the data directory, unless thehost_name
.err--pid-file
option is specified. In that case, the file name is the PID file base name with a suffix of.err
in the data directory.If
--log-error
is given to name a file, the default destination is that file (with an.err
suffix added if the name has no suffix), located under the data directory unless an absolute path name is given to specify a different location.
If the default error log destination is the console, the
server sets the log_error
system variable to stderr
. Otherwise, the
default destination is a file and the server sets
log_error
to the file name.
On Unix and Unix-like systems, mysqld uses
the --log-error
option to
determine whether the default error log destination is the
console or a file, and, if a file, the file name:
If
--log-error
is not given, the default destination is the console.If
--log-error
is given without naming a file, the default destination is a file named
in the data directory.host_name
.errIf
--log-error
is given to name a file, the default destination is that file (with an.err
suffix added if the name has no suffix), located under the data directory unless an absolute path name is given to specify a different location.If
--log-error
is given in an option file in a[mysqld]
,[server]
, or[mysqld_safe]
section, mysqld_safe finds and uses the option, and passes it to mysqld.
It is common for Yum or APT package installations to
configure an error log file location under
/var/log
with an option like
log-error=/var/log/mysqld.log
in a server
configuration file. Removing the file name from the option
causes the
file in the data directory to be used.
host_name
.err
If the default error log destination is the console, the
server sets the log_error
system variable to stderr
. Otherwise, the
default destination is a file and the server sets
log_error
to the file name.
After the server interprets the error log destination
configuration options, it sets the
log_error
system variable to
indicate the default error log destination. Log writer
components may base their own output destination on the
log_error
value, or determine
their destination independently of
log_error
If log_error
is
stderr
, the default error log destination
is the console, and log writers that base their output
destination on the default destination also write to the
console:
log_sink_internal
,log_sink_json
,log_sink_test
: These writers write to the console. This is true even for writers such aslog_sink_json
that can be enabled multiple times; all instances write to the console.log_sink_syseventlog
: This writer writes to the system log, regardless of thelog_error
value.
If log_error
is not
stderr
, the default error log destination
is a file and log_error
indicates the file name. Log writers that base their output
destination on the default destination base output file naming
on that file name. (A writer might use exactly that name, or
it might use some variant thereof.) Suppose that the
log_error
value
file_name
. Then log writers use the
name like this:
log_sink_internal
,log_sink_test
: These writers write tofile_name
.log_sink_json
: Successive instances of this writer named in thelog_error_services
value write to files namedfile_name
plus a numbered.
suffix:NN
.json
,file_name
.00.json
, and so forth.file_name
.01.jsonlog_sink_syseventlog
: This writer writes to the system log, regardless of thelog_error
value.
Deutsche Übersetzung
Sie haben gebeten, diese Seite auf Deutsch zu besuchen. Momentan ist nur die Oberfläche übersetzt, aber noch nicht der gesamte Inhalt.Wenn Sie mir bei Übersetzungen helfen wollen, ist Ihr Beitrag willkommen. Alles, was Sie tun müssen, ist, sich auf der Website zu registrieren und mir eine Nachricht zu schicken, in der Sie gebeten werden, Sie der Gruppe der Übersetzer hinzuzufügen, die Ihnen die Möglichkeit gibt, die gewünschten Seiten zu übersetzen. Ein Link am Ende jeder übersetzten Seite zeigt an, dass Sie der Übersetzer sind und einen Link zu Ihrem Profil haben.
Vielen Dank im Voraus.
Dokument erstellt 26/06/2006, zuletzt geändert 26/10/2018
Quelle des gedruckten Dokuments:https://www.gaudry.be/de/mysql-rf-error-log-destination-configuration.html
Die Infobro ist eine persönliche Seite, deren Inhalt in meiner alleinigen Verantwortung liegt. Der Text ist unter der CreativeCommons-Lizenz (BY-NC-SA) verfügbar. Weitere Informationen auf die Nutzungsbedingungen und dem Autor.
Referenzen
Diese Verweise und Links verweisen auf Dokumente, die während des Schreibens dieser Seite konsultiert wurden, oder die zusätzliche Informationen liefern können, aber die Autoren dieser Quellen können nicht für den Inhalt dieser Seite verantwortlich gemacht werden.
Der Autor Diese Website ist allein dafür verantwortlich, wie die verschiedenen Konzepte und Freiheiten, die mit den Nachschlagewerken gemacht werden, hier dargestellt werden. Denken Sie daran, dass Sie mehrere Quellinformationen austauschen müssen, um das Risiko von Fehlern zu reduzieren.