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 questi
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 e
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
d
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
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..
L
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
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 yo
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 (i
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
wor
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
(i
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 fo
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 peri
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 (on
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 se
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
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 Schwa
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 <[EMA
> -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
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
logging
19 matches
Mail list logo
