[packages/mysql.git] / mysql.logrotate

# This section is used from mysqld.conf for logrotation.
# Be sure that the password in config matches the actual one.
#
# ATTENTION: The mysqld.conf should be readable ONLY for *system* root!
#
# [mysqladmin]
# user = mysql_sysadmin
# password = <secret>
#
# where "<secret>" is the password.
#
# You must do this for every active cluster defined in /etc/mysql/clusters.conf

/var/log/mysql/query.log
/var/log/mysql/mysqld.log
/var/log/mysql/slow.log
/var/log/mysql/update*
{
	olddir /var/log/archive/mysql
	notifempty
	missingok
	create 640 mysql mysql
	sharedscripts

	# NOTE:
	# if you run the rotation less often than "daily" then the
	# "expire-logs-days" mysqld server parameter may no longer work as you
	# expect
	daily

	postrotate
		/sbin/service mysql flush-logs
	endscript
}
Commit	Line	Data
4f1d5e55 ER	1	# This section is used from mysqld.conf for logrotation.
	2	# Be sure that the password in config matches the actual one.
	3	#
	4	# ATTENTION: The mysqld.conf should be readable ONLY for system root!
7a0e0e17 ER	5	#
7a0e0e17 ER	6	# [mysqladmin]
4f1d5e55	7	# user = mysql_sysadmin
4fa89cc7	8	# password = <secret>
7a0e0e17	9	#
4fa89cc7	10	# where "<secret>" is the password.
7a0e0e17	11	#
4f1d5e55	12	# You must do this for every active cluster defined in /etc/mysql/clusters.conf
7a0e0e17	13
fee2af30 ER	14	/var/log/mysql/query.log
	15	/var/log/mysql/mysqld.log
	16	/var/log/mysql/slow.log
f0d55a6c ER	17	/var/log/mysql/update*
f0d55a6c ER	18	{
5087696e	19	olddir /var/log/archive/mysql
7a0e0e17	20	notifempty
613e8547	21	missingok
ea57d024	22	create 640 mysql mysql
0c4232c2	23	sharedscripts
84837ab6 ER	24
	25	# NOTE:
	26	# if you run the rotation less often than "daily" then the
	27	# "expire-logs-days" mysqld server parameter may no longer work as you
	28	# expect
	29	daily
	30
aecc7924	31	postrotate
82225fb1	32	/sbin/service mysql flush-logs
aecc7924	33	endscript
aecc7924	34	}