FsseInfo: MySql log files

Revision [281]

Last edited on 2006-11-27 11:07:41 by FsseInfo

Additions:

==Global Settings==
May be globally defined in /etc/mysql/my.cnf
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
log = /var/log/mysql.log
#log = /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
#log-slow-queries = /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication.
#server-id = 1
log-bin = /var/log/mysql/mysql-bin.log
expire-logs-days = 20
max_binlog_size = 104857600
#binlog-do-db = include_database_name
#binlog-ignore-db = include_database_name

Revision [279]

Edited on 2006-11-24 13:02:42 by FsseInfo

Additions:

Error logs and Query logs are overwritten when you restart mysqld or flush the logs. So make sure you save them FIRST !

Deletions:

Error logs and Query logs are overwritten when you restart mysqld or flush the logs.
So make sure you save them FIRST !

Revision [278]

Edited on 2006-11-24 12:58:19 by FsseInfo

Additions:

%%--log-error[=file_name]%%

Deletions:

~~%%-log-error[=file_name]%%~~

Revision [277]

Edited on 2006-11-24 12:56:50 by FsseInfo

Additions:

==WARNING==
Error logs and Query logs are overwritten when you restart mysqld or flush the logs.
So make sure you save them FIRST !
Save logs
$ cd mysql-logfile-directory
$ cp mysql.log mysql.old
$ cp mysql-slow.log mysql-slow.old
then restart mysql or flush logs

Deletions:

~~===MySql log file maintenance===~~

Revision [276]

Edited on 2006-11-24 12:49:50 by FsseInfo

Additions:

%%--log-slow-queries[=file_name]%%
SQL statement
Command line

Deletions:

~~%%--log-slow-queries[=file_name]~~

Revision [275]

The oldest known version of this page was created on 2006-11-24 12:48:56 by FsseInfo