(mysql.info.gz) Log Files

Info Catalog

(mysql.info.gz) Localisation

(mysql.info.gz) MySQL Database Administration

(mysql.info.gz) Multiple servers

 
 5.9 The MySQL Log Files
 =======================
 
 MySQL has several different log files that can help you find out what's
 going on inside `mysqld':
 
 *Log File*     *Types of Information Logged to File*
 The error log  Logs problems encountered 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  Logs established client connections and executed
                statements.
 The update     Logs statements that change data. This log is deprecated.
 log            
 The binary     Logs all statements that change data. Also used for
 log            replication.
 The slow log   Logs all queries that took more than `long_query_time'
                seconds to execute or didn't use indexes.
 
 By default, all logs 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'.   FLUSH.
 
 If you are using MySQL replication capabilities, slave replication
 servers maintain additional log files called relay logs. These are
 discussed in  Replication.
 

Menu

 
* Error log                   The Error Log
* Query log                   The General Query Log
* Update log                  The Update Log
* Binary log                  The Binary Log
* Slow query log              The Slow Query Log
* Log file maintenance        Log File Maintenance
 

Info Catalog

(mysql.info.gz) Localisation

(mysql.info.gz) MySQL Database Administration

(mysql.info.gz) Multiple servers