GNU Info

(mysql.info)Log Files

---

Next: Replication Prev: Client-Side Scripts Up: MySQL Database Administration

---

Enter node , (file) or (file)node

The MySQL Log Files
===================

MySQL has several different log files that can help you find out what's
going on inside `mysqld':

The error log          Problems encountering starting, running or
                       stopping `mysqld'.
The isam log           Logs all changes to the ISAM tables. Used only
                       for debugging the isam code.
The query log          Established connections and executed queries.
The update log         Deprecated: Stores all statements that changes
                       data
The binary log         Stores all statements that changes something.
                       Used also for replication
The slow log           Stores all queries that took more than
                       `long_query_time' to execute or didn't use
                       indexes.

All logs can be found in the `mysqld' data directory.  You can force
`mysqld' to reopen the log files (or in some cases switch to a new log)
by executing `FLUSH LOGS'. Note: FLUSH.

Error log

The Error Log

Query log

The General Query Log

Update log

The Update Log

Binary log

The Binary Update Log

Slow query log

The Slow Query Log

Log file maintenance

Log File Maintenance