Re: PURGE MASTER LOGS

[Gleb Paharenko]

Hello.

> Absolutely nothing happens.... 

It works for me in 4.1.13. See:

[gleb@blend mysql-debug-4.1.13-pc-linux-gnu-i686]$ ls -l ../logs/log_r
total 12
-rw-rw----  1 gleb gleb 1095 Aug 12 00:04 log_r.000002
-rw-rw----  1 gleb gleb   79 Aug 17 17:19 log_r.000003
-rw-rw----  1 gleb gleb   84 Aug 17 17:19 log_r.index
[gleb@blend mysql-debug-4.1.13-pc-linux-gnu-i686]$ lmysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.13-debug-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> PURGE MASTER LOGS BEFORE DATE_SUB(NOW(), INTERVAL 1 DAY);
Query OK, 0 rows affected (0.01 sec)

mysql> quit
Bye
[gleb@blend mysql-debug-4.1.13-pc-linux-gnu-i686]$ ls -l ../logs/log_r
total 8
-rw-rw----  1 gleb gleb 79 Aug 17 17:19 log_r.000003
-rw-rw----  1 gleb gleb 42 Aug 17 17:19 log_r.index

File log_r.000002 was deleted after the 'PURGE...' statement.



"Chris Knipe" <savage@stripped> wrote:
> Lo everyone,
> 
> Small issue.. MySQL 4.1.12... 
> 
> 
> PURGE MASTER LOGS BEFORE DATE_SUB(NOW(), INTERVAL 10 DAY);
> 
> Absolutely nothing happens.... 
> 
> PURGE MASTER LOGS TO 'blah-bin.00030';
> 
> Logs are cleared immediately.
> 
> Any reason why LOGS BEFORE is not working??? 
> 
> 
> Thanks,
> Chris.
> 
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com