Bug#349661: mysql-server-4.1: /var/log/mysql increases without limits
Hello Oliver On 2006-01-25 Olivier Berger wrote: > It would be so bad if lots of people would get /var full because of this > one... > > > On 2006-01-24 Olivier Berger wrote: > > > The value KEEP_BINARY_LOGS is at 0 by default in > > > /etc/mysql/debian-log-rotate.conf Eh, at least for Sarge this isn't even true? mysql-server-4.0 (4.0.24-10sarge1) has "7" mysql-server-4.1 (4.1.11a-4sarge2) has "2" So although the value of 2 was choosen bad, it's not disabled. For testing/unstable the next version will have expire_logs_days in use. bye, -christian- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#349661: mysql-server-4.1: /var/log/mysql increases without limits
Hmmm... OK, I see... My fault if I'm using testing, then ;) Hmmm... Any way to warn users of testing maybe ? DWN ? It would be so bad if lots of people would get /var full because of this one... Regards, Le mardi 24 janvier 2006 à 19:41 +0100, Christian Hammers a écrit : > tags 349661 + wontfix confirmed > thanks > > Hello Olivier > > On 2006-01-24 Olivier Berger wrote: > > The value KEEP_BINARY_LOGS is at 0 by default in > > /etc/mysql/debian-log-rotate.conf > > The value was probably indeed not choosen very well but I can't change > it for the already released Debian Sarge release any more. > > In the next Debian release, which will only ship MySQL 5.0, the binary > logging will be configurable via expire-logs-days in /etc/mysql/my.cnf > which will be set to a value of 20. The cronscript will then be superflous. > > bye, > > -christian- -- Olivier BERGER <[EMAIL PROTECTED]> Ingénieur Recherche - Dept INF INT Evry (http://www.int-evry.fr) OpenPGP-Id: 1024D/6B829EEC
Bug#349661: mysql-server-4.1: /var/log/mysql increases without limits
tags 349661 + wontfix confirmed thanks Hello Olivier On 2006-01-24 Olivier Berger wrote: > The value KEEP_BINARY_LOGS is at 0 by default in > /etc/mysql/debian-log-rotate.conf The value was probably indeed not choosen very well but I can't change it for the already released Debian Sarge release any more. In the next Debian release, which will only ship MySQL 5.0, the binary logging will be configurable via expire-logs-days in /etc/mysql/my.cnf which will be set to a value of 20. The cronscript will then be superflous. bye, -christian- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#349661: mysql-server-4.1: /var/log/mysql increases without limits
Package: mysql-server-4.1 Version: 4.1.15-1 Severity: important I've noticed a behaviour where /var/log/mysql endlessly increases. This has serious consequences on /var becoming full, which is a bad situation. Binary logs seem to be created in default config (why ?... only necessary for special needs ?), rotated and never purged. The value KEEP_BINARY_LOGS is at 0 by default in /etc/mysql/debian-log-rotate.conf The comments in this file state : "A value of 0 disables rotating and is set as default for backward compatibility." I'd suggest that by default, if binary logs have to be used (which is not obvious to me), they should be purged at some time not to fill up the /var. At least this should be explained to the user in README.Debian or something (or configured at installation time). Best regards. -- System Information: Debian Release: testing/unstable APT prefers testing APT policy: (500, 'testing'), (500, 'stable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.12-1-686 Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15) Versions of packages mysql-server-4.1 depends on: ii adduser 3.80Add and remove users and groups ii debconf [debconf 1.4.67 Debian configuration management sy ii libc62.3.5-8 GNU C Library: Shared libraries an ii libdbi-perl 1.48-2 Perl5 database interface by Tim Bu ii libgcc1 1:4.0.2-5 GCC support library ii libmysqlclient14 4.1.15-1mysql database client library ii libncurses5 5.5-1 Shared libraries for terminal hand ii libreadline5 5.1-5 GNU readline and history libraries ii libstdc++6 4.0.2-5 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-8 Wietse Venema's TCP wrappers libra ii mailx1:8.1.2-0.20050715cvs-1 A simple mail user agent ii mysql-client-4.1 4.1.15-1mysql database client binaries ii mysql-common 5.0.16-1mysql database common files (e.g. ii passwd 1:4.0.13-7 change and administer password and ii perl 5.8.7-10Larry Wall's Practical Extraction ii psmisc 21.8-1 Utilities that use the proc filesy ii zlib1g 1:1.2.3-9 compression library - runtime mysql-server-4.1 recommends no packages. -- debconf information: mysql-server-4.1/start_on_boot: true mysql-server-4.1/postrm_remove_databases: false mysql-server-4.1/really_downgrade: false mysql-server-4.1/nis_warning: * mysql-server-4.1/mysql_install_db_notes: mysql-server-4.1/mysql_update_hints1: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]