mysql中的日志（一）(三)
未指 定， 默认值为tmpdir变量的值
?
查看日志
?
SHOW RELAYLOG ['connection_name'] EVENTS
? ? [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
?
六、日志切割
?
不要忘记了切割日志.否则日志文件将会很大
?
In Debian (and Debian derivatives as Ubuntu etc)?
?
1
vim /etc/logrotate.d/mysql-server
?
其他版本，可能需要一些改变
?
# - I put everything in one block and added sharedscripts, so that mysql gets
# flush-logs'd only once.
# Else the binary logs would automatically increase by n times every day.
# - The error log is obsolete, messages go to syslog now.
/var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log {
daily
rotate 7
missingok
create 640 mysql adm
compress
sharedscripts
postrotate
test -x /usr/bin/mysqladmin || exit 0
# If this fails, check debian.conf!
MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
if [ -z "`$MYADMIN ping 2>
/dev/null`" ]; then
# Really no mysqld or rather a missing debian-sys-maint user?
# If this occurs and is not a error please report a bug.
#if ps cax | grep -q mysqld; then
if killall -q -s0 -umysql mysqld; then
exit 1
fi
else
$MYADMIN flush-logs
fi
endscript
}
?