I'd like the DBAs to have a look at https://phabricator.wikimedia.org/diffusion/EABF/browse/master/maintenance/purgeOldLogIPData.php and check if it is safe to run on production. We're in the process of making IP data avalaible to CheckUsers, but data older than 90 days has to be removed per our data retention policies. Granted, AbuseFilter has been nonetheless storing that information indefinitelly since it got installed in the abuse_filter_log table (afl_ip field) so we need to clean those rows before enabling access and, later, have the script run periodically which can be done via a puppet cron job.
The first run Wikimedia wiki will involve tens of thousands of rows to update, so I'm guessing that a deployment window should be scheduled on Wikitech to do the first run. However, I'd like to check with you if special precautions should be taken prior and during the running of this script. Would DB overload, do you need to backup the data first, etc?