Advanced Database Growth Monitoring

ZiziCache includes an advanced database growth monitoring system that automatically detects unusual size changes and alerts administrators to potential issues. This proactive monitoring helps prevent database bloat and performance degradation before they impact your website.

Automated Anomaly Detection

The monitoring system tracks these critical metrics:

• Individual Table Sizes – Monitor growth of each database table separately
  • Tracks posts, comments, options, and meta tables
  • Identifies tables with abnormal growth patterns
  • Provides historical size comparison data
• Total Database Size – Overall database size monitoring
  • Tracks cumulative database growth
  • Monitors storage usage trends
  • Compares against historical averages
• Growth Rate Analysis – Calculate weekly growth percentages
  • Identifies rapid growth periods
  • Compares current vs. historical growth rates
  • Predicts future storage requirements
• Table Fragmentation – Detect fragmented tables requiring optimization
  • Monitors table efficiency metrics
  • Identifies optimization opportunities
  • Tracks fragmentation trends over time

Monitoring Configuration

Configure monitoring settings using these parameters:

// Basic monitoring configuration
'db_growth_monitoring' => true,              // Enable monitoring
'db_growth_alert_threshold' => 30,           // Alert threshold (30%)
'db_growth_alert_emails' => '[email protected]', // Alert email addresses
// Advanced monitoring settings
'db_monitoring_config' => [
    'check_interval' => 'daily',             // Monitoring frequency
    'fragmentation_threshold' => 20,         // Fragmentation alert (20%)
    'size_alert_threshold' => 100,           // Size alert (100MB)
    'growth_rate_alert' => 50,               // Growth rate alert (50% weekly)
    'email_reports' => true,                 // Enable email reports
    'dashboard_alerts' => true,              // Show dashboard alerts
    'retention_days' => 90                   // Keep monitoring data for 90 days
]

Adaptive Cleaning Intelligence

The plugin can automatically adjust cleaning frequency based on database growth rate:

• Rapid Growth (>10% daily) – Switch to daily cleaning
  • Prevents rapid database bloat
  • Maintains optimal performance
  • Sends immediate alerts to administrators
• Moderate Growth (5-10% daily) – Implement twice-daily cleaning
  • Balances optimization with system resources
  • Monitors for sustained growth patterns
  • Adjusts automatically based on trends
• Slow Growth (<1% daily) - Maintain weekly cleaning
  • Efficient for stable, low-activity sites
  • Minimal system resource usage
  • Continues monitoring for changes

Alert Types and Notifications

Comprehensive alerting system for various database conditions:

• Growth Rate Alerts – When database grows faster than configured thresholds
• Size Threshold Alerts – When total database size exceeds limits
• Fragmentation Alerts – When table fragmentation requires attention
• Performance Impact Alerts – When database issues affect site performance
• Cleanup Failure Alerts – When automatic cleanup operations fail

Reporting and Analytics

Detailed reporting capabilities for database health tracking:

• Weekly Growth Reports – Comprehensive growth analysis and trends
• Performance Impact Reports – How database changes affect site speed
• Cleanup Effectiveness Reports – Results and benefits of optimization
• Predictive Analysis – Forecasting future storage and performance needs