- rebuild with libevent 2.1.11

[packages/mysql.git] / mysql.logrotate

diff --git a/mysql.logrotate b/mysql.logrotate
index 7d230f8426fdbcaca5f00048b7a12e9fb6c9f3e5..4bb78ceb9acd84287db5a16baef4e66400b9d1a3 100644 (file)
--- a/mysql.logrotate
+++ b/mysql.logrotate
@@ -1,60 +1,34 @@
-/var/log/mysql/err {
-       olddir /var/log/archiv/mysql
-        notifempty
-       create 640 mysql mysql
-        prerotate
-               /usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
-       endscript
-
-       postrotate
-               /usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
-       endscript
-}
-
-/var/log/mysql/log {
-       olddir /var/log/archiv/mysql
-        notifempty
-       missingok
-       create 640 mysql mysql
-
-        prerotate
-               /usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
-       endscript
-
-       postrotate
-               /usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
-       endscript
-}
-
-/var/log/mysql/isamlog.log {
-       olddir /var/log/archiv/mysql
-        notifempty
+# 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
 
-        prerotate
-               /usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
-       endscript
+       # 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
-               /usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
+               /sbin/service mysql flush-logs
        endscript
 }
-
-/var/log/mysql/update* {
-        olddir /var/log/archiv/mysql
-        notifempty
-        missingok
-        create 640 mysql mysql
-
-        prerotate
-                /usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
-        endscript
-
-        postrotate
-                /usr/bin/mysqladmin --defaults-file=/etc/mysqld.conf flush-logs
-        endscript
-}
-
-
-