The Error Log

• The error log file 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.

• Specify where mysqld stores the error log file with the --log-error[=name] option.
  • If no name value is given, mysqld uses the hostname followed by .err and writes the file in the data directory.

• If mysqld_safe is used to start mysqld and mysqld dies unexpectedly, mysqld_safe restarts mysqld and writes a restarted mysqld message to the error log.

What does the general query log contain?

---

---

© 2007 John Michael Pierobon

Notes