Baron Schwartz wrote:
I will test again on my servers now that I have upgraded to 5.0.38.
One question for people for whom expire_logs_days DOES work: do you
have any slaves connected to the server?
I did not within my test. I could easily add that if need be however..
Let me know if your
Mark Leith wrote:
Baron Schwartz wrote:
I will test again on my servers now that I have upgraded to 5.0.38.
One question for people for whom expire_logs_days DOES work: do you
have any slaves connected to the server?
I did not within my test. I could easily add that if need be however..
Hi,
Jake Peavy wrote:
On 5/4/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Mark Leith wrote:
Baron Schwartz wrote:
I will test again on my servers now that I have upgraded to 5.0.38.
One question for people for whom expire_logs_days DOES work: do you
have any slaves connected to the server?
Baron Schwartz wrote:
I think we've found the bug. I just did a bunch of tests and I'm 99%
sure not only does expire_logs_days not work if there are slaves
attached, neither does PURGE MASTER LOGS. When I read my email this
morning, Nagios alerted me the master server was over the expected
On 5/4/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
Jake Peavy wrote:
On 5/4/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Mark Leith wrote:
Baron Schwartz wrote:
I will test again on my servers now that I have upgraded to 5.0.38.
One question for people for whom expire_logs_days
Hi,
Jake Peavy wrote:
On 5/4/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
Jake Peavy wrote:
On 5/4/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Mark Leith wrote:
Baron Schwartz wrote:
I will test again on my servers now that I have upgraded to 5.0.38.
One question for people for
Paul DuBois wrote:
At 8:46 PM -0400 5/2/07, Baron Schwartz wrote:
Ofer Inbar wrote:
That's a good point, though probably a minor one: At most you would
end up with one binary logfile that's old and not deleted. As soon
as you create a new one, that one would be deleted (if this feature
Mark Leith wrote:
Paul DuBois wrote:
At 8:46 PM -0400 5/2/07, Baron Schwartz wrote:
Ofer Inbar wrote:
That's a good point, though probably a minor one: At most you would
end up with one binary logfile that's old and not deleted. As soon
as you create a new one, that one would be deleted (if
At 9:55 PM -0400 5/3/07, Baron Schwartz wrote:
Mark Leith wrote:
Paul DuBois wrote:
At 8:46 PM -0400 5/2/07, Baron Schwartz wrote:
Ofer Inbar wrote:
That's a good point, though probably a minor one: At most you would
end up with one binary logfile that's old and not deleted. As soon
as you
Hi,
Ofer Inbar wrote:
There's a system variable called expire_logs_days that lets you set a
number of days to keep binary logs, and automatically delete logs
older than that. I've heard rumors that using this feature is
problematic. I notice that in the MySQL documentation about binary
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 02, 2007 7:55 AM
To: Ofer Inbar
Cc: mysql@lists.mysql.com
Subject: Re: expire_logs_days
Hi,
Ofer Inbar wrote:
There's a system variable called expire_logs_days that lets you set a
number
Baron Schwartz [EMAIL PROTECTED] wrote:
Actually, the manual does mention the variable, but it doesn't work
for us. We run a nightly cron job that just runs [purge master logs]
When you say it doesn't work for us do you mean that you tried it?
In what way did it not work?
Tim Lucia [EMAIL
Hi,
I'm experience using expire_log_days and don't work. I set this parameters
in the CNF and when the time of ( for example 5 days) is in, don't delete
anything.
On my expirience, this parameters don't work ( 5.0.27).
Regards
Juan
On 5/2/07, Ofer Inbar [EMAIL PROTECTED] wrote:
Baron
Ofer Inbar wrote:
Baron Schwartz [EMAIL PROTECTED] wrote:
Actually, the manual does mention the variable, but it doesn't work
for us. We run a nightly cron job that just runs [purge master logs]
When you say it doesn't work for us do you mean that you tried it?
In what way did it not work?
Juan Eduardo Moreno wrote:
Hi,
I'm experience using expire_log_days and don't work. I set this
parameters
in the CNF and when the time of ( for example 5 days) is in, don't delete
anything.
On my expirience, this parameters don't work ( 5.0.27).
I am testing this now (on 5.0.40) and will
Mark Leith wrote:
Juan Eduardo Moreno wrote:
Hi,
I'm experience using expire_log_days and don't work. I set this
parameters
in the CNF and when the time of ( for example 5 days) is in, don't
delete
anything.
On my expirience, this parameters don't work ( 5.0.27).
I am testing this now
Mark Leith [EMAIL PROTECTED] wrote:
Do keep in mind that expire_logs_days only gets triggered at a) server
start up b) the time a binary log has to roll over.
If your binary logs do not roll over for quite a period of time (i.e are
lower load systems) that still stay up for long periods -
Ofer Inbar wrote:
Mark Leith [EMAIL PROTECTED] wrote:
Do keep in mind that expire_logs_days only gets triggered at a) server
start up b) the time a binary log has to roll over.
If your binary logs do not roll over for quite a period of time (i.e are
lower load systems) that still stay up for
At 8:46 PM -0400 5/2/07, Baron Schwartz wrote:
Ofer Inbar wrote:
Mark Leith [EMAIL PROTECTED] wrote:
Do keep in mind that expire_logs_days only gets triggered at a)
server start up b) the time a binary log has to roll over.
If your binary logs do not roll over for quite a period of time
19 matches
Mail list logo