Re: Redo logs take to much disk space
the ask lies in expire_logs_days. If you set this to optimal number of days, logs older than the configured days will get purged. ~Alex On 5/15/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > One question about this, is it safe to turn of log_bin? i think, you can. the log is necessary for data replication and sometimes for data recovery. you can read about it here: http://dev.mysql.com/doc/refman/5.0/en/binary-log.html > Or can you tweak it somehow so that it won't' take some much disk space? you can bzip old logs if you need them but don't want them to take so much space :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: Redo logs take to much disk space
> One question about this, is it safe to turn of log_bin? i think, you can. the log is necessary for data replication and sometimes for data recovery. you can read about it here: http://dev.mysql.com/doc/refman/5.0/en/binary-log.html > Or can you tweak it somehow so that it won't' take some much disk space? you can bzip old logs if you need them but don't want them to take so much space :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Redo logs take to much disk space
What can I do to stop this kind of behavior? and is its safe to delete all the files with a cronjob? and witch files are recommend to delete if so? just commet log-bin option of [mysqld] section in your my.cnf file (/etc/my.cnf) you can also remove these files manually -- it will not affect server -- Thanks, it works. I also had to comment: expire_logs_days and max_binlog_size. One question about this, is it safe to turn of log_bin? Or can you tweak it somehow so that it won't' take some much disk space? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Redo logs take to much disk space
> What can I do to stop this kind of behavior? and is > its safe to delete all the files with a cronjob? and witch files are > recommend to delete if so? just commet log-bin option of [mysqld] section in your my.cnf file (/etc/my.cnf) you can also remove these files manually -- it will not affect server -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Redo logs take to much disk space
Hello, I got a problem with the redo log from mysql. my /var/log/mysql fills up with mysql-bin.0# files and a few moments ago it was about 10Gb in size (after 2 weeks in production), so I decide to delete al the files. What can I do to stop this kind of behavior? and is its safe to delete all the files with a cronjob? and witch files are recommend to delete if so? chiel
