X-Git-Url: https://git.pld-linux.org/?a=blobdiff_plain;f=mysql.logrotate;h=4bb78ceb9acd84287db5a16baef4e66400b9d1a3;hb=09ee1717a7ae896cf1736baa367a52636ffd00f9;hp=548488bd78ee629812c130c33bfcefc2127cc366;hpb=5087696e4e3ecbcae0786e52e06934f173897ece;p=packages%2Fmysql.git

diff --git a/mysql.logrotate b/mysql.logrotate
index 548488b..4bb78ce 100644
--- a/mysql.logrotate
+++ b/mysql.logrotate
@@ -1,18 +1,19 @@
-# If the *mysql* root user has a password you have to set it in mysqld.conf
+# 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_logrotate
+# user = mysql_sysadmin
 # password = <secret>
 #
 # where "<secret>" is the password.
 #
-# You must do this for every cluster defined in /etc/mysql/clusters.conf
-#
-# ATTENTION: The mysqld.conf should be readable ONLY for *system* root!
+# You must do this for every active cluster defined in /etc/mysql/clusters.conf
 
-/var/log/mysql/error*
-/var/log/mysql/log
-/var/log/mysql/mysql.err
+/var/log/mysql/query.log
+/var/log/mysql/mysqld.log
+/var/log/mysql/slow.log
 /var/log/mysql/update*
 {
 	olddir /var/log/archive/mysql
@@ -20,6 +21,13 @@
 	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