Database Cleanup & Optimization
Manage cache, clean orphaned data, and optimize database performance
Healthy
Database Status
248 MB
Database Size
of 1 GB allocated
42
Tables
All optimized
3.2 GB
Backup Size
Last: Today 14:28
Cleanup Tasks
Clear Page Cache
Removes cached HTML pages and API responses
42 MB
Purge Session Data
Remove expired user sessions (older than 30 days)
18 MB
Clean Email Logs
Remove email log entries older than 90 days
28 MB
Remove Orphaned Images
Delete uploaded images not linked to any product
156 MB
Clear Analytics Cache
Reset computed analytics data for recalculation
12 MB
Purge Abandoned Carts
Remove abandoned carts older than 60 days
8 MB
Clean Audit Logs
Archive audit log entries older than 6 months
64 MB
Remove Draft Products
Delete products in draft status with no orders
4 MB
Total recoverable: 332 MB
Optimization Tools
Optimize Tables
Defragment and optimize all database tables
Last run: 3 days ago
Rebuild Indexes
Rebuild search indexes for faster queries
Last run: 1 week ago
Check Integrity
Verify table structures and foreign keys
Last run: Yesterday
Compact Storage
Reclaim unused disk space from deleted data
Last run: 2 weeks ago
Scheduled Maintenance
Daily Backup
02:00 AM
Active
Weekly Optimization
Sunday 03:00 AM
Active
Monthly Cleanup
1st of month 04:00 AM
Active
Quarterly Archive
Next: Oct 1
Pending
Largest Tables
| Table | Rows | Size | Index Size | Last Optimized | Status |
|---|---|---|---|---|---|
| analytics_events | 2,847,291 | 84.2 MB | 22.4 MB | Today | Optimized |
| audit_logs | 847,122 | 64.8 MB | 18.2 MB | 3 days ago | Optimized |
| email_logs | 128,847 | 28.4 MB | 8.6 MB | 3 days ago | Optimized |
| orders | 14,847 | 22.1 MB | 6.4 MB | Today | Optimized |
| products | 1,247 | 18.6 MB | 4.2 MB | Yesterday | Optimized |
| customers | 8,421 | 12.4 MB | 3.8 MB | Yesterday | Optimized |
| sessions | 42,847 | 8.2 MB | 2.1 MB | Today | Needs cleanup |
| cart_items | 28,142 | 4.8 MB | 1.2 MB | Today | Needs cleanup |