librenms/librenms — pull request #301 by laf (2014-10-02 00:48:04+00:00)
Title: Added authlog purge + improved efficiency of clearing out large syslog tables

I've found that with large volumes of syslog data, a delete based on the datetime alone is not enough as MySQL can't complete the transaction in time so it fails. This has led to the build up of over 9m records in my test box alone.

This change now removes data in batches of 1000 without issue. It ran through 250,000 entries in 1 hour so should be fine now.

It also adds the clearing of authlog entries (logs web interface access).