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 maximilian.doerr@gmail.com:
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 strigiwm@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 labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud