summaryrefslogtreecommitdiff
path: root/etc/logrotate.d/mysql-server
diff options
context:
space:
mode:
Diffstat (limited to 'etc/logrotate.d/mysql-server')
-rw-r--r--etc/logrotate.d/mysql-server27
1 files changed, 27 insertions, 0 deletions
diff --git a/etc/logrotate.d/mysql-server b/etc/logrotate.d/mysql-server
new file mode 100644
index 0000000..5f66109
--- /dev/null
+++ b/etc/logrotate.d/mysql-server
@@ -0,0 +1,27 @@
+# - 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 /var/log/mysql/error.log {
+ daily
+ rotate 7
+ missingok
+ create 644 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
+} \ No newline at end of file