DB Clean Ups

DB Cleanup helps Drupal sites automatically clean cache tables and watchdog (dblog) entries at configurable intervals. It is especially useful for sites running on shared or resource-restricted hosting environments.

Features

Key features include:

• Automatically cleans watchdog (dblog) table at configurable time intervals.
• Automatically clears cache_ tables* on a scheduled basis.
• Optional OPTIMIZE TABLE execution after cleanup to reclaim space and improve performance.
• Manual controls to immediately clear cache tables and watchdog entries from the UI.
• Lightweight and cron-based, suitable for shared hosting and low-resource servers.
• Simple configuration form integrated into the Administration → Configuration → Development section.

Use cases:

• Drupal sites with limited database storage.
• Shared hosting environments where database size grows quickly.
• Sites where log tables are not cleaned frequently enough by default.
• Developers who want predictable and controlled cleanup intervals.

Post-Installation

After installing and enabling the module:

1. Navigate to
   
   Administration → Configuration → Development → Database Cleanup Settings
2. Configure:
   
   • Watchdog Cleanup Interval (hours)
   • Cache Tables Cleanup Interval (hours)
   • Enable or disable Optimize tables after cleanup
3. Save the configuration
4. The cleanup tasks will run automatically during Drupal cron execution.
5. Optionally, use Run Cleanup Now to manually clear cache tables and watchdog entries instantly.

No additional content types or permissions are required.

Additional Requirements

• Drupal core (no external libraries required)
• Uses Drupal core cron system
• Works with core Database Logging (dblog)

Similar projects

• Core cron & cache clear mechanisms – DB Cleanup adds configurable intervals and manual controls in one place.
• DBLog Cleanup modules – often focus only on watchdog, while DB Cleanup also manages cache tables.
• Performance-focused cleanup modules – DB Cleanup is intentionally lightweight and suitable for shared hosting environments.

What differentiates DB Cleanup is its simple configuration, combined cache + watchdog cleanup, and suitability for low-resource servers.