Query Server Error Log

The query server error log (see the example shown in Figure 1) contains the following information, if applicable:

• When mysqld was started and stopped
• Critical errors found when running mysqld
• Replication errors and warnings
• Warnings if mysqld detects a table that needs to be automatically checked or repaired

The query server error log is assigned a name based on the name of your host and appended with a .err extension (for example, <hostname>.err) and is located in one of the following directories:

• On the LSMS, in /var/TKLC/lsms/db
• On a query server, in /usr/mysql1. On a Windows machine, mysqld writes this log directly to C:\mysql\data\mysql.err.
  Note: Because the query server error log continuously increases in size, it is the user's responsibility to monitor it. To manually delete the log, first shut down the server. Alternatively, execute the mysql-log-rotatescript inside your crontab.

Query Server Error Log Example