DEVELOPER ZONE ::
Login / Register
MySQL has several different logs that can help you find out what is going on inside mysqld:
|Log Type||Information Written to Log|
|The error log||Problems encountered starting, running, or stopping mysqld|
|The general query log||Established client connections and statements received from clients|
|The binary log||All statements that change data (also used for replication)|
|The slow query log||All queries that took more than
By default, all log files are created in the mysqld data directory. You can force mysqld to close and reopen the log files (or in some cases switch to a new log) by flushing the logs. Log flushing occurs when you issue a
FLUSH LOGS statement or execute mysqladmin flush-logs or mysqladmin refresh. See Section 188.8.131.52, “
FLUSH Syntax”, and Section 8.10, “mysqladmin — Client for Administering a MySQL Server”.
If you are using MySQL replication capabilities, slave replication servers maintain additional log files called relay logs. Chapter 6, Replication, discusses relay log contents and configuration.