That should technically work, but you want to be sure you have the timestamp 
column indexed.

Based on what I’m seeing, it looks as if you mixed PHP in there.

Here’s how my garbage collector works for my IABot interface.

https://github.com/cyberpower678/Cyberbot_II/blob/master/IABot/www/Includes/session.php#L147
 
<https://github.com/cyberpower678/Cyberbot_II/blob/master/IABot/www/Includes/session.php#L147>

Cyberpower678
English Wikipedia Account Creation Team
English Wikipedia Administrator
Global User Renamer

> On Apr 7, 2018, at 09:41, MarcoAurelio <strig...@gmail.com> wrote:
> 
> Hi,
> 
> I'd like to issue a command to a database our team manages to clean all data 
> older than 30 days.
> 
> Browsing around I've found that:
> 
> DELETE FROM $table WHERE $timestamp < NOW() - INTERVAL 30 DAY
> 
> could work, but I'd like to check with you first just in case you have a 
> better command or ideas.
> 
> Thanks in advance for your help.
> 
> Best regards, M.
> _______________________________________________
> Wikimedia Cloud Services mailing list
> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
> https://lists.wikimedia.org/mailman/listinfo/cloud

_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud

Reply via email to