Hi, thanks for your reply.
I do too run from time to time a query like yours: "DELETE FROM logging WHERE l_timestamp < 20180201000000;" for example; however I have to manually set the timestamp. Ideally we should perhaps move to have a coded garbage collector on our tool instead of doing this ourselves manually. Regards, M. 2018-04-07 15:55 GMT+02:00 Maximilian Doerr <[email protected]>: > 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 > > Cyberpower678 > English Wikipedia Account Creation Team > English Wikipedia Administrator > Global User Renamer > > On Apr 7, 2018, at 09:41, MarcoAurelio <[email protected]> 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 > [email protected] (formerly [email protected]) > https://lists.wikimedia.org/mailman/listinfo/cloud > > > > _______________________________________________ > Wikimedia Cloud Services mailing list > [email protected] (formerly [email protected]) > https://lists.wikimedia.org/mailman/listinfo/cloud >
_______________________________________________ Wikimedia Cloud Services mailing list [email protected] (formerly [email protected]) https://lists.wikimedia.org/mailman/listinfo/cloud
