MySQL Error Log File

The error log contains information indicating when mysqld was started and stopped and also any critical errors that occur while the server is running.

If mysqld notices a table that needs to be automatically checked or repaired, it writes a message to the error log.
On some operating systems, the error log contains a stack trace if mysqld dies.

You can specify where mysqld writes the error log with the –log-error[=file_name] option.
If no file_name value is given, mysqld uses the name host_name.err by default and writes the file in the data directory.

On Windows, error output is always written to the .err file if –console is not given.

If you use mysqld_safe to start mysqld, mysqld_safe arranges for mysqld to write error messages to a log file or to syslog mysqld_safe has three error-logging options, –syslog, –skip-syslog, and –log-error.

Trackback URI | Comments RSS

Leave a Reply

You must be logged in to post a comment.