DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info) log-files

Info Catalog (mysql.info) localization (mysql.info) database-administration (mysql.info) multiple-servers
 
 5.12 MySQL Server Logs
 ======================
 

Menu

 
* error-log                    The Error Log
* query-log                    The General Query Log
* binary-log                   The Binary Log
* slow-query-log               The Slow Query Log
* log-file-maintenance         Server Log Maintenance
 
 MySQL has several different log files 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 log           All queries that took more than `long_query_time'
                        seconds to execute or didn't use indexes
 
 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  flush.
 
 If you are using MySQL replication capabilities, slave replication
 servers maintain additional log files called relay logs. These are
 discussed in  replication.
 
Info Catalog (mysql.info) localization (mysql.info) database-administration (mysql.info) multiple-servers
automatically generated byinfo2html