Watchdog Prune
This module allows you to selectively delete watchdog entries based on criteria like age or type. It provides more control over log retention than Drupal core, ensuring entries are kept for specific periods while preventing the log table from growing too large.
This module will allow you to selectively delete watchdog entries based on criteria, like age.
Drupal normally only deletes watchdog entries after 1,000 to 1,000,000 entries.
Instead, you can use this module to say "Delete entries older than 2 years", for example, or "Delete 'user' entries after 3 months", etc. This allows your site to guarantee that it retains watchdog entries for a certain time, regardless of how many entries are accumulated. However, it also lets you still remove entries from the table eventually, so as not to have a watchdog table which is too large.
This module is ideal for sites where entries should be kept for a certain amount of time, and for the purpose of generating reports based on user activity, without the worry that entries might start getting deleted by Drupal before a report can be run.
Installation / Configuration
After normal module installation, configure by visiting admin/config/development/watchdog-prune.
Drupal core's setting of "Database log messages to keep" must be set to "All", and will be set to that by this module.